Moving database from windows platform to unix platform

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
smet
Forum Newbie
Posts: 4
Joined: Mon Jun 06, 2005 12:29 pm

Moving database from windows platform to unix platform

Post 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.
User avatar
sman317
Forum Newbie
Posts: 10
Joined: Wed Jun 01, 2005 11:47 am

Post by sman317 »

I use Phpmyadmin from: http://www.phpmyadmin.net/

Good luck.
jmut
Forum Regular
Posts: 945
Joined: Tue Jul 05, 2005 3:54 am
Location: Sofia, Bulgaria
Contact:

Post 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
Post Reply