copy all mysql thngs to another server
I have a redhat server , there are mysql databases running on it , I just would like to copy everything of mysql (database , permission , user id ... etc ) to another server .
I search from web , one method is mysqldump database from it and then import to another server , could advise if this method could copy Everything includes permission , user id to another server ? what I worry is just that I don't not to miss anything when migration. Thanks a lot . http://dev.mysql.com/doc/refman/5.0/...databases.html |
I've always done this...
Code:
mysqldump --user=root --password=password -A > mysql_bkup.sql Code:
mysql --user=root --password=password < mysql_bkup.sql Another thing you can do is use rsync to sync the directories over to another machine...but I don't recommend this. Since you have Red Hat, you can ask support for assistance with this |
Can you clarify "copy" and "migrate".
Are you moving the db to a new host or merely just copying the data (say, as an experience building exercise)? |
|
All times are GMT -5. The time now is 07:28 PM. |