MySQL Backup Mod

[atlantis]

Hello,

I have used this mod before and works realy well however, I have installed a new zencart and when trying to backup the database i get the following error at the top of the screen.

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

I have tried all backup options, download to pc and backup on server but both do not work.

Please could someone point me in the right direction.


Thank You

[DrByte]

is this a windows host or linux?

[atlantis]

this is a windows host. I hope to backup the database from the windows host then restore it onto a linux host. Is that possible also ?


Thanks

[DrByte]

Yes it is.

The error you're experiencing is a result of how Windows interprets command-line parameters.

If you need a faster one-time solution, you can simply use phpMyAdmin, if you have it installed on your servers:
http://www.zen-cart.com/wiki/index.p...P_THE_DATABASE

[atlantis]

Hello,

I have it installed on my linux and windows servers, however on my windows server it is not connecting to MySQL. I am using the correct user name and passwords, and ports but I am greeted with the message below...

Error
MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I know this phpmyadmin error is not exactly a Zencart issue but I would be happy with any thoughts :)

Thanks Again

[DrByte]

you need to configure your phpMyAdmin config.inc file with your MySQL credentials

[neuzen]

hi dr. byte - you really byte the big ones [the big important mods like backups]!

anyway, if i get the error

'Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.'

will this likely get resolved if i switch to virtual dedicated hosting?

[a la >> open_basedir detection issue]

or would this utility likely require access to all server settings ? what do you guys test on?

[rebekah]

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

...If you need a faster one-time solution...

I'm getting this error too. What if I want more than a faster, one-time solution? Is there a way to correct this error?

This is the first time I've installed ZC using WAMP5 server locally. I'm new to this so please use the "dummies" explanation. I just figured I should learn how to do a test local site for experimenting purposes.

I tried changing the paths in admin\includes\languages\english\backup_mysql.php to this...

define('LOCAL_EXE_MYSQL', 'c:/wamp/mysql/bin/mysql.exe'); // used for restores
define('LOCAL_EXE_MYSQLDUMP', 'c:/wamp/mysql/bin/mysqldump.exe'); // used for backups

Thank you for any help in this area.

Rebekah

[rebekah]

Hmm. Now I went back to log in to the Admin and the page is totally blank. I'm about ready to pull my hair out. Help.