MySQL database Import external *.sql file detailed steps

if you want to reprint please indicate the source: http://blog.csdn.net/itas109

Environment:

MySQL 50515

Navicat for MySQL

First, the introduction of the premise

Ensure that the host and port of the imported SQL file are consistent with the MySQL version

Specific operation:

1. Click the connection Properties.

2. Ensure that the hostname and port are consistent with the information in SQL

3, run, MySQL default login program, view MySQL version

II. databases in the new SQL

The database name in this example is TR, such as the new data named TR, encoded as UTF8 (based on actual modification).

Third, Import Database 1, right-click the TR database, hit "Run SQL file"
2, confirm the database, coding and other information consistent

3. Import Process

Iv. Display of imported data

1, after the completion of the import we found that the table does not add the data we imported, in fact, we just right click on the table, click Refresh (or F5) can be.

2. Final result

if you want to reprint please indicate the source: http://blog.csdn.net/itas109

MySQL database Import external *.sql file detailed steps