:04:27 AM
> Subject: Re: help: innodb database cannot recover
>
> I removed "ib_logfile0" and "ib_logfile1" and restarted mysql with
> innodb_force_recovery=1,
> mysql keeps crashing and restart:
>
>
> thd: 0x0
> Attempting backtrace. You can use the fol
>boah you *must not* remove ibdata1
>it contains the global tablespace even with file_per_table
>"ib_logfile0" and "ib_logfile1" may be removed, but make sure you have
>a as cinsistent as possible backup of the whole datadir
I removed "ib_logfile0" and "ib_logfile1" and restarted mysql with
in
Am 20.06.2013 23:47, schrieb Peter:
>> Hello,
>>>
>>> I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
>>> database directory) from one crashed machine to another.
>>> I find that I cannot start database to get the database data any more.
>>
>>
>>> How did you copy the d
>Hello,
>>
>>I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
>>database directory) from one crashed machine to another.
>>I find that I cannot start database to get the database data any more.
>
>
>>How did you copy the database?
>>Manuel
>
>I copy the files ib_logfile
2013/6/20 Peter
>
>2013/6/20 Peter
>
>Hello,
>>
>>I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
>>database directory) from one crashed machine to another.
>>I find that I cannot start database to get the database data any more.
>
>
>>How did you copy the databa
Am 20.06.2013 15:18, schrieb Peter:
>>
>>> I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
>>> database directory) from one crashed machine to another.
>>> I find that I cannot start database to get the database data any more.
>
>>> How did you copy the database?
>>> M
Am 20.06.2013 15:18, schrieb Peter:
>>
>>> I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
>>> database directory) from one crashed machine to another.
>>> I find that I cannot start database to get the database data any more.
>
>>> How did you copy the database?
>>>
2013/6/20 Peter
>
> 2013/6/20 Peter
>
> Hello,
>
> I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
> database directory) from one crashed machine to another.
> I find that I cannot start database to get the database data any more.
>
>
> >How did you copy the database?
>
2013/6/20 Peter
Hello,
>
>I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
>database directory) from one crashed machine to another.
>I find that I cannot start database to get the database data any more.
>How did you copy the database?
>Manuel
I copy the files ib_lo
Am 20.06.2013 15:18, schrieb Peter:
> 2013/6/20 Peter
>
> Hello,
>>
>> I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
>> database directory) from one crashed machine to another.
>> I find that I cannot start database to get the database data any more.
>
>> How did y
2013/6/20 Peter
> Hello,
>
> I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
> database directory) from one crashed machine to another.
> I find that I cannot start database to get the database data any more.
How did you copy the database?
Manuel
Am 20.06.2013 10:11, schrieb Peter:
> 130620 00:47:08 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> InnoDB: Error: tablespace size stored in header is 456832 pages, but
> InnoDB: the sum of data file sizes is only 262080 pages
> InnoDB: Cannot start InnoDB. The tail o
Hello,
I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole
database directory) from one crashed machine to another.
I find that I cannot start database to get the database data any more.
I tried innodb_force_recovery=1
or innodb_force_recovery=4, it doesn't help.
Here is th
13 matches
Mail list logo