Home
Webmaster Central
Web Design & Development
Export – Import settings for MYSQL Databases

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

    Thanks a lot for this article! Was really helpful.

    regards, Vin

  2. Vikramaditya December 24, 2011

    Nice Info,

    Cheers,

    Vik

  3. Samantha December 24, 2011

    Thanks for sharing this info here!

  4. Bill Poteet December 24, 2011

    Something i was looking to find out and you have posted just exact thing i was looking for. Thanks a bunch

  5. Database Monitoring April 4, 2012

    Truly a good source of information and this is perfect for the beginners.