Upto 27% OFF On All Hosting Plans! USE CODE : MRh27 30^th April Order Now.

How to Optimize database tables? Print

0

Please use following steps to optimize your MySQL tables.

1) Log into your cPanel and select the PHPMyAdmin icon.

2) Select the database you wish to optimize.

3) Select the tables you wish to optimize. Or you can click the select all link located at the bottom of the table list.

4) Click the “with selected” drop-down menu, and select optimize

5) After it completes optimize you will see the results of it on the next screen.

That’s it! You should see a message confirming the requested operation.

Was this answer helpful?

Related Articles

How can I access mysql database remotely? Under the mysql header in Cpanel, select 'manage mysql' Then scroll down to the 'access hosts'... How can I backup a database using phpmyadmin? Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have... How do I add a mysql database in Cpanel? To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In... How do I delete a MYSQL database? Removing a database will delete that database ENTIRELY from the server. Please make sure you... How do I restore a database using PHPMyadmin? You can restore a database backup in PHPMyadmin by doing the following: 1) After entering...

« Back