Export – Import settings for MYSQL Databases

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.

Export - Import settings for MYSQL Databases

Export - Import settings for MYSQL Databases

Export - Import settings for MYSQL Databases

Import Settings

Export - Import settings for MYSQL Databases

5 Comments

  1. Vinod Sandhya December 24, 2011
  2. Vikramaditya December 24, 2011
  3. Samantha December 24, 2011
  4. Bill Poteet December 24, 2011
  5. Database Monitoring April 4, 2012