troubleshooting Question

MySQL database cleanup

Avatar of knopr
knoprFlag for Saint Martin, (French part) asked on
Visual Basic ClassicMySQL ServerWeb Applications
5 Comments1 Solution895 ViewsLast Modified:
Hi, I got a question to solve a php website / database issue. Having no knowlegde of MySQL databases, I have to cleanup a database because it has become too large. This website uses a forum, phpBB software.

The problem is probably simple, the database has had no maintenance,but I need to knw which action to take (without knowlegde of MySQL) to clean the database up without causing problems or losiing information.

In the web admin folder I see an overview of tables and in particular 3 tables take a lot of space:

phpbb_posts
phpbb_wordmatch
phpbb_wordlist

See attached screenshot. What action can I take best?

Thanks,

Richard Screenshot MySQL Admin
ASKER CERTIFIED SOLUTION
knopr

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros