Darence - Wa Kau!
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment