| Both sides previous revision Previous revision Next revision | Previous revision |
| en:2.0:datenbankbackup_erstellen_und_wiederherstellen [2021/01/01 09:25] – fasse | en:2.0:datenbankbackup_erstellen_und_wiederherstellen [2026/02/08 09:37] (current) – fasse |
|---|
| |
| ===== How do I create a database backup? ===== | ===== How do I create a database backup? ===== |
| A backup of a database can be created using different tools. Many tools that can be used to access the database [[http://www.phpmyadmin.net|phpMyAdmin]] or [[http://www.mysql.de/products/workbench|MySQL-Workbench]] also offer possibilities to backup the database or individual tables. In addition to these tools your website hosters usually should also create regular backups of the database every day ideally. | A backup of a database can be created using various tools. Many tools that allow you to access the database, such as [[http://www.phpmyadmin.net|phpMyAdmin]] or [[http://www.mysql.de/products/workbench|MySQL Workbench]], also offer the option of backing up the database or individual tables. If you use PostgreSQL, you can create a backup with [[https://www.pgadmin.org|pgAdmin]]. In addition to these tools, your website host should also create regular backups of the database, ideally on a daily basis. |
| |
| In addition to the methods just mentioned, we have in Admidio another way to quickly and easily create a backup of the database. Just before an update of Admidio it is advisable to create such a backup. | In addition to the methods just mentioned, Admidio offers another way to quickly and easily create a backup of your MariaDB or MySQL database. It is particularly advisable to create such a backup before updating Admidio. |
| | - To do this, log in as **administrator** to your Admidio installation. |
| - For this purpose, you log in as a **administrator** in your Admidio-installation. | - Now select the **Preferences** menu item and then the **Information** tab. |
| - Now choose the menu item **Database Backup**. | - Here, click on the **Download database backup** button. |
| - Here you click on the button **Create Backup** | - A backup of all Admidio tables and data in the database will now be created.\\ {{:en:2.0:documentation:backup:create_backup.png?400|Create backup}} |
| - Now a backup of all Admidio tables and data in the database is applied.\\ {{:en:2.0:documentation:backup:backup_create.png?400|v}} | - The created file will be zipped and saved in the selected folder on your computer. |
| - The created file is stored as zipped file under **adm_my_files / backup**. On request they can also be downloaded as an additional safeguard and stored locally on the computer. | |
| |
| Now, all data (user data, role permissions, role memberships, guestbook messages, etc.) from Admidio are secured. Photos, downloads and backups are not affected by this assurance. These you should additionally back up with your FTP program by loading the folder **adm_my_files** on your computer! The Admidio program files must be backed up when you have made there own customizations. All program files older Admidio versions can be downloaded from [[https://sourceforge.net/projects/admidio/files/Admidio/|Sourceforge]]. | Now, all data (user data, role permissions, role memberships, guestbook messages, etc.) from Admidio are secured. Photos, downloads and backups are not affected by this assurance. These you should additionally back up with your FTP program by loading the folder **adm_my_files** on your computer! The Admidio program files must be backed up when you have made there own customizations. All program files older Admidio versions can be downloaded from [[https://sourceforge.net/projects/admidio/files/Admidio/|Sourceforge]]. |
| If you want to import the database on another server, or something went wrong with an Admidio update, or data is lost by an error, a backup needs to be restored. The method described here refers to the restore from a backup that was created with Admidio. But it will also work with all other backups, providing a pure SQL file as backup. | If you want to import the database on another server, or something went wrong with an Admidio update, or data is lost by an error, a backup needs to be restored. The method described here refers to the restore from a backup that was created with Admidio. But it will also work with all other backups, providing a pure SQL file as backup. |
| |
| - Get your last backup file from your current Admidio installation. This can be downloaded after logging in as **Administrator**, via the menu item **Database Backup**:\\ {{:en:2.0:documentation:backup:backup_download.png?400|Download Backup}} | - First, obtain the latest backup file. This should be stored in a secure location on your computer or on a backup storage device. |
| - Alternatively, the file can be downloaded via FTP from the Admidio folder **adm_my_files/backup**. | |
| - The file is packed and must be decompressed with a corresponding [[http://de.wikipedia.org/wiki/Gzip|GZip-Program]]. | - The file is packed and must be decompressed with a corresponding [[http://de.wikipedia.org/wiki/Gzip|GZip-Program]]. |
| - Next, you should now delete all existing Admidio tables in the database with an appropriate program (in this documentation [[http://www.phpmyadmin.net|phpMyAdmin]]). For this you mark the appropriate tables and choose entry **Delete**.\\ {{:en:2.0:documentation:backup:backup_delete_tables.png?400|Delete tables}} | - Next, you should now delete all existing Admidio tables in the database with an appropriate program (in this documentation [[http://www.phpmyadmin.net|phpMyAdmin]]). For this you mark the appropriate tables and choose entry **Delete**.\\ {{:en:2.0:documentation:backup:backup_delete_tables.png?400|Delete tables}} |
