database pre-fix, can I change it?

I did a fresh install of v1.3.0.2 specifying the database prefix as "zen". My tables now show as "zentablename". I wanted them to read "zen_tablename". I'm guessing that during the install I should have used a prefix of "zen_". Is there a way that I can change the prefixes now?

Any advice is much appreciated,
Audra

Hi!

Yes, you can, but it'll take some time.

You have to rename every table in the database:
ALTER TABLE zentablename RENAME zen_tablename ;

Then you have to change the prefix settings in your config files:
Change this define('DB_PREFIX', 'zen');
to define('DB_PREFIX', 'zen_'); in both includes/configure.php and admin/includes/configure.php.

It should work, but if it's a new install and you haven't changed many things yet, it seeems easier to reinstall the whole thing.

Thank you! I will reinstall w/ the correct prefix:yes:

MarW is right ; however, you can also use the zc_install program via the Database-Upgrade page to change the prefix (but a re-install is definitely better if you have no specific data to preserve !!! )