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.

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.

How to Mass Delete Spam Comments at once using a SQL query?

I have observed that among web masters, even though success in not so very common, the problems that they face are common! I have had many web masters seeking help when they are facing issues with Spam Comments and they are finding it difficult to keep a tab on them even after installing Akismet plugin that helps in spam identification.

Let me clarify that the problem here is not in the identification of the Spam comments, but is in mass deleting all of them at one go without crashing your Wordpress installation. Often the “empty spam” button works like a charm when there are less comments like below a count of 1000. Imagine you have an amount of 20,000 pending comments – how would you tackle such a situation to delete all the spam comments? its simple, read on..

Mass Deleting un approved comments using a SQL query

How to Transfer a WordPress Blog to a new Server or Web Hosting

I have been seeing many queries and requests about transfer / migration of a WordPress blog installation from one server to another server or web hosting account from different webmasters.

There is an increasing demand for a dependable and detailed tutorial for the same. Hence I decided to create a detailed tutorial with screenshots and steps that will clearly explain on how to migrate an already established WordPress blog to a different web hosting server without any issues.

Tutorial Legend:

• OLDserver – The server on which the blog is already installed on.
• NEWserver – The destination server of the new target web hosting company.
• OLDdatabase – The database file of the original blog.
• NEWdatabase – The database of the target blog.

How to Import Large SQL Database files using phpMyadmin

Often migrating websites from one host or domain to another could lead you to situations where you would have to import one Database SQL Dump to another database using programs like phpMyadmin.

While importing smaller databases of size less than 20 MB it would not be an issue using phpMyadmin, but in some cases we would have to import larger databases ranging from 20 MB to even GBs which the phpMyadmin program would not allow us to do. Today I will share an extremely useful light weight application that automatically splits SQL dumps into smaller chunks of your choice that you can effortlessly upload using phpMyadmin.

SQL Dump Splitter is a 180 KB application that gives total control over splitting huge databases into smaller SQL files with ease. With SQL Dump Splitter you can:

Hey friends,

Here is a simple tip to back up your entire WordPress blog, users, posts, and Images.

Firstly Backup the Text content

Go to your blogs admin section,  Manage > Export to download it in XML format, further this can be used to import to your latest wordpress version.

Then Backup the images

Download and install the Firefox extension DownThemAll, then login to your  your WordPress blog’s admin section

Manage > Media Library page & set DownThemAll to download all your image links on the page, you are done with it. Isnt that simple.

[ratings]