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= | {{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 17: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.
Discussions