mysql error
 
Notifications
Clear all

mysql error

2 Posts
2 Users
0 Reactions
1,603 Views
(@fiatlux)
New Member
Joined: 7 years ago
Posts: 1
Topic starter  

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

Screen Shot 2018 02 19 at 9.47.21 AM
 

   
Quote
Astghik
(@astgh)
Illustrious Member Admin
Joined: 7 years ago
Posts: 6154
 

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.


   
ReplyQuote
Share:
Scroll to top