Backup MySQL Database

The day I go "live", it will be on a window server, will it be "quote problems" you think ? Or is your addon "windows friendly" ? :D

/T

Ugh.

"friendly" ... as friendly as "windows" is in a hosting environment :P

Since every Windows server is configured differently, and since Windows has complicated security risks, it is a challenge to pre-anticipate every issue.

Try it on your live host and when the time comes, we'll deal with it then.

Keep in mind that if your host isn't willing to open up webserver access to cmd.exe, then this tool will most likely not work for you. Sorry... thank Bill.

Quote:

---

Originally Posted by DrByte

Try it on your live host and when the time comes, we'll deal with it then.

---

Hi there !

You were very right, when I put my shop on my live host, the backup part is working just like it suppose to. Thanx.

/Typhoon

I am also getting this error:

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.


Is there no way to install ZC on Windows XP for local testing purposes?

I tried WAMP5 and got this error and now I have switched to XAMPP and get the same error. Anyone have a suggestion?

Thank you.

Quote:

---

Originally Posted by duncanad

One small bug I have found with the new version is that if I backup to the server and click the 'No compression' radio button I get a .gzip file rather than an uncompressed file. If, however, I tick the 'Download without storing on the server' box I get an uncompressed file as expected.

Anyone else experienced this problem?

---

Yep. Exactly the same problem here.

Quote:

---

Originally Posted by Woodymon

Workaround: When I want to back up with compression off I just turn it off in Configuration > GZip Compression. Then I back up.

---

Doesn't work for me :(

Quote:

---

Originally Posted by duncanad

When I checked my configuration GZip compression was set to 'Off' so this setting does not appear to affect how the backup operates.

---

Same here!

Quote:

---

Originally Posted by Woodymon

The "No Compression (Pure SQL)" radio button in the BU mod dialog is defectively sticky ... I was the same way, not compressing the DB at first. But after many imports and exports I am now just fine with compressing.

---

Still can't get it to work for me. Strange thing is that out of 20-odd attempts to backup without compression, 1 or 2 will work but the rest will be .gz.

Quote:

---

Originally Posted by duncanad

By compresing the data there is a slight increase in the risk of corrupting the data. Larger backup files might be preferable to lost data. Anyway the engineer in me thinks if you are given the option then you should have that option.

---

Me too! Intermittent faults are always the worst. It's just kindof unsettling when you know something doesn't work but you don't know why :unsure:

I have a development site on my local machine. if i try to use the backup command, i get the following error.

http://localhost/zenadmin/images/icons/warning.gif Result code: 1
http://localhost/zenadmin/images/icons/warning.gif 0 => 'c:/Program' is not recognized as an internal or external command,
http://localhost/zenadmin/images/icons/warning.gif 1 => operable program or batch file.

I should point out that it does work on the live site. Can you please help with a fix for the local environment.

Thanks

G'day,

If you're thinking of using something like this to backup your MySQL databases, then you might want to check out the excellent mySQLdumper at www.mysqldumper.de/en/.

mySQLdumper enables me to get regular backups of all of my MySQL databases sent via email or FTP file transfer.

mySQLdumper works so as to overcome the limitations people often come up against when trying to backup and/or restore larger databases.

It's pretty much a set and forget solution. Though I must admit it took me a while to set it up the first few times. I wrote myself a detailed step by step guide which you should be able to find either on the mySQLdumper forums, or on the forums at JaguarPC.

Best Regards, Lloyd Borrett.

I am trying to upgrade my cart to 1.3.6, but I've decided to start from a vanilla version of the current codebase. I just tried to install the latest version of the excellent database backup utility on my windows xp sp2 test box and I get a similar problem as other windows users :-

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

However, I have an older version of this in contribution working on my 1.2.6 cart running, on the same windows test box. Any idea's ?.

It is pretty sad! I am a total beginner with no PHP, HTML, CSS, etc.
I am learning as i go, but there doesn't seem to be a great deal of support from those with the knowledge.....

The problem with this mode is: -

mqsqldump: - (backup)

Line 115, 116, 177, 129:

Original
$dump_params .= '" --host=' . DB_SERVER . '"';

New
$dump_params .= ' --host=' . DB_SERVER . '';

The original only works on linux/unix (i guess) the quotes don't work on windows.

Removes the quotes and the backup will function on both environments.


Mysql; - (restore)
Linux/Unix
$load_params .= ' "--host=' . DB_SERVER . '"';

Windows
$load_params .= ' --host=' . DB_SERVER . '';

Now i need your help! How do i make a switch to use quotes on linux/unix or no quotes on windows please.

I have successfully modified this mode to work on both linux and windows.

The only issue i have with it now is to get it to use gzip for windows.
I didn't seem to have much luck with that after many unsuccessful attempts.