Difference between revisions of "Backup isi database MySQL"

From OnnoWiki
Jump to navigation Jump to search
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 07: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