X-Git-Url: https://git.toastfreeware.priv.at/philipp/winterrodeln/wradmin.git/blobdiff_plain/03798cba14d6d5690b2473b96291611855929902..d580b5080edb92e4e4f663e48f8589e842fbb925:/tests/testdb.md diff --git a/tests/testdb.md b/tests/testdb.md index 1a9da8d..2eeffec 100644 --- a/tests/testdb.md +++ b/tests/testdb.md @@ -5,7 +5,7 @@ First import a "real" database snapshot in a temparary database on a non-product 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, @@ -80,7 +80,11 @@ watchlist ; ``` -Should remain: +The command + + show tables; + +should show the following remaining tables: ``` categorylinks page @@ -182,4 +186,4 @@ DELETE FROM wrregioncache; 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