Backup MySQL Database

Hi:

I am having trouble with the database Backup too. After I installed it, I changed the CHMOD on the backup folder to 777. I got an error so I changed it to 755as recommended by the "read me" file. I am getting a 404 error now. Any suggestions?

Silver

I have been hacking this about for a long time and would like people to try it out before I upload it:

2015-01-14 - v1.6
added option to add a suffix to backup filename
changed mysql to mysqli
added support for gzip and zip restores in windows
added extra tool paths to configures file to enable the same file to be used in a production and local development environment
minor debug formatting changes
moved mysql tool path defines from language files to /extra_datafiles
added automatic path detection to the paths checked
added error checks to page registration of admin tools menu item to detect incomplete installations

Note the DEBUG option is on by default.

Quote:

---

Originally Posted by torvista

I have been hacking this about for a long time and would like people to try it out before I upload it:

2015-01-14 - v1.6
added option to add a suffix to backup filename
changed mysql to mysqli
added support for gzip and zip restores in windows
added extra tool paths to configures file to enable the same file to be used in a production and local development environment
minor debug formatting changes
moved mysql tool path defines from language files to /extra_datafiles
added automatic path detection to the paths checked
added error checks to page registration of admin tools menu item to detect incomplete installations

Note the DEBUG option is on by default.

---

Would love to test this potential mod. Finding havng issues with current php and commands in version available online. Was going to read back to see what solutions have been offered, but saw this first. :)

Please advise how to obtain.

Quote:

---

Please advise how to obtain.

---

Hmmm, I thought it was in my previous post, so here it is (again?):

Why this is not core functionality I cannot understand, I use it constantly to copy the production db to my development db,and do repeated restores when testing installation routines that affect the db.
It's an essential tool for me.

Quote:

---

Originally Posted by torvista

Hmmm, I thought it was in my previous post, so here it is (again?):

Why this is not core functionality I cannot understand, I use it constantly to copy the production db to my development db,and do repeated restores when testing installation routines that affect the db.
It's an essential tool for me.

---

Dunno what happened to it/why/how removed. But thanks. Kinda me too, been looking for a way to integrate it into some other software that modifies the database and would love to be able to call a function if the capability were present to "automatically" do a backup (bypassing the applicable question screens if installed).

Obviously haven't tried hard, but...

Hi,

I have installed the tool.
It creates the backup file but also shows the error message:
Warning 0 => Warning: Using a password on the command line interface can be insecure.

Also, I tried to restore a file. It does not show any error, but actually it is not restoring the database.

I am using zencart version 1.5.4

thanks in advance for your help !!

According to the Version history here https://www.zen-cart.com/downloads.php?do=file&id=7
Backup MYSQL Plugin - Version: v1.5a has not been updated since 2012 and is only validated up to Zen Cart v1.5.3.
Is it good for Zen Cart v1.5.5 and v1.5.5a?

Quote:

---

Originally Posted by Zean

According to the Version history here https://www.zen-cart.com/downloads.php?do=file&id=7
Backup MYSQL Plugin - Version: v1.5a has not been updated since 2012 and is only validated up to Zen Cart v1.5.3.
Is it good for Zen Cart v1.5.5 and v1.5.5a?

---

It works fine for me on 1.5.5a

Thanks! It is not working for me.
I get an error message and an empty gzip file saved in the admin/backups directory.
Here's the error message . . .

Code:

---

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

---

Any ideas?

My vitals
1. Zen Cart v1.5.5a fresh clean install including demo data; files uploaded via FTP then run zc_install
2. Linux Apache
3. PHP Version: 5.6.17 (Zend: 2.6.0)
4. Database: MySQL 5.5.42-37.1-log

Quote:

---

Originally Posted by Zean

Thanks! It is not working for me.
I get an error message and an empty gzip file saved in the admin/backups directory.
Here's the error message . . .

Code:

---

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

---

Any ideas?

My vitals
1. Zen Cart v1.5.5a fresh clean install including demo data; files uploaded via FTP then run zc_install
2. Linux Apache
3. PHP Version: 5.6.17 (Zend: 2.6.0)
4. Database: MySQL 5.5.42-37.1-log

---

Could be that your database password (in DB_PASSWORD) contains a special character that's not translating well when the backup drops out to the command-line and passes the password parameter to do the database export. Anything in there like a $ or # or back-tick or quote/apostrophe or * or & might be problematic, depending on your server operating system.