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 inc

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

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

Exporting/Importing Databases

2004-06-02 Thread David Blomstrom
I just got my first MySQL database online, but I have some questions. First, if I want to import a database named, say username_jack, do I have to create a database named username_jack online first? In other words, could I access an online MySQL account that's empty, with no databases, then just i