Fw: problem open a innodb table

Fw: problem open a innodb table

am 04.01.2011 23:39:29 von Elim Qiu

------=_NextPart_000_03F1_01CBAC25.934437C0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_03F2_01CBAC25.934437C0"


------=_NextPart_001_03F2_01CBAC25.934437C0
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable

I messed up the ibdata1,ib_logfile1,0 files and encounter the problems =
of openning innodb tables even after I copied the back-up files of few =
months ago. I don't have many innodb tables and so this not causing too =
much trouble.

I don't know what to do for restoring those tables, and not even know if =
that is possible or not. Please help.

Attached is a table of primes that contains 2+ million primes yet it is =
so small that I can attached here.

Thanks
------=_NextPart_001_03F2_01CBAC25.934437C0
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable








I messed up the ibdata1,ib_logfile1,0 =
files and=20
encounter the problems of openning innodb tables even after I copied the =
back-up=20
files of few months ago. I don't have many innodb tables and so this not =
causing=20
too much trouble.

 

I don't know what to do for restoring =
those tables,=20
and not even know if that is possible or not. Please help.

 

Attached is a table of primes that =
contains 2+=20
million primes yet it is so small that I can attached here.

 

Thanks


------=_NextPart_001_03F2_01CBAC25.934437C0--


------=_NextPart_000_03F1_01CBAC25.934437C0
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
------=_NextPart_000_03F1_01CBAC25.934437C0--