Backup MySQL Database

I've set up a cron job to schedule a daily backup (using backup_mysql.php?action=backupnow) and it's working but the backup is made in an uncompressed file format.

Does anybody know what parameter should be included in the cron job to invoke gzip compression (backup_mysql.php?action=backupnow 'parameter')?

I would like to have the backups gzipped for the obvious reason of reducing size. Strange thing is that a manual backup using the admin interface does produce a gzip file. Even stranger because at initially I only had the option 'No Compression (Pure SQL)' and still it produced a gzip file.

Looking for a parameter to invoke gzip compression using the cron job I ran across this post by Woodyman.

Quote:

---

Originally Posted by Woodymon

The "No Compression (Pure SQL)" radio button in the BU mod dialog is defectively sticky, after the first time I selected I have never been able to unselect.

---

This seemed to be the same issue I was having and made me realize something was missing in my setup.

Found out that within admin/includes/init_includes/init_gzip.php there are four paths defined for gzip and zip configs. Within backup_mysql.php these paths are checked and, once found correct, options 'Use GZIP' and 'Use ZIP' are added to the admin interface.

In my case changing the paths to:

/bin/gzip
/bin/gunzip
/usr/bin/zip
/usr/bin/unzip

made the options appear. Check with your hosting provider if these settings don't work for you. Hope this helps.

hi...

i'm sure this is a dumb question:

i've just installed this mod for the first time... i'm quite thankful as i've often worried about not having a recent enough backup...

i haven't tried to create a backup yet, but the option is in the admin window and such, so i'm confident.

I would just like to know where it will save my backup

it says:
/home/content/(some removed)html/admin/backups/

but where is the 'home' folder...

like i said, i'm sure it's a dumb question...thanks in advance.

d'oh.

i figured it out...

thanks so much Dr. Byte!

Hi all,

I have just made a clean install of zencart 1.3.7 in a new MySQL (Client API version 5.0.18) database. After installing the "Backup MySQL" module (BACKUP_MYSQL Admin Tool v1.3) but I get the following error when trying to make a back-up using gzip:

Warning Result code: 2
Warning 0 => /usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Warning 1 => /usr/bin/mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
Warning 2 => /usr/bin/mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect
Error Failure: The database has NOT been saved.

Is there anything I can do to make it work?

Kind regards and many thanks for your help,

Goshawk.

two possible causes:

1. your database server isn't localhost, and thus it cannot connect to remote server
2. your webserver's command-line configuration for mysql client isn't fully complete, hence the charset warnings etc.

These are common symptoms of clustered hosting setups where the server administrator hasn't considered the need for command-line tools to be available to access the database from the webserver.

Hopefully your host can handle the error and make the required corrections. You'll have to report the issue to them.

Thank you DrByte for your quick response. I will take it up with my host. :)

HI, I am using my local test server - WinXP with WAMP and MYSQL 5

When I try and run the backup I get from the Admin:

http://192.168.0.250/store/admin/ima...ns/warning.gif Result code: 1
http://192.168.0.250/store/admin/ima...ns/warning.gif 0 => 'C:\wamp\mysql\bin\/mysqldump.exe" "--host' is not recognized as an internal or external command,
http://192.168.0.250/store/admin/ima...ns/warning.gif 1 => operable program or batch file.
http://192.168.0.250/store/admin/images/icons/error.gif Failure: The database has NOT been saved.

I edited the backup_mysql.php

define('LOCAL_EXE_MYSQL', 'c:\wamp\mysql\bin\mysql.exe');
define('LOCAL_EXE_MYSQLDUMP', 'c:\wamp\mysql\bin\mysqldump.exe');

If the problem is that WinXP is not letting the guest user run CMD.exe. Can you give me the (mysqldump.exe ...) command string so I can run it as a local scheduled task?

Then when I get ZenCart up and running on a Linux server I can set it back to default.

THANKS
JOhn ><>

@LibertyFlag:

I'm unable to connect to your web site. Meaning, I cannot see the screenshots you have posted. Perhaps posting them as an attachment of your next message should facilitate others to visualize what might of had happened (and if this error has not been covered yet). :wink2:

Anyone ever have the issue of the backup that goes to 101% and finishes immediately without actually backing up anything?

Quote:

---

Originally Posted by deadeye

Anyone ever have the issue of the backup that goes to 101% and finishes immediately without actually backing up anything?

---

I guess it appears to be an issue when GZip is turned on. I didn't have the problem prior, but intermittingly I was getting it the last few months. Not sure why it'd work sometimes and not others if host related. ZC 1.3.7; backup mySQL plugin 1.3