X-Git-Url: http://aymargeddon.de/gitweb/?p=aymargeddon%2Fcurrent.git;a=blobdiff_plain;f=var%2Ffrom_scratch;h=b45ff476ea1d5d45176e05be8d90d94dd2fec0be;hp=ed1442499e91e4de2a329d682106e2fb56e85d48;hb=04e6fbd873a9142c6497832831b1544a53a2c4ae;hpb=edbdf981639e5bc7d16a8ccd7e59ce2cf71bd142 diff --git a/var/from_scratch b/var/from_scratch old mode 100644 new mode 100755 index ed14424..b45ff47 --- a/var/from_scratch +++ b/var/from_scratch @@ -1,8 +1,30 @@ +# with this script you can delete the whole database but still use +# LOCALIZE and PLAYER tables. +# +# to init an empty database you have to do an +# ./do.sql < LOCALIZE_INIT.sql +# first. + +echo "dumping LOCALIZE.sql ..." + mysqldump -u aymargeddon -p`cat ../+secrets` -c --add-drop-table RAGNAROEK LOCALIZE \ > LOCALIZE.sql + +echo "dumping +PLAYER.sql ..." + mysqldump -u aymargeddon -p`cat ../+secrets` -c --add-drop-table RAGNAROEK PLAYER \ > ./+PLAYER.sql +echo "reading RAGNAROEK.sql ..." + ./do_sql < RAGNAROEK.sql + +echo "reading LOCALIZE.sql ..." + ./do_sql < LOCALIZE.sql + +echo "reading +PLAYER.sql ..." + ./do_sql < ./+PLAYER.sql + +echo "ready."