logo

Black Friday
Sale

  •  99.9% Uptime
  •  Free SSL Certificate
  •  24/7 Live Support
  •  30-Days Money-Back Guarantee
Get Started

Up To

90

%

OFF

45
DAYS
22
HOURS
58
MINUTES
20
SECONDS
Black Friday Sale: Best Web Hosting
From ₹45.00 /Month!
See All Deals
×

Hostinger's Knowledge Base

Find articles and information about features, various troubleshooting guides,
and other technical information related to the Hostinger's services

How can I fix/repair and optimize database myself?

Modified on:
repair database optimize database fix database

You can optimize/repair your database via phpMyAdmin:
First, log into cPanel and open up the MySQL Databases section icon.
At the bottom of the screen, you will find a link for phpMyAdmin. Clicking on this link will open up a new browser window with the home screen for phpMyAdmin. On this screen, click Databases. This will list all the databases you have setup.
Click on the database you want to work on. The database screen will list the tables for the given database.
Click the Check All link on the bottom left. Then from the pull down menu choose Optimize /Repair Table.