Skip to main content

Export and Import SQL Files

Last updated 21/10/2024

You can export your data from the database for backup. This can be done for the MySQL database that Five automatically creates for you when you save an application, and any external databases that are connected in Five. Data exported will be exported in an SQL file.



Export an SQL Data Dump

1. Navigate to the Databases view.

2. Select the database record in the list.

3. Click the Export Database button.


Export Database button
Figure 1 - Export Database button

tip
A backup of your SQL can also be performed on the Cluster Managment page on the instance record!

Import an SQL Data Dump


caution
When you import a data dump, any existing data in the database will be removed and replaced with the imported data.

Import Data into Five's Default Database

1. Select the database record in the list.

2. Click the Import Database button.


Import Database button
Figure 2 - Import Database button

3. Navigate your files and open the compatible SQL file.

4. Click the OK button.


OK button
Figure 3 - OK button

Import Data into an External Database

When importing an SQL file into an external database, you need to have the Managed By Five switch in a true state to allow Five to make changes to your database. For an external database, if this switch is turned on, Five will manage the database schema when changes are made to the database definition in your application.

Tips
  • Your SQL file must be compatible with the type of database you are importing the data dump into!
  • Your database ID in Five must be exactly the same as the name of your external database!

1. Select the database record in the list.

2. Either click the Edit button in the form app bar, or directly in a field.

3. Click the Managed By Five switch.

4. Click the Save button.

info
The record must be saved first with the Managed By Five switch in a true state before importing your SQL file.