Przeszukaj forum

Witam Proszę o wskazówkę, jak mogę odzyskać dane z bazy po uszkodzeniu logu binarnego. (nie mam backupu) mysql -u root -p: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) fragment /var/log/mysql/error.log: 120904 10:59:00 InnoDB: Starting shutdown... 120904 11:28:29 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 120904 11:28:29 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... InnoDB: Transaction 0 381994154 was in the XA prepared state. InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 0 row operations to undo InnoDB: Trx id counter is 0 381995008 InnoDB: Last MySQL binlog file position 0 8440536, file name ./mysql-bin.001388 InnoDB: Starting in background the rollback of uncommitted transactions 120904 11:28:29 InnoDB: Rollback of non-prepared transactions completed 120904 11:28:29 InnoDB: Started; log sequence number 6 3806000415 ^G/usr/sbin/mysqld: File './mysql-bin.001388' not found (Errcode: 2) 120904 11:28:29 [ERROR] Failed to open log (file './mysql-bin.001388', errno 2) 120904 11:28:29 [ERROR] Could not open log file 120904 11:28:29 [ERROR] Can't init tc log 120904 11:28:29 [ERROR] Aborting 120904 11:28:29 InnoDB: Starting shutdown... na forach znalazłem metodę: echo '' >/var/db/mysql/mysql-bin.index jak przypuszczam, to spowoduje utratę danych? czy istnieje jakiś sposób na naprawę pliku bez utraty bazy?