php my admin – Email shop Community https://theemailshop.co.uk/community Wed, 04 Dec 2019 06:12:54 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 How to optimize your database table via PHP MY ADMIN in your cPanel account? https://theemailshop.co.uk/community/knowledge-base/how-to-optimize-your-database-table-via-php-my-admin-in-your-cpanel-account/ Wed, 04 Dec 2019 06:12:54 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1256
  • Sign in to the cPanel account.
  • Click on the icon ‘Php my admin’ in the database section

    • phpmyadmin-icon

    • At the left sidebar, you will click on the expand button to expand your database like ‘example’.

    phpmyadmin-expand-db

    • Under the cPanel username, find the list of all the databases, and select an appropriate database that you want to optimize and it would be expanded

    phpmyadmin-db-list

    • Scroll below and then click ‘check all’, after that click the drop-down option and select ‘optimize tables’

    It would be optimized successfully.

    optimize-db

    ]]>