Have a simple, flat file database that is being maintained in FileMaker Pro 10.
Want to import it into MySQL. The MySQL database will be the data source for a PHP-based dynamic website.
Do not expect to need to transfer data from MySQL back to FileMaker Pro.
FileMaker can export the file as:
Tab-Separated Text format -- .tab or .txt
XML format -- .xml
Microsoft Excel format -- .xls or .xlsx
Comma-Separated Text format -- .csv or .txt
HTML Table format -- .htm
Merge format -- .mer
(FileMaker Pro format -- .fp7)
Field contents include:
text (as much as 10 Kbytes per field, will contain commas)
integers (up to a value of 1,000,000)
dates
Would one of the file formats above work well when imported into MySQL? If several are good, is one preferred for importation into MySQL?
Thanks in advance for your help.
XAMPP Lite 1.7.3
XP Pro, SP 3