Introduction
MySQL Workbench is a powerful tool for managing your database and viewing data mapped from your Podio apps. With thatapp.io’s seamless integration, you can configure MySQL Workbench to manage and analyze your synced data efficiently. This guide walks you through setting up MySQL Workbench, viewing data, and managing database tables.
Step 1: Download and Install MySQL Workbench
To begin, ensure you have MySQL Workbench installed on your computer. If you haven’t:
Visit MySQL Workbench's official page to download the installer.
Follow the on-screen prompts to install the application.
Step 2: Create a Connection in MySQL Workbench
Launch MySQL Workbench and locate the MySQL Connections section on the home screen.
Click the + (plus) icon to create a new connection.
Connection Setup Details:
Head to your connector in thatapp.io and copy the connection details into your workbench to set up. To see the connection details, click on the "View Connector" icon on the connector table. The details are explained below.
Connection Name: Enter a unique name for your connection (e.g., "Thatapp Database Connection").
Connection Method: Select Standard TCP/IP (default).
Hostname: Enter the host IP address provided in your thatapp.io connection details.
Port: Leave the default port as 3306 unless otherwise specified.
Username: Input the database username from thatapp.io connection details.
Password: Click Store in Vault to securely save the password from your connection details.
After filling out the details, click Test Connection to verify the setup. If successful, click OK to save the connection.
Step 3: Open Your Connection
Locate the newly created connection under the MySQL Connections section.
Click the connection name to open your database. This will load the workspace where you can view and manage data.
Step 4: Viewing Synced Data in Your Database
In the workspace, click on the Schemas tab to access the database tables.
Expand the database name to reveal all synced tables and data structures.
Locate the app or space table you want to view.
To view table data:
Right-click on the table name and select "Select Rows - Limit 1000".
This action opens a grid view of the table, displaying the first 1000 rows of data.
Compare the data with your Podio records to ensure the sync was successful.
Step 5: Managing Data in MySQL Workbench
Edit Data:
Double-click any cell in the table grid to modify its content.
Press Enter to save changes.
Save Updates Locally:
After editing or inspecting the table, click File > Save Script As to save the database script to your local storage.
Choose a descriptive name and save the file for backup or future use.
Inspect Deleted Data:
If you enabled the "delete sync" option during mapper setup, check the database to confirm that deleted Podio items are removed from the table.
Pro Tips for Efficient Management
Use descriptive names for connections to differentiate between multiple organizations or databases.
Regularly test connections to avoid syncing disruptions.
Periodically export database backups to ensure data security.