For those who looking for way to backup mysql database,
you can use mysqldump to backup mysql database.
Below is the script example to backup mysql database in command line:-
$ mysqldump -h localhost -u username -p database_name > backup_db.sql
If your mysql database is very big, you might want to compress your sql file. Continue reading How to backup MySQL Database in command line with compression »
Just use the mysql backup command below and pipe the output to gzip,
then you will get the output as gzip file.
