Database Upgrade issues

[Danielle]

Hi there,

I just did a new install of a zencart site. The new database I created does not have a prefix. The site is fully setup now and so there have been lots of additions to the database. My client just sent me an old database that they want information imported from (they were not planning on this but changed their minds). The old database has the prefix direct, with no _ in it. So for example, the admin table is called directadmin. I have tried absolutely everything to remove the prefix, but it just will not work. Is this because there is no _ between the prefix and the table names? I have tried doing it using the database upgrade features during zc_install and I have tried the prefix change mod in the downloads section. I also tried adding the prefix direct to the new database, but that did not work either, just gives a blank page that says:

in:
[SHOW TABLES]

Is there some way to merge these two databases? I have been working on this literally all day and am ready to scream! I tried manually going through the sql file in notepad and changing the database names, but I must be doing something wrong, because it just keeps giving me errors when I upload the changed file.

Thanks!

[Danielle]

OK, I FINALLY got the prefix removed!!! However, how do I now merge the two databases? I tried exporting the old one and then importing it into the new one, but it keeps giving errors saying duplicate entry. I did check the box that says "if not exists" while exporting. Do I need to do something else?

[Danielle]

Figured out a way to do it, all fixed now :)

[therealex]

Figured out a way to do it, all fixed now :)

Glad you got it sorted. We're moving to a new host, and I'm sitting here waiting for the database to be built (I installed using the hosts application installer, as opposed to doing it manually.)

Would you mind explaining how you solved your two problems? I'm sure you're not the only one who has run into it, and your post came up right away when I searched for "database prefix".

In advance, thanks!