How to take a backup of a database by using mysqldump in MySQL Server - MySQL DBA Training

How to take a backup of a database by using mysqldump in MySQL Server


demo explains

  • How to create new directory for MySQL Backups
  • How to change the ownership of MySQL backup directory
  • How to create the backup user that you will use to take backup of MySQL Databases
  • Execute mysqldump on linux shell to take backup of a database
you will use below syntax to run the backup of a database in MySQL Server

mysqldump --user=UserName --password=PasswordforUser DbName >/DestinationDirectory/BackupFileName.sql

How to take backup of a database by using mysqldump for MySQL Database