Thoughts from Dan Miser RSS 2.0
 Tuesday, September 18, 2007

To move a MySQL 5.x database from one machine to another, follow these steps.

On the source machine, type this:

mysqldump -u root db_development > backup.sql 

After copying backup.sql to the destination machine, type this (assuming the database doesn't already exist there):

mysqladmin -u root -p create db_development
mysql -u root -D db_development < backup.sql

References

I used these web pages as inspiration, but it seems that things have gotten out of date.
Tuesday, September 18, 2007 1:17:46 PM (Central Standard Time, UTC-06:00)  #    Comments [0] -

Navigation
Archive
<July 2008>
SunMonTueWedThuFriSat
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2008
Dan Miser
Sign In
Statistics
Total Posts: 306
This Year: 21
This Month: 0
This Week: 0
Comments: 604
All Content © 2008, Dan Miser
DasBlog theme 'Business' created by Christoph De Baene (delarou)