Hello all
Yesterday night in one my server mysql got crashed. I am using MySQL 5.0.15 ver. I tried to restart mysqld no use. Then i reboot the server may be 2 to 3 times. No luck. Still crashed.
I have checked the error log:-
=============
060515 23:38:23 mysqld started
060515 23:38:23 InnoDB: Started; log sequence number 0 95736
060515 23:38:24 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060527 22:16:24 mysqld started
060527 22:16:25 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060527 22:16:26 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 96375.
InnoDB: Doing recovery: scanned up to log sequence number 0 96375
InnoDB: Last MySQL binlog file position 0 0, file name
060527 22:16:26 InnoDB: Started; log sequence number 0 96375
060527 22:16:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060530 6:12:09 [Note] /usr/sbin/mysqld: Normal shutdown
060530 6:12:09 InnoDB: Starting shutdown...
060530 6:12:10 InnoDB: Shutdown completed; log sequence number 0 96385
060530 6:12:10 [Note] /usr/sbin/mysqld: Shutdown complete
060530 06:12:10 mysqld ended
=============
Right now i am running mysqld in safe mode. But how can i run in normal mode at the moment; it won't started.
I am stuck.. pleaseeeeeeeeeee help me out.
Thanking you
Yesterday night in one my server mysql got crashed. I am using MySQL 5.0.15 ver. I tried to restart mysqld no use. Then i reboot the server may be 2 to 3 times. No luck. Still crashed.
I have checked the error log:-
=============
060515 23:38:23 mysqld started
060515 23:38:23 InnoDB: Started; log sequence number 0 95736
060515 23:38:24 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060527 22:16:24 mysqld started
060527 22:16:25 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060527 22:16:26 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 96375.
InnoDB: Doing recovery: scanned up to log sequence number 0 96375
InnoDB: Last MySQL binlog file position 0 0, file name
060527 22:16:26 InnoDB: Started; log sequence number 0 96375
060527 22:16:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060530 6:12:09 [Note] /usr/sbin/mysqld: Normal shutdown
060530 6:12:09 InnoDB: Starting shutdown...
060530 6:12:10 InnoDB: Shutdown completed; log sequence number 0 96385
060530 6:12:10 [Note] /usr/sbin/mysqld: Shutdown complete
060530 06:12:10 mysqld ended
=============
Right now i am running mysqld in safe mode. But how can i run in normal mode at the moment; it won't started.
I am stuck.. pleaseeeeeeeeeee help me out.
Thanking you
