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.
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.
Figure 2 - Import Database button
3. Navigate your files and open the compatible SQL file.
4. Click the 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.