How to Copy Database MYSQL to difference host using SCP


Berikut adalah cara singkat untuk melakukan copy database antar host yang berbeda dengan menggunakan command line scp di linux:

[root@gmosking ~]#mysqldump -uroot -pgmosking –database openfire | ssh root@192.168.0.125 mysql -uroot -pdesmosesking –database openfire

[root@gmosking ~]#mysqldump -uroot -pgmosking –database openfire tblname | ssh root@192.168.0.125 mysql -uroot -pdesmosesking –database openfire tblname

 

Terimakasih

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

shisdew

Listens until think alike

moses.spaceku@yahoo.com / voip ipbx

Hosted PBX, IP-PBX SOHO/ CALL CENTER, VOICE GATEWAY, VOICE CARD, COST EFECTIVE SOLUTIONS (LCR), GSM/CDMA GATEWAY

%d bloggers like this: