MySQL Forums
Forum List  »  MyISAM

Cannot display index entries
Posted by: Pavlos Ponos
Date: November 07, 2015 11:04AM


I have installed the 5.6 in my server.
I have the following table:
data (ID int unsigned auto_increment not null primary key, text varchar (20000)) character set 'utf8' engine=myisam;

And I built a full-text-index in text column.
Tables in my server stored under /var/lib/mysql/

Neither myisam_ftdump nor myisamchk run..

Examples I tried are:
myisam_ftdump --help;
myisam_ftdump data 1;
myisam_ftdump /var/lib/mysql/elsa/data 1;
myisamchk -dv data;
myisamchk -dv /var/lib/mysql/elsa/data;

all of them returned the following error message:
ERROR 1064 (42000): 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 'blablabla' at line 1

Can you please let me know what I'm doing wrong?

Thanks in advance!

Options: ReplyQuote

Written By
Cannot display index entries
November 07, 2015 11:04AM
November 07, 2015 01:46PM
November 07, 2015 01:47PM
November 30, 2015 08:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.