Backup isi database MySQL: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
No edit summary
Onnowpurbo (talk | contribs)
No edit summary
Line 12: Line 12:
  isidatabase.sql.gz
  isidatabase.sql.gz


==Referensi==
* http://subair.wordpress.com/2010/03/28/coba-coba-materi-backup-database-mysql-di-ubuntu-server-manual-dan-otomatis/





Revision as of 00:50, 7 September 2010

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


Pranala Menarik