MySQL Forums
Forum List  »  MyISAM

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

Hello,

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!
Pavlos

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot display index entries
2321
November 07, 2015 11:04AM
1333
November 07, 2015 01:46PM
1386
November 07, 2015 01:47PM
1466
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.