Difference between revisions of "Rename a MediaWiki database"

Revision as of 20:01, 20 November 2008

Rename a MediaWiki database
Organic Design procedure

The simplest approach is to take a sql dump of a database;

{{{1}}}

and manually edit the lines in backupfile.sql

<PHP>

CREATE DATABASE /*!32312 IF NOT EXISTS*/ [database]

USE DATABASE [database]

</PHP>

then restore the mysqldump file with;

<PHP>

mysql -u [user] -p [database] < backupfile.sql # Restore </PHP>

In the LocalSettings.php file, the global

{{{1}}}

may need to be changed to point to the new database. Privileges may also need to be set in the db table in the mysql permissions database.

@@ Line 12: / Line 12: @@
 }}
-and manually edit the line in '''backupfile.sql'''
+and manually edit the lines in '''backupfile.sql'''
+{{code|<PHP>
   CREATE DATABASE /*!32312 IF NOT EXISTS*/ [database]
+ USE DATABASE [database]
+</PHP>
+}}
 then restore the mysqldump file with;