Created page with " ===<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 "mysqldu..." Tag: 2017 source edit |
No edit summary Tag: 2017 source edit |
||
| Line 4: | Line 4: | ||
mysqldump -u <username> -p --lock-tables <datenbank> > database.sql | 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. | 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. | ||
{{ | {{Messagebox|boxtype=Hinweis|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 of the file system</span>=== | ===<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. | 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.''' | '''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.''' | ||
Revision as of 14:50, 22 December 2021
Archived!This documentation is obsolete and no longer applies to the current BlueSpice version.
Backup of the database
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.
Hinweis:In Windows, make sure that your environment variables are set correctly, so that you can access the command "mysqldump".
Backup of the file system
Back up the complete directory <installpath-bluespice>, 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, since it can be accessed from the browser.
