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(a)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(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l