By astra on

How to have all database names prefixed by installing? For example, each table name prefixed with the string 'main_'.

I have ever run the file database.mysql with phpMyAdmin to ceate a database for Drupal 4.6.3, but all tables are without prefix. Nobody likes to have so many tables mamually prefixed one by one.

Any solution? Thanks!

Comments

mike3k’s picture

mike3k commented

Open database.mysql in your favorite editor and do a global replace like:

s/CREATE TABLE /CREATE TABLE main_/
s/INSERT INTO /INSERT INTO main_/

--
Mike Cohen, http://www.mcdevzone.com/

djnz’s picture

djnz commented

... remember to do the same. And don't forget UPDATE. Drupal really needs a proper installer.

--------------------- WEBg8 ---------------------