mysql backup

[James.W@AST]

by the way, mysqldump should be available since 1.0.9

[ho66es]

by the way, mysqldump should be available since 1.0.9

nice work

[atiras]

I'm trying to use this script and testing it by executing it as root before I schedule it using cron. I get the following error:

Code: Select all

Backing up database performance_schema to /volume1/sqlbackup/mysql/performance_schema.sql\n
/volume1/sqlbackup/mysqlbackup.sh: line 74: /volume0/usr/builtin/sbin: Permission denied

The sql user and password exist and have all rights to all databases. (I've hard-coded these for now). I've also tried using no password and the root account for sql -- no joy.
The share sqlbackup exists and has RW access for everyone.

What else do I need to check?

[ho66es]

I'm trying to use this script and testing it by executing it as root before I schedule it using cron. I get the following error:

Code: Select all

Backing up database performance_schema to /volume1/sqlbackup/mysql/performance_schema.sql\n
/volume1/sqlbackup/mysqlbackup.sh: line 74: /volume0/usr/builtin/sbin: Permission denied

The sql user and password exist and have all rights to all databases. (I've hard-coded these for now). I've also tried using no password and the root account for sql -- no joy.
The share sqlbackup exists and has RW access for everyone.

What else do I need to check?

there was a bug in the script, I have uploaded v1.1 please try this one

[atiras]

Thank you -- that works.

[ho66es]

Thank you -- that works.

glad to hear it is useful to someone

[sksbir]

Ok this is the script I am using from cron

cron entry is

Code: Select all

# backup prep
10 1 * * * /volume1/misc/mysqlbackup.sh

this is designed to be run before my backups to remote location so that the database is fully backed up daily and previous backups are archived. The backup dumps each database to a separate sql file and is commented where your install may differ from mine (I run the script from a share called misc, the backups go to a share called backup and the password for the backup user is stored in a file /etc/backuppass the only contents of that file are the password.

*updated script*

mysqlbackup.zip

please feel free to read and get back to me with any ideas for changes / fixes. If you choose to try this please understand I make no guarantees other than it works for me and on my austor and I will not be responsible if it damages the contents of your nas in any way etc etc.

Hello
Two corrections to do : replace LOC_C by LOG_C 2 times.

[Gunthor]

Thank you ho66es - What a wonderful and highly professional solution. I love the system log entries. Works like a charm. I messed up 70 data records in one of my MySql databases today - managed to recreate them with quite some time - and was just looking for an automatic solution for regular updates. Again: "Thank you for sharing..."