How to import a database in PhpMyAdmin?

How to import a database in PhpMyAdmin?

Step 1

1 - 
In cPanel, go to “PhPMyAdmin”;


Step 2

In the top bar of your PHPmyadmin click on "Import";



Click the "Choose File or File" button and select your database (.sql);

Step 3

Then correctly define the settings you want for import as in the image



Finally, click on the "import" button.

Hope this helps !

    • Related Articles

    • Import a CSV file to MYSQL in PHPMYADMIN

      Step 1 First you must access your cPanel and go to the "phpMyadmin" item in the Database Section; Step 2 - In PHPMyAdmin, go to the menu "Import"; Step 3 - Select CSV format Step 4 - Click "Choose file", and search for local file and select CSV ...
    • How to import/export a MySQL database

      1 - In cPanel, go to “PhPMyAdmin”; Import: 2 - Click on "Import"; 3 - Click the "Choose File or File" button and select your database (.sql); 4 - Click the "Execute" button; Export: 2 -Choose the database you want to export from the list on the left; ...
    • How to export your database in phpMyAdmin?

      To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...
    • How to import/export a PostgreSQL database

      Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...
    • How to upload a firebird database to your hosting acount

      If you already have a Firebird database and want to upload it to your hosting account, just follow these steps: Step 1 1. Save/export your local database with the user that accesses your hosting. The password must contain exactly 8 characters, you ...