Difference between revisions of "Backup isi database MySQL"

From OnnoWiki
Jump to navigation Jump to search
Line 6: Line 6:
  
 
  /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
 +
 +
isidatabase.sql.gz
 +
  
  

Revision as of 07:16, 20 April 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


Pranala Menarik