On 24 May 2004, at 6:05 pm, Gilbert Wu wrote:
Hi All,
The dump file is a 4Gytes text file. Could find an editor able to look at the content of the file. Hence, I had to write a little Perl program (something I haven't done for 5 years). I discovered the line that caused a syntax error whenever I tried to restore from the dump file.
It looks something like:
INSERT INTO TABLE2 VALUES
(5,579,265,16,20020312,-438,191.789,191.789,5.5767e-006,5.5767e -006,0,0,0,-12086.6),(5,579,265,16,20020313, -438,157.242,157.242,4.5723e-006,4.5723e-006,0,0,0, -11892.7),(5,579,265,16,20020314,-438,-177.829,-177.829,-5.1788e-006, -5.1788e-006,0,0,0,-11829.3),(5,579,265,16,20020315,-438,-131.495, -131.495,-3.8387e-006,-3.8387e-006,0,0,0, -12012.6),(5,579,265,16,20020318,1,-133.587,-173.91,-4.7218e-006, -6.147e-006,47.0828,1.6642e-006,12290.1,-12135.1),(5UNLOCK TABLES;
It seems like mysqldump gave up during the file generation and inserted "UNLOCK TABLES;" in the middle of the insertion block. Hence, the syntax error during restoration.
Is this a mysqldump bug?
Regards,
Gilbert
-----Original Message----- From: Gilbert Wu Sent: 24 May 2004 17:10 To: Brian Reichert Cc: [EMAIL PROTECTED] Subject: RE: mysqldump problem
Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server.
Consider the OS and filesystem as well (wheatever uyou _are_ using; you didn't tell us).
Quotas? Limits by FS? getrlimit()?
Would this by any chance be dumping to a disk formatted with the FAT32 filesystem? FAT32 files are limited to 2^32-1 bytes - i.e. 1 less than 4GB.
Tim
-- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
