katz

Sorry for the late reply. I was able to significantly reduce the DB size using one of your queries, I modified it slightly but thank you very much for your help. It took hours to OPTIMIZE the large tables but it worked. It's an old version of IPB running on PHP5, do you have an idea on how to make it compatible with newer servers / PHP versions?

I just checked and I saw the script you sent is for ibf_topics My ibf_posts table is 50GB - Do I use the same script to delete from there? Also these tables are over 1GB: ibf_inline_notifications ibf_core_share_links_log ibf_topic_views

Thank you, if I use the OPTIMIZE on the table, it will still have at least 2 million rows, won't the MySQL timeout (MySQL server has gone away error)?

It's a dedicated server just for the database with 128GB DDR3 + 2TB SSD. What number of rows to delete, per run is safe in your opinion? The MySQL configuration is untouched (installed by Plesk). Maybe the timeouts are a config issue? (impossible to repair large table = timeout, extra long delete query = timeout) By the way, will the DB size reduce automatically after the posts are deleted or is there something I need to do?

Thank you for your reply, it's appreciated. Just to confirm, if I run this 10 times, for just 1000 posts, nothing will happen to the forum? it won't crash? the numbers won't go mismatch and fatal error?

I'm using IPB 3.4 and I tried that code before, simple, just delete old rows where date > than 2 years. It crashed the database and the forum wasn't working (over 10 million topics, 80GB database). I found this topic, see the last reply, do you think this is a better solution (they use ID but I can use date) or do you have a better solution:

Добрый день, У меня есть форум в котором накопилось миллионы тем за много лет. Кто нибудь может подсказать как можно удалить темы старее чем например 2 года через консолу MySQL? Спасибо за любой ответ.