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
Exile SQL file import error
-
- New to forums
- Posts: 1
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Fri Jan 19, 2018 1:37 am
Re: Exile SQL file import error
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.