Backup isi database MySQL: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) No edit summary |
Onnowpurbo (talk | contribs) |
||
| Line 13: | Line 13: | ||
==Restore Database== | ==Restore Database== | ||
mysqladmin --user=usernamemysql --password=passwordmysql --force drop namedb | |||
mysqladmin --user=usernamemysql --password=passwordmysql create namedb | |||
contoh | |||
mysqladmin --user=root --password=123456 --force drop dvwa | |||
mysqladmin --user=root --password=123456 create dvwa | |||
restore database | |||
gunzip isidatabase.sql.gz | gunzip isidatabase.sql.gz | ||
mysql -u usernamemysql -ppasswordmysql namedb < isidatabase.sql | mysql -u usernamemysql -ppasswordmysql namedb < isidatabase.sql | ||
contoh | |||
mysqladmin -u root -p123456 dvwa < backup-dvwa.sql | |||
==Referensi== | ==Referensi== | ||
Revision as of 22:21, 27 May 2020
/usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c /usr/bin/mysqldump -u usernamemysql -ppasswordmysql namadb -c > isidatabase.sql
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
Restore Database
mysqladmin --user=usernamemysql --password=passwordmysql --force drop namedb mysqladmin --user=usernamemysql --password=passwordmysql create namedb
contoh
mysqladmin --user=root --password=123456 --force drop dvwa mysqladmin --user=root --password=123456 create dvwa
restore database
gunzip isidatabase.sql.gz mysql -u usernamemysql -ppasswordmysql namedb < isidatabase.sql
contoh
mysqladmin -u root -p123456 dvwa < backup-dvwa.sql
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
