Difference between revisions of "Setup:Installation Guide/Advanced/Backup"
← Setup:Installation Guide/Advanced/Backup
[quality revision] | [quality revision] |
(Tag: 2017 source edit) |
m (Mlink-rodrigue moved page Setup:Installation Guide/Compendium/Backup to Setup:Installation Guide/Advanced/Backup without leaving a redirect) |
Backup of the database[edit | edit source]
To back up your database, use the native program "mysqldump" of MySQL/MariaDB: Open a console, switch to the directory <installpath-bluespice>
and backup your database with the following command:
mysqldump -u <username> -p --lock-tables <datenbank> > database.sql
For <username>
, use the administrative database user (usually "root"), and for <datenbank>
, use the database of your MediaWiki/BlueSpice installation.
Note: In Windows, make sure that your environment variables are set correctly, so that you can access the command "mysqldump".
Backup des Filesystemsof the file system[edit | edit source]
Sichern Sie das komplette Verzeichnis Back up the complete directory <installpath-bluespice>
, das jetzt auch das Datenbankabbild beinhaltet, an einem anderen Ort auf Ihren Server. Löschen Sie anschließend aus Sicherheitsgründen umgehend die Datei which now also includes the database image, to a different location on your server.
For security reasons, immediately delete the file<installpath-bluespice>/database.sql
, da diese per Browser aufrufbar istsince it can be accessed from the browser.
=== <span class="mw-headline" id="Backup_der_Datenbank" style="box-sizing: inherit;">Backup of the database</span> === To back up your database, use the native program "mysqldump" of MySQL/MariaDB: Open a console, switch to the directory <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice></code> and backup your database with the following command: mysqldump -u <username> -p --lock-tables <datenbank> > database.sql For <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><username></code> <span>,</span> use the administrative database user (usually "root"), and for <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><datenbank></code> <span>, use the database of your</span> MediaWiki/BlueSpice installation. {{Box Note|boxtype=note|Note text=In Windows, make sure that your environment variables are set correctly, so that you can access the command "mysqldump".}} === <span class="mw-headline" id="Backup_des_Filesystems" style="box-sizing: inherit;">Backup des Filesystems</span> === Sichern Sie das komplette Verzeichnis <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice></code>, das jetzt auch das Datenbankabbild beinhaltet, an einem anderen Ort auf Ihren Server. '''Löschen Sie anschließend aus Sicherheitsgründen umgehend die Datei of the file system</span>=== Back up the complete directory <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice></code>, which now also includes the database image, to a different location on your server. '''For security reasons, immediately delete the file<code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice>/database.sql</code>, da diese per Browser aufrufbar istsince it can be accessed from the browser.''' [[de:Setup:Installationsanleitung/Backup]] [[en:{{FULLPAGENAME}}]]
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | === <span class="mw-headline" id="Backup_der_Datenbank" style="box-sizing: inherit;">Backup of the database</span> === | + | ===<span class="mw-headline" id="Backup_der_Datenbank" style="box-sizing: inherit;">Backup of the database</span>=== |
To back up your database, use the native program "mysqldump" of MySQL/MariaDB: Open a console, switch to the directory <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice></code> and backup your database with the following command: | To back up your database, use the native program "mysqldump" of MySQL/MariaDB: Open a console, switch to the directory <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice></code> and backup your database with the following command: | ||
mysqldump -u <username> -p --lock-tables <datenbank> > database.sql | mysqldump -u <username> -p --lock-tables <datenbank> > database.sql | ||
Line 5: | Line 5: | ||
{{Box Note|boxtype=note|Note text=In Windows, make sure that your environment variables are set correctly, so that you can access the command "mysqldump".}} | {{Box Note|boxtype=note|Note text=In Windows, make sure that your environment variables are set correctly, so that you can access the command "mysqldump".}} | ||
− | === <span class="mw-headline" id="Backup_des_Filesystems" style="box-sizing: inherit;">Backup | + | ===<span class="mw-headline" id="Backup_des_Filesystems" style="box-sizing: inherit;">Backup of the file system</span>=== |
− | + | Back up the complete directory <code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice></code>, which now also includes the database image, to a different location on your server. | |
− | ''' | + | '''For security reasons, immediately delete the file<code style="box-sizing: inherit; font-family: monospace, Courier; font-size: 13.5px; padding: 1px 4px; color: black; background-color: rgb(249, 249, 249); border-radius: 2px; border: 1px solid rgb(221, 221, 221);"><installpath-bluespice>/database.sql</code>, since it can be accessed from the browser.''' |
[[de:Setup:Installationsanleitung/Backup]] | [[de:Setup:Installationsanleitung/Backup]] | ||
[[en:{{FULLPAGENAME}}]] | [[en:{{FULLPAGENAME}}]] |