List:MySQL on Win32« Previous MessageNext Message »
From:Christian Mack Date:September 13 1999 7:04pm
Subject:Re: isamchk version 6 buggy on NT
View as plain text  
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

Thread
isamchk version 6 buggy on NTSteve Ruby9 Sep
  • Re: isamchk version 6 buggy on NTChristian Mack13 Sep