By peaceninja on

I've installed drupal 5.1 successfully, but I wish it gave me the option to append a prefix to the tables. Post-installation, what is the best way for me to place these prefixes on the table names?? I am sharing the database with a wiki site and hope to goodness there isn't a conflict in the tables. Thanks,

⋅ Categories: Drupal 5.x

Comments

vm’s picture

vm commented

during installation you do/did have the ability to set a prefix, under the advanced menu which is collapsed. Had it been expanded during installation you could have added a prefix during installation.

Post installation, I'd suppose you can export the DB, add your table prefixes, reimport the DB, and then adjust the proper setting in settings.php to reflect the prefix.

kkkkkkkkkkkkkkkkkkkkkkk’s picture

kkkkkkkkkkkkkkkkkkkkkkk commented

Will any body tell me where to get the sql code for building the tables for the database that I have created?
Note: I use drupal-5.1

Thanks.

danmurf’s picture

danmurf commented

Do you want to export your current database tables, modify them (or not), and import them back? I would use something like phpmyadmin to export the tables - it will generate all the sql for you which you can then use to import, or edit as appropriate.

I came across this post as I've recently renamed my table prefix - I did this using phpmyadmin to rename each table one at a time. I know it's slow, but I didn't want to do a search/replace in case it replaced anything NOT a table name. The only problem I've found is now the sequencer table is off beat with the node IDs - maybe I should have done a search/replace in the sql after all? That way it would have picked up on the data in the sequencer table.

Does anyone know of any procedures for renaming the table prefix, like all areas to consider?

Many thanks

mooffie’s picture

mooffie commented

The only problem I've found is now the sequencer table is off beat with the node IDs -

The sequence table has a name column, which contains the prefixed name of the tables. You have to update it as well. do UPDATE pref_sequences SET name = CONCAT('pref_', name);

danmurf’s picture

danmurf commented

Did this and everything worked fine! Many thanks!
Dan