MySQL Forums
Forum List  »  InnoDB

InnoDB recovery from copy
Posted by: elder santos
Date: August 30, 2005 01:06PM

Hi there,

My server had a total a crash and now i am trying to recover it from a backup. My backup is a copy from the MySQL directory.

I copied the ibdata file, ib_log files and the directory with the .frm files to my new mysql instance. The problem is when i try to run the service i get an error 1067. In the .err file i get the following:

InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html
050830 16:03:32 [ERROR] Can't init databases
050830 16:03:32 [ERROR] Aborting

050830 16:03:32 [Note] C:\Arquivos de programas\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

Any suggestions? I already added the following to my my.ini file:
innodb_force_recovery=1 but it made no difference...

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB recovery from copy
4094
August 30, 2005 01:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.