Is there a way to convert FilePro db to MySql?
Please Help!
Filepro to Mysql
6 days later
is that filemaker pro if it is just convert data into a csv or tab deliminated file. you can use that to restore data it wont create a db for you. I did a lot of fmpro before Mysql and I have converted all the files over it is possible.
4 years later
I have written an application that will convert a filepro database to mysql. It uses only the raw filepro files and no filepro programming, proprietary code or information. What is required is the map, key and data files for each "table" in filepro. Filepro stores its table in subdirectories.
The application will allow you to upload a tar gzipped file containing the map, key and data files. It will then extract the files and create a mysql database called filepro and populate it with the table names derived from the directory names in the extracted upload. You will then be able to import each of the tables by choosing them from a drop-down list. If the data files are large, this process can take quite some time. ex. for a table with 150,000 rows, it will take about 90 minutes.
Once all of the tables have been imported into MySQL, you can then export the information back out into either a standard ansi sql file or in tab-delimited format.
The application is web-based but can also be used with the php command line interface and incorporated into a shell script to perform the entire filepro to mysql conversion unattended.
It uses php 4.3.x with the filepro module and mysql 3.23.x.
I wrote this application for a specific client, but I would imagine it would be of use to others.
For more information, please contact me at bakerd@mgtinfoconsultants.com