Forums / All Other Contributions/Addons / 'mysqldump" "--host' is not recognized as an internal or external command

'mysqldump" "--host' is not recognized as an internal or external command

Locked

Views: 9,289

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
7 Jan 2009, 5:45 PM
#1
patf avatar

patf

Zen Follower

Join Date:
May 2008
Posts:
200
Plugin Contributions:
0

'mysqldump" "--host' is not recognized as an internal or external command

Bit of a mega bump but did not see a support thread for this so -

I am also having problems using the sql backup - turned on the debug as described and what I get is ..

Checking Path: /usr/bin/
Warning Checking Path: /usr/bin/mysql/
Warning Checking Path: /usr/bin/
Warning Checking Path: /usr/local/bin/
Warning Checking Path: /usr/local/mysql/bin/
Warning Checking Path: c:/mysql/bin/
Warning Checking Path: d:/mysql/bin/
Warning Checking Path: e:/mysql/bin/
Warning Checking Path: c:/apache2triad/mysql/bin/
Warning Checking Path: d:/apache2triad/mysql/bin/
Warning Checking Path: e:/apache2triad/mysql/bin/
Warning Checking Path: c:/server/mysql/bin/
Warning Checking Path: c:/Program Files/MySQL/MySQL Server 5.0/bin/
Warning Checking Path: d:\Program Files\MySQL\MySQL Server 5.0\bin
Warning Checking Path: c:/Program Files/MySQL/MySQL Server 4.1/bin/
Warning Checking Path: /
Warning
Warning COMMAND FILES SELECTED:
Warning mysqlexe="mysql"
Warning mysqldumpexe="mysqldump"

Warning COMMAND: "mysqldump" "--host=localhost" "--user=xxxxxxxxxx" "--password=xxxxxxxxxx" --opt --complete-insert "--result-file=C:/Inetpub/vhosts/xxxxxxxxxx/backups/db_xxxxxxx-20090107174058.sql" xxxxxxxxx 2>&1
Warning Result code: 1
Error valueA: operable program or batch file.
Error valueB:
Warning 0 => 'mysqldump" "--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.

Would you have any idea where I am in trouble on this ??

Thanks in advance for any help.

7 Jan 2009, 6:27 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: 'mysqldump" "--host' is not recognized as an internal or external command

You're on a Windows server; thus you need to change one parameter to deal with windows limitations:
http://www.zen-cart.com/forum/showthread.php?t=87531
http://www.zen-cart.com/forum/showpost.php?p=397263&postcount=9

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

7 Jan 2009, 9:12 PM
#3
patf avatar

patf

Zen Follower

Join Date:
May 2008
Posts:
200
Plugin Contributions:
0

Re: 'mysqldump" "--host' is not recognized as an internal or external command

Thanks for the reply - I have done as instructed but now get

Result code: 1
Error valueA: operable program or batch file.
Error valueB:
Warning 0 => '"mysqldump"' is not recognized as an internal or external command,
Warning 1 => operable program or batch file.
Error Failure: The database has NOT been saved.

It appears that the "--host" issue has been resolved but there is still something amiss. :lookaroun

8 Jan 2009, 5:30 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: 'mysqldump" "--host' is not recognized as an internal or external command

Find out what the correct path is for the mysqldump.exe program, and enter that specifically in the /admin/includes/languages/english/backup_mysql.php file.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Jan 2009, 1:10 PM
#5
patf avatar

patf

Zen Follower

Join Date:
May 2008
Posts:
200
Plugin Contributions:
0

Re: 'mysqldump" "--host' is not recognized as an internal or external command

This does not seem to be anywhere on my host. Is this available as a stand alone program and if so is it just a case of uploading it to the relevant folder specified in /admin/includes/languages/english/backup_mysql.php file.

Thanks again.

8 Jan 2009, 5:25 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: 'mysqldump" "--host' is not recognized as an internal or external command

It comes as part of a standard install of MySQL. You'll have to ask your hosting company to install it to the server.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.