MYSQL Backup problem running Zen Cart on home computer

[carlvt88]

Thanks for this plug-in. I've used it daily and it's saved me much time.

Minor tweak - I believe the radio_field for skiplocks should be a checkbox_field.

My problem: Works great on my server, but not on my home development system. I'm running PHP5/MySQL5 on WinXP. When I press 'Backup', I get the following error:

Warning Result code: 1
Warning 0 => 'c:/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,
Warning 1 => operable program or batch file.
Error Failure: The database has NOT been saved.

PHP wasn't installed there, but I moved that executable to that location. In a command prompt window, I can type the following:

C:\>c:/mysql/bin/mysqldump.exe --host localhost
Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

Any ideas why I can't backup / restore on my home server?


My backup directory is not read-only. I don't have PHP safe mode on. The following is some of the server info:

Server Information
Server Host: localhost (127.0.0.1)       	Database Host: localhost (127.0.0.1)
Server OS: Windows NT OFFICE2 5.1 build 2600    	Database: MySQL 5.0.67-community-nt
Server Date: 03/29/2009 21:05:31   	Database Date: 03/29/2009 21:05:31
Server Up Time: operable program or batch file. 	HTTP Server: Apache/2.2.10 (Win32) PHP/5.2.6
PHP Version: 5.2.6 (Zend: 2.2.0)   PHP Memory Limit: 128M 	PHP Safe Mode: Off
PHP File Uploads: On    Max Size: 4M 	POST Max Size: 8M
Database Data Size: 5,246 kB 	Database Index Size: 1,123 kB

Zen Cart
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8   [2008-03-18 19:36:23]   (Fresh Installation)
v1.3.8   [2008-03-18 19:36:23]   (Fresh Installation)
PHP Logo
PHP Version 5.2.6

System 	Windows NT OFFICE2 5.1 build 2600
Build Date 	May 2 2008 18:01:20
Configure Command 	cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared" "--with-extra-includes=C:\Program Files (x86)\Microsoft SDK\Include;C:\PROGRA~2\MICROS~2\VC98\ATL\INCLUDE;C:\PROGRA~2\MICROS~2\VC98\INCLUDE;C:\PROGRA~2\MICROS~2\VC98\MFC\INCLUDE" "--with-extra-libs=C:\Program Files (x86)\Microsoft SDK\Lib;C:\PROGRA~2\MICROS~2\VC98\LIB;C:\PROGRA~2\MICROS~2\VC98\MFC\LIB"
Server API 	Apache 2.0 Handler
Virtual Directory Support 	enabled
Configuration File (php.ini) Path 	C:\WINDOWS
Loaded Configuration File 	C:\Program Files\PHP\php.ini
PHP API 	20041225
PHP Extension 	20060613
Zend Extension 	220060519
Debug Build 	no
Thread Safety 	enabled
Zend Memory Manager 	enabled
IPv6 Support 	enabled
Registered PHP Streams 	php, file, data, http, ftp, compress.zlib, compress.bzip2, https, ftps, zip, ssh2.shell, ssh2.exec, ssh2.tunnel, ssh2.scp, ssh2.sftp, res
Registered Stream Socket Transports 	tcp, udp, ssl, sslv3, sslv2, tls
Registered Stream Filters 	convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*, bzip2.*, http.*

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
    with Zend Debugger v5.2.15, Copyright (c) 1999-2008, by Zend Technologies

PHP Credits
Configuration
PHP Core
Directive	Local Value	Master Value
allow_call_time_pass_reference	Off	Off
allow_url_fopen	On	On
allow_url_include	Off	Off
always_populate_raw_post_data	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
asp_tags	Off	Off
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	no value	no value
default_mimetype	text/html	text/html
define_syslog_variables	Off	Off
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	Off	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	On	On
error_append_string	no value	no value
error_log	no value	no value
error_prepend_string	no value	no value
error_reporting	6135	6143
expose_php	On	On
extension_dir	C:\Program Files\PHP\ext	C:\Program Files\PHP\ext
file_uploads	On	On
highlight.bg	#FFFFFF	#FFFFFF
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.;C:\php5\pear	.;C:\php5\pear
log_errors	On	On
log_errors_max_len	1024	1024
magic_quotes_gpc	Off	Off
magic_quotes_runtime	Off	Off
magic_quotes_sybase	Off	Off
mail.force_extra_parameters	no value	no value
max_execution_time	60	30
max_input_nesting_level	64	64
max_input_time	60	60
memory_limit	128M	128M
open_basedir	no value	no value
output_buffering	4096	4096
output_handler	no value	no value
post_max_size	8M	8M
precision	14	14
realpath_cache_size	16K	16K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
register_globals	Off	Off
register_long_arrays	Off	Off
report_memleaks	On	On
report_zend_debug	On	On
safe_mode	Off	Off
safe_mode_exec_dir	no value	no value
safe_mode_gid	Off	Off
safe_mode_include_dir	no value	no value
sendmail_from	[email protected]	[email protected]
sendmail_path	no value	no value
serialize_precision	100	100
short_open_tag	Off	Off
SMTP	mail.vtpeaches.net	mail.vtpeaches.net
smtp_port	25	25
sql.safe_mode	Off	Off
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	4M	4M
upload_tmp_dir	C:\WINDOWS\Temp	C:\WINDOWS\Temp
user_dir	no value	no value
variables_order	GPCS	GPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
y2k_compliance	On	On
zend.ze1_compatibility_mode	Off	Off

