Mark,
> Is the only reason for this the fact that I have mysql running? Are
> mysqlcheck and myisamchk doing the exact same thing. Or are
> there scenarios in which one reports errors and the other doesn't.
mysqlcheck and myisamchk are doing the same things _basically_.
mysqlcheck does all the op
Hi,
I have a question about using myisamchk and mysqlchk.
I am running myisamchk -s on a certain table and get this error:
/usr/local/mysql/bin/myisamchk: MyISAM file /usr/local/mysql/var/db1/my_table.MYI
/usr/local/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed the table
prope
Hi!
On Dec 27, Thomas Spahni wrote:
> Hi everyone
>
> I am using 3.23.39 and newer on Linux and do:
>
> me> mysqladmin flush-tables
> me> myisamchk --keys-used=0 -rq /path/to/db/tbl_name
>
> before inserting lots of data (15 mio rows) with LOAD DATA INFILE
>
> and then re-create the indexes w
Hi everyone
I am using 3.23.39 and newer on Linux and do:
me> mysqladmin flush-tables
me> myisamchk --keys-used=0 -rq /path/to/db/tbl_name
before inserting lots of data (15 mio rows) with LOAD DATA INFILE
and then re-create the indexes with
me> myisamchk -r -q /path/to/db/tbl_name
as suggest
