Backup isi database MySQL

From OnnoWiki
Revision as of 10:26, 12 January 2024 by Onnowpurbo (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Dump isi database MySQL

/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

mysql -u root -p123456 dvwa < backup-dvwa.sql

Youtube


Referensi

mysqldump ke csv

mysqldump -u your_username -p your_database_name your_table_name --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='\n' > outputfile.csv
-u MySQL username.
-p prompts MySQL password.
your_database_name database berisi table
your_table_name table
--fields-terminated-by=',' set field separator ke comma
--fields-enclosed-by='"' set field enclosed ke "
--lines-terminated-by='\n' line terminator
> outputfile.csv redirect output ke CSV file.


Pranala Menarik