Home >Database >Mysql Tutorial >mysql导出sql文件_MySQL
mysql导出sql文件_MySQL
- WBOYOriginal
- 2016-06-01 13:12:321205browse
首先打开MySQL的安装目录，然后进入MySQL Server 5.6，再进入bin文件夹，看看是否有mysqldump.exe这个可执行的文件，然后复制下mysqldump.exe的路径，本人的mysql安装在E:盘的Program Files下面，路径为：E:/Program Files/MySQL/MySQL Server 5.6/bin。
接下来打开cmd，进入E:盘，再进入刚才复制的目录
然后输入mysqldump --no-defaults -h localhost -u 数据库的用户名 -p 要导出的数据库名>导出的路径+文件名.sql，输完后回车
这时输入数据库的密码，然后回车
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
Previous article：SQLUnit 环境搭建_MySQLNext article：MySQL Enterprise Monitor 3.0.11 has been released_MySQL