Difference between revisions of "Rename a MediaWiki database"

From Organic Design wiki
(New page: {{procedure |description = The [[Renam...)
 
Line 20: Line 20:
 
{{code|<PHP>
 
{{code|<PHP>
 
mysql -u [user] -p [database] < backupfile.sql # Restore
 
mysql -u [user] -p [database] < backupfile.sql # Restore
 +
</PHP>
 
}}
 
}}
  
 
[[Category:Installation]]
 
[[Category:Installation]]

Revision as of 09:14, 18 November 2008

Procedure.svg Rename a MediaWiki database
Organic Design procedure

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


{{{1}}}

and manually edit the line;

CREATE DATABASE *name* IF NOT EXISTS

then restore the mysqldump file with;


<PHP>

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