Couldn't execute "SELECT * FROM `table` LIMIT 10000,10000

**knows MySQLDumper** Joined: 10 Apr 2011 Posts: 3

Hi

Love the product and find it really useful. I have just intsalled on a new host and have the following problem

When running the php backup script all works ok

I get the following error when I try and run the perl backup script

................................................
9831 inserted records (size of backupfile: 205.15 MB)
Dumping table `tahola_support_email_body` (Type MyISAM):
Perl Cronscript ERROR: Couldn't execute "SELECT * FROM `table__body` LIMIT 10000,10000;" - MySQL-Error: Lost connection to MySQL server during query

Stopping script because of this fatal error!

Any ideas ?

Rgds,

Mike

Posted: 2011-07-31, 22:06 (No subject)

Hi Mike,

in the Perl mode MySQLDumper tries to read 10,000 records in one go. This is no problem normally and makes the backup via Perl much faster than using PHP.
But reading your error message, it looks like your new MySQL server doesn't like to fetch this number of records and is running into memory problems.

You can try to lower the number of records read at once by editing the file inc/runtime.php and changing line 70 from

**knows MySQLDumper** Joined: 10 Apr 2011 Posts: 3

Brilliant !

This worked and the the backup has completed successfully Smile

I can now schedule in cron but.....

I have got the following message displayed

Finished backup of database `mydb__system`.

Starting autodelete function:
Keep the latest 3 backup files for each database and delete older ones.
Software error:

Undefined subroutine &main::gzopen called at crondump.pl line 1090.

For help, please send mail to the webmaster webmaster@midodds.email

for info my perl installation from my host does not support compressed files - following is displayed when I test perl modules but Gzip compression is switched off in General settings for my configuration

Output from test perl modules ....
"testing Compress::Zlib (needed for dumping data into a crompessed *.gz-file)...
Error: modul Compress::Zlib not found! crondump.pl can't write compressed files. Falling back to uncrompressed files (files are 10 times bigger)."

**knows MySQLDumper** Joined: 10 Apr 2011 Posts: 3

Thanks for such quick responses Very Happy

OK that makes sense

I was able to run the backup process using the PHP selection but not Perl so have created a few zipped backups.

As I have zipped files in the backup folder, from previous PHP backups, it appears the problem is the perl script is " falling over" when it reads the zipped files.

Now the perl cronscript is running successfully - based on chanes made earlier as per your recommendation I will schedule perl backup in cron and manually delete / move the zipped files out of the backup folder

Thanks again for your help ... I think it would be v useful to start a separate conversation / thread on using just php as I think this would be a very useful addition . BUT I'll create this separately

Mike