A new Flexera Community experience is coming on November 18th, click here for more information.
mysqldump -u [user] -p [database_name] > [filename].sql
To backup of an entire Database :
mysqldump --all-databases --single-transaction --quick --lock-tables=false > full-backup-$(date +%F).sql -u root -p
To include more than one database in the backup :
sudo mysqldump -u [user] -p [database_1] [database_2] [database_etc] > [filename].
sql
Important: If you have dual SVM-on-premise Application and DB server setup. Then edit the following part of the above commands to take the backup.
mysql -u [user] -p -h <Database Sever Name>
Dec 11, 2019 04:44 AM - edited Nov 27, 2020 04:08 AM