Backing up and exporting a database of your database server

Last updated 16th September 2020

Objective

Your database can contain a lot of essential information for your website. It is therefore important to be able to save it, or even export it.

Find out how to back up and export your database from your database server.

Requirements

• a Private SQL Web Hosting plan or a Cloud Database
• access to the OVHcloud Control Panel

Instructions

Backing up and exporting a database from the Control Panel

Log in to your OVHcloud Control Panel and select Web Cloud in the top navigation bar. Click Databases in the services bar on the left-hand side, then choose the SQL instance concerned. Next, go to the Databases tab.

In the Backups column, the number corresponds to the number of backups available for your database.

1. Launching a manual backup

Click the ... button to the right of the database, then click Back up now.

2. Exporting a backup

Click the ... button to the right of the database, then click Show backups

The list of available backups will appear. Click on the ... button to the right of the backup you want to create, then click Download the backup to retrieve this backup.

Backing up and exporting a database outside the Control Panel

1. Exporting MySQL or MariaDB databases

In some cases, the RAM available in your database server may not be sufficient to perform the desired import. If this is the case, we recommend using the tool available in the OVHcloud Control Panel. This will enable you to use resources external to your solution.

1.1 Exporting a MySQL or MariaDB database with OVHcloud phpMyAdmin (for Private SQL only)

To export your database directly from phpMyAdmin, you will need to log in to the interface first. To do this, you can refer to our guide on connecting to a database.

Once you have logged in to phpMyAdmin, click on the name of the database you want to export, then on the Export tab at the top.

You have two possible export modes. If you do not have a specific need, we recommend using quick mode in SQL format.

1.2 Exporting a MySQL or MariaDB database from the command line

mysqldump --host=server --user=username --port=port --password=password database_name > database_name.sql

1.3 Exporting a MySQL or MariaDB database with a PHP script

1. <?php echo "Your database is being backed up.......";
2. system("mysqldump --host=server --user=username --port=port --password=password database_name > database_name.sql");
3. echo "Completed. You can retrieve the database via FTP.";
4. ?>

2. Exporting and importing PostgreSQL databases outside the Control Panel

In some cases, the RAM available in your database server may not be sufficient to perform the desired import. If this is the case, we recommend using the tool available in the OVHcloud Control Panel. This will enable you to use resources external to your solution.

2.1 Exporting my PostgreSQL database from the command line

pg_dump --host=server --port=port --user=usernmame --password=password database_name > database_name.sql

2.2 Exporting a PostgreSQL database with a PHP script

1. <?php echo "Your database is being backed up.......";
2. system("PGPASSWORD=password pg_dump --host=server --port=port --user=username --password=password database_name > database_name.sql");
3. echo "Completed. You can retrieve the database via FTP.";
4. ?>

Go further

Restoring and importing a database to your database server

Join our community of users on https://community.ovh.com.

These guides might also interest you...