Skip to main content

Import MySQL Data Dump Into Five (Cloud)

Last updated 8/02/2024

How to Import Your MySQL Dump

When working in the Cloud, you will need to use multiple logins due to permissions that are different from working as a standalone user in a local version of Five. The first thing you will need to do is create your application to import your FileMaker's data and schema. The role of Administrator is required to do this.

When you create an application, Five will automatically create and establish the connection with your database in MySQL. You can either use this database to import your FileMaker database schema or add a new database. If your application has already been created and you are an Administrator user, click the Manage button and proceed to the section below, Edit Your MySQL file.

Create Your Application

Prerequisite: The role of Administrator.

1. Click the Add Item button.


Add Item button
Figure 1 - Add Item button

2. Type a title in the Title field.

3. Click the Save button in the form app bar.


Add an application
Figure 2 - Add an application

4. Click the Manage button in the form app bar.


Manage button
Figure 3 - Manage button

Edit Your MySQL File

note
The name of your database must exactly match the name in the Database ID field as Five uses this in the connection string to connect to your database in MySQL. Five appends DB to the end of the application name, you will need to open your MySQL script either in Workbench or your preferred text editor and edit the name in two places.

Database ID must match database name in the script
Figure 4 - Database ID must match database name in the script

1. Navigate your files and open your MySQL script.

2. Edit the name of the database in the lines shown below.


Edit the database name
Figure 5 - Edit the database name

3. Save your MySQL script.


Save the script
Figure 6 - Save the script

Import Your Database

Prerequisite: The role of Administrator.

info
Performing the steps below will import the structure of your database as well as all the data from your FileMaker application.

1. Select Data in the menu.

2. Select Databases in the sub-menu.


Databases menu item
Figure 7 - Databases menu item

3. Select your database record in the list.

4. Click the Import Database button.


Import Database button
Figure 8 - Import Database button

5. Click the OK button in the alert box.

caution
When you click the OK button you will erase all the data in the database in Five.

OK button
Figure 9 - OK button

6. Navigate and open your extracted MySQL file.

7. Click the OK button.


Ok button
Figure 10 - OK button

info
Performing the steps below will read the structure of the database and automatically create the table definitions for you inside your Five application.

8. Click the Import Database Schema button.


Import Database Schema button
Figure 11 - Import Database Schema button

9. Click the Ok button in the alert box.

caution
When you click the OK button you will erase the current definition in Five.

OK button
Figure 12 - OK button

10. Click the Ok button.


OK button
Figure 13 - OK button

View Your Tables

Prerequisite: The role of Developer or Control.

info
Performing the steps below verifies all your tables with their fields and definitions were created.

1. Log in with your Developer or Control account.

2. Select the application record in the list.

3. Click the Manage button.

4. Select Data in the menu.

5. Select Tables in the sub-menu.


Tables menu item
Figure 14 - Tables menu item

6. Select a table record in the list and click the Fields tab.


Table and fields
Figure 15 - Tables and fields

caution
Double check that all your data types have come through correctly because in certain scenarios, Five may bring in some of your data types as Text.