#!/bin/bash

mkdir -p /tmp/pre-comment-wipeout-backup/

for i in $(cat /tmp/database_list.txt | grep -v "^Database|^information_schema|^performance_schema|^mysql")
do
	TRUE=$(mysql -e "USE $i ; SELECT TRUE FROM wp_posts WHERE post_name='hello-world' AND ID=1;" 2>/dev/null | tail -1)

	if [[ "$TRUE" == 1 ]];
	then
		echo "Working ON $i"
		mysqldump $i > /tmp/pre-comment-wipeout-backup/$i\.sql
		mysql -e "USE $i ; DELETE FROM wp_posts WHERE ID=1;"
		mysql -e "USE $i ; DELETE FROM wp_comments WHERE comment_post_ID=1;"
	fi
done