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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.