Re: corrupt innodb database

2011-08-01 Thread a . smith
PS and put back the two log files you moved. PPS if you don't have any space currently to do what I suggested then at least softlink the log files from /tmp to their original locations. Quoting a.sm...@ukgrid.net: Quoting supr_star : This db is on its own partition, so I can't delete logs o

Re: corrupt innodb database

2011-08-01 Thread a . smith
Quoting supr_star : This db is on its own partition, so I can't delete logs or anything else to clear up space.  So I moved ib_logfile0 and ib_logfile1 This is a really bad idea as will break all ur InnoDB databases. Do you have space elsewhere on other partitions on the server? If yes mo

corrupt innodb database

2011-08-01 Thread supr_star
I'm not sure if this is the correct way to post, my apologies if it's not..   Anyway, I have a zabbix system on a mysql database where the ibdata1 file grew to 93GB and filled up the disk.  Restarting mysql results in: /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! Th