Yo Yo Mr. P - Here's my shortlist:
1. want primary keys and NEVER USED THEM BEFORE ? add them at the end of a table structure in mySql as an autoinc column 2. I prefer CSV or SDF on the output types from VFP, if you wish to stick to using the INFILE . I do a lot of work on remote systems, and INFILE is your friend. There is a bug in some mySql instances, if it was not compiled with the right switch (I'll find the reference and post it back to here later today/tonight), that causes a blip/burp in appending data using infile. It's evil, it's heinous, and causes me to do inserts via odbc across the internet instead. 3. why not use ODBC and SPT ? I have codebase in vfp that will recreate the structure in mySql via spt, add in the primary keys (again at the end of a table structure), then start a scan..endscan on a collection of tables, slinging data about into the mySql instance . - The basic sequence - a. look at a table, write the structure to an array b. take the array, parse it, create <text> that mimics a sql [create table] codeblock, adding in a PK at the end. c. process the codeblock via spt into the mySql db instance, creating the table. look at sqlconnect, sqlexecute in vfp help d. look at the table, create <text> that handles the insert statement (insert into tablename (field list if needed) values (?field1, ?field2 ...) . The ? is important, as it will force , during the spt via odbc, the actual value of the column to be evaluated and passed over, regardless of the data type. e. process the insert spt codeblock - end of basic sequence - Now - the FUN thing about doing is THIS WAY - 1). table names are the same in vfp and mySql 2). column/field names are the same name AND IN THE SAME ORDER . 3). since I am relying on positional stuff (column names, field names) I was able to automate it, not carrying about manually WRITING IN THE NAME OF THE FIELD during table creation or record insert. 4). I don't include the primary key field data or column name on insert, i let the mySql db handle it. -=-=-= 4. if you need something visually use myphpadmin. If you haven't touched any mySql instance yet (but I think you have, yes?) then look at the installer package for WAMP from www.foxserv.net 5. forget yer vfp compound indices for now 6. Ages past I gave a free analysis about this see http://efgroup.net/mysql.html It's no longer free, so if you need some assistance, let me know. 7. review http://groups.yahoo.com/group/vfpmysql and http://fox.wikis.com/wc.dll?Wiki~VFPmySQLLinuxP1~VFP Lots of folk were able to make that initial online lecture and go forth with other stuff. Good Luck. regards [Bill] -- William Sanders / efGroup {rmv the DOT BOB to reply} Mondo Cool DSL -> http://www.efgroup.net/shopfordsl.html VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting Failing dotNet Project? -> http://www.dotnetconversions.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
