Help - Search - Members - Calendar
Full Version: mysql - back up, move, and restore help
The Planet Forums > System Administration > Backups, Restores and Transfers
Nervosa
Hello,
I want to take all my databases I have on one machine, and place them on a new one.

mysqldump --all-databases > all_databases.sql

scp all_databases.sql username@serverip:all_databases.sql

mysql --all-databases < all_databases.sql

Will this work, do I need to do something else?
I'm not real big on command like interfaces, do I need to provide directorys to where mysql is located at? If so where and how would I add that.

Thank you for your time.
Gary Simat
on the import you dont need the --all-databases.

mysql < all_databases.sql

the rest should be fine.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.