Editing Manual/Upgrading (section)

== Back up existing files and the database == <!--T:29-->

<!--T:30-->
:''Full instructions: <tvar name=1></tvar>''

<!--T:31-->
While the upgrade scripts are well-maintained and robust, things could still go awry. Before proceeding to update the database schema, '''make a full [[<tvar name=backup>Special:MyLanguage/Manual:Backing up a wiki</tvar>|backup]]''' of the wiki, including both the database and the files:

<!--T:32-->
* the wiki's content, from the database, (make sure you get the character set specified correctly, first check <tvar name=1><code>LocalSettings.php</code></tvar>). It may be a good idea to create an XML dump in addition to the SQL database dump.
</translate>
:* <translate><!--T:33--> MySQL, both SQL dump and XML dump are for use with the <tvar name=1><code>mysql</code></tvar> command:</translate>
 mysqldump --user='''''wikidb_user''''' --password='''''wikidb_userpassword''''' '''''wikidb''''' > '''''file.sql'''''
 mysqldump --user='''''wikidb_user''''' --password='''''wikidb_userpassword''''' '''''wikidb''''' --xml > '''''file.xml'''''
:* <translate><!--T:34--> PostgreSQL, database dump for use with <tvar name=1><code>pg_restore</code></tvar> command:</translate>
 pg_dump --create -Fc '''''wikidb''''' > '''''file.db.dump'''''
:* <translate><!--T:35--> SQLite, you use a MediaWiki script for making a backup:</translate>
 php '''''wikifolder'''''/maintenance/run.php SqliteMaintenance --backup-to '''''file'''''
<translate>
<!--T:36-->
* images and other media files (the contents of the <tvar name=1><code>images</code></tvar> directory, custom logo <tvar name=2>/skins/common/images/wiki.png</tvar>)</translate>
<translate>
<!--T:37-->
* configuration files, e.g. <tvar name=1><code>LocalSettings.php</code></tvar> and <tvar name=2><code>.htaccess</code></tvar> (if present)</translate>
<translate>
<!--T:38-->
* MediaWiki's program files, including all skins and extensions, especially if you modified them.