[求助] 求助老大 如何更改mysql var目錄路徑

kiah

求助老大 如何更改mysql var目錄路徑   因為我掛載盤了 想把數(shù)據(jù)庫放到掛載的盤里 請老大一定要幫助

admin

可以在/www/wdlinux/etc/my.cnf里修改
又或是用目錄加載或連接形式

kiah

回復(fù) 2# admin


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

1. # mysql conf /etc/my.cnf
   
2. # Created by http://www.fsowen.com
   
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

復(fù)制代碼

admin

增加
datadir=目錄