Does your website goes down sometimes? Did you notice your website database corrupted? Have you noticed SQL injection attacks on your website? Have you seen your website defaced by any hacker where all your website reflects, a message that ‘you are hacked’, or ‘patch your site admin’ etc. Its a routine matter, seen by many webmasters. I can tell you, I have experienced it all and still see this often. Sometimes website front page is replaced by hacker. Sometimes database gets corrupted. Sometimes website goes down. Sometimes whole root directory disappears. Hosting provider can suspend your hosting account because of any hacker who gained access to your hosting account to spread malware. Its horrible.
Doesn’t matter how much security you may apply, somehow there may be still chances that your website will be hacked, defaced or your mySQL database will be corrupted. In that case if you request web hosting backups, they fail to guarantee the latest full backup. Sometimes backup will be incomplete. Sometimes backup will be outdated.
So here comes the need for a regular, automated full website FTP and mySQL database backup. How do you take website and mySQL backups? Manually? Forget it. We recommend BackupSF software that can take automated full website FTP and database backups for you. Good news is, we are giving away 10 license keys for BackupSF. Subscribe to TechMynd’s newsletter and comment this post to enter in this giveaway contest. Ten lucky winners will be announced after 25 September 2012.
Setting up a database connection can be a difficult task. Search Google and the scripts you will find will amaze you. These are lengthy and boring. Here is the easy most method to create a dbconnection for PHP and mysql.
Ever encountered with this WordPress MySQL error? MySQL Server Has Gone Away. And then your blog sidebars will refuse to show posts links, tags, recent posts, recent comments etc. I got this problem over and over again and I thought that I was using heavy plugins and MySQL query was timed out being very long. I searched for some solution but just found this answer that if I will use long query, MySQL server will be timed out and will be gone away. Funny!!! But I was hesitating to use more plugins and actually using limited options and other limits in existing WordPress plugins in my blog.
Did you wonder sometimes that why mySQL Update Command do not update records when the syntax of update query is perfectly alright? This is the problem I stuck with couple of times and I just wondered and looked for solution but seriously never found any solution to that anywhere untill I found the answer to this question and I was relieved.
WHERE command is used to collect the records from the table based on some condition specified by the where clause. More than one condition can be added to the where clause by using various logical expressions like AND, OR, < ( less than ), >(greater than) etc. Logical expressions plays important role in returning the desired records. Let us start with some examples. We are interested in the marks of Fourth class students. You can just follow the table creation process and the select query section discussed here. We will use the table named as student to work with WHERE clause.
Table structure can be changed by using alter command. With this command Field type or property can be changed or a new field can be added. If you decide to change a field to UNIQUE so it will not accept any duplicate records then if some records with duplicate value are already there then system will not allow this. Same way we have to take care of other constraints.