(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 16:50, 22 December 2021
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.
Discussions