Differences

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

--- en:2.0:datenbankbackup_erstellen_und_wiederherstellen [2021/01/01 09:03] – fasse
+++ en:2.0:datenbankbackup_erstellen_und_wiederherstellen [2021/01/01 09:25] (current) – fasse
@@ Line 21: / Line 21: @@
   - 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]].
-  - 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**.
-  - There, you 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.