Zen Cart Logo
Forums / All Other Contributions/Addons / Database Backup Manager - MySQL

Database Backup Manager - MySQL

Locked

Views: 4,437

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
26 Jul 2006, 10:48 AM
#1
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Location:
Sofia, Bulgaria
Posts:
195
Plugin Contributions:
0

Database Backup Manager - MySQL

Warning Result code: 1
Warning 0 => 'c:/apache2triad/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.

Whats wrong ?

Im using Zen Cart 1.3.0.2
Win 2003 adv server R2

Radoslav

27 Jul 2006, 7:04 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: Database Backup Manager - MySQL

:D... "windows" is the problem.

You could try removing the double-quote marks from the line that executes the mysqldump binary.

around line 140 or so, try removing both double-quote marks

        $resultcodes = @exec('"'.$toolfilename . $dump_params .'"', $output, $dump_results );

or add this on a line above it:```
$dump_params = str_replace('"','',$dump_params);

27 Jul 2006, 12:07 PM
#3
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Location:
Sofia, Bulgaria
Posts:
195
Plugin Contributions:
0

Re: Database Backup Manager - MySQL

thanks drByte for ur explanation and help :))
keep the hard work to make more people have a good web projects :)

**
Kind Regards,
Radoslav**

29 Jul 2006, 10:01 AM
#4
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Location:
Sofia, Bulgaria
Posts:
195
Plugin Contributions:
0

Re: Database Backup Manager - MySQL

hmm
where i can edit the mysqldump binary. ?

7 Aug 2006, 3:25 PM
#5
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Location:
Sofia, Bulgaria
Posts:
195
Plugin Contributions:
0

Re: Database Backup Manager - MySQL

Ok i EDited the line but when I needed to restore from admin panel i get this error

Result code: 1
Failure: The database may NOT have been restored properly. Please check it carefully.

what that means ?

7 Aug 2006, 6:14 PM
#6
zapisto avatar

zapisto

Zen Follower

Join Date:
Aug 2005
Posts:
163
Plugin Contributions:
0

Re: Database Backup Manager - MySQL

i got this error :

Result code: 2
attention 0 => mysqldump: Got error: 1045: Access denied for user '*******'@'localhost' (using password: YES) when trying to connect
erreur Failure: The database has NOT been saved.

the username was correct , and i presume the mod take pass from the config file so it must be correct the shop work fine.
any suggestion ?

7 Aug 2006, 8:08 PM
#7
drbyte avatar

drbyte

Sensei

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

Re: Database Backup Manager - MySQL

Sound like your server may not like letting you use the mysqldump binary without extra parameters or other security clearance.

Talk to your host about any special command-line requirements.

7 Aug 2006, 8:42 PM
#8
zapisto avatar

zapisto

Zen Follower

Join Date:
Aug 2005
Posts:
163
Plugin Contributions:
0

Re: Database Backup Manager - MySQL

DrByte:

Sound like your server may not like letting you use the mysqldump binary without extra parameters or other security clearance.

Talk to your host about any special command-line requirements.
thanks doc will check that