No edit summary Tag: 2017 source edit |
No edit summary |
||
| Line 2: | Line 2: | ||
===<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 < | mysqldump -u <username> -p --lock-tables <database> > 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 | 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, 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);"><database></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".}} | {{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>=== | ||
Revision as of 11:41, 3 August 2023
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 <database> > database.sql
For <username> , use the administrative database user, and for <database> , 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.
