Setup:Installation Guide/Advanced/Backup: Difference between revisions

Revision as of 16:15, 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.

Hint: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.

To submit feedback about this documentation, visit our community forum.

@@ Line 4: / Line 4: @@
   mysqldump -u <username> -p --lock-tables <database> > database.sql
 For <code><username></code> , use the administrative database user, and for <code><database></code> , use the database of your 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=Hint|Note text=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 <code><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><installpath-bluespice>/database.sql</code>, since it can be accessed from the browser.'''