mysql philipp_winterrodeln_wiki < philipp_winterrodeln_wiki.sql
-Delete unnessary tables (execute it a few times until no more "Cannot delete or update a parent row: a foreign key constraint fails" errors occur):
+Delete unnessary tables:
```{sql}
DROP TABLE IF EXISTS
wrintermapsreport,
;
```
-Should remain:
+The command
+
+ show tables;
+
+should show the following remaining tables:
```
categorylinks
page
Export data to SQL:
- mysqldump philipp_winterrodeln_wiki --skip-extended-insert --skip-add-locks > philipp_winterrodeln_wiki.sql
\ No newline at end of file
+ mysqldump philipp_winterrodeln_wiki --skip-extended-insert --skip-add-locks > testdb.sql