mysql backup and restore from ib_logfile failure

Posted by i need help on Stack Overflow See other posts from Stack Overflow or by i need help
Published on 2009-09-29T16:07:13Z Indexed on 2010/05/24 9:41 UTC
Read the original article Hit count: 670

Filed under:
|
|
|

Here's the case:

After computer being hacked, we are in a rush to backup all data out to other computer.

As a result, the mysql databases are not backup out as sql statement.

What we have done is backup out all the physical files/folders in the C drive to new computer.

Eg:

C:\Program Files\MySQL\MySQL Server 4.1\data

In this case, all data for mysql are inside unreadable file. Inside data folder consist of files like ib_logfile0, ib_logfile1, but not ib_data1 All database's table structure format are inside each respective folder. (Some folder have .frm, .opt) (some other folder have .frm, .myd, .myi)

How can I retrieve back the data from the database in a new computer?

I tried to install the same mysql version(4.1) at new computer, then replace all backup files inside data folder into this mysql in new computer. Then restart mysql service.

When I restart, it fail: Could not start mysql service on local computer. error 1067: process terminated unexpectedly.

Error log showing:

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090930 10:24:49  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 25165824 bytes!
090930 10:24:49 [ERROR] Can't init databases
090930 10:24:49 [ERROR] Aborting

090930 10:24:49 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown complete

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database