In this article, we are going to discuss how to backup MySQL databases with the help of SQLBackupAndFTP or using mysqldump. Organizing the backup process ought to be one of the components that are vital in the life of any DBA. Such a simple and easy procedure will definitely save you lots of time and effort in the future.
How to Backup MySQL Databases Using MySQLBackupFTP
Pass these simple steps to learn how to backup MySQL databases automatically using SQLBackupAndFTP.
- First of all, you need to download, install and run SQLBackupAndFTP, then click on the “Gear” button at the “Connect to Database Server” section and choose the way to connect to MySQL Server with the help TCP / IP or phpMyAdmin. Specify your Server name, Port, User Name, and Password, then press “Test Connection” to check the connection.
- Go to the “Select databases” section and press the “Gear” button and choose all databases from the list which you are going to backup.
- The next step you need to do is to specify a place where your backups will be stored. To do it click on the “plus” at the “Store backups in selected destinations” section and select backup destination places.
- Now it is necessary to create a MySQL Server backup schedule. To do it turn on the “Schedule backups” option and click on the “Gear” button to find the “Advanced settings”. In the “Advanced Backup Schedule” window add all necessary backup schedule settings and press “Save & Close”.
- Now all basic backup job settings are done and the backup job will run according to the selected schedule, also you can run it immediately with the help of the “Run Now” button.
This is the easiest way how to backup MySQL databases. All backup job settings will take about two minutes.
How to Backup MySQL Databases Using mysqldump
- From the very beginning, you need to open a Windows Command Prompt. To do it press “Start” and enter “cmd” into the dialog box then press the “Enter” button.
- Specify the directory to mysqldump utility – cd C:\Program Files\MySQL\MySQL Server 5.7\bin
- Create a dump of your current MySQL database. To do it run the mysqldump.exe using the following arguments:
mysqldump.exe --user=YourUserName --password=YourPassword --host=localhost --port=3306 --result-file="Path\dump.sql" --databases "DatabaseName"
- After you have made all necessary settings the program will connect to your current MySQL Server. A dump of your whole database will be made in the directory you specified in your D:\ directory.
Note, that you will not receive a message that will indicate the dump has been completed. The text cursor will simply move to the next line. That is how to backup MySQL databases using mysqldump.