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

This article mainly gives you a brief introduction to the methods of importing and exporting MYSQL database. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on the methods of importing and exporting MYSQL database can bring you some practical help.

Sql files are imported into the database.

1.MySQL-u username-p password

2.use database name; / / create one first if you don't have it.

3.source D:\ file name .sql; / / file path.

4.repair table table name, table name,... ; / / the table can be repaired to prevent table errors.

5.check table table name, table name,... ; / / check that all tables are OK.

Import the txt file into the table

1.mysql-u username-p password

2.use database name

3.create table if not exists table name (field …) ; / / create the table first

4.load data local infile "D:\ file name .txt" into table table name; / / file path

5.repair table table name

6.check table table name

III. Database export / backup

1.mysqldump-u user name-p password database name > D:\ file name.sql / / sql file path

Import and export MYSQL database methods to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.