If this is your first visit, check our documentation. To post, register or login.
Forums / Basic Configuration / testing DB Restore?

testing DB Restore?

Started by kevinmc3 on 25 May 2013, 3:08 PM · Views: 749

Results 1 to 3 of 3
25 May 2013, 3:08 PM
#1
kevinmc3 avatar

kevinmc3

Totally Zenned

Join Date:
Jun 2006
Posts:
786
Plugin Contributions:
0

testing DB Restore?

Would like to periodically test my backups by restoring DB to a test site . Was told there was a MOD but Checked mods and didn;t see any tool.
Other than hiring someone with a test server , any other options?

25 May 2013, 3:22 PM
#2
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: testing DB Restore?

kevinmc3:

Would like to periodically test my backups by restoring DB to a test site . Was told there was a MOD but Checked mods and didn;t see any tool.
Other than hiring someone with a test server , any other options?

Set up a test environment on your own computer. It's quite easy using one of the 'WAMP" distribution packages. You'll then be able to test your recovery procedures off-line in a safe environment.

Such a site is perfect for trialling mods, etc before deploying on your live server too.

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

25 May 2013, 6:32 PM
#3
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

Re: testing DB Restore?

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

and I never get tired of saying it should be core to encourage/instill exactly what Rod suggested as the recommended working method for developing your shop safely with no downtime.

I use this to backup nightly automatically and on demand ad-hoc for use in my local test site every time I am preparing an spreadsheet import.
Or while repeatedly testing sql statements included with a mod, to fix/improve the bits I don't like before installing on the production site.

In short, leave the production site well alone, only play with the local site and upload all your hacklets/changes in one go with Beyond Compare or similar when you are sure all is well ...that's my opinion of course!!

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...