求救my.cnf文件的配置信息！

hx851112

由于本人疏忽用远程软件编辑了my.cnf信息但是却没上传至服务器，而导致my.cnf文件内的信息丢失成为空文件，希望可以有哪个朋友可以提供一下my.cnf文件的配置信息.

licess

mysql版本不同、机器配置不同的话配置文件参数也不一样
一下为mysq 5.5，开启innodb，数据库目录自行替换

1. [client]
   
2. #password        = your_password
   
3. port                = 3306
   
4. socket                = /tmp/mysql.sock
   
5. 
   
6. [mysqld]
   
7. port                = 3306
   
8. socket                = /tmp/mysql.sock
   
9. datadir = 数据库目录
   
10. skip-external-locking
    
11. key_buffer_size = 16M
    
12. max_allowed_packet = 1M
    
13. table_open_cache = 64
    
14. sort_buffer_size = 512K
    
15. net_buffer_length = 8K
    
16. read_buffer_size = 256K
    
17. read_rnd_buffer_size = 512K
    
18. myisam_sort_buffer_size = 8M
    
19. thread_cache_size = 8
    
20. query_cache_size = 8M
    
21. tmp_table_size = 16M
    
22. 
    
23. #skip-networking
    
24. max_connections = 500
    
25. max_connect_errors = 100
    
26. open_files_limit = 65535
    
27. 
    
28. log-bin=mysql-bin
    
29. binlog_format=mixed
    
30. server-id        = 1
    
31. expire_logs_days = 10
    
32. 
    
33. default_storage_engine = InnoDB
    
34. innodb_file_per_table = 1
    
35. innodb_data_home_dir = 数据库目录
    
36. innodb_data_file_path = ibdata1:10M:autoextend
    
37. innodb_log_group_home_dir = 数据库目录
    
38. innodb_buffer_pool_size = 16M
    
39. innodb_additional_mem_pool_size = 2M
    
40. innodb_log_file_size = 5M
    
41. innodb_log_buffer_size = 8M
    
42. innodb_flush_log_at_trx_commit = 1
    
43. innodb_lock_wait_timeout = 50
    
44. 
    
45. [mysqldump]
    
46. quick
    
47. max_allowed_packet = 16M
    
48. 
    
49. [mysql]
    
50. no-auto-rehash
    
51. 
    
52. [myisamchk]
    
53. key_buffer_size = 20M
    
54. sort_buffer_size = 20M
    
55. read_buffer = 2M
    
56. write_buffer = 2M
    
57. 
    
58. [mysqlhotcopy]
    
59. interactive-timeout

复制代码

hx851112

感谢军哥~通过以上配置信息已经修复问题~