Difference between revisions of "Backup isi database MySQL"

From OnnoWiki
Jump to navigation Jump to search
Line 16: Line 16:
  
 
* http://subair.wordpress.com/2010/03/28/coba-coba-materi-backup-database-mysql-di-ubuntu-server-manual-dan-otomatis/
 
* 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://ngadimin.org/2009/03/24/backup-mysql-di-ubuntu-atau-di-debian/
 +
* http://machine-cycle.blogspot.com/2008/04/backup-mysql-databases.html
  
 
==Pranala Menarik==
 
==Pranala Menarik==

Revision as of 07:52, 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