How To Rename Database

Well I do know how to rename the database with phpAdmin, and in many other scripts all that needs to be done is update a file, usually named something like config.inc.php or perhaps db_conf.php but I see that Dolphin is somewhat different. I checked on the forum and there does not seem to be any advice, however I suspect that while not often, renaming the database might sometimes be necessary.

Has anyone successfully done this ?

Reinstalling Dolphin with a new database name is also possible but I believe (hope) there must be a simpler manner to rename the database.

Thanks for any ideas in advance

/inc/header.inc.php

There's the configuration file you were looking for.  Remember to clear the site's cache after making changes to the database information. 

Thanks Nath - just to make this a bit clearer for others that might try this...

I originally looked for header.php on my local computer from where I uploaded the files over FTP - of course there was NO header.php - kinda worried me for a moment there...

I take it therefore that header.php is created on the remote server during installation.

So obviously I made a copy of header.php from the remote server onto my local pc made the changes, and then FTP'd it back up to the remote server.

Using FileZilla I cleared the caches

Renamed the database to its new name (user and password are exactly the same)

But...

Now I am getting a white page with the error "Cannot complete query (select_db)"

Scary stuff... where did I go wrong?

OK I got it... Working now

The explanation to this gets somewhat abstract here, but what I did was using phpMyAdmin delete all users and passwords to the new database that was renamed... deleted the names and password from header.php and uploaded it again to the remote server... of course that gave an error.

Next I re-added the same name and password again to the new database using phpMyAdmin with all priviledges... and then re-added the same name and password to header.php - reuploaded header.php to the remote server and there you have it - it worked

If you want a more logical explanation to this then I am sorry lol, I just followed my instincts...

Closed - That is how to rename your database and survive... hehe