Mysql Database backup & restore command

Mysql single database backup:-

mysqldump --force --opt --single-transaction --lock-tables=false --skip-events --user=root --password=xxxx --routines --databases testdb > singledb.sql

Mysql all database backup:-

mysqldump --force --opt --single-transaction --lock-tables=false --skip-events --user=root --password=xxxx --routines --all-databases > all_databases.sql

Mysql Restore database:

mysql -u root -predhat dbname < /mnt/dbname.sql



Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.