Backup MySQL Database

Backup MySQL Database to Backblaze Using SnapShooter

Manually backing up MySQL to Backblaze Bucket is a very time-consuming process. You will need to create and compress a backup every time then upload it to Backblaze Bucket manually. You can't control and manage it automatically. In this case, SnapShooter provides an easier way to create a backup, compress it and schedule it automatically for you. Also, SnapShooter provides a web-based control panel to manage all your backup jobs from the web browser.

Follow the below steps to back up the MySQL database to Backblaze Bucket:

Step 1 - First, go to the SnapShooter website and register for their 14-day free trial.

Step 2 - On the SnapShooter dashboard, click on the Backup Jobs in the left sidebar. You should see the following screen:

Step 3 - Click on the Create New Job. You should see the various database option on the following screen:

Step 4 - Click on the All MySQL Databases. You should see the following screen:

Step 5 - Provide your job name and click on the Continue button. You should see the Add Your Server screen:

Step 6 - Now, copy the code shown on the above screen and paste it to your MySQL server as shown below:

curl -sSL "https://ingestor.snapshooter.com/api/server/add?token=eyJpdiI6Ijg5TjMycmpOUGl4bitLSElROVN0U2c9PSIsInZhbHVlIjoiTGRyd01LcW9kMm96SlJMNDRzSkFPUT09IiwibWFjIjoiMjRkMjE0YmU4ZWYwMjM3YWIzMTA3MDEyYzdmYzViNzgzMmVhMzQwNmJiNzA3YmZiYWUzNDVkNTI1NmE3MzQ0NCIsInRhZyI6IiJ9&key=5895" | bash

Once your server is added to the SnapShooter, you will get the following output:

Welcome to SnapShooter Server Setup
Environment Detected: OS: linux, OS Type: amd64
Installing SSH public key
Creating temp SSH key file
grep: /root/.ssh/authorized_keys: No such file or directory
cp: cannot stat '/root/.ssh/authorized_keys': No such file or directory
Creating authorized_keys backup /root/.ssh/authorized_keys.bak-1648479522
Key Installed /root/.ssh/authorized_keys
Removing temp SSH key file
Scanning SSH config
Checking 22
matched (22)
SSH test confirmed, Server Added to SnapShooter ...

Step 7 - Once your MySQL server is added to the SnapShooter, you should see the following screen:

Step 8 - Click on the Next button. You should see the MySQL database configuration screen:

Step 9 - Provide your MySQL username, password, host, port, and click on the Test button to test the connection. If everything is fine, you should see the following screen:

Step 10 - Click on the Save and Next button. You should see the Storage Selection screen:

Step 11 - Here, you will need to define your Backblaze Bucket to store the MySQL database. Click on the Add New Storage Provider. You should see the following screen:

Step 12 - Click on the Config S3 button. You should see the following screen:

Step 13 - Provide your friendly name, select your storage provider, define your region, provide your Backblaze Bucket name, Access Key, and Secret Key, and click the Test and Save button. Once your Backblaze is connected to the SnapShooter, you should see the following screen:

Step 14 - Click on the Set Storage button to set your Backblaze as default storage. You should see the Backup Schedule Setup screen:

Step 15 - Select and define all options as per your requirements and click on the Set Schedule and Finish button. You should see the following screen:

Step 16 - Click on the Backup Now button to run your first backup job. Once your backup job is executed successfully, you should see the following screen:

Now, go back to your Backblaze Bucket and verify your backup as shown below:

Depending on your compression level and the size of the backup, it may take time to complete. Every minute SnapShooter will go and check the process to see how far it has got. Using the Log button, you can see the latest state the backup is in.