数据库

MySQL数据导入导出教程

最新推荐文章于 2025-09-12 20:11:40 发布

iteye_16293

最新推荐文章于 2025-09-12 20:11:40 发布

阅读量209

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签：数据结构 MySQL C C++ C#

本文链接：https://blog.youkuaiyun.com/iteye_16293/article/details/81764128

mysql 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了MySQL数据库的导入导出方法，包括使用mysqldump和mysql命令进行操作的具体步骤，以及如何通过SQL语句实现数据的导出与导入。

sql导入导出
数据库导出：mysqldump -u root -p databaseName>f:/fileName.sql
数据库导入:
mysql -u root -p --default-character-set=utf8
mysql> create database qq1;
mysql> use qq1;
mysql> source f:/fileName.sql

mysql数据导入导出语句
导出:SELECT * from ebook INTO OUTFILE "bookdev.txt" FIELDS ENCLOSED by '"' TERMINATED by "," LINES TERMINATED BY " "
导入:LOAD DATA INFILE "bookdev.txt" into TABLE ebook FIELDS ENCLOSED by '"' TERMINATED by "," LINES TERMINATED BY " "

／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／／
mysql sql语句导入与导出
导入: mysql -u root -p 数据库名如: C:\mysql\bin>mysql -u root -p house < c:\1-1.txt

导出: mysqldump -u root -p 数据库名 [表名1 表名2] > 输出地址其中表名可选
如: 导出house中的blacklist表 C:\mysql\bin>mysqldump -u root house blacklist > c:\1-1.txt
导出house中的blacklist和userinfo表 C:\mysql\bin>mysqldump -u root house blacklist userinfo> c:\1-1.txt
导出house中的所有表 C:\mysql\bin>mysqldump -u root house > c:\1-1.txt
在使用mysqldump中可以使用 "-d" ,这时只导出表结构,没有数据如: 导出house中的所有表 ,这时只有表结构 C:\mysql\bin>mysqldump -u root -d house > c:\1-1.txt 导出:SELECT * from ebook INTO OUTFILE "bookdev.txt" FIELDS ENCLOSED by '"' TERMINATED by "," LINES TERMINATED BY "\n"
导入:LOAD DATA INFILE "bookdev.txt" into TABLE ebook FIELDS ENCLOSED by '"' TERMINATED by "," LINES TERMINATED BY "\n"