Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
en:2.0:datenbankbackup_erstellen_und_wiederherstellen [2015/10/12 20:13] – created thomas-rcven:2.0:datenbankbackup_erstellen_und_wiederherstellen [2021/01/01 09:25] (current) fasse
Line 6: Line 6:
 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, 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.
  
-  - For this purpose, you log in as a webmaster in your Admidio-installation.+  - For this purpose, you log in as a **administrator** in your Admidio-installation.
   - Now choose the menu item **Database Backup**.    - Now choose the menu item **Database Backup**. 
   - Here you click on the button **Create Backup**    - Here you click on the button **Create Backup** 
-  - Now a backup of all Admidio tables and data in the database is applied.\\ {{:de:2.0:documentation:backup:backup_erstellen.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 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.   - 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.
  
Line 18: Line 18:
 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 Webmasters, via the menu item **Database Backup**:\\ {{:de:2.0:documentation:backup:backup_herunterladen.png?400|Download 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}}
   - Alternatively, the file can be downloaded via FTP from the Admidio folder **adm_my_files/backup**.   - 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**.\\ {{:de:2.0:documentation:backup:tabellen_loeschen.png?400|Clear 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}} 
-  - Step 4 you have possibly frequently to repeat because of dependencies among the tables, all tables can not be deleted at once+  - In the next step you have to disable the setting **Enable foreign key checks**.\\ {{:en:2.0:documentation:backup:backup_foreign_keys.png?400|Disable foreign key checks}} 
-  - Then you choose menu **Import**. +  - Now the previous tables are deleted and you can select the menu item **Import**. 
-  - Thereyou show to the unpacked backup file and start the Import.\\ {{:de:2.0:documentation:backup:backup_importieren.png?400|Import Backup}}+  - There you choose the unpacked backup file and start the import. You do not have to change any other settings in the dialog.\\ {{:en:2.0:documentation:backup:backup_import.png?400|Import backup}}
   - Now, all data should be restored back to the state of the backup.   - Now, all data should be restored back to the state of the backup.
  • en/2.0/datenbankbackup_erstellen_und_wiederherstellen.1444673586.txt.gz
  • Last modified: 2015/10/12 20:13
  • by thomas-rcv