Mysql import database method

MySQL is a small and medium-sized relational database management system developed by the Swedish MySQL AB company and currently belongs to Oracle. MySQL is a relational database management system. A relational database stores data in different tables instead of putting all data in one large warehouse, which increases speed and flexibility. MySQL's SQL language is the most commonly used standardized language for accessing databases. MySQL software adopts GPL (GNU General Public License), which is divided into free version and commercial version. Due to its small size, fast speed and low total cost of ownership, especially the open source feature, the development of small and medium-sized websites is generally Choose MySQL as the website database. Due to the excellent performance of its free version, it can form a good development environment with PHP and Apache.

So how to import MySQL into the database? In fact, the import method is very simple. Here we use two methods: tool import and import using only the mysql command interface. Of course, there are many mysql database graphical interface tools, which are also more convenient to use. Follow me to operate it together!

Method 1

1. First, we use the command line interface provided by MySQL to import the database and ensure that the MySQL database is installed on our computer. We can confirm whether it is through the command line After installing the MySQL database, of course, the first step is to open the Mysql database service. We use the command line to open it: as shown below:

##2. After starting MySQL, we find the script file we need to use, which is the database file. Of course, we must first create a database. Only in this way can the script be imported, as shown below:

##3. We are copying the script to the root directory of the local disk, so that it is easy to enter and find the script. Here we use the D drive to illustrate, use test.sql: Then we come to the command line, use SOURCE d:/test.sql ;To import the database, first enter mysql, as shown below:

#4. First, you need to create a database in the database, and then import the script, so create a database first. If you don’t need a script, you won’t know which database you want to import the script into, as shown in the figure below:

##5. Then you can enter the import .sql file Command:

mysql> USE 数据库名;
mysql> SOURCE d:/test.sql;

As shown below:

#6. See the above screen, indicating that the mysql database has been imported successfully Oh!

Isn’t it very simple? Now let’s introduce the second method, using the mysql graphic tool to import the database. We still use the test.sql script to illustrate:

Method 2

1. Use Navicat for MySQL graphical interface to import the database. The steps to import the database using the graphical interface are very simple, as shown in the following figure:

##2. After establishing the database in the graphical interface , we use the function of the import script to import the database, as shown in the following figure:

##

3. Click to select the script, we select the test.sql script on the D drive, and then set the database character format, as shown below:

4. Then click to start running the script. The script will start to be imported! After the import is completed, a success prompt will appear. , as shown in the figure below:

##5. Then we close the database first, and then open the database to see the tables of the established database, as shown in the figure below:

Isn’t it very simple?

If you are not very familiar with mysql, let’s try it together!

The above is the detailed content of Mysql import database method. For more information, please follow other related articles on the PHP Chinese website!