Weap.io allows you to schedule backups for your MySQL databases and to choose the storage location (
DigitalOcean Spaces and
Thanks to the intuitive user interface, getting started with your first MySQL backup is simple and fast.
Open your Weap.io dashboard and click on the
Database Backups menu button. On the page just opened, click the button
Weap.io needs to be able to connect to a server that can connect to your MySQL database. It can be the server on which the database is hosted or simply another server. Next, you need to enter the server details:
Friendly name: a friendly name that will help you recognize the server later
Server user: the user that Weap.io will use to SSH into the server. It can be
root or one specially created for Weap. If you need help creating a new user, check this guide.
Server IP or hostname: the IP or hostname of the server.
Server port: The SSH port of the server. The default one is 22.
After filling the details, click the button
Weap.io generated a new SSH key for your server. The key must be added to your
authorized_keys file. All the required instructions are already displayed during the setup process.
If everything went ok with the previous step, Weap.io was able to SSH into your server. Now it's time to establish a connection with your MySQL database. To be able to do that, you will need to enter the details of the database:
User: the user of the database. It can be root a one specially created for Weap. If you need help creating a new MySQL user, check this guide.
Password: the password of the MySQL user.
Host: the host of the database. If the database is stored on the same server added previously, it's
127.0.0.1. If the database is running on a remote server, the host will be the IP (or hostname) of that server.
Port: the port of the database, usually 3306.
After successfully connecting to the database, Weap will show you a list of all databases available. You can select 1, more or all databases available. After selecting the databases, click the button
Backup selected databases.
Congratulations! Your database is now automatically backed-up using the default retention policy and stored on your default storage location (the one provided by Weap if you didn't change it).
The next steps for you are:
How to change the backup frequency & retention policy of a database
How to change the storage of a database