Difference between revisions of "Backup isi database MySQL"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| Line 20: | Line 20: | ||
==Pranala Menarik== | ==Pranala Menarik== | ||
| − | * [[MySQL]] | + | * [[Perintah MySQL]] |
| + | * [[Instalasi MySQL]] | ||
* [[Linux Howto]] | * [[Linux Howto]] | ||
| + | * [[Backup isi database MySQL]] | ||
* [[Reset Password MySQL]] | * [[Reset Password MySQL]] | ||
| + | * [[Mengatasi Masalah Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock']] | ||
| + | * [[Masalah 'mysqld.sock' yang cukup menjengkelkan]] | ||
| + | * [[MySQL: Memperbaiki Corrupt Database]] | ||
| + | * [[MariaDB]] | ||
| + | |||
| + | |||
| + | [[Category: Linux]] | ||
| + | [[Category: Database]] | ||
Revision as of 09:58, 24 December 2012
/usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c
jika kita menginginkan agar file yang di hasilkan langsung di gz, kita dapat menggunakan perintah
/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/
- http://machine-cycle.blogspot.com/2008/04/backup-mysql-databases.html