mysql数据备份，还原
http://www.jianshu.com/p/b31e80678472
MySQL指定启动时的一些配置
/usr/sbin/mysqld
--defaults-file=/etc/mysql/my.cnf
--basedir=/usr
--datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock
查看修改当前数据库的编码
show create database xxx;
alter database xxx CHARACTER SET utf8;
修改服务器的编码格式:my.cnf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
log-error = /Applications/XAMPP/xamppfiles/var/mysql/mysql_error.log
网友评论