Store dump from DB on Server A to Server B (File) and test restore on C

[Henry Mill]

Hi
I make a dump from DB on server A on Server B:

mysqldump --host=[IP Server A] -u [user] -p[password] [database] | mysql --host=[IP Server B] -u [user] -p[password] > backup.sql

Now I would like to test the dump in a test-db on Server C
- take the file backup.sql on B
- fill the db with that on Server C

I guess it must be something like this:

mysqldump --host=[IP Server B] -u [user] -p[password] < backup.sql | mysql --host=[IP Server B] -u [user] -p[password] [database]

What is the propper syntax for that?

Thanks a lot for help.



Edited 1 time(s). Last edit at 09/28/2012 05:59AM by Henry Mill.