can't find MySQL Backup Tool

21 Dec 2007, 3:37 PM

#1

cheapstairparts

Zen Follower

Join Date:: Oct 2007
Posts:: 149
Plugin Contributions:: 0

can't find MySQL Backup Tool

The faq says
Use either the "Backup MySQL Database" contribution under Admin->Tools to do the backup of your database

I have no option under there.

zencart 1.3.5

Get cheap stair parts at low prices - http://cheapstairparts.com - A highly successful zen-cart ecommerce site.

21 Dec 2007, 4:22 PM

#2

yellow1912

Totally Zenned

Join Date:: Oct 2006
Posts:: 5,422
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

Did you go to the download section on this site, download and install that mod?

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

21 Dec 2007, 4:43 PM

#3

cheapstairparts

Zen Follower

Join Date:: Oct 2007
Posts:: 149
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

Nope! Didn't know I had to. Doing it now. Thanks!

Get cheap stair parts at low prices - http://cheapstairparts.com - A highly successful zen-cart ecommerce site.

21 Dec 2007, 7:05 PM

#4

Kim

Obaa-san

Join Date:: Jun 2003
Location:: West Coast, North America
Posts:: 26,684
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

The keyword in the FAQ is contribution - that means it is an optional add-on.

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

21 Dec 2007, 9:26 PM

#5

cheapstairparts

Zen Follower

Join Date:: Oct 2007
Posts:: 149
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

in that case, rewrite the faq to state you need to download and install the contribution before you can go to admin->tools to use it.

Get cheap stair parts at low prices - http://cheapstairparts.com - A highly successful zen-cart ecommerce site.

16 Jan 2008, 4:36 AM

#6

jenpen

Zen Follower

Join Date:: Sep 2007
Location:: Far South Coast, NSW, Australia
Posts:: 427
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

I have downloaded mySQL Backup mod but not sure where to put it. The readme says "upload all files from the "admin" folder of this ZIP as-is to your server". Where on the server? Root directory? When I put them there I still don't get a listing under Admin> Tools. I've tried a couple of other places too.

16 Jan 2008, 6:08 AM

#7

misty

Inactive

Join Date:: Apr 2004
Location:: UK
Posts:: 5,752
Plugin Contributions:: 1

Re: can't find MySQL Backup Tool

says "upload all files from the "admin" folder of this ZIP as-is to your server". Where on the server?
It means upload files contained in the zip to admin folder of your zencart install.

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others

16 Jan 2008, 6:40 AM

#8

jenpen

Zen Follower

Join Date:: Sep 2007
Location:: Far South Coast, NSW, Australia
Posts:: 427
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

So you mean, the "includes" folder and backup_mysql.php file should end up directly in the shop's admin folder? There's already a folder there called "includes", I don't want to overwrite it.

16 Jan 2008, 7:12 AM

#9

misty

Inactive

Join Date:: Apr 2004
Location:: UK
Posts:: 5,752
Plugin Contributions:: 1

Re: can't find MySQL Backup Tool

There's already a folder there called "includes",
Yes, you ADD the files to /admin/ includes folder, NOT replace the /admin/includes folder.
File paths are defined in zip file.. i.e NOT all those files go into /admin/includes/

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others

17 Jan 2008, 12:44 AM

#10

jenpen

Zen Follower

Join Date:: Sep 2007
Location:: Far South Coast, NSW, Australia
Posts:: 427
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

I have carefully added the files and folders to the corresponding folders in "Admin". So backup_mysql.php is in Admin. The folders in the Includes folder in the download (languages, extra_datafiles, boxes) are in the includes folder in my Admin. Still I get no "Database Backup-MySQL" in my Tools menu. Could it be a permissions issue? I am hosting the cart locally for now so have no CHMOD but have removed the "read-only" on the back-ups folder.

17 Jan 2008, 1:14 AM

#11

jenpen

Zen Follower

