Difference between revisions of "Add a wiki database"
m |
({{legacy}}) |
||
| (11 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | {{legacy}} | ||
{{procedure | {{procedure | ||
|description = This process defines the steps involved in adding a new version of the MediaWiki software to an existing environment created by [[Install a new server|installing a new server]]. | |description = This process defines the steps involved in adding a new version of the MediaWiki software to an existing environment created by [[Install a new server|installing a new server]]. | ||
|role = Sysop | |role = Sysop | ||
| − | |status = | + | |status = legacy |
}} | }} | ||
| − | + | 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: |
| − | + | <source> | |
| − | + | create database foo; | |
| − | < | + | </source> |
| − | add-db | + | 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. |
| − | < | + | <source> |
| − | + | /var/www/tools/add-db /var/www/empty-1.13.sql foo.bar_ foo.baz_ | |
| − | + | </source> | |
| − | + | 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 == | == Next == | ||
| − | After installing a wiki database, you can then [[ | + | After installing a wiki database, you can then [[install a new wiki]]. |
== See also == | == See also == | ||
| − | *[[add-db | + | *[[Install a MediaWiki code-base]] |
| + | *[[Install a new wiki]] | ||
| + | *[[add-db]] | ||
| + | [[Category:Wikia]] | ||
Latest revision as of 22:31, 24 June 2020
|
|
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:
create database foo;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.
/var/www/tools/add-db /var/www/empty-1.13.sql foo.bar_ foo.baz_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.
