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 13:41, 3 August 2023
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.
Discussions