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


Advanced Search

Store dump from DB on Server A to Server B (File) and test restore on C
Posted by: Henry Mill ()
Date: September 28, 2012 05:29AM

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.

Options: ReplyQuote


Subject Written By Posted
Store dump from DB on Server A to Server B (File) and test restore on C Henry Mill 09/28/2012 05:29AM
Re: Store dump from DB on Server A to Server B (File) and test restore on C Rick James 10/01/2012 07:31PM
Re: Store dump from DB on Server A to Server B (File) and test restore on C Henry Mill 10/02/2012 01:28AM
Re: Store dump from DB on Server A to Server B (File) and test restore on C Rick James 10/03/2012 07:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.