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.
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