By flexy123 on

i read around and came along the tips to replace (in the drupal SQL database)

CREATE TABLE `
with CREATE TABLE `prefix_

INSERT TO `
with INSERT TO `prefix_

REPLACE `
with REPLACE `prefix

and then edit settings.php and edit the $db_prefix="prefix_"

This basically works, but there also needs the sequences in the DB fixed as described elsewhere.

My question, before i go into this further:

Are additional drupal modules, like google-sitemap and all other 3rd party modules compatible when i change my DB from not having table-prefixes to have prefixes ?

Or does the changes of the db prefixes only affect core-database table-names and should i leave all other table-names (for 3rd party modules) alone ?

Anyone have a recent all-in-one doc/script for doing that on-the-fly ?

⋅ Categories: Drupal 5.x

Comments

Cybergarou’s picture

Cybergarou commented

Unless you are sharing tables across sites you should prefix all of your tables the same way. Both core modules and 3rd-party modules are supposed to follow the prefixing rule unless the prefix is overridden in the settings file for a specific table.

I don't have a script to help you with that. I use MySQL Administrator which does renaming with a right-click.