HI All,

Kindly help me in resolving the mysql database get crashed due to some reason . We tried to restore the mysql directory under /var/lib of old dates when database was working fine , after we have started the mysql service we are getting the below error in the mysqld.log file .

Secondly we also tried to restore the database using its dump which we created by taking it into the innodb recovery mode 4 . And this dump is also created of old date data.

Below is the logs for mysqld.log and mysql dump logs.


40120 2:30:51 InnoDB: Error: page 456173 log sequence number 596 3894282887
InnoDB: is in the future! Current system log sequence number 2 1545511088.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/...-recovery.html
InnoDB: for more information.
140120 2:30:51 InnoDB: Error: page 456174 log sequence number 596 3894314563
InnoDB: is in the future! Current system log sequence number 2 1545511088.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/...-recovery.html
InnoDB: for more information.
140120 2:30:51 InnoDB: Error: page 456175 log sequence number 596 3894353246
InnoDB: is in the future! Current system log sequence number 2 1545511088.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/...-recovery.html
InnoDB: for more information.
^Cls
[root@linux mnt]# /etc/init.d/mysqld status
mysqld (pid 17435) is running...
[root@linux mnt]# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use postfix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: postfix

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server

mysql> eixt
-> exit
-> Aborted
[root@linux mnt]# [A

total 10651880
drwxr-xr-x 2 mysql mysql 12288 Oct 20 02:19 postfix
-rw-r-xr-x 1 mysql mysql 10886316032 Oct 20 02:36 ibdata1.old
-rw-rw---- 1 mysql mysql 5242880 Oct 20 02:36 ib_logfile1
drwxrwxrwx 2 mysql mysql 4096 Apr 18 2013 mysql
srwxrwxrwx 1 mysql mysql 0 Oct 20 02:36 mysql.sock
drwxrwxrwx 2 mysql mysql 4096 Apr 18 2013 test
[root@linux mysql]# mys
[root@linux mysql]# ls -lh /dump/anv.sql
-rw-r--r-- 1 root root 6.5G Oct 19 20:24 /dump/anv.sql
[root@linux mysql]# mysql -u root --force -p postfix < /dump/anv.sql
Enter password:
ERROR 2013 (HY000) at line 7549: Lost connection to MySQL server during query
ERROR 2006 (HY000) at line 7550: MySQL server has gone away
ERROR 2006 (HY000) at line 7551: MySQL server has gone away
ERROR 2006 (HY000) at line 7552: MySQL server has gone away
ERROR 2006 (HY000) at line 7558: MySQL server has gone away
ERROR 2006 (HY000) at line 7559: MySQL server has gone away
ERROR 2006 (HY000) at line 7560: MySQL server has gone away
ERROR 2006 (HY000) at line 7561: MySQL server has gone away
ERROR 2006 (HY000) at line 7567: MySQL server has gone away
ERROR 2006 (HY000) at line 7573: MySQL server has gone away
ERROR 2006 (HY000) at line 7574: MySQL server has gone away
ERROR 2006 (HY000) at line 7575: MySQL server has gone away
ERROR 2006 (HY000) at line 7576: MySQL server has gone away
ERROR 2006 (HY000) at line 7582: MySQL server has gone away
ERROR 2006 (HY000) at line 7583: MySQL server has gone away
ERROR 2006 (HY000) at line 7584: MySQL server has gone away
ERROR 2006 (HY000) at line 7585: MySQL server has gone away
ERROR 2006 (HY000) at line 7601: MySQL server has gone away
ERROR 2006 (HY000) at line 7607: MySQL server has gone away
ERROR 2006 (HY000) at line 7608: MySQL server has gone away
ERROR 2006 (HY000) at line 7609: MySQL server has gone away
ERROR 2006 (HY000) at line 7610: MySQL server has gone away
ERROR 2006 (HY000) at line 7616: MySQL server has gone away
ERROR 2006 (HY000) at line 7617: MySQL server has gone away
ERROR 2006 (HY000) at line 7618: MySQL server has gone away
ERROR 2006 (HY000) at line 7619: MySQL server has gone away
ERROR 2006 (HY000) at line 7636: MySQL server has gone away
ERROR 2006 (HY000) at line 7642: MySQL server has gone away

This could be of some help.

Okay the log gave some hints about whats wrong but not really anything to solve this. I don't know where to start so I just get some random order going.

The name of the ibdata1.old file, my installation does not have the .old suffix.

The reason why you get error "ERROR 2006 (HY000) at line 7642: MySQL server has gone away" is due to mysql shutting it self down if innodb table space or log space is damaged. This is to prevent any further damage and possible repair of it. So if you fix the innodb space files your server will stay active.

If you have a dump of the table maybe its best to use that on a fresh installation. Move all you got now to another directory. Then use mysql_install_db to recreate the base mysql tables. AFter this just use the dump to get the db up and running. Use disable keys if not allready in the dump to speed up things.