MySQL 5.6修改data目录

默认数据存放位置：

C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.6\

打开该位置，即可看见my.ini

修改该配置文件的datadir 属性，并将data文件夹放在你修改后的文件夹路径下，重启mysql服务即可。

# server_type=3
[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# The Pipe the MySQL Server will use
# socket=mysql

# The TCP/IP Port the MySQL Server will listen on
port=3307

# Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.6/"

# Path to the database root
datadir="D:/MySQL Server 5.6/data\"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

 mysqldump -uuser -p123456 ubk_platform > D:\data_bak\ubk_platform.sql