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. -----Original Message----- From: Brian Reichert [mailto:[EMAIL PROTECTED] Sent: 24 May 2004 15:42 To: Gilbert Wu Cc: [EMAIL PROTECTED] Subject: Re: mysqldump problem On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote: > Hi, > > I've been using mysqldump to backup my entire database. Every day, I restore the > whole thing to my test/develop database by piping the large sql generated by > mysqldump. All is well until the file size of the sql file reached about 4Gbytes. I > wonder if there is a size limit to the database I can backup and restore? Consider the OS and filesystem as well (wheatever uyou _are_ using; you didn't tell us). Quotas? Limits by FS? getrlimit()? > Many Thanks. > > Regards, > > Gilbert Wu > [EMAIL PROTECTED] > <http://www.sabrefund.com/> http://www.sabrefund.com/ -- Brian Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
