MySQL databases store all the dynamic content for applications like WordPress. phpMyAdmin is the web tool used to manage them.
Step 1: Create the Database & User
-
Go to MySQL Databases: In cPanel, click the MySQL Databases icon in the Databases section.
-
Create Database: Enter a name and click Create Database.
-
Create User: Scroll down to MySQL Users, enter a username, and set a strong password. Click Create User.
-
Add User to DB: Scroll down to Add User to Database, select the new user and new database, and click Add. On the next screen, check ALL PRIVILEGES and click Make Changes.
Step 2: Import/Export using phpMyAdmin
-
Access phpMyAdmin: In cPanel, click the phpMyAdmin icon in the Databases section.
-
Select Database: Click the name of the database you want to work with in the left sidebar.
-
Export (Backup):
-
Click the Export tab at the top.
-
Choose Quick export method (recommended for backups) and SQL format.
-
Click Go. A
.sqlfile will download to your computer.
-
-
Import (Restore):
-
Click the Import tab at the top.
-
Click Choose File and select your
.sqlor compressed database backup file from your computer. -
Click Go.
-
united states