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

No edit summary
Tag: 2017 source edit
No edit summary
Line 4: Line 4:
  mysqldump -u <username> -p --lock-tables <database> > database.sql
  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.  
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===
===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.
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.'''
'''For security reasons, immediately delete the file<code><installpath-bluespice>/database.sql</code>, since it can be accessed from the browser.'''

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

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.