Backup isi database MySQL: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
/usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c | /usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c | ||
langsung di gz | 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 | /usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c | /bin/gzip -9 > isidatabse.sql.gz | ||
[[Database]] akan tersimpan di file | |||
Database akan tersimpan di file | |||
isidatabase.sql.gz | isidatabase.sql.gz | ||
Revision as of 00:40, 24 February 2011
/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
