[求助] 求助老大 如何更改mysql var目录路径

kiah

求助老大 如何更改mysql var目录路径   因为我挂载盘了 想把数据库放到挂载的盘里 请老大一定要帮助

admin

可以在/www/wdlinux/etc/my.cnf里修改
又或是用目录加载或连接形式

kiah

回复 2# admin


   老大看下 这我的my  我不知道在哪里修改呀   希望老大教我修改下

1. # mysql conf /etc/my.cnf
   
2. # Created by http://www.wdlinux.cn
   
3. # Last Updated 2010.06.01
   
4. 
   
5. [client]
   
6. port                = 3306
   
7. socket                = /tmp/mysql.sock
   
8. [mysqld]
   
9. port                = 3306
   
10. socket                = /tmp/mysql.sock
    
11. skip-external-locking
    
12. key_buffer_size = 128M
    
13. max_allowed_packet = 1M
    
14. table_open_cache = 256
    
15. sort_buffer_size = 1M
    
16. read_buffer_size = 1M
    
17. read_rnd_buffer_size = 2M
    
18. myisam_sort_buffer_size = 8M
    
19. thread_cache_size = 8
    
20. query_cache_size= 16M
    
21. thread_concurrency = 8
    
22. max_connections = 300
    
23. wait_timeout = 30
    
24. interactive_timeout = 30
    
25. max_connect_errors = 9
    
26. long_query_time = 1
    
27. tmp_table_size = 16M
    
28. #log-bin=mysql-bin
    
29. #binlog_format=mixed
    
30. #server-id        = 1
    
31. [mysqldump]
    
32. quick
    
33. max_allowed_packet = 8M
    
34. [mysql]
    
35. no-auto-rehash
    
36. [myisamchk]
    
37. key_buffer_size = 12M
    
38. sort_buffer_size = 1M
    
39. read_buffer = 1M
    
40. write_buffer = 1M
    
41. [mysqlhotcopy]
    
42. interactive-timeout

复制代码

admin

增加
datadir=目录