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.