------=_NextPart_000_0279_01C61F38.679F2370
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_027A_01C61F38.67A16D60"
------=_NextPart_001_027A_01C61F38.67A16D60
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
MySQL Version: 4.1.10
I am loading a temporary table in a MySQL database from an Access database.
The Access database has 245 records in it and when I reach record #245 I get
the error incorrect key file for table 'tblTempClasses';Try to repair it and
any records following record #243 are dropped. I'm dropping the table and
re-creating it each time and I know it has nothing to do with the data
itself because I can change the sort and the problem then appears on a
different record but it's always record #244. The table is corrupted and the
REPAIR TABLE does fix it but what is causing it to get corrupted preventing
me from loading the entire table? Here's the table structure:
CREATE TABLE `vic_showsec_com_tblTempClasses` (
`ClassSelected` enum('ON','OFF') default
NULL,
`ClassNumber` varchar(11) default NULL,
`ClassDescription` varchar(100) default
NULL,
`ShowNumber` int(11) default NULL,
`ClassPrice` decimal(5,2) default NULL,
`ShowID` bigint(20) default NULL,
`ClassDate` date default NULL,
UNIQUE KEY `ClassNumber` (`ClassNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Vic
------=_NextPart_001_027A_01C61F38.67A16D60
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE id=3DridTitle>Clear Day</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<STYLE>BODY {
MARGIN-TOP: 25px; FONT-SIZE: 10pt; MARGIN-LEFT: 10px; COLOR: #0033cc; =
FONT-FAMILY: Arial, Helvetica
}
</STYLE>
<META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR></HEAD>
<BODY id=3DridBody background=3Dcid:546393017 [at] 22012006-07E3>
<P><SPAN class=3D546393017-22012006>MySQL Version: 4.1.10</SPAN></P>
<P><SPAN class=3D546393017-22012006>I am loading a temporary table in a =
MySQL
database from an Access database. The Access database has 245 records in =
it and
when I reach record #245 I get the error incorrect key file for table
'tblTempClasses';Try to repair it and any records following record #243 =
are
dropped. I'm dropping the table and re-creating it each time and I know =
it has
nothing to do with the data itself because I can change the sort and the =
problem
then appears on a different record but it's always record #244. The =
table is
corrupted and the REPAIR TABLE does fix it but what is causing it to get =
corrupted preventing me from loading the entire table? Here's the =
table
structure:</SPAN></P>
<P><SPAN class=3D546393017-22012006>CREATE TABLE =
`vic_showsec_com_tblTempClasses`
(
<BR> &nb=
sp; &nbs=
p;
`ClassSelected` enum('ON','OFF') default NULL,
<BR> &nb=
sp; &nbs=
p;
`ClassNumber` varchar(11) default
NULL,
<BR> &nb=
sp; &nbs=
p;
`ClassDescription` varchar(100) default NULL,
<BR> &nb=
sp; &nbs=
p;
`ShowNumber` int(11) default
NULL, &n=
bsp;
<BR> &nb=
sp; &nbs=
p;
`ClassPrice` decimal(5,2) default
NULL,
<BR> &nb=
sp; &nbs=
p;
`ShowID` bigint(20) default
NULL, &n=
bsp;
<BR> &nb=
sp; &nbs=
p;
`ClassDate` date default
NULL, &n=
bsp;
<BR> &nb=
sp; &nbs=
p;
UNIQUE KEY `ClassNumber`
(`ClassNumber`)
<BR> &nb=
sp; &nbs=
p;
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1 =
</SPAN></P>
<P><SPAN class=3D546393017-22012006></SPAN> </P>
<P><SPAN class=3D546393017-22012006>Vic</SPAN></P></BODY></HTML>
------=_NextPart_001_027A_01C61F38.67A16D60--
------=_NextPart_000_0279_01C61F38.679F2370--
