Backup all MySQL Database by using mysqldump in separate files in TimeStamp directory

Backup all MySQL Database by using mysqldump in separate files in TimeStamp directory

You are working as MySQL DBA, you need to create script that should create a new TimeStamp Directory in /mysqlbackup directory and then take backup of all databases in separate files.

Solution:
The below script can be used to create new TimeStamp directory every time you will run the script and then it will run mysqldump for each of the database on your MySQL Server.

Replace the backupuser with your user name and 'MyPassword$123' with the password you are using for your user in MySQL server to run mysqldump.

Link to post for scripts used in the video

To follow step by step tutorial for MySQL DBA for beginner to Advance

MySQL Backup Restore Database Tutorial
MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin