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 2:17:46 PM (Central Daylight Time, UTC-05:00)  #    Comments [0] -

Comments are closed.
Navigation
Archive
<May 2012>
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 2012
Dan Miser
Sign In
Statistics
Total Posts: 380
This Year: 8
This Month: 0
This Week: 0
Comments: 670
Themes
Pick a theme:
All Content © 2012, Dan Miser
DasBlog theme 'Business' created by Christoph De Baene (delarou)