0
votes
1answer
97 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
2
votes
2answers
311 views

Mysqld InnoDB crash

my MySQL server just crashed and I cannot restart/recover it. I've tried: /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . ...
2
votes
1answer
158 views

MySQL crashing when trying to restore from dump

So I had a very large corrupt innodb table. mysqld would crash whenever I did a check table on it. I did a innodb-force-recovery=1 and did a dump of the table. No errors showed up. I dropped the ...
1
vote
2answers
2k views

InnoDB recovery

My MySQL server run to crash due to (page file write error). I did a disk diagnosis but no errors found. I restarted MySQL server. It scanned the bin log like for 1-2 hours and recorded log as below: ...
5
votes
1answer
427 views

Mysql disaster recovery

We just got a major disaster: somebody made an uncontrolled update on the production database, and obviously, the backup process is not working since a long time, so we got a major data loss. A 40 ...
4
votes
1answer
2k views

MySQL data recovery (innoDB) - missing .frm files but intact ibdata

A recent server fiasco left me with a by-all-appearances intact ibdata file but only half of my .frm-containing directories. I've copied all of this to a fresh mysql install, and have successfully ...
0
votes
1answer
690 views

MySQL Server - Got error -1 from storage engine

I am currently trying to restore a MySQL table from the .ibd file. I have been following the instructions on the MySQL reference manual on how to use DISCARD and IMPORT TABLESPACE to replace the .idb ...