Page 1 of 1

Moving database from windows platform to unix platform

Posted: Thu Aug 11, 2005 11:41 am
by smet
hi, i'd like to to move a database from a windows platform to a unix platform. i was told i can use a "dump" command but i'm not sure how to go about using it. Also i'd like to run two databases from one unix server. if anyone has any suggestions PLEASE let me know. THANKS.

Posted: Thu Aug 11, 2005 12:02 pm
by sman317
I use Phpmyadmin from: http://www.phpmyadmin.net/

Good luck.

Posted: Thu Aug 11, 2005 12:04 pm
by jmut
I suppose you're talking about MySQL database....

Here is a sample way to do it from command line....

mysqldump -u root -pyourpassword yourdatabase > d:\yourpath\yourfile.sql

then to import on the new machine:

mysql -B -u root --password=yourpassword -h localhost yourdatabase < d:\yourpath\yourfile.sql

http://dev.mysql.com/doc/mysql/en/mysqldump.html

If the databases are MyISAM you can also copy/paste the directories(databases)....but using mysqldump is far more reliable.

This should help you with the second problem.....
http://dev.mysql.com/doc/mysql/en/multiple-servers.html