rename drupal database and prefix table

By amedjones on 15 Nov 2012 at 13:53 UTC

Hi All

What is the procedure if i want to change my drupal database name and also change the prefix ? can someone please explain it in details ?

Also which one of the two is more safe to do ?

Thanks

Comments

Has the database already been

bartmcpherson

He/him/his

English

Cleveland

commented 18 November 2012 at 22:01

Has the database already been altered to have the new names?

The sites/default/settings.php file contains the db connection information.

$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'NEW_DB_NAME',
      'username' => 'dbuser',
      'password' => 'dbpasswd',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => 'NEWPREFIX',
    ),
  ),
);

thanks I will give that a

amedjones commented 2 December 2012 at 05:39

thanks I will give that a try.

Is that all that I have to do ? how do I rename my tables?

Currently i am upgrade my site from drupal 5 to drupal 6 ...I know im soo out dated :( . all my tables are named with the prefix drupal5_ I want to remove this prefix and just have drupal_