Last time we talked about how to restore your MySQL database from a backup with phpMyAdmin. Let’s continue to review other tools to work with mysql database backups.
MySql Backup FTP (in short MySqlBF) is a GUI tool for automating MySQL database backup. In addition to TCP/IP connection it has a unique feature of backing up MySQL database through phpMyAdmin. It is often the only way to connect to many hosted MySql databases where TCP/IP connection is restricted. No other tool other than MySqlBF currently allows automating backups through phpMyAdmin. This post will explain indetails how to set it up.
Connect to MySql Server
Launch MySqlBF tool and click “Connect to MySql Server” button. Supply phpMyAdmin URL and login credentials on the “Connect” dialog:
Click “Test MySql Connection”:
Select databases for backup
After saving the connection you can select the databases that you would like to backup right on the main window:
Configure backup destination
Click “Add backup destination” link to select where to send the backups for storage:
Configure destination, for example if you’ve selected to send backups to an FTP server – specify the host address and login:
You can specify many export options in Main Window -> Advanced Backup Settings -> More SQL Options…
Run MySql backup
Now it’s time to aave job settings and press “Run Now” button:
That’s all. You can schedule this backup and can be certain that your data is always safe even if you have no a direct access to the host where your database is.