News Detail

Mysql database can not start recovery mysql database crash recovery mysql database recovery

 

Mysql database can not start recovery mysql database crash recovery mysql database recovery

Customer name confidential
Data type mysql 5.5 innodb
Data capacity 1500 MB
Failure type server power failure caused mysql to fail to start. Customers themselves try innodb crash recovery from parameter 1-6 invalid,
InnoDB: for more information.
InnoDB: Error: trying to access page number 805281720 in space 0,
InnoDB: space name .\ibdata1,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i / o type 10.
InnoDB: If you get this error at mysqld startup, please check that
InnoDB: your my.cnf matches the ibdata files that you have in the
InnoDB: MySQL server.
InnoDB: Assertion failure in thread 11500 in file fil0fil.c line 4578
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
After the repair database file is sent, the analysis file finds a garbage transaction, directly shields it, and mysql directly starts OK. The export backup completes recovery.
InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
InnoDB: 5.5.46 started; log sequence number 50311840278
[Note] Server hostname (bind-address): '0.0.0.0'; port: 3307
[Note]   - '0.0.0.0' resolves to '0.0.0.0';
[Note] Server socket created on IP: '0.0.0.0'.
[Note] Event Scheduler: Loaded 0 events
[Note] D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
Version: '5.5.46-log'  socket: ''  port: 3307  MySQL Community Server (GPL)
Customer satisfaction is half an hour.
Shenzhen Excellent Data Rescue Center Friendly Reminder: Important data must be backed up frequently, encounter data loss data corruption and other issues, you should contact professionals at the first time.
For all kinds of mainstream databases, we can do the lowest level of data recovery and data repair. For some specific faults of the database, we guarantee that the database 100% original model is restored as it is, no matter how large the database is ready.