Thanks Brion and François.

Beside in LocalSettings, is there somewhere else I need to change the name of the database?

-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Brion Vibber Sent: 22 novembre, 2006 16:06 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Changing database name?

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) _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l