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
10: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 following information to find
out
where mysqld died
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 of
2013/6/20 Peter one2001...@yahoo.com
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 15:18, schrieb Peter:
2013/6/20 Peter one2001...@yahoo.com
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.
2013/6/20 Peter one2001...@yahoo.com
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
2013/6/20 Peter one2001...@yahoo.com
2013/6/20 Peter one2001...@yahoo.com
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
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?
Manuel
I copy
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?
Manuel
I copy
2013/6/20 Peter one2001...@yahoo.com
2013/6/20 Peter one2001...@yahoo.com
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.
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_logfile0 ib_logfile1
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 database?
Manuel
I
12 matches
Mail list logo