I added the max-allowed-packet line, but looks like it fails again (not sure,because I didn't receive the log mail yet). My server blocks because it has a load of 13,94 during the backup. Is there a way to do the backup in low-priority to minimize the load?

2011/6/6 Wipe_Out <wipe_out@users.sourceforge.net>
Try adding something like --max_allowed_packet=100M to the OPT= line in the backup script and see if that helps things along..

Also is there anything being reported in the logs?



On 6 June 2011 10:41, Ward Loockx <ward@loockx.be> wrote:
It contains VARCHARS, INT, timestamp, DATETIME.

This is the size info about the table
Data 815,0 MB
Index 226,0 MB
Total 1,041,0 MB

The individual size of a row = 815.000Kb / 777263 records = 1.05kb / record


2011/6/6 Wipe_Out <wipe_out@users.sourceforge.net>
What data is in the table thats failing?
--Just alphanumeric text fields?
--or something else?

How big is the table? (MB)
How big are the individual rows of data?



On 6 June 2011 07:32, Ward Loockx <ward@loockx.be> wrote:
I see that mysqlhotcopy is only available for myIsam and currently we use innoDB tables..

Do you have another solution?


2011/6/2 Ward Loockx <ward@loockx.be>
Hello,

Thanks for the reply. I have control over the mysql settings. I'll also take a look at mysqlhotcopy.


2011/6/2 Wipe_Out <wipe_out@users.sourceforge.net>
Hi,

It could be an issue with the server running out of memory while dumping that large table.. The --opt switch is used which should disable memory buffering when its dumping the database but perhaps its something else.. It could also be that the table is being locked for a long time which is causing a problem for your website..

Are you able to change the MySQL server settings? eg buffers etc..

An alternative would be to not use the script to backup that database and instead use the mysqlhotcopy command which may work better for a larger database thats always active..



Does seem strange because 

On 2 June 2011 08:44, Ward Loockx <ward@loockx.be> wrote:
Hello,

I currently use automysqlbackup to backup 10databases. There is one big database that contains a table with +- 780.000records. When mysqlbackup executes it fails (on that table) and brings my websites down (maybe the load is so high that apache processes can't answer in time). Looks like there are a lot of query's executed at the moment of backup and maybe the query's are locking each other.

I also get the following by email:

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `video` at row: 745740

I think this are 2seperate problems:
  • Mysql backup script failing
  • Website's are down (because the use of too many resources?)

Do you guys have any ideas how to fix this? Can you let the script run in low priority mode, so that it doesn't eat the resources and does not lock any tables ?

Thanks!
Ward



------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It's vRanger. Get your free trial download today.
http://p.sf.net/sfu/quest-sfdev2dev
_______________________________________________
Automysqlbackup-users mailing list
Automysqlbackup-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users



------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.

Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
_______________________________________________
Automysqlbackup-users mailing list
Automysqlbackup-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users




------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
_______________________________________________
Automysqlbackup-users mailing list
Automysqlbackup-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users



------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
_______________________________________________
Automysqlbackup-users mailing list
Automysqlbackup-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users



------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
_______________________________________________
Automysqlbackup-users mailing list
Automysqlbackup-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users



------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
_______________________________________________
Automysqlbackup-users mailing list
Automysqlbackup-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users