Export – Import settings for MYSQL Databases

If you are looking forward to Migrating your Blog or website from one host to another or some other web based application from one location to another, you will encounter a situation where you need to select the right settings for exporting and importing a MYSQL database. Below are some settings that will help you identify the right settings for Exporting and Importing your databases.

Below screenshots shows the appropriate settings that works fine with me and make sure you have your database backup before deleting it to make sure you have the complete DB migrated as it should be.

WordPress Comment Spamming at all time High!

Its alarming and frustrating when you see the number of spam comments you receive on your blog every day and the remember that the count is going to spike up the closer your blog gets to being popular.  If you see the screenshot on this page, it shows the Spam messages / comments blocked by Akismet in this month alone (20 days) and the count is as high as 20,000! If you too have a WordPress blog I am sure that you will be also facing the same issues with arresting spam.

The best practices I would recommend for any blogger to use to keep the BAD spammers out of our way are:

Life Saving SQL Queries for a WordPress Blogger

Often its very tedious and time wasting job to clean up the mess on your blog! I find it very irritating at times when several unwanted work eat up my precious time as a webmaster that I could have otherwise used for creating meaningful content to share on my blog. Various tasks that could consume your valuable time as  a blogger are:

• Cleaning up Spam / pending comments
• Removing unwanted post revisions
• Deleting pending posts created by Spam bots
• Clearing web server cache etc.
• The list simply goes on.

Fatal Error on WordPress Version 3.3: Call to undefined function is_rtl()

Soon after the roll out of the latest WordPress 3.3 version upgrade, many webmasters have been reporting a failure on the blog and the following error occurring on their WordPress Admin dashboard page: “Call to undefined function is_rtl()“

Complete Error: Fatal error: Call to undefined function is_rtl() in /public_html/wp-includes/general-template.php on line 2102

WordPress 3.3 Version update is Launched today

Today the WordPress team has launched its latest version update 3.3 and this time its really quite a visual update with several changes to the interface. There are several key changes like an improved dashboard with dynamic update messages, Flyout menu options, more filetypes and automatic file detection with drag and drop file uploads.

Below are the list of features added / improved in the latest version of WordPress framework:

How to change WordPress Theme folder Name

Your Blog theme can be identified easily by checking the page source and searching for the term “themes”. If you have to hide the theme name all you need to do is rename the theme folder from the FTP of your web hosting. But if you are renaming an active theme on your blog, it will cause several working issues and hence you will have to change the theme to the default one and then rename the intended theme folder.

You might be skeptical to change the folder name worrying if the structure or theme performance might be affected but if the folder name is changed when the theme is not in use, it should not be a problem at all. After changing the theme, you can rebuilding the permalink structure even though its not a must.