Difference between revisions of "Add a wiki database"
(run as root) |
(convention is to prefix sudo if root is needed) |
||
| Line 5: | Line 5: | ||
}} | }} | ||
| − | New wiki databases are added by copying from a template database for the version of MediaWiki the wiki will run on. A template exist for every code-base in the wikia because they get created during the [[install a MediaWiki code-base]] procedure | + | New wiki databases are added by copying from a template database for the version of MediaWiki the wiki will run on. A template exist for every code-base in the wikia because they get created during the [[install a MediaWiki code-base]] procedure. |
If you intend on creating the new wiki in a new database, you'll first need to create the new database manually, for example by logging in to MySQL: | If you intend on creating the new wiki in a new database, you'll first need to create the new database manually, for example by logging in to MySQL: | ||
| Line 13: | Line 13: | ||
You can then make a copy of the template database and define a table prefix for the new wiki tables using our [[add-db.pl|add-db script]] as follows. The best practice is that a table prefix should always be used even if there is only one wiki, and the prefix should always end with an underscore character. | You can then make a copy of the template database and define a table prefix for the new wiki tables using our [[add-db.pl|add-db script]] as follows. The best practice is that a table prefix should always be used even if there is only one wiki, and the prefix should always end with an underscore character. | ||
{{code|<pre> | {{code|<pre> | ||
| − | /var/www/add-db empty-1.13.sql foo.bar_ foo.baz_ | + | sudo /var/www/add-db empty-1.13.sql foo.bar_ foo.baz_ |
</pre>}} | </pre>}} | ||
In this example, two wiki databases have been added at once, both in the new "foo" database we created, one wiki has tables prefixed by "bar_" and the other by "baz_". Both new wiki's are copies of the ''empty-1.13.sql'' template which was created when the ''MediaWiki-1.13'' code-base was installed into the wikia. | In this example, two wiki databases have been added at once, both in the new "foo" database we created, one wiki has tables prefixed by "bar_" and the other by "baz_". Both new wiki's are copies of the ''empty-1.13.sql'' template which was created when the ''MediaWiki-1.13'' code-base was installed into the wikia. | ||
Revision as of 19:45, 25 January 2009
|
Add a wiki database Organic Design procedure |
New wiki databases are added by copying from a template database for the version of MediaWiki the wiki will run on. A template exist for every code-base in the wikia because they get created during the install a MediaWiki code-base procedure.
If you intend on creating the new wiki in a new database, you'll first need to create the new database manually, for example by logging in to MySQL:
You can then make a copy of the template database and define a table prefix for the new wiki tables using our add-db script as follows. The best practice is that a table prefix should always be used even if there is only one wiki, and the prefix should always end with an underscore character.
In this example, two wiki databases have been added at once, both in the new "foo" database we created, one wiki has tables prefixed by "bar_" and the other by "baz_". Both new wiki's are copies of the empty-1.13.sql template which was created when the MediaWiki-1.13 code-base was installed into the wikia.
Next
After installing a wiki database, you can then install a new wiki.
