mysql paypal_testing table issue during restore

[24jedi]

I am trying to move an existing store but there is a mismatch with the tables in the database.
This is not an update question ... I think

The Current site has a working v1.3.8 Zen-Cart
I have exported the DB using phpmyadmin, basically accepting the defaults.
The I attempted to 'restore' the backup into a fresh install at new hosting service.

The Zen-Cart version for the new install is v1.3.8 as well.
The restore process is failing.

It appears that the NEW db has "zen_paypal_testing" table, whereas the current site does not.

All other tables have identical naming syntax.
The table prefix is same for both mysql db's.
To verify, I cut-n-paste the table names into temporary files, then used WinMerge to compare nameing syntax..etc.
Please help me work trough this.

Original site was updated about a year ago from v1.2.7 - v1.3.8
I have not updated either site to 1.3.8a yet.

Current Site
(94) tables in db
Zen Cart 1.3.8
Database Patch Level: 1.3.8
v1.3.8 [2007-12-19 22:29:23] (Version Update 1.3.7->1.3.8)
v1.3.7 [2007-12-19 22:28:57] (Version Update 1.3.6->1.3.7)
v1.3.6 [2007-12-19 22:28:41] (Version Update 1.3.5->1.3.6)
v1.3.5 [2007-12-19 22:28:21] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2007-12-19 22:27:41] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2007-12-19 22:26:47] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2007-12-19 22:25:53] (Version Update 1.2.7->1.3.0)
v1.2.7 [2006-03-02 13:56:59] (Fresh Installation)

----------------------
NEW site
(95) tables in db
Clean Install setup on another hosting service
uploaded from "zen-cart-v1.3.8-full-fileset-11302007.zip"
Zen Cart 1.3.8
Database Patch Level: 1.3.8
v1.3.8 [2009-01-02 23:12:32] (Fresh Installation)
v1.3.8 [2009-01-02 23:12:32] (Fresh Installation)

----------------------
?? Can I simplly copy the section of the sql file for "zen_paypal_testing" from NEW database backup and paste into the sql file I am trying to restore.

One other question concerning charset..
Current table... ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=359 ;
New Table....... ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

?? Can I do I find/replace in Current file and replace latin1 with utf8

Thanks

[DrByte]

The "paypal_testing" table can be ignored. It is used by the developers, and serves no purpose whatsoever for storeowners. It is being removed as of v2.0.0

[24jedi]

DrByte ... Thanks, but your wisdom was unfortunately not real helpful. The restore process was failing due to this extra table. keyword=failing. I was unable (I seem to recall) to simply ignore the table.

However... after getting some much needed sleep and some additional trial-n-error, I came up with a solution that does work. I also submit that my experience level was also a probable factor.

1. From within the phpmyadmin GUI interface for database administration, there is an export tab.
2. Within the OPTIONs box there are some check boxes, most but not all, default to checked.
3. selecting all to be checked, allowed the restore process to complete successfully.

• Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
• Add IF NOT EXISTS
• Add AUTO_INCREMENT value
• Enclose table and field names with backquotes
• Add CREATE PROCEDURE / FUNCTION

I am pretty sure enabling Add DROP TABLE / VIEW / PROCEDURE / FUNCTION allowed the import process to procede successfully.

As for CHARSET, again from within the phpmyadmin GUI, there is a dropdown selector which is used to identify the CHARSET for the file being imported/restored.

Thanks

[DrByte]

Yes, you need to drop existing tables first before you can create them fresh, whether manually or as part of the backup/restore settings.

The recommended backup settings are listed here: https://www.zen-cart.com/tutorials/i...hp?article=103
At the present time, Zen Cart does not use views, procedures, or database-side functions, so there's no need to choose those options specifically unless they're lumped in with "table" options.