Hello.
Please provide information about MySQL and operating system versions. Include your configuration file. This link might be helpful in case you want to save your data: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html Mayuran Yogarajah wrote: > Mayuran Yogarajah wrote: > >> Here is a small portion of the error log: >> >> InnoDB: Error: trying to use a corrupt >> InnoDB: table handle. Magic n 13459851911327004931, table name mysqld >> got signal 11; >> This could be because you hit a bug. It is also possible that this binary >> or one of the libraries it was linked against is corrupt, improperly >> built, >> or misconfigured. This error can also be caused by malfunctioning >> hardware. >> We will try our best to scrape up some info that will hopefully help >> diagnose >> the problem, but since we have already crashed, something is >> definitely wrong >> and this may fail. >> >> key_buffer_size=67108864 >> read_buffer_size=1044480 >> max_used_connections=1 >> max_connections=160 >> threads_connected=1 >> It is possible that mysqld could use up to key_buffer_size + >> (read_buffer_size + sort_buffer_size)*max_connections = 1539454 K >> bytes of memory >> Hope that's ok; if not, decrease some variables in the equation. >> >> >> Is this equation out of date? It differs from the formula in the >> current documentation. This one >> doesn't take into consideration innodb_buffer_pool size or >> binlog_cache_size. >> >> M >> > Initially I thought I was dealing with a memory problem but it seems now > that some tables are corrupt. It looks like the trouble began > at around 6am, which is when our backup script (which calls mysqldump to > dump the databases) also runs. Has anyone had similar > problems? Why would mysqldump cause corruption in the database? > > M > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
