Wednesday, September 10, 2014

Pushing mysqldump to another server!

Server 1 need to mysqldump to server 2.
HOW HOW HOW!

mysqldump DBNAME tablename | ssh root@remoteserver.com "mysql -D dbname"

Best to use the authorized keys to ssh! So no need password lah!

No comments: