Catatan MySQL – II

Membuat backup & restore database :)

1. mysqldump -u root -p [nama database] > [namafile].sql “contoh : backupglpi.sql”
2. #!/bin/sh
   date=`date -I`
   mysqldump –all-databases | gzip > /var/backup/backup-$date.sql.gz
3. mysqldump -u root -p [nama database] < [namafile].sql “contoh : backupglpi.sql”

 

Cyd!

thanks to : http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/

Advertisement