Shulou(Shulou.com)06/01 Report--

This article is about how SQL files can be imported into a database. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

1. Import SQL files by using the source command in Mysql under Win system:

mysql -u root -pmysql>use database name mysql>source d:/database name

This completes the import of SQL files under Win system.

2. Import SQL files under Linux system:

(1)Create an empty database in Mysql

mysql>create database 123;

(2)Set encoding for database

mysql>set names utf8;

(3)Import Data SQL File

The requested URL/home/abc/123.sql was not found on this server. About "SQL file how Mysql import database" This article is shared here, I hope the above content can have some help for everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.