Re: Table crashes after optimize

2003-09-25 Thread Antony Dovgal
On Thu, 25 Sep 2003 09:23:13 -0500 Ben Ricker <[EMAIL PROTECTED]> wrote: > Here is the output we got this morning: > > test.MESSAGES optimizeerror 13 when fixing table > test.MESSAGES optimizestatus Operation failed # perror 13 Error code 13: Permission denied check if

Table crashes after optimize

2003-09-25 Thread Ben Ricker
I am the admin of a Mysql 4.0.14-standard databas running on Solaris 9. A developer and I created a shell script that does a mysqldump of the database and then runs an optimize on the largest table we have. The command line is as follows: $EXECPATH/mysql --host=172.65.12.10 --user=user --password