"PaT!" <[EMAIL PROTECTED]> wrote: > > I need a hint how to use myisamchk > > I use this syntax in a shell but it doesn't work > > myisamchk -R=ID \mysql\data\db\mytable.myi > > ID is the index name I want to use to sort the table > > I'm using mysql 4.0.13 on Win 2K server
myisamchk -Rindex_number /path/to/the/index/file/table_name.MYI Index number you can see using SHOW INDEX command. For example: myisamchk -R1 /var/lib/mysql/mydatabase/table1.MYI -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]