Steve Ruby wrote:
>
> Isamchk seems to be introducing errors in to my dump files.
>
> The following is a segment of a dump file
>
> 461498 INSERT INTO _ _data VALUES
> (1280292,65,'17:30:00','1999/03/24',458.00000,'1999-03-24 17:30:00');
> 461499 INSERT INTO _data VALUES
> (1280293,65,'18:00:00','1999/03/24',440.00000,'1999-03-24 18:00:00');
> 461500 INSERT INTO _data VALUES
> (1280294,65,'18:30:00','1999/03/24',407.00000,'1999-03-24 18:30:00');
> 461501 INSERT INTO _data VALUES
> (1280295,65,'19:00:00','1999/03/24',404.00000,'1999-03-24 19:00:00');
> 461502 INSERT INTO _data VALUES
> (1280296,65,'19:30:00','1999/03/24',402.00000,'1999-03-24 19:30:00');
> 461503 INSERT INTO _data VALUES
> (1280297,65,'20:000','1999/03/24',402.00000,'1999-03-24 20:00:00');
> 461504 INSERT INTO _data VALUES
> (1280298,65,'20:30:00','1999/03/24',399.00000,'1999-03-24 20:30:00');
> 461505 INSERT INTO _data VALUES
> (1280299,65,'21:00:00','1999/03/24',396.00000,'1999-03-24 21:00:00');
> 461506 INSERT INTO _data VALUES
> (1280300,65,'21:30:00','1999/03/24',394.00000,'1999-03-24 21:30:00');
>
> the first field are the line numbers. line 416498 has an error in the
> table name "_ _data" should be "_data"
>
> line 461503 should read 20:00:00 in the third value column.
>
> There were 4 other errors in this file that lead to sql errors and I
> don't have a clue how may errors there were inside of the field values
> that inserted fine but are bad data.
>
> the other errors are all missing commas between fields, missing quotes,
> etc.
>
> Suggestions?
>
> using licensed 3.22.24 on NT
>
> mysqldump is:
>
> H:\backup>mysqldump --help
> mysqldump Ver 6.0 Distrib 3.22.24, for Win95/Win98 (i586)
> By Igor Romanenko, Monty, Jani & Sinisa. This software is in public Domain
> This software comes with ABSOLUTELY NO WARRANTY
>
> Suggestions? I tried --opt but when I imported the dump file it stopped
> somewhere in the middle and I had to stop mysqld and restart it because
> it stopped responding to all requests.
>
> Thanks
> Steve Ruby
Hi Steve
Sorry, but I couldn't reproduce your problem :(
Perhaps your table is corrupted.
Did you check the table with isamchk?
The problem while importing can be because of not enough temporary disk space.
How much do you have free there?
Tschau
Christian
