Backup MySQL Database

[rued]

Is the Backup MySQL Database contibution working in v1.3?

https://www.zen-cart.com/downloads.php?do=file&id=7

[Woodymon]

Is the Backup MySQL Database contibution working in v1.3,

Yes. .

[rued]

Ok, thanks. :)

[DrByte]

File Is Now In The Downloads Area

https://www.zen-cart.com/downloads.php?do=file&id=7

[rued]

Great, thank you DrByte - this saves the day. :)

[ts232]

Thanks for posting this. I installed it, but when I attempt the backup I get the error:


Result code: 127
Error ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED.


But mysqldump is right where it should be on my dreamhost linux host at /usr/bin/mysqldump . Any ideas what to try for a fix?

[theodin]

DrByte,
I have a renamed admin folder - When I installed it would seem the MySQL plugin couldnt find my backups dir anymore. (It exists, just under my new admin location.) I searched the file, and couldnt find any hard references. I also looked in config.php in admin/includes.

My problem was not only should
define('DIR_WS_ADMIN', '/store/xxx/');
define('DIR_WS_HTTPS_ADMIN', '/store/xxx/');

be changed, but ALSO:
define('DIR_FS_ADMIN', '/var/users/xyz/abc/htdocs/store/xxx/');

I dont know if this info might be useful to stick in the docs you have for it...

Fantastic work, thanks for the plugin!!!

[Ajeh]

Thanks very much for posting the solution to your backups issue with a renamed /admin ... this will help others who also are following the suggestion to rename the /admin for security purposes ...

[Woodymon]

I also looked in config.php in admin/includes.

My problem was not only should
define('DIR_WS_ADMIN', '/store/xxx/');
define('DIR_WS_HTTPS_ADMIN', '/store/xxx/');

be changed, but ALSO:
define('DIR_FS_ADMIN', '/var/users/xyz/abc/htdocs/store/xxx/');

The instructions regards to above, plus many more important instructions, are located in /docs/important_site_security_recommendations.html

[tekram]

i get the following message when trying to backup:

0 => 'c:/apache2triad/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,

does this mean the server is running "in strict safe_mode,
or with open.basedir restrictions in effect, or with restrictions against
using "exec()" commands. "