Get started

Get started with MySQL backups.

Weap.io allows you to schedule backups for your MySQL databases and to choose the storage location (AWS S3, Wasabi, DigitalOcean Spaces and Backblaze B2).

Our MySQL backup solution comes with a default storage location of up to 250GB. That's in case you don't want to bring your own storage.

Thanks to the intuitive user interface, getting started with your first MySQL backup is simple and fast.

1. Open Weap.io dashboard

Open your Weap.io dashboard and click on the Database Backups menu button. On the page just opened, click the button Add database.

2. Add a new server

If your server was already added previously, you can skip this step by clicking "Choose an existent server".

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 Next.

3. Add the SSH key to the server

If your server was already added previously, you can skip this step by clicking "Choose an existent server".

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.

4. Connect to the database

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 localhost or 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.

5. Select the databases to backup

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.

6. Conclusion

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