Backup & Restore MySQL

Backup MySQL Without Compression :

mysqldump -u <user_mysql> -p <nama_database> > <nama_file_backup>
cth :
mysqldump -u root -p db_microsite  > db_microsite.sql.gz

for 1 more database
mysqldump -u <user_mysql> -p <nama_database1> <nama_database2> <nama_database3> > <nama_file_backup>

for all database
mysqldump -u <user_mysql> -p <nama_database1> -all-databases > <nama_file_backup>

Restoring MySQL Without Compression :

mysql -u <user_mysql> -p <nama_database> < <nama_file_backup>
cth :
mysql -u root -p db_microsite < db_microsite.sql.gz

Backup MySQL With Compression (Gunzip) on Linux :

mysqldump -u <user_mysql> -p <nama_database> | gzip -9 > <nama_file_backup>
cth :
mysqldump -u root -p db_microsite | gzip -9 > db_microsite.sql.gz

Restoring MySQL With Compression (Gunzip) on Linux :

gunzip < <nama_file_backup> | mysql -u <user_mysql> -p <nama_database>
cth :
gunzip < db_microsite.sql.gz | mysql -u root -p db_microsite