Home >Database >Mysql Tutorial >MySQL导库命令_MySQL

MySQL导库命令_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:30:051039browse

bitsCN.com

MySQL导库命令

 

1,先登录再导库:

 

mysql -uroot -p123465 回车create database testdb;source D:/DB/test.sql;

 

 

2,导库时使用账户密码:

 

mysql -uroot -p123456 testdb < D:/DB/test.sql;

 

 

导出:

mysqldump -uroot -p123456 testdb > D:/DB/test.sql

 


bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn