Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Help! Moving Data from FMP 6 file to MySQL DB

A T Martin
in External Data Sources

Featured Replies

  • Newbies

Hello - I'm an old hack with FileMaker Pro but brand new to the SQL world and I'm learning hands on here... smile.gif

I need to move some data from my FMP database to my "MySQL" branded database at my web server. How do I do this?

Currently I have the MySQL ODBC Driver installed on my PC and it does connect to the database successfully (when using the "test connection" button in the driver setup app). I also have MySQL Control Center as my query application which I've used to connect to and set up tables in my remote database.

Now, all I need to know is how to actually move the data from the FMP 6 database to the remote MySQL database.

Do I use MySQL Control Center or FMP 6 to move the data from the FMP 6 database to the MySQL database? Once I know what application I use, I'll need to know how to actually do it. I've read the manual (Chapter 15 - ODBC) in FileMaker but it's still kinda gibberish to me right now - tho it's slowly sinking in... smile.gif

Any ideas or pointers to information for me? Thank you in advance.

A T Martin

I just made final recommendation on this issue: Lasso 6 from Blue World.

  • Newbies

also if you know anyone who knows perl, have them whip up a script. i had someone do a similar thing for me w/ perl. perl is powerful and portable.

Or PHP.

After checking various web languages I have the feeling, that Lasso 6 is for me the best. Obviously, for next person it can be something different.

Create an account or sign in to comment

https://fmforums.com/topic/17777-help-moving-data-from-fmp-6-file-to-mysql-db/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.