Moving database from windows platform to unix platform
Moderator: General Moderators
Moving database from windows platform to unix platform
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.
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
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