speyfisher
asked on
Move MySQL database from Windows to Linux
How shall I move a MySQL database from Win2K to Linux-RH9. Never done it and haven't seen 'the' recommended method.
Windows2000 - MySQL 4.0.15 - phpMyAdmin 2.5.3
Linux RH9 - MySQL 3.23.58 - phpMyAdmin 2.5.3
Windows2000 - MySQL 4.0.15 - phpMyAdmin 2.5.3
Linux RH9 - MySQL 3.23.58 - phpMyAdmin 2.5.3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
On Windows:
mysqldump -u <username> -p<password> --quick <databasename> > dump.sql
Move dump.sql to Linux machine.
On Linux:
mysql -u <redhatuser> -p<redhatpassword> <databasename> < dump.sql
Just introduces a file as the middleman is all.
mysqldump -u <username> -p<password> --quick <databasename> > dump.sql
Move dump.sql to Linux machine.
On Linux:
mysql -u <redhatuser> -p<redhatpassword> <databasename> < dump.sql
Just introduces a file as the middleman is all.
ASKER
thanks!
ASKER
If I could not use this method over a network, would you illustrate how I'd install a dump ... a .sql or .gz for example on the Linux machine?