[Mediawiki-l] Changing database name?

[Brion Vibber]

Simon Renshaw wrote:
> I'm not sure if this can be done without breaking the Wiki but is it
> possible to rename the database that the Wiki is using?
> 
> And then put the new name in LocalSettings?
> 
> I didn't know that one of my colleagues would need to use a database
> with the same name I used for the Wiki.
> 
> Is it possible to switch database?

AFAIK you can't directly rename a database in MySQL, but you *can* move 
tables between two databases. Something like:

CREATE DATABASE bar;
ALTER TABLE foo.page RENAME TO bar.page;
ALTER TABLE foo.revision RENAME TO bar.revision;
[etc]

You might also have to GRANT user privileges appropriately on the new 
database.

-- brion vibber (brion @ pobox.com)