-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, Jun 06, 2003 at 05:27:30PM -0700, Jamin Roth wrote: > I designed a simple script to backup my MySQL databases. Basically it loops > through all the databases then through each table. This section of code > retreives the table and writes it to a csv file. When I execute the code at > the end of this message on a table with 2.7 million rows it works fine. > When it's executed on 4.7 million rows it exits out with only "Terminated" > as the error message. Is there any way I can get more information about > what is going on? Could MySQL be timing out? Should I split up the table > if it is over 2.5 million records (just do a limit in the SQL statement)?
If this is Linux, it sounds like the kernel OOM killer is sniping the process. Hopefully you're not trying to hold all those records in memory at once.... - -- Stephen Clouse <[EMAIL PROTECTED]> Senior Programmer/DBE, Core Technology Developer The IQ Group, Inc. <http://www.theiqgroup.com/> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+5Pg4A4aoazQ9p2cRAsk1AJ48gukiiX9gJX8gkNupUmTK58YdKgCg4J1b LKzYhEcTDG4YgAj8Dp6HeQ0= =j8yu -----END PGP SIGNATURE-----
