Re: Exporting/Importing Databases

2004-06-03 Thread Robert A. Rosenberg
At 21:54 -0700 on 06/02/2004, David Blomstrom wrote about Re: Exporting/Importing Databases: --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: >Third, my practice database in

Re: Exporting/Importing Databases

2004-06-03 Thread David Blomstrom
Wow, I tried importing my SQL file again, with the referential integrity statements. This time I got a NEW error: Database geoblue_world - Table continents running on localhost Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also he

Re: Exporting/Importing Databases

2004-06-03 Thread David Blomstrom
--- Egor Egorov <[EMAIL PROTECTED]> wrote: > David Blomstrom <[EMAIL PROTECTED]> wrote: > >> If you use command-line client you can do: > >> > >> mysql> SET FOREIGN_KEY_CHECKS = 0; > >> mysql> SOURCE file_name; > >> mysql> SET FOREIGN_KEY_CHECKS = 1; > > > > Does anyone on this list know... > >

Re: Exporting/Importing Databases

2004-06-03 Thread Egor Egorov
David Blomstrom <[EMAIL PROTECTED]> wrote: > --- Egor Egorov <[EMAIL PROTECTED]> wrote: >> David Blomstrom <[EMAIL PROTECTED]> wrote: >> > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> >> wrote: >> >> You just got caught with the old Referential >> >> Integrity Gotcha. It >> >> will not allow you

Re: Exporting/Importing Databases

2004-06-03 Thread David Blomstrom
--- Egor Egorov <[EMAIL PROTECTED]> wrote: > David Blomstrom <[EMAIL PROTECTED]> wrote: > > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> > wrote: > >> You just got caught with the old Referential > >> Integrity Gotcha. It > >> will not allow you to create countries since > >> statesarticles does

Re: Exporting/Importing Databases

2004-06-03 Thread Egor Egorov
David Blomstrom <[EMAIL PROTECTED]> wrote: > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: >> At 20:36 -0700 on 06/02/2004, David Blomstrom wrote >> about >> Exporting/Importing Databases: >> >> >Third, my practice database includes half a dozen >> >tables, but only one made it online, fol

Re: Exporting/Importing Databases

2004-06-02 Thread David Blomstrom
--- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: > At 20:36 -0700 on 06/02/2004, David Blomstrom wrote > about > Exporting/Importing Databases: > > >Third, my practice database includes half a dozen > >tables, but only one made it online, followed by > this > >error message: > > > >Database U

Re: Exporting/Importing Databases

2004-06-02 Thread Robert A. Rosenberg
At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: Third, my practice database includes half a dozen tables, but only one made it online, followed by this error message: Database USERNAME running on localhost Error SQL-query : CREATE TABLE `counties` ( `SCod

Re: Exporting/Importing

2001-04-13 Thread Jeremy Zawodny
On Fri, Apr 13, 2001 at 01:48:26PM -0700, Ravi Jayagopal wrote: > Hi, > > I need to export data from development to production. > > Development - Win98 > > Production - Unix > > What is the best way to transport data to & fro dev & prod ? > > mysqldump doesn't seem to work - keeps giving me e