Skip to main content

Import MySQL Data Dump Into Five (Local)

Last updated 17/10/2023

How to Import Your MySQL Dump​

You will first need to create your application. When you do this Five will automatically create and establish the connection with your database in MySQL. If you have already created your application, select your application in the list, click the Manage button and proceed to the section below, Edit Your MySQL File.

Create Your Application​

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​

Important
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​

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 Navigate and open your extracted MySQL file.

6. Click the OK button.


Ok button
Figure 9 - 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.

7. Click the Import Database Schema button.


Import Database Schema button
Figure 10 - Import Database Schema button

8. Click the Ok button.


OK button
Figure 11 - OK button

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

9. Select Data in the menu.

10. Select Tables in the sub-menu.


Tables menu item
Figure 12 - Tables menu item

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


Imported tables and fields
Figure 13 - Imported tables and fields