How I crated the testdb.sql

Work on a copy of the philipp_winterrodeln_wiki database:

select * from philipp_winterrodeln_wiki.wrreport order by id desc limit 10;
delete from wrreport where id < 19587 or id > 19596;
select * from wrreport;
update wrreport set author_ip = null, delete_person_ip = null;
update wrreport set author_username = null where author_userid is null;
select * from wrreport;
select * from wrregion;
select * from wrsledruncache;
select * from wrsledruncache where page_id = 926 or page_id in (select page_id from wrreport);
delete from wrsledruncache where page_id != 926 and page_id not in (select page_id from wrreport);
delete from wrregioncache where page_id != 926 and page_id not in (select page_id from wrreport);
select * from wrsledruncache;


mysqldump philipp_winterrodeln_wiki --skip-extended-insert --tables wrreport wrsledruncache wrregion wrregioncache --skip-add-locks --skip-disable-keys --hex-blob > testdb.sql