Changing database name?

Hi,

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?

Thanks!
Simon
_______________________________________________
MediaWiki-l mailing list
MediaWiki-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

Hi Simon,

Try using a tool like ESKUEL to perform a full backup/dump
of the  
existing database, then reimport the dump in the new emty
database  
( with the new name ) ...

I've done it and it works for me ( Mediawiki 1.7.1 ) ...



Best Regards,

Arnaud.

Le 20 nov. 06 à 19:58, Simon Renshaw a écrit :

> Hi,
>
> 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?
>
> Thanks!
> Simon
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-lWikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>

_______________________________________________
MediaWiki-l mailing list
MediaWiki-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

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-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l