Backup/Restore MySQL database dg SSH

July 13, 2011

Kalo mau backup MySQL database pake SSH, jalankan perintah sbb:

mysqldump –add-drop-table -u [user] -p [db_name] > /home/backups/backup.sql

bisa ditaroh di directory mana aja terserah.

Ntar kalo mau restore, pastikan berada di directory dimana file hasil backup berada, trus pake perintah:

mysql -u [user] -p [db_name] < backup.sql

Nah udah gitu aja :D

Cheers!!! :D

Yg udah pada nyasar sini pake keywords:

  • perintah backup ssh

Leave a Comment

Previous post:

Next post: