Chico Che wrote:
> lark <hamzee@scglobal.net> wrote in
> news:cxBbi.3231$c06.1230@newssvr22.news.prodigy.ne t:
>
>> == Quote from Chico Che (jsisk24@yahoo.com)'s article
>>> We have a mysql database that we had setup on a second partition, our
>>> first partition went haywire and had to reinstall the server os. We
>>> reinstalled the os and mysql but when we reattached the data folder
>>> that was already there on the second drive it will not recognize the
>>> database. It is setup as Innodb database and have the frm files and
>>> two log files and one datafile. Running mysqlcheck shuts downs the
>>> mysql service. Any help would be greatly appreciated.
>> copy the log files out of the data directory and try to start the
>> server. don't delete them just copy them to a different location.
>>
>>
>> --
>> POST BY: lark with PHP News Reader
>>
>
> I get the following on the err.log
> 070612 21:30:17 InnoDB: Log file .\ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file .\ib_logfile0 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 070612 21:30:18 InnoDB: Log file .\ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file .\ib_logfile1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Cannot initialize created log files because
> InnoDB: data files are corrupt, or new data files were
> InnoDB: created when the database was started previous
> InnoDB: time but the database was not shut down
> InnoDB: normally after that.
> 070612 21:30:19 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin
> \mysqld-nt: ready for connections.
> Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
>
> Is the data file unfixable?

What messages do you get when the correct log files are in the directory
and you try to start it?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================