Join Date:: Sep 2007
Location:: Far South Coast, NSW, Australia
Posts:: 427
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

I have carefully added the files and folders to the corresponding folders in "Admin". So backup_mysql.php is in Admin. The folders in the Includes folder in the download (languages, extra_datafiles, boxes) are in the includes folder in my Admin. Still I get no "Database Backup-MySQL" in my Tools menu. Could it be a permissions issue? I am hosting the cart locally for now so have no CHMOD but have removed the "read-only" on the back-ups folder.

17 Jan 2008, 2:42 AM

#12

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: can't find MySQL Backup Tool

jenpen:

The folders in the Includes folder in the download (languages, extra_datafiles, boxes) are in the includes folder in my Admin. Still I get no "Database Backup-MySQL" in my Tools menu. Could it be a permissions issue?

No, it's not a permissions issue.
If you haven't loaded the /admin/includes/boxes/extra_boxes/xxxxxx.php file included in the zip, you won't get the menu option.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

17 Jan 2008, 4:16 AM

#13

jenpen

Zen Follower

Join Date:: Sep 2007
Location:: Far South Coast, NSW, Australia
Posts:: 427
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

Everything's there. everything in place.
I just noticed something in the readme file, about defining some settings in languages/english/backup_mysql.php. It refers to this code:

define('LOCAL_EXE_MYSQL', '/usr/bin/mysql'); // used for restores
define('LOCAL_EXE_MYSQLDUMP', '/usr/bin/mysqldump'); // used for backups

and it says to specify the exact path to these utilities for my server.
I'm a real newbie and at a loss here, any help much appreciated.

17 Jan 2008, 4:19 AM

#14

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: can't find MySQL Backup Tool

jenpen:

Everything's there. everything in place.
I just noticed something in the readme file, about defining some settings in languages/english/backup_mysql.php. It refers to this code:

define('LOCAL_EXE_MYSQL', '/usr/bin/mysql'); // used for restores
define('LOCAL_EXE_MYSQLDUMP', '/usr/bin/mysqldump'); // used for backups

and it says to specify the exact path to these utilities for my server.
I'm a real newbie and at a loss here, any help much appreciated.

Those settings will have nothing to do with your Tools menu. It is handled strictly by the /admin/includes/boxes files.

If you're having trouble installing and getting the addon utility to run, you can always do your own database backups using the database management tools supplied by your hosting company. The most popular one is phpMyAdmin. Instructions for doing database backups via phpMyAdmin can be found in this FAQ: https://www.zen-cart.com/tutorials/index.php?article=103

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

17 Jan 2008, 6:16 AM

#15

jenpen

Zen Follower

Join Date:: Sep 2007
Location:: Far South Coast, NSW, Australia
Posts:: 427
Plugin Contributions:: 0

Re: can't find MySQL Backup Tool

Thanks DrByte. As I said, it's hosted locally at the moment but I have done back-ups through phpMyAdmin. I just thought this would be quicker, but no problem.

26 Jan 2008, 8:17 AM

#16

misty

Inactive

Join Date:: Apr 2004
Location:: UK
Posts:: 5,752
Plugin Contributions:: 1

Re: can't find MySQL Backup Tool

DrByte:

Those settings will have nothing to do with your Tools menu. It is handled strictly by the /admin/includes/boxes files.

If you're having trouble installing and getting the addon utility to run, you can always do your own database backups using the database management tools supplied by your hosting company. The most popular one is phpMyAdmin. Instructions for doing database backups via phpMyAdmin can be found in this FAQ: https://www.zen-cart.com/tutorials/index.php?article=103
Backup MYSQL Plugin
Does current version in downloads, work with 1.3.8*?
Details state for 1.3.7..

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others

26 Jan 2008, 3:51 PM

#17

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: can't find MySQL Backup Tool

misty:

Backup MYSQL Plugin
Does current version in downloads, work with 1.3.8*?
Details state for 1.3.7..

Yes - works with any v1.3.x release.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.