Backup MySQL Database

[DrByte]

Backing up appears to work fine. But if I click on any of those backups, or if I click on restore, the program goes back to the login screen, and the login doesn't work. No errors were generated.

Sounds like maybe the backup filenames (which are named after your db name) might be triggering some anti-hijack rules that your hosting company has configured in "mod_security" on your server, and thus the URLs are being rejected, and then the mangled URL means ZC can't interpret the request, so it takes you to the home page.

[utefan]

I am seeing the same security error. @muteyaar, did you find a fix for this? Thanks.

[torvista]

I made a lot of changes to this ages ago and never got round to uploading them until now:
https://github.com/torvista/Backup-MySQL-for-Zen-Cart

If you are already using the version from the Plugins with no problems, the only thing you may be interested in is the option to add a suffix to the backup filename. I find that useful prior to doing some major db import/update.

- 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
- 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
- changed quote marks to single for Nix and double for Win around passwords to cope with metachars ($%<&* etc.) in passwords
- added debug info option tickbox (at foot of file)
- changed to html5, removed obsolete formatting tags
- tested with php 7

The functionality this plugin offers should really be in the core. It is indispensable for repeat testing of code that modifies a database and anything that makes testing easier has to be a good thing.

[Website Rob]

Please don't tell people to automatically use 777 permissions--for anything on a server/hosting account. That is just wrong for all kinds of reasons.

FTP programs automatically use correct permissions as defined by the server. I would suggest you tell people to use 755 permissions and if there is problem, to first look at their error logs and determine the problem. If it is a file permission only then to try 777 permissions.

[torvista]

Please don't tell people to automatically use 777 permission

Agreed...that was blindly copied from the original readme.

[mc12345678]

Please don't tell people to automatically use 777 permissions--for anything on a server/hosting account. That is just wrong for all kinds of reasons.

FTP programs automatically use correct permissions as defined by the server. I would suggest you tell people to use 755 permissions and if there is problem, to first look at their error logs and determine the problem. If it is a file permission only then to try 777 permissions.

And even then, file permissions may need 644.

My first install years back and it included other non-ZC pages, I tried 777 for folders and files. At that point, host had to go back and reset everything. Max they allowed: folders: 755, files: 644...

[Website Rob]

That is true. I forgot I needed to specific.

So for those in doubt, default settings for properly secured Linux server are:

755 dir.
644 file

I cannot speak for Windows servers as I don't use them.

As mentioned though, FTP programs usually use the default setting of the server (regardless of OS) and that is best to start with. So don't change dir. or file permissions unless you have to!

[ideasgirl]

Hi,

Lately I'm getting the following warning when doing backups:

Warning: Using a password on the command line interface can be insecure.

Zen Cart v.1.5.4
PHP Version: 5.6.30
Database: MySQL 5.6.35

Is there a way to solve this?

[DrByte]

Not at the present time.

[idtags]

I installed BACKUP_MYSQL Admin Tool Designed for: Zen Cart v1.3.x and 1.5.x series on my 1.5.5. Zen Cart.

Everything appears is working fine.

But I have 2 questions:

1. Admin->Tool menu shows sub menu "DataBase BACKUP_MYSQL" 2 times:

Attachment 17055

2. When I use both options No Compression (Pure SQL) and Use GZIP generating backup is compressed in both cases.

Is this issue of installation of web hosting server software?

Any suggestions are appreciated.