Home >Database >Mysql Tutorial >mysql导出表结构命令_MySQL

mysql导出表结构命令_MySQL

WBOY
WBOYOriginal
2016-06-01 13:19:06995browse

bitsCN.com

如果将数据库中的数据导出来的话有时候一个文件都有一点多G,所以测试的时候就只需要表结构。命令如下:

  mysqldump -h127.0.0.1 -uroot -p -d DBname >D:/db.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