How to back up and restore a MYSQL database by command line

Here is how to back up and restore a MYSQL database by command line Back up a MYSQL database: Code: ——— mysqldump –opt -Q -u dwhs_dwhs -p dwhs_wrdprss*A* > /home/dwhs/workroom/dwhs_wrdprss1.sql ——— Restore a MYSQL database: Code: ——— mysql -u dwhs_dwhs -p dwhs_wrdprss*B* < /home/dwhs/workroom/dwhs_wrdprss1.sql ———

10 ways to backup mysql

1. Automatically backup mysql database to Amazon S3 MySQL Backup Solution Many of users use Amazon S3 to backup their mysql databases. Here is an automated script which does this task of taking the backup of a mysql database and then moving it to the Amazon S3. 2. How to Backup MySQL Database automatically (for… Continue reading 10 ways to backup mysql