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.

Syncing Filemaker database with Remote FM Server and MySQL server

Featured Replies

Hi All,

Here it is my (wannabe) solution:

A) One FM server 11A (Win Machine, unspecified so far), on the local Intranet, few clients (6) online
B) One FM Server 11B (Windows Server 2008 Machine), on remote server
C) One MySQL server on the remote server
D) 2 distinct Databases (filemaker 11 and PHPMySQL) with exactly the same structure (i.e fields and tables) BUT differejnt data: Users working on FM database and MySQL database will be different, there will be no overlapping or editing of the same record between the 2 interfaces

FM Server 11B and MySQL server are on the same remote machine.

What I would like to do:

The User (Jimmy as an example) insert a new record in the local intranet using Server A. Every now and then (let us say, every 3 hours) the updated database running locally should be uploaded from Server A (or even from a FM client (robot)) to Server B (Remotely). The new updated version should overwrite the previous one (3 hours old) and become the current one on Server B as well. Immediately after a sync between FM Data and MySQL data (receiving data from a totally different group of users) should be done so that an updated and current version of the database will be local and, after 3 hours, even on the remote machine (either in FM format, and MySQL format)

Would be possible to make all the procedure automatic and schedule it to happen every 3 hours ? We are not talking about an enormous amount of data (No images, just text, around 10 new records every 3 hours MAX, usually much less)

Thanks a lot for any help,

 

Diego

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.