myisamchk multiple tables

[Dave#]

Anyone know how to myisamchk multiple tables [200] easier than doing them all one by one?

I have a disk full issue that screwed a whole load of tables and I want to find an easier way of repairing them.

Dave

[eva2000]

myisamchk -s -u root -p /path/to/vbdatabase/directory/*.MYI

[Dave#]

Thanks George - I got it anyways

./mysqlrepair -A -S /

[eva2000]

Originally posted by Dave#
Thanks George - I got it anyways

./mysqlrepair -A -S / that's a new one renaming mysqlcheck to mysqlrepair i see

[Dave#]

Originally posted by eva2000
that's a new one renaming mysqlcheck to mysqlrepair i see

Yes - more suited to 200 tables I think -

[eva2000]

Originally posted by Dave#
Yes - more suited to 200 tables I think - nope same as what i posted if you mean 200 tables in the same database

mysqlrepair can be done while mysql is running while myisamchk can't :)