cancel
Showing results for 
Search instead for 
Did you mean: 

Migration of MySQL Database

yc_2
Regular Advisor

Migration of MySQL Database

Hi,

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,
YC
3 REPLIES
Yogeeraj_1
Honored Contributor

Re: Migration of MySQL Database

hi,

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:
http://www.gossamer-threads.com/scripts/source/mysqlman.zip
or
http://www.gossamer-threads.com/scripts/source/mysqlman.tar.gz

Hope this helps!
Yogeeraj
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:
http://www.mysql.com/doc/en/mysqldump.html

Regards,
Sergejs
Garry Ferguson
Frequent Advisor

Re: Migration of MySQL Database

http://www.educat.hu-berlin.de/doc/mysql-3.23/manual_toc.html

Chapters 14.5 and 14.6 tell
you what to do.

Regards,
Garry