Okay, first, I have to say that I've always loved the word "wonky". But I digress....

I am running the latest version of zen cart. The way I did it was through phpmyadmin at home here. I exported and saved as an SQL file with the following checked:
structure:
add AUTO_INCREMENT value
enclose table and field notes with backquotes
SQL export compatability: none
Data:
use hexidecimal for binary fields
export type: insert
save as file.

On the other end (again in phpmyadmin) I dumped all the existing data from the database and used the browse option to snag the file from my computer. The nice (but slightly clueless) lady at lunarpages tech support said not to touch the character set of the file option (set at utf8 by default) but I think that she new what that meant about as much as I did. That was it. I'm not really sure what the heck you do with the editor (I'm using PSpad by the way, crimson editor pissed me off) but the file structure in both phpmyadmins looks the same. Not sure about the internal structure though. So what did I do wrong?