Notifications
Clear all
Topic starter
19/02/2018 7:24 pm
Hi,
Importing a copy of my wp database onto a local OS X server running MAMP I get an error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
One solution discussed on the net said to change the table to MyISAM and then add FULLTEXT to the column index. I'm having trouble accomplishing that.
Has this been seen before?
Thanks,
Jason
20/02/2018 1:59 pm
Hi fiatlux,
1. Please update MySQL local server version.
2. If it doesn't help, remove tables, (which are recently created during import) from local server, then edit .sql file, find all ENGINE=MyISAM and replace to ENGINE=MyISAM, save and start to import to local server.