Forums / General Questions / Where is the phpMyadmin 4.9.7 database backup custom setting how to page?

Where is the phpMyadmin 4.9.7 database backup custom setting how to page?

Views: 395

Results 1 to 3 of 3
8 Jul 2021, 7:02 AM
#1
justwade avatar

justwade

Zen Follower

Join Date:
Oct 2005
Posts:
206
Plugin Contributions:
0

Where is the phpMyadmin 4.9.7 database backup custom setting how to page?

That is my question, I have been stumped trying to find the same "ticks" for making a good custom DB backup but all the zen links lead me to the same page https://docs.zen-cart.com/user/running/backup/. This is not the same as a list we could refer to before. It had setting for v3.3 or lower, using v3.4 to 3.9, and v4.x as i recall. I have phpMyAdmin 4.9.7. This link appears to be for a one fit all version that i cant match settings with confidence.
Please help, I am needing to do some DB backups!

Justwade
Zen 1.5.5f
Zen 1.3.9h*, Zen 1.27 + (did that, done with that)*

8 Jul 2021, 9:59 AM
#2
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,720
Plugin Contributions:
56

Re: Where is the phpMyadmin 4.9.7 database backup custom setting how to page?

Just verified against phpMyAdmin 4.9.7. What's specified in the help is correct, except you might not see these:

Tick “Complete Inserts” (helpful during upgrades if you have many custom fields added by modifications made to your site)
Tick “Extended Inserts” to help keep the file smaller, especially if you are just making backups for safekeeping and not for troubleshooting something.

Everything else is the default setting for a Custom export.

Note that your cPanel may also provide a Backup utility which allows you to export your database with one click.

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

12 Jul 2021, 7:14 PM
#3
justwade avatar

justwade

Zen Follower

Join Date:
Oct 2005
Posts:
206
Plugin Contributions:
0

Re: Where is the phpMyadmin 4.9.7 database backup custom setting how to page?

Yes, it was those missing ticks that had me confused looking for different settings in this version. I do need to set up a backup utility.

We just found an old printout for v4x and it does say use mostly default settings.

Output: Leave all the settings defaults except maybe Compression
Object creation options: -check the box next to DROP TABLE

Thank you!

Justwade
Zen 1.5.5f
Zen 1.3.9h*, Zen 1.27 + (did that, done with that)*