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
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-l@Wikimedia.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@lists.wikimedia.org