Problem with Mysqldump

Not open for further replies.
I have a few Wordpress installations running and want to create a simple, reliable way of backing up the databases. For various reasons I have decided against plugins, and am using Cron.

I created a script which is called from Cron -
/usr/bin/mysqldump --host=hostserver --user=username --password=password database --quick > /usr/local/webspace/httpdocs/backups/backupdb-`date +%d.%m.%y`.sql
My problem is that this script works perfectly on two of the sites, but on the third it just produces an empty file.

The database sizes are 13.8 Mb, 3.4 Mb and 31.4 Mb, and it is the last one that is failing.

Has anyone got any ideas as to why one should fail when the other two work? Could the size be relevant?
Not having terminal access to the server, I can't run the command directly. Forgive my ignorance but is there a way to dump errors etc to a file?

Problem Solved!

Through a lot of trial and error, found the problem - mysqldump didn't like some of the characters used in the database password. Set up a new user for the DB and the job is oxo. :eagerness:
I tried that but the code bitched about the escape characters! I ended up creating a new database user with a password containing non-contentious characters. :congratulatory:
Not open for further replies.
Award-winning Mac antivirus and Internet security software