Results 1 to 3 of 3
  1. #1

    Arrow add table_prefix to DB

    Hello.
    I have a phpbb board in use and in the DB i have all the tables name as

    DB1
    - table 1
    - table 2

    what i need to do is add a "table_prefix" in all the tables without loosing any information.

    DB1
    - phpbb_table1
    - phpbb_table 2

    Is that possible?

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Posts
    772
    Hi

    To modify the dbconf/mysql/*mysql files to
    make use of the REAL_NAME option:

    Database userdb userdb.txt dbi:mysql:whatever
    Database userdb REAL_NAME ic_userdb
    Database userdb ... ...
    Database userdb ... ...
    etc.

    In this case, the Interchange facilities will continue to refer to the
    table as 'userdb', but actual table used would be called 'ic_userdb'.

    If you want to change in Phpbb board then please have a look into this URL for detailed information...

    http://www.phpbb.com/phpBB/viewtopic...846&highlight=

    I hope this may work to resolve your problem.

    Regards,

    Bright

  3. #3
    Thanks for the reply.
    I use "ALTER TABLE tablename1 RENAME tablename2;" for rename table bu table.
    All works ok!
    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •