Migration of MySQL Database

[yc_2]

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

[Yogeeraj_1]

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

[Sergejs Svitnevs]

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]

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