Paul,
> What I have done in the past was to write a Fox program to
> open a table, generate a CREATE TABLE command and scan
> through the table generating INSERT INTO commands. All this
> was saved into 1 big text files and executed on the SQL
> server. This way you can 'fix' the data as needed. For
> example, my dataset originated from DOS days and there were a
> few invalid dates in there. Also I did things like change
> dates (and strings?) to NULL where they were empty.
I've given some thoughts to write such a PRG myself, but then I
decided for a simpler PRG that eventually creates a TXT for every table,
which I then feed to LOAD DATA INFILE. There are only 9 tables in this app,
and some are simply lookup tables, not a big deal.
BUT I know that PostgreSQL has a command to do just this (generate a
CREATE TABLE.../INSERT INTO... text file for the whole database), and I
wonder if such a beast exixts for MySQL too. I could enjoy it when the time
comes to port these data from MySQL/Windows to MySQL/Linux. Can someone tell
me if it exists? What is there is a SELECT ... INTO OUTFILE 'file', but it's
limited to the current table and creates a simple TAB-delimited text file.
Mmmm...
Iames
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Corso base ASP Gratis - Video con trucchi e segreti per imparare a creare il
tuo Sito Web Dinamico con la tecnologia ASP
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5146&d=8-8
_______________________________________________
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.
