Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Migration of MySQL Database

Regular Advisor

Migration of MySQL Database


What is the appropriate way to migrate a database ? Is it by exporting and importing the database ?

Actual problem:
Migrate MySQL database running in Linux to W2K (based on management decision).

Thanks in advance,
Honored Contributor

Re: Migration of MySQL Database


Export/Import would be the best way as long as the database structure is not too complex.

You may wish to have a look at tools that help you in this task. E.g. MySQLMan

MySQLMan is a web based database manager. It allows you to perform common maintenance and administration tasks in Mysql (Mysql is a great mostly-free SQL database server). MySQLMan was based off of PHPmyadmin, but written in Perl. It allows you to do common tasks like:
- browse/create/drop databases
- browse/search/create/drop/alter tables
- import/export data
- add/remove/alter table columns
- add/remove/alter table keys

You can download it from:

Hope this helps!
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Sergejs Svitnevs
Honored Contributor

Re: Migration of MySQL Database

You should use mysqldump[.exe] to export/import.

check out the following link:

Garry Ferguson
Frequent Advisor

Re: Migration of MySQL Database

Chapters 14.5 and 14.6 tell
you what to do.