Re: R: R: R: Going client/server, looking for tips

2006-08-08 Thread Ted Roche
On 8/8/06, Iames Pizzoli <[EMAIL PROTECTED]> wrote: 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. Check out the mysqldump program. There are lots

R: R: R: Going client/server, looking for tips

2006-08-08 Thread Iames Pizzoli
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 nee