phpmyadmin

Log in to your cPanel account. In the Databases section, click on phpMyAdmin. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file. Click on Import. Under File to Import, click on Browse and select SQL file from your computer. Scroll down and click on Go. If it shows a success message, your SQL has been successfully uploaded.

Log in to your cPanel account. In the Databases section, click on phpMyAdmin. From the navigation tree in the left sidebar. Please select an appropriate database that you want to export to your computer Click on Export. Select SQL format and then click on Go. SQL file will be downloaded within a few seconds, depending on the size of the file.

Log in to your cPanel account. In the Databases section, click on phpMyAdmin. Click on the Expand icon from the navigation tree in the left sidebar. Select the appropriate table you want to edit. If you wish to change the blog name of WordPress, then select “wp-options”. Click on Edit in the third row. Modify the text value and then click on Go. By doing that, you can change the value of SQL data of any software without accessing the administration area. For example, if you can’t change the theme from the administration area, you can use this method to change the value of SQL data.

Log in to your cPanel account. In the Databases section, click on phpMyAdmin. Click on the Expand icon from the navigation tree in the left sidebar. Select the appropriate table you want to delete. If you’re going to delete table “wp_links”, choose it. Now click on Operations. Scroll down and then click on Delete the table (DROP). Warning: The whole table will be removed. Please, note that it will be impossible to restore it, especially if you don’t have a backup.

Log in to your cPanel account. In the Databases section, click on phpMyAdmin. Click the Expand icon from the navigation tree in the left sidebar. Scroll down and mark Check All. Then click on the drop-down arrow and select Repair table. If the table has been repaired successfully, it will show an OK message. Otherwise, it will display an error on some tables.