MYSQL Backup addon error

[cadfc]

zencart version: 1.3.6 (will be upgraded shortly!)
PHP: 4.4.4
MYSQL: 4.1.21

My store's not able to backup MYSQL database due to mysqldump path error.

Error Messages

"Result code: 127"

"Skip Lock option (check this if you get a LOCK TABLES permissions error)
ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED."

one line from my /admin/includes/languages/english/backup_mysql.php

define('LOCAL_EXE_MYSQLDUMP', '/usr/bin/mysqldump'); // used for backups

My host insisted the location of mysqldump is locating at /usr/bin/ so backup_mysql.php is correct.


My hosting tech further investigated and stated:

We have investigated your issue and the error we receive in the logs while running the backups is:

sh: /usr/bin/mysqldump --host=localhost --user=xxxxxx --password=xxxxxx --opt --complete-insert --skip-lock-tables --result-file=/home/xxxxx/public_html/admin/backups/db_xxxxx_zencart_xxx.sql xxxxxx_zencart 2>&1: No such file or directory
sh: -c: line 0: syntax error near unexpected token `0'
sh: -c: line 0: `exit(0)'.

which mean that the backup utility is looking for the backup file instead of creating one. I would suggest you to acquire support from the developers of Zen cart as any changes made by us would brake some thing.

I've read http://www.zen-cart.com/forum/showthread.php?t=45039 and http://www.zen-cart.com/forum/showthread.php?t=45238. But I'm not sure what next actions I shall take? Any suggestions?

[DrByte]

That same syntax works fine on a large number of other hosts without problem.

I'm not sure how it should be changed to work with your particular host's server configuration. Without knowing detailed configuration differences between their servers and other servers, there is no quick answer.

If you wanted to remove the "2>&1" part from the command sent to the server, you might find the error message will change to reflect more accurately what is happening, as I suspect using that on the command line is confusing the shell, since it's primarily used to send feedback to a calling script, which a shell statement doesn't have access to.


To get a database backup "today", I suggest you use phpMyAdmin instead:
http://www.zen-cart.com/wiki/index.p...P_THE_DATABASE

[tcustomgolf]

Hey Doc, I see you authored the Backup MYSQL Plugin and looking for some help on an error.

Getting errors on both my live 1.2.7 and test 1.3.7 carts within the admins. Enclosed screenshot..."backups" dir is there and chmoded at 777..

[DrByte]

"Error: Backup directory does not exist. Please set this in configure.php"
"Warning: dir(home/tcustom/public_html/zen137/admin/backups/) faied to open dir -- no such file or directory."

Try putting a / at the beginning of the backup path in your admin configure.php. You can't use just "home/tcustom...." ... you need "/home/tcustom...."

[tcustomgolf]

In my admin configure.php I changed this:

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

to this:

define('DIR_FS_BACKUP', DIR_FS_ADMIN . '/home/tcustom/public_html/zen137/admin/backups/');

but error still saying the backups dir does not exist and it doubles itself as below...

Warning: dir(home/tcustom/public_html/zen137/admin//home/tcustom/public_html/zen137/admin/backups/) [function.dir]: failed to open dir: No such file or directory in /home/tcustom/public_html/zen137/admin/backup_mysql.php on line 385

[DrByte]

undo that change, or remove the DIR_FS_ADMIN . portion.

what are the permissions and ownership on the "backups" folder ?

oh ... what is your DIR_FS_ADMIN setting ?

[tcustomgolf]

Good work, Doc!

My DIR_FS_ADMIN define did not have the leading / in the configure.php
Added that and I'm good!

Appreciate the help!

[cadfc]

DrByte,

Thank, I'll use PhpMyAdmin to backup for now.

Cheers

[andy]

ive just installed the backup files, when i go into admin tools and the backup page, there is just a button saying restore, should i have a backup button?

so it can be backed up before needing to restore it?

sorry if its a silly question

Andy

[kuroi]

Have you checked that your admin/backups directory is writeable?