hello ,
i have just restored a backup copy of all mysql files which includes both mysql and innodb tables mixed in each database .i have also restored ibdata1 file which is auto extended by 10M .
the problem is when i try to view them through PhpMyadmin i see the innodb tables of some db's are in use when i try to repair them i get the above error .
on backtrace i get this on every query on innodb tables which i see they are in use :
thd=0xb9e09a8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x5e0000, thread_stack=196608, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xbab3f78 = select * from general_vars
thd->thread_id=41
The manual page at
http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
090113 16:48:12 mysqld restarted
is there a tool or some way that can help me repair those innodb tables ?
ps . i haven't got a dump file of the db because of the size of the db . it is about 6G . so when i tried to mysqldump it , mysqldump tool hang-died.
thank you in advance for your answers ,
MIchail T .