automysqlbackup on cPanel server not ignoring eximstats

Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10

AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs. This tutorial explains how to install and use it on an Ubuntu 9.10 server.

I'm using automysqlbackup, here is the default cron entry created

#!/bin/sh test -x /usr/sbin/automysqlbackup && /usr/sbin/automysqlbackup

My files are stored here

/var/cache/automysqlbackup

I need to read them with my user but all the dumps are owned by root:root and 600

-rw------- 1 root root 945671 mars 12 06:49 my_2013-03-12.sql.gz -rw------- 1 root root 951541 mars 13 06:32 m

When I started managing a server, due to small database I always took manual backups, scarcely though. And because of my laziness in doing so, my fellow author, shredder12 constantly bugged me to do so. So, I started with weird entries in cron until I find this awesome script.

Hello,

I noticed on one server that there are some slow queries on eximstats database. Had anyone else this problem ? And if yes ...how did you optimized this database? Searching on the net i saw that many people prefer to empty eximstats tables.

I'm trying to use AutoMysqlBackup script to perform daily backups of my application. Unfortunately on the first try it didn't served me how I thought it would.

I believe that the script has used the --lock-tables=true parameter and it made my application stop working.

If this is the case, how can I make the script not lock the tables? (so my application can continue running)?

Thank you.

I have automysqlbackup running on Ubuntu 10.04 and it works perfectly fine. I currently have it performing daily backups for all databases, but I would like to adjust the configuration to do the following:

Perform daily backups of all databases into one folder but as separate .sql files, and then have that folder be a gzip with the timestamp the backup performed.

I was wondering if anyone else h

Recently I’ve decided reinstall OS.

Before reinstalling OS, I’ve tried to save data but mysqldump couldn’t dump MySQL’s data.

I think mysqldump can’t get information about tables because of other fact that SHOW statements also haven’t shown schema information correctly.

I think SHOW statements and mysqldump use information_schema table.

Then my question is how does MySQL resolve schema informa

hello i have 8 cpanel server and i upgraded mysql from MySQL Upgrade in whm in my all server at tonight after upgrade i can not give any backup on my cpanel servers and i get bellow error and backups going fail : please help me for solve this dangerous event

for example : /scripts/pkgacct hdhopir

warn [pkgacct] hdshopir_allgraphicd: mysqldump failed -- database may be corrupt (57795 by

Hi there, Does anyone know how to write this command for mysql version 4? (The command is for mysql version 5, I guess since when I check database in mysql server version4 there is no database name information_schema )