Category: Databases

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click the Expand icon from the navigation tree in the left sidebar. 4. 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 […]

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.  3. Under Current Databases, you can see a list of all your databases. Locate the Database and then click on Rename. 4. Change the database name and click on Proceed.

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Scroll down and mark Check All. Click on the drop-down option and select Optimize tables. The table has been successfully optimized.

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file. 4. Click on Import. 5. Under File to Import, click on Browse and select SQL file from your computer. 6. Scroll down and click on Go. If it shows a […]

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

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to edit. If you wish to change the blog name of WordPress, then select “wp-options”. 5. Click on Edit in the third row. 6. Modify the text value and then […]

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.  3. Under Current Databases, you can see a list of all your databases. Locate the database you want to remove and click on Delete. 4. Click on Delete Database.

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to delete. If you’re going to delete table “wp_links”, choose it. 5. Now click on Operations. 6. Scroll down and then click on Delete the table (DROP). Warning: The whole table […]

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. In the New Database field, enter a name for the new database you wish to create. 4. Click on Create Database.

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.  3. Under MySQL Users, in the Username field, enter the new username you want to create. 4. Enter your new password or use a password generator.5. Click on Create a User. Tip: Write down the database username and password on a notepad so you can easily recall them while installing a script […]