1 你可以看你的my.ini文件,里面有可以看到datadir后面定义的路径就是 D:\mysql\bin
2 如果这个文件中找不到,你就登陆mysql,在myql下运行 D:\mysql\data\documentmysql> show variables like '%datadir%';
+---------------+--------------+
| Variable_name | Value |
+---------------+--------------+
| datadir | /data/mysql/ |
+---------------+--------------+
1 row in set (0.10 sec)D:\mysql\data\document>mysqldump -uroot -proot document qishu_novels > F:\document\qishu_novels.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
4.导入数据库
常用source 命令
进入mysql数据库控制台,如mysql -u root -p
C:\Users\Administrator>mysql -h27.255.79.21 -uuser -pSs19940317!
mysql>use 数据库
然后使用source命令,后面参数为脚本文件(如这里用到的.sql)mysql>source d:/dbname.sql
mysql> source F:\document\qishu_details.sql#进入mysql
mysql -h27.255.79.21 -uuser -pSs19940317!
#导入服务器mysql数据库
C:\Users\Administrator>mysql -h27.255.79.21 -uuser -pSs19940317! --default-character-set=utf8 document < F:\document\qishu_books.sql
#导入服务器mysql数据库
source F:\document\qishu_books.sql
报错信息:
ERROR 2005 (HY000): Unknown MySQL server host '10997107101114' (0)
ERROR: