php myadmin – Email shop Community https://theemailshop.co.uk/community Wed, 04 Dec 2019 06:04:51 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 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 export your database table via PHP MY ADMIN in your cPanel account? https://theemailshop.co.uk/community/knowledge-base/how-to-export-your-database-table-via-php-my-admin-in-your-cpanel-account/ Wed, 04 Dec 2019 06:01:07 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1217
  • 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 the appropriate database that you want to export it to the PC

    phpmyadmin-db-list

    • Click the export button,

    phpmyadmin-export

    Select SQL format and then choose the Go button

    ]]>