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

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

    phpmyadmin-expand-db

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

    phpmyadmin-db-list

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

    repair-db

    If the table has repaired successfully, it would show an ‘Ok’ message, otherwise it may show some error like ‘error unknown engine’ etc

     

    ]]>
    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

    ]]>
    How to delete your database table via PHP MY ADMIN in your cPanel account? https://theemailshop.co.uk/community/knowledge-base/how-to-delete-your-database-table-via-php-my-admin-in-your-cpanel-account/ Wed, 04 Dec 2019 06:08:37 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1239
  • 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 (1)

    • Under the cPanel username, find the list of all the databases, and select an appropriate database that you want to edit and it would be expanded
    • Select the desired table you need to delete, for example, if you want to edit the WordPress table and change the name of the blog from phpMyAdmin then choose “wp-options”.

    wp-links

    • Click the delete button present in 3rd row

    wp-link-delete

    • Scroll down and then click on delete.

     

    ]]>
    How to edit your database table via PHP MY ADMIN in your cPanel account? https://theemailshop.co.uk/community/knowledge-base/how-to-edit-your-database-table-via-php-my-admin-in-your-cpanel-account/ Wed, 04 Dec 2019 06:04:51 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1227
  • 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-db-list

    • Under the cPanel username, find the list of all the databases, and select an appropriate database that you want to edit and it would be expanded
    • Select the desired table you need to edit, for example, if you want to edit the WordPress table and change the name of blog from phpMyAdmin then choose “wp-options”.

    phpmyadmin-db-list2

    • Click the edit button present in 3rd row

    wp-table-change

     

    ]]>
    How to add new user to a database and add some privileges? https://theemailshop.co.uk/community/knowledge-base/how-to-add-new-user-to-a-database-and-add-some-privileges/ Wed, 04 Dec 2019 05:50:53 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1198
  • Sign in to the cPanel account.
  • Click on the icon ‘MYSQL databases’ in the database section
  • mysql-databases-icon

    • Scroll to the bottom of your page and find ‘add a user to database’, choose a relevant user from the drop-down list and then select the required database.
    • Click on the ‘Add’ button

    add-db

    • You will find ‘manage user privileges’, then mark the box ‘add privileges’ click ‘make changes’

    add-privileges

    ]]>
    How to delete database in your cPanel account? https://theemailshop.co.uk/community/knowledge-base/how-to-delete-database-in-your-cpanel-account/ Wed, 04 Dec 2019 05:46:08 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1187
  • Sign into the cPanel account.
  • Click on the icon ‘MYSQL databases’ in the database section
  • mysql-databases-icon

    • Find ‘current databases’ to check out the list of all databases and then choose the option ‘delete’.

    delete-db

    • Click the ‘delete database’ button
    • If you see a warning, again click the ‘delete database’ button

    db-remove-confirmation

    ]]>
    How to create database in your cPanel account? https://theemailshop.co.uk/community/knowledge-base/how-to-create-database-in-your-cpanel-account/ Wed, 04 Dec 2019 05:40:54 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1173
  • Sing into the cPanel account.
  • Click on the icon ‘MYSQL databases’ in the database section
  • mysql-databases-icon

    • In “New Database: Username_” Add a name for the new database you may wish you to create in the text area.

    create-db

    • After that, click on ‘create database’

    paper-db-added-successfully

    ]]>