Backup MySQL Database

RedDevilDistributing:

Has anyone had any luck using this with the new release, 1.5.6?

Works fine. Check to be sure you uploaded all files.

swguy:

Works fine. Check to be sure you uploaded all files.

Thank you for your reply swguy. This is very odd. I have re-uploaded the entire package (using the exact same structure) and it still is not showing up under the Tools drop down. I am missing something very, very stupid and simple here.

RedDevilDistributing:

Thank you for your reply swguy. This is very odd. I have re-uploaded the entire package (using the exact same structure) and it still is not showing up under the Tools drop down. I am missing something very, very stupid and simple here.
Remember this is an admin side plugin, all files need to go into the admin directory structure.

mc12345678:

Remember this is an admin side plugin, all files need to go into the admin directory structure.

Remember when I said "I am missing something really stupid here?" Have you ever had one of those times where you just KNOW that you are overlooking something very simple and then instead of just letting go and coming back to it, you just keep on plugging away at it? Yup, that is what happened here.

Uh, gee, putting it in the ADMIN directory made all of the difference in the world. Geesh, thank you for beating me over the head -- LOL! Much thanks!

RedDevilDistributing:

Remember when I said "I am missing something really stupid here?" Have you ever had one of those times where you just KNOW that you are overlooking something very simple and then instead of just letting go and coming back to it, you just keep on plugging away at it? Yup, that is what happened here.

Uh, gee, putting it in the ADMIN directory made all of the difference in the world. Geesh, thank you for beating me over the head -- LOL! Much thanks!
Well, I can't remember if I posted to the thread or not, but I do remember the "difficulty" I had installing this plugin as my first to ever install... even though things seem pretty straight forward when really reading the instructions and looking at the folder structure, there just was something about it that didn't sink in.

Anyways, hopefully you learned something to apply to the installation of other plugins and at the same time when you see someone else with the same issue, maybe you'll jump in to help them as well.

When I try to backup the database I get the following error?

1 => mysqldump: Got error: 1045: Access denied for user 'tennes60_zenc'@'localhost' (using password: YES) when trying to connect

admin/backups has 777 permission

This isn't a filesystem issue, it's an issue connecting to your database. Did you try the latest version of this mod? I tried to handle the case where the password contains shell-expanded characters, which might be what you are running into.

In php7.3 getting this

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? ... backup_mysql.php on line 518

How to fix?

Change that to a break.

  if ($dir_ok == false) break;

swguy:

Change that to a break.

  if ($dir_ok == false) break;

Thanks for the info. The warning message gone.

Just changed host and belatedly discovered exec and shell_exec are disabled.
Has anyone attempted to modify this plugin to use "another method"...IS there any other method possible in the same vein: making a backup/restore from within Zen Cart?
Or, just give up and just use phpmyadmin export?

torvista:

Just changed host and belatedly discovered exec and shell_exec are disabled.
Has anyone attempted to modify this plugin to use "another method"...IS there any other method possible in the same vein: making a backup/restore from within Zen Cart?
Or, just give up and just use phpmyadmin export?
Are **passthru **and **system **also disabled? Those could be alternate ways to cause an external program to be executed.

I have always just told my hosting site to turn it on or I am moving to another hosting site ...

They are using this standard list:
exec, show_source, system, shell_exec, passthru, popen, proc_open

Is this just lazy protecion?

It seems kind of "knee-jerk", but I don't know what problem the hosting company is trying to solve by those functions' disablement.

torvista:

Just changed host and belatedly discovered exec and shell_exec are disabled.

Close your account. Not kidding - this is a terrible red flag that they are clueless.

Thanks for your comments. Not wishing to prolong the off-thread discussion, but note that this is shared/reseller hosting, not a vps and from what I read, it seems the norm that these functions are disabled on shared hosting...I don't find any comments out there indicating it is a sign of incompetance, annoying as it is.

torvista:

.. This is shared/reseller hosting, not a vps and from what I read, it seems the norm that these functions are disabled on shared hosting.

Not true. Plenty of shared hosting accounts permit you to run database backup, which depends on exec.

This file does an instant backup if called with the parameter ?backupnow, as per this post
https://www.zen-cart.com/showthread.php?35714-Backup-MySQL-Database&p=363376#post363376

In my cron tests I get "file not found" due to the ?parameter. Without the parameter it finds the file but complains about other stuff.

Anyone got this to work as a cron?

Hello, I am using this plugin and have a VPS. This is working fine on one of my accounts but is not working on another. Here is the error messages: Running V1.56a works fine on one site but not this one. Any suggestions or thoughts? When I get on phpAdmin from this account this is the database server it is showing:

Server: localhost:3306 same as the working backup site.

Server: lo
Result code: 2
0 => mysqldump: Got error: 1045: "Access denied for user 'website'@'localhost' (using password: YES)" when trying to connect

Failure: The database has NOT been saved.