MySQL Forums
Forum List  »  Newbie

Re: Moving data between servers
Posted by: Barry Galbraith
Date: April 28, 2017 07:23PM

When you say one server is remote, how remote?
192.168.0.199 is a private network address and unroutable on public internet.
if your localhost 127.0.0.1 and 192.168.0.199 are on the same network that's ok.

But, does the mysql server on 192.168.0.199 allow connections from the real network address of the machine where the dump is coming from, eg 192.168.0.198?

Best is to dump the table into a local file
mysqldump --host=127.0.0.1 --user=root --password=djtvision -databases=ezmysqltest --tables=cqt > /path/to/localfile.sql

Then use mysql client to load that file into the remote machine, as long as the remote machine allows connections from your remote user.

mysql --host=192.168.0.199 --user=vision --password=backedup
-databases=vision -tables=cqt < /path/to/localfile.sql

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Moving data between servers
April 28, 2017 07:23PM


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.