Easy way to move 40 databases from one server to another?

[ghurty]

I am trying to move about 40 databases from one server to another. Is there an easy to use command that will allow me to do that?

 

The two servers are on separate private networks, so I may not be able to copy them directly, so what I would want to do is create a backup, then manually move it and the restore it.

 

I belive I need to exclude informatio_schema as well as the mysql databses.

 

Thanks

[darkfreaks]

Usually you run mysqldump to create a database copy and backups as follows:

 

$ mysqldump -u user -p db-name > db-name.out

Copy db-name.out file using sftp/ssh to remote MySQL server:

$ scp db-name.out [email protected]:/backup

Restore database at remote server (login over ssh):

$ mysql -u user -p db-name < db-name.out

OR

$ mysql -u user -p 'password' db-name < db-name.out

[ghurty]

In order  to do that, I have to do this to each database individually. Is there a way to do multiple databases at once?

 

Thanks

[lastkarrde]

Write a shell script, put the above commands in a loop and iterate over the names of your databases.

[trq]

mysqldump has an --all-databases option or a --databases option that takes a space seperated list of database names.

 

Does no one look at the manual's these days?