Thread: Import problem on full restore (structure and data)

When importing a database dump with both structure and data - the import will fail due to FriendList creating a key using Profiles, which has yet to be imported.

Code:

ERROR 1064 at line 198395: You have an error in your SQL syntax.  Check the manu
al that corresponds to your MySQL server version for the right syntax to use nea
r 'tinyint(2) NOT NULL default '0',
  UNIQUE KEY FriendPair (ID,Pr

I found this and used quotes and problem was fixed.

Code:

mysqldump --user=USER --password=PASS -Q DATABASE > db_bkp_before_IQ