mysql5.5 导入_mysql5.5怎么导入导出.sql文件

2013-09-29 回答

进入mysql目录下的bin文件夹

mysqldump -u 用户名 -p 数据库名 > 导出的文件名

例如：

c:\program files\mysql\mysql server 5.5\bin>mysqldump -u root -p test > test.sql

enter password: ********

c:\program files\mysql\mysql server 5.5\bin>dir *.sql

驱动器 c 中的卷没有标签。

卷的序列号是 406a-c32e

c:\program files\mysql\mysql server 5.5\bin 的目录

2013-01-29 16:34 39,574 test.sql

1 个文件 39,574 字节

0 个目录 5,498,294,272 可用字节

导入

c:\program files\mysql\mysql server 5.5\bin>mysql -u root -p

enter password: ********

welcome to the mysql monitor. commands end with ; or \g.

your mysql connection id is 17

server version: 5.5.29 mysql community server (gpl)

copyright (c) 2000, 2012, oracle and/or its affiliates. all rights reserved.

oracle is a registered trademark of oracle corporation and/or its

affiliates. other names may be trademarks of their respective

owners.

type 'help;' or '\h' for help. type '\c' to clear the current input statement.

mysql> create database test2;

query ok, 1 row affected (0.04 sec)

mysql> use test2

database changed

mysql> source test.sql

......