Needing sql query to drop table prefix

[audradh]

I have a database that was set up with table prefixes. I need to export the data from some of the tables then import it into another zen database that does not have any prefix.

I am looking for an sql query to drop the table prefix, so that when I export/import the data will fall into the correct tables rather than creating new ones.

Any help appreciated!
Audra

[Merlinpa1969]

once you have it downloaded open it in a text editor and do a search replace for the prefix_ and replace it with a blank


ALERT!!!!! See DrByte's note below for caveats to this approach!!



.

[audradh]

That was simple, thank you.

[Merlinpa1969]

quite welcome,
if you were going to be moving the configure tables that wouldnt work that easy but since only moving customers and orders products will work fine

[DrByte]

as an addendum for others reading this thread, be very careful about doing a carte-blanche replacement of "prefix_" especially if it's "zen_".

You're better off searching for "CREATE TABLE prefix_" and then removing the "prefix_" portion. This can be automated quite easily with most text editors. You should do similarly with DROP TABLE and INSERT INTO statements.


Another thing to note: If you simply want to rename all the tables in your database to remove or change the prefix ... on the live site ... simply use the "change prefix" fields in the Database Upgrade screen of the zc_install tools.

[ptowers49]

I needed to import a datbase with a zen_ prefix into a new store without a zen_ prefix as part of a 139 upgrade and this method of editing the database export file seemed to work well.

I noticed that most of the other posts suggest using the zc_install database upgrade method. DOes anyone know whether this file editing method is sound?