标题:
[求助]
求助老大 如何更改mysql var目录路径
[打印本页]
作者:
kiah
时间:
2012-3-11 16:08
标题:
求助老大 如何更改mysql var目录路径
求助老大 如何更改mysql var目录路径 因为我挂载盘了 想把数据库放到挂载的盘里 请老大一定要帮助
作者:
admin
时间:
2012-3-11 18:18
可以在/www/wdlinux/etc/my.cnf里修改
又或是用目录加载或连接形式
作者:
kiah
时间:
2012-3-11 18:37
回复
2#
admin
老大看下 这我的my 我不知道在哪里修改呀 希望老大教我修改下
# mysql conf /etc/my.cnf
# Created by http://www.wdlinux.cn
# Last Updated 2010.06.01
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
max_connections = 300
wait_timeout = 30
interactive_timeout = 30
max_connect_errors = 9
long_query_time = 1
tmp_table_size = 16M
#log-bin=mysql-bin
#binlog_format=mixed
#server-id = 1
[mysqldump]
quick
max_allowed_packet = 8M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 12M
sort_buffer_size = 1M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]
interactive-timeout
复制代码
作者:
admin
时间:
2012-3-12 08:55
增加
datadir=目录
欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/)
Powered by Discuz! 7.2