problem open a innodb table
am 07.01.2011 05:50:28 von Elim Qiu------=_NextPart_000_00BD_01CBADEB.BBC9DE80
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_00BE_01CBADEB.BBC9DE80"
------=_NextPart_001_00BE_01CBADEB.BBC9DE80
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_00BE_01CBADEB.BBC9DE80
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: =
normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; =
widows: 2; webkit-border-horizontal-spacing: 0px; =
webkit-border-vertical-spacing: 0px; webkit-text-decorations-in-effect: =
none; webkit-text-size-adjust: auto; webkit-text-stroke-width: =
0px">
style=3D"FONT-SIZE: 13px; FONT-FAMILY: arial, sans-serif; =
BORDER-COLLAPSE: collapse">
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.
those tables,=20
and not even know if that is possible or not. Please help.
contains 2+=20
million primes yet it is so small that I can attached here.
------=_NextPart_001_00BE_01CBADEB.BBC9DE80--
------=_NextPart_000_00BD_01CBADEB.BBC9DE80
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_00BD_01CBADEB.BBC9DE80--