Thanks again for your reply Torvista. Yes, this is correct...I can backup, but when I try to restore is when I get this issue. This production site is in a sub folder on my live site server now...so this is where I am testing once again with my current store database in this environment.

I have just tried backing up as a .zip file in this test site and all worked perfectly. File size is 68,896Kb.

I am then saving my live site database, placing it in the Admin->Backups folder in my test site and then trying to restore it in. On my live site, I am using this same plugin (version 1-5g)for Zen Cart v.1.5.8. It does not have the option to save as just a .zip file. Can only save as .gz or pure SQL