apache2handler
Apache Version 	Apache/2.2.10 (Win32) PHP/5.2.6
Apache API Version 	20051115
Server Administrator 	[email protected]
Hostname:Port 	localhost:80
Max Requests 	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts 	Connection: 300 - Keep-Alive: 5
Virtual Server 	No
Server Root 	C:/Program Files/Apache Software Foundation/Apache2.2
Loaded Modules 	core mod_win32 mpm_winnt http_core mod_so mod_actions mod_alias mod_asis mod_auth_basic mod_authn_default mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_setenvif mod_php5

Directive	Local Value	Master Value
engine	1	1
last_modified	0	0
xbithack	0	0

Apache Environment
Variable	Value
HTTP_HOST 	localhost
HTTP_USER_AGENT 	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.7) Gecko/2009021910 Firefox/3.0.7
HTTP_ACCEPT 	text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE 	en-us,en;q=0.5
HTTP_ACCEPT_ENCODING 	gzip,deflate
HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 	300
HTTP_CONNECTION 	keep-alive
HTTP_REFERER 	http://localhost/vthfhome/tix/mgr/backup_mysql.php
HTTP_COOKIE 	ZDEDebuggerPresent=php,phtml,php3; zenAdminID=gbb6itb98lgdals8sflipvflm0
PATH 	C:\Program Files\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;c:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Teradyne\IG-XL\7.10.00_uflx\bin;C:\Program Files\Teradyne\IG-XL\Version Selector Plus\;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\CteAddIns\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin;c:\program files\java\jdk1.6.0_12\bin;C:\Program Files\QuickTime\QTSystem\
SystemRoot 	C:\WINDOWS
COMSPEC 	C:\WINDOWS\system32\cmd.exe
PATHEXT 	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
WINDIR 	C:\WINDOWS
SERVER_SIGNATURE 	no value
SERVER_SOFTWARE 	Apache/2.2.10 (Win32) PHP/5.2.6
SERVER_NAME 	localhost
SERVER_ADDR 	127.0.0.1
SERVER_PORT 	80
REMOTE_ADDR 	127.0.0.1
DOCUMENT_ROOT 	C:/htdocs
SERVER_ADMIN 	[email protected]
SCRIPT_FILENAME 	C:/htdocs/vthfhome/tix/mgr/server_info.php
REMOTE_PORT 	4422
GATEWAY_INTERFACE 	CGI/1.1
SERVER_PROTOCOL 	HTTP/1.1
REQUEST_METHOD 	GET
QUERY_STRING 	no value
REQUEST_URI 	/vthfhome/tix/mgr/server_info.php
SCRIPT_NAME 	/vthfhome/tix/mgr/server_info.php

HTTP Headers Information
HTTP Request Headers
HTTP Request 	GET /vthfhome/tix/mgr/server_info.php HTTP/1.1
Host 	localhost
User-Agent 	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.7) Gecko/2009021910 Firefox/3.0.7
Accept 	text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language 	en-us,en;q=0.5
Accept-Encoding 	gzip,deflate
Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 	300
Connection 	keep-alive
Referer 	http://localhost/vthfhome/tix/mgr/backup_mysql.php
Cookie 	ZDEDebuggerPresent=php,phtml,php3; zenAdminID=gbb6itb98lgdals8sflipvflm0
HTTP Response Headers
X-Powered-By 	PHP/5.2.6
Set-Cookie 	ZDEDebuggerPresent=php,phtml,php3; path=/
Expires 	Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control 	no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma 	no-cache
Keep-Alive 	timeout=5, max=100
Connection 	Keep-Alive
Transfer-Encoding 	chunked
Content-Type 	text/html; charset=iso-8859-1

[DrByte]

My problem: Works great on my server, but not on my home development system. I'm running PHP5/MySQL5 on WinXP. When I press 'Backup', I get the following error:

Warning 0 => 'c:/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,

If you're running on windoze, you need to set the OS_DELIM to ", as discussed here: http://www.zen-cart.com/forum/showthread.php?t=87531

[carlvt88]

Thanks!
Carl