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, followed

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 to create countries since

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... 1. Can I also open the

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

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 includes half a dozen tables

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

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

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 USERNAME running