Backup isi database MySQL

Dump isi database MySQL

/usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c

langsung di gz

/usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c | /bin/gzip -9 > isidatabse.sql.gz

Database akan tersimpan di file

isidatabase.sql.gz

Referensi

• http://subair.wordpress.com/2010/03/28/coba-coba-materi-backup-database-mysql-di-ubuntu-server-manual-dan-otomatis/
• http://ngadimin.org/2009/03/24/backup-mysql-di-ubuntu-atau-di-debian/

Pranala Menarik

• MySQL
• Linux Howto
• Reset Password MySQL