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 ...
#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
2 posts • Page 1 of 1
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.