How to manage a MySQL database with phpMyAdmin in cPanel?

You can import and export MySQL databases for a variety of scenarios, including:
  • Transferring a database from one web hosting account or provider to another.
  • Importing a third-party database.
  • Backing up a database.

To import a MySQL database using phpMyAdmin, follow these steps:

  1. Log in to your cPanel account.
  2. In the Databases section of the cPanel home screen, click phpMyAdmin.
  3. In the left pane of the phpMyAdmin page, click the database that you want to import the data into.
  4. Click the Import tab.
  5. Under File to Import, click Browse, and then select the dbexport.sql file on your local computer.
  6. Click Go. The import process runs.
  7. The database should now contain the data that is in the dbexport.sql file.

To import a MySQL database using phpMyAdmin, follow these steps:

  1. Log in to your cPanel account.
  2. In the Databases section of the cPanel home screen, click phpMyAdmin.
  3. Click the database you are working with in the left menu
  4. Click Export in the top menu
  5. Under the Export heading, ensure that all of your tables are selected and that the SQL option is selected.
  6. Under the Options heading, ensure that you have selected, Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
  7. Ensure the Save as file option (towards bottom of page) is checked. If you think you database is quite large, choose either "zipped" or "gzipped" to compress the file so it will be easier to download. If you choose none, you will be save the file without compression (which is OK, you don't have to compress the file).
  8. Click Go
  9. You will be prompted to either open or save the file. Please select the option to save the file and then save the somewhere you'll remember (such as directly on your desktop).
  • mysql, phpmyadmin, video tutorial
  • 0 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Articles Relacionats

How to remove a user from a MySQL database in cPanel?

To delete a MySQL user, follow these steps: In the Databases section of the cPanel home...

How to repair a MySQL database in cPanel?

You can check MySQL databases for errors or possible corruption. If a database check reveals...

Does XtraOrbit provide an online tool to manage MySQL databases?

Yes, your web hosting control panel come with an online database managment tool called...

How to setup a database using the MySQL Database Wizard in cPanel?

To create a MySQL database, follow these steps: In the Databases section of the cPanel home...

How to delete a MySQL database user in cPanel?

To delete a MySQL user, follow these steps: In the Databases section of the cPanel home...