What's new

Welcome to WebForum | Zimbabwe Web Hosting Forum.

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Ask question

Ask questions and get answers from our community


Answer questions and become an expert on all topics.

Contact us

Get in touch with the site administrator directly.

Forum Group

Join the Forum Whatsapp group for daily updates.
  • Thanks for participating in our community, Discuss and Learn. All Forum members are allowed to create threads and posts. Resources posted here should be CLEAN and SAFE. Do not post “offensive” posts, links, or images. Remain respectful of other members at all times.

phpMyAdmin Database Repair and Optimization Tutorial

How to repair and optimize MySQL databases​

In this tutorial, we'll show you how to repair and optimize your MySQL databases through phpMyAdmin. It's advisable to perform these operations periodically.

If a database table or tables become corrupt, the application that uses these database tables won't be able to access them. Usually, this can be fixed with the Repair function. You can perform it through phpMyAdmin.

To access phpMyAdmin, log in to the Pixie control panel, go to the Databases section and click on the phpMyAdmin link on the right. This will open phpMyAdmin. In the left frame, you'll see listed the databases that you have created. Click on the name of the database that you want to repair. After you do it you'll see the tables of this database displayed in the right frame. Mark the checkboxes in front of the names of the tables, or if you want to repair all the tables just click on Check All at the bottom of the page, and from the With selected drop-down menu at the bottom select Repair table:

1 (1).jpg

Then to execute the Optimize Table query click on the Go button in the lower right corner.

Forum statistics

Latest member