|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-01-2007, 9:34 PM
| #1 | ||
 |
I just imported an sql backup. I had to SET FOREIGN_KEY_CHECKS=0 otherwise I would get an error 150 when it tried to create a table that had a foreign key (because of course the table it was referencing did not exist yet). But now the database has no foreign keys in it. How do I import the sql file and have the keys be created as well? | ||
      |
| Featured Websites | ||||
|
|
| Tags: foreign, import, keys, sql |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Foreign key | Bruno Guerpillon | Database | 2 | 07-01-2007 6:42 PM |
| Compound and foreign keys | Jimi Hullegård | Database | 3 | 07-01-2007 6:23 PM |
| foreign key constraint | marco | Database | 0 | 05-31-2007 8:42 PM |
| examples of INNODB & foreign keys | matt | Database | 3 | 05-31-2007 8:42 PM |
| Keys into keys in template flexy | Jandro brozaman | Pear | 1 | 05-20-2007 6:34 PM |
| Featured Websites | ||||
|
Sql Import with Foreign Keys 
PacMan
Linear Mode
