Contact

Call

Call us

Our support team is happy to help you, be it for technical or administrative issues. We’re there for you!

 

+43 (0)720 511 555

(Calls from the Austrian landline 0.25 EUR / minute)

 

Monday to Friday/Saturday1
9:00 am – 12:00 pm & 1:30 – 5:00 pm

1 Administration: Monday to Friday, technical support: Monday to Saturday

Write

Write to us

To be able to help you as quickly and effectively as possible, we kindly ask that you make your request as specific as possible. And of course you can contact us by email: support@hoststar.at

Creating a manual MySQL database backup

Support > Hosting > MySQL databases

If you are logged into the administration interface of the MySQL databases, you can import the database backup file from the relevant database by following these steps:

1. Selection

If you have access to multiple databases with the MySQL user you logged in with, open the MySQL database into which you want to import the backup. Click the relevant database names in the grey column at the left.

2. Export

Click the «Export» button at the top edge of the screen.

3. Configure the export

You have the following configuration options for the selected MySQL database:

If you want to back up a database to a file, select «Export Method» → «Custom – show all possible options».

Under «Table(s)», click «Select all» to include all database tables in the backup.

If you only need certain tables, you can also select tables individually.

Select «Save output to file» under «Output» and, if desired, make changes to the character encoding or compression used for the export (useful for large databases).

Under «Format», «SQL» is selected by default and can be used to import a database at a later date. You can select different formats for different purposes.

4. Export database

Typically, you can leave the other settings unchanged when performing a database backup, and then click «OK» to start downloading the database backup.

5. Download backup

After clicking «OK», the MySQL database backup is shown as a downloadable file. This may vary depending on the browser.

Save the file (here, «CMSWebsite.sql») to your device.

This completes the procedure for manually creating a MySQL database backup.

Was this article helpful?