No edit summary Tag: 2017 source edit |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
=== Manual backup === | |||
=== | ==== Backup of the database ==== | ||
To back up your database, use the native program | To back up your database, use the native program <code>mysqldump</code> of MySQL/MariaDB: Open a console, switch to the directory <code><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 | For <code><username></code> , use the administrative database user, and for <code><database></code> , use the database of your MediaWiki/BlueSpice installation. | ||
'''For security reasons, immediately delete the file<code | {{Textbox|boxtype=important|header=|text=On Windows, make sure that your environment variables are set correctly, so that you can access the command <code>mysqldump</code>.|icon=yes}} | ||
==== 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.''' | |||
=== Using the <code>mediawiki-adm</code> tool === | |||
To eas backup and restore one can also use the <code>mediawiki-adm</code> tool. It can be downloaded here: https://github.com/hallowelt/misc-mediawiki-adm | |||
'''Example usage:''' | |||
mediawiki-adm wiki-backup \ | |||
--mediawiki-root <installpath-bluespice> \ | |||
--dest /mnt/backup/ | |||
The tool will leave out all unnecessary data (like temporary files and cache database tables)and produce much smaller backup files that the manual method described above. It also allows to create versioned backups. | |||
Latest revision as of 08:31, 7 March 2024
Manual backup
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.
On 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.
Using the mediawiki-adm tool
To eas backup and restore one can also use the mediawiki-adm tool. It can be downloaded here: https://github.com/hallowelt/misc-mediawiki-adm
Example usage:
mediawiki-adm wiki-backup \ --mediawiki-root <installpath-bluespice> \ --dest /mnt/backup/
The tool will leave out all unnecessary data (like temporary files and cache database tables)and produce much smaller backup files that the manual method described above. It also allows to create versioned backups.
