restore thread in woltlab from old backup of database

1 files changed, 34 insertions, 0 deletions

diff --git a/restore_thread.sh b/restore_thread.sh
new file mode 100644
index 0000000..10a8164
--- /dev/null
+++ b/restore_thread.sh
@@ -0,0 +1,34 @@
+#!/bin/bash
+
+if [ $# -ne 1 ]
+then
+   echo "no thread id"
+   exit 1
+fi
+
+threadID=$1
+
+#clean database
+echo "clean database..."
+mysql -u root -N -e "drop view if exists view_1000_posts;" tmp
+mysql -u root -N -e "show tables;" tmp | xargs -I{} mysql -u root -N -e "drop table if exists {};" tmp
+
+#import backup
+echo "import backup..."
+nice -n19 mysql -u root tmp < database_mitsu-talk.sql 
+
+#delete all but the ones we need
+echo "delete unused tables..."
+mysql -u root -N -e "drop view if exists view_1000_posts;" tmp
+mysql -u root -N -e "show tables;" tmp | grep -v "^wbb1_1_post$" | grep -v "^wbb1_1_thread$" | grep -v "^wbb1_1_thread_subscription$" | grep -v "^wbb1_1_thread_visit$" | grep -v "^wbb1_1_savepost$" | grep -v "^wbb1_1_thread_announcement$" | grep -v "^wbb1_1_thread_rating$" | grep -v "^wbb1_1_thread_similar$" | xargs -I{} mysql -u root -N -e "drop table if exists {};" tmp
+
+#delete all entries but the ones with searched threadID
+mysql -u root -N -e "show tables;" tmp | while read tablename
+do
+   echo "deleting entries from $tablename..."
+   nice -n19 mysql -u root -N -e "delete from $tablename where not threadID=$threadID;" tmp
+done
+
+#dump it
+echo "dumping..."
+nice -n19 mysqldump --skip-add-drop-table --no-create-info tmp > $threadID.sql