Hi John,
The data files will give you some informations like log_file_size, mutliple
tablespace is being used or not. Although my.cnf can help you a lot. With
the above information, use it with newer version of mysql.
Krishna
On Wed, Jan 20, 2010 at 3:02 PM, Johny Brawo wrote:
> Hello!
>
> I g
Hi Johny
Do you have the my.cnf configuration file ?? that can simplify things.
Carlos
On 1/20/2010 3:32 AM, Johny Brawo wrote:
Hello!
I got all data files (ibdata1, ib_logfile, etc) recovevered from mine
old Debian 3.1 box (and i dont know MySQL version :( ). I want to get
that DB running a
Heikki Tuuri wrote:
log files are as important a part of a database as ibdata files.
Trust me, I know; they didn't get backed up I've realized too late
though ...
You can try using some dummy log files from another installation and set
force recovery to 6 to skip the log scan.
... what's
Michael,
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 4:36 PM
Subject: Re: InnoDB recovery
> Heikki Tuuri wrote:
>
>
Heikki Tuuri wrote:
if you have on tape old images of ibdata files and ib_logfile's, you can try
crash recovery from them, possibly using innodb_force_recovery=6.
Unfortunately, as mentionned, I only have the data files on tape, no log
files.
Are the data files 'dumpable' ??
SQL
--
Michae
Michael,
- Original Message -
From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 05, 2002 6:00 PM
Subject: InnoDB recovery
> I have a table that accidentally had a query run on it that NULL'd a
> certain field of the entire table.
