Will you not be able to import the mysql database during the use of SQLyog? I believe some novice friends still don’t understand it. For this reason, the editor below will explain how to use SQLyog to import mysql database.
Open the SQLyog software, enter the password, click Connect, and open the software interface. Note that mysql needs to be installed first.
Create a database with the same name as the database to be imported. For example, if you want to import a database of shop.sql here, first create a database named shop.
Enter the shop database name and click Create.
Click on the database you just created, then click Database->Import->Import database from SQL dump file.
Select the path to import the database, click Execute, and after execution, click Finish.
Open the database table and you can see that each table has been imported.
The above explains the specific operation process of using SQLyog to import mysql database. I hope friends in need can learn it.
