Exile SQL file import error

Post Reply
Habits
New to forums
New to forums
Posts: 1
Joined: Fri Jan 19, 2018 1:37 am

Exile SQL file import error

Post by Habits » Fri Jan 19, 2018 2:00 am

The SQL file that came with the exile server files was meant to create a database from scratch but with a NFO web host that isn't possible since databases have to be created through the cpanel. I had an error that stated access denied because it was trying to create a database but because of security reasons it's not allowed to do so. I quickly fixed this error by deleting the code that was trying to create this database and just have it import the tables from the SQL file. Unfortunately it came back with an error stating ...

Error
MySQL said:

#1215 - Cannot add foreign key constraint

I cannot figure this out for anything. I am quite new to SQL so help would be much appreciated.

here's a dropbox link to the file

https://www.dropbox.com/s/pd7md0gfv407s ... e.sql?dl=0

User avatar
Spray
Staff
Staff
Posts: 543
Joined: Wed Dec 28, 2011 10:41 pm
Location: Oregon

Re: Exile SQL file import error

Post by Spray » Mon Jan 22, 2018 9:36 am

On the "Import" tab in phpMyAdmin, ensure you deselect the "Enable foreign key checks" option there. If this isn't deselected, the foreign key checks fail, since the first table created attempts to add a key from a table that doesn't yet exist, as it's created further down within the SQL file.

Post Reply