Remove DB Prefix

[shags38]

I am doing an upgrade 'trial' from 1.5.1 to 1.5.5e and have a problem with copying old database into the new install - old database has a 'prefix' so tables with prefix are not loading into correct tables in new install.

During install the process didn't ask if DB should have prefix (as it does in 1.5.1 install for example) unless I missed that step - so I now have a database with duplicate entries, with and without prefix so I assume I need to either 'merge' tables in new db or using the copy of the old db delete the prefix then load that modified db into the new install.

Problem is if my assumptions are correct I have no idea how to merge tables if it can be done at all - or how to delete the prefix from the copy??

cheers,
Mike

[mc12345678]

Umm... so many options to choose from by which to possibly explain all of the pitfalls, caveats, and possible work-a-rounds...

What's wrong with "starting over" with the database aspect and stepping through the upgrade as suggested through say this FAQ: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

Merging of database records.... Yes can be done, some things quickly, others require matching up records from one or more tables which may require matching with again one or more tables, etc... there are ways to salvage specific data in a way that is database independent, but as always, the post for assistance should be more specific to get more direct assistance...

Besides, as you said this is a trial upgrade... It will help you most if you do now what you plan to do later and even better if it is something consistent, describable, and/or even published. Go out on a limb with something wild and crazy and you're more likely to require specialized unique support to correct the issue. :/

Just sayin'.

[shags38]

Umm... so many options to choose from by which to possibly explain all of the pitfalls, caveats, and possible work-a-rounds...

What's wrong with "starting over" with the database aspect and stepping through the upgrade as suggested through say this FAQ: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

Merging of database records.... Yes can be done, some things quickly, others require matching up records from one or more tables which may require matching with again one or more tables, etc... there are ways to salvage specific data in a way that is database independent, but as always, the post for assistance should be more specific to get more direct assistance...

Besides, as you said this is a trial upgrade... It will help you most if you do now what you plan to do later and even better if it is something consistent, describable, and/or even published. Go out on a limb with something wild and crazy and you're more likely to require specialized unique support to correct the issue. :/

Just sayin'.

Thanks MC - the problem with the upgrade as I see it was twofold;
1. install didn't ask to nominate a db prefix
2. running zc_install after uploading old db into new did not give 'upgrade database only' option but simply 'clean install'

I assume that both of these should have occurred?

However I will start again (again) - however if install doesn't ask for prefix then I am back to square one.

cheers, Mike

p.s. found this so figured I could delete prefix, export, upload to new install and then reload copy with prefix back to old db;
https://www.zen-cart.com/showthread....atabase+prefix

If your host provides phpMyAdmin, you can scroll to the bottom of the database, select all the tables and have it change the With selected to Replace table prefix.

BACKUP BACKUP BACKUP

You'll enter the current prefix in the From box (Zen_ or zen_) and leave the To box empty. That will remove the prefix from all tables.

Not sure if it is case sensitive.

[shags38]

MC - I followed the process at bottom of last post and data is now in new install but I get message >> Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.

cheers,
Mike

[mc12345678]

MC - I followed the process at bottom of last post and data is now in new install but I get message >> Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.

cheers,
Mike

And following the instructions of the previous post, the zc_install folder gets uploaded again and run. The message presented indicates that the new fileset is trying to access an old database which means that at least the store side of the configure.php is pointing to the same database content (hopefully a backup copy and not the live store) as your live site.

[shags38]

And following the instructions of the previous post, the zc_install folder gets uploaded again and run. The message presented indicates that the new fileset is trying to access an old database which means that at least the store side of the configure.php is pointing to the same database content (hopefully a backup copy and not the live store) as your live site.

Yeppers - got it - ran install again and at least that side of it is ok now.

So having sorted out how to modify the database I am now going to start afresh with the install instructions open

thanks again, Mike