How to manage MySQL databases with phpMyAdmin:
Step 1: Access cPanel
- Log in to your cPanel account. If you are unsure how to do this, please refer to the tutorial on "How to Login to cPanel."
Step 2: Access phpMyAdmin
- On the main cPanel page, scroll down to the section labeled "Databases."
- Click on the icon named "phpMyAdmin." This will take you to the phpMyAdmin main screen.
Step 3: Upload a Database
- On the top menu bar in phpMyAdmin, click on the "SQL" tab. This will open several new windows.
- In the window labeled "Location of the text file," click on the "Browse" button to search for the database file you want to upload.
- Once you locate the database file, click on it and then click "Open." This action will take you back to the previous window.
- To complete the upload, click the "Go" button.
- Upon successful completion of the upload, you will receive a confirmation screen, which may also list any tables found in the database.
- In the left-hand column, you will see the tables listed under the name of the database you uploaded.
Step 4: View Table Details
- If you want to view the details of a specific table, click on the table's name in the left-hand column. The right-hand window will open, displaying all the details of that table.
Step 5: Export a Table
- To save the table to your personal computer, click on the "Export" option in the upper menu bar.
- Scroll down the new window until you reach the section that says "Save as File" and select the checkbox.
- Click the "Go" button.
- A file download screen will open, asking if you want to save the file. Click "Save."
- In the next window ("Save as"), choose the file folder where you want to save the file and click "Save."
- Once the download is complete, a window will open confirming your download. Click "Close."
Step 6: Access Help and Exit
- If you need assistance while using phpMyAdmin or MySQL, you'll find some helpful links in the left-hand column of the phpMyAdmin pages.
- To sign out of phpMyAdmin and return to the main cPanel page, click the "Exit" button, which is located next to the help links in the left-hand column.
Step 7: Logout and Exit cPanel
- When you're finished managing your MySQL database, you can exit cPanel by closing your browser or by using the "Logout" button in the upper right corner.
- If you are using a public computer, it's important to always log out of cPanel before closing it for security reasons.
