Importing a database through PhpMyAdmin.

Introduction

• The phpMyAdmin utility provides the possibility to import a database into the Mysql server;

Requirements

• The user and password associated with the database we want to import;
• For example, in the ISPConfig panel, we will be able to create a database with an associated user by following the tutorials: 
  Creating a MYSQL user in the ISPConfig control panel
  Creating a database in the ISPConfig control panel
  
  

Steps to follow

• Within the hosting packages with cPanel and Plesk administration panels, logging into PhpMyAdmin is done directly from the administration panel;
• Instead, in the case of ISPConfig or Webuzo panels, the PhpMyAdmin plugin in the panel will be accessed, which will redirect to a login page in the database management interface;
• On the page that will be displayed, it will be necessary to enter the MYSQL username and password to view the databases assigned to that user, after which the "Go" button is pressed;

• Once in the interface, the databases assigned to the user will be visible in the column on the left side;

• To import a database from your personal computer, select the desired database from the list, and then from the menu at the top of the page, click the "Import" button;

• On the page that will be displayed, click the "Browse" button to select the database imported from the local computer;

• After selecting the database, press the "Go" button without making any other changes;

• After the successful import of the SQL file, a confirmation message will be displayed;