python-管理MySQL之ConfigParser模块

1、拷贝2.7版本的ConfigParser.py模块支持无值解析

cp /usr/local/src/Python-2.7.5/Lib/ConfigParser.py /usr/lib/python2.6/

2、导入并使用

import ConfigParser

c = ConfigParser.ConfigParser()

c.read('/etc/my.cnf')

c.sections()
Out[8]: ['client', 'mysqld', 'mysqldump', 'mysql', 'myisamchk', 'mysqlhotcopy']

c.options('mysqld')
Out[9]: 
['port',
'socket',
'skip-locking',
'key_buffer_size',
'max_allowed_packet',
'table_open_cache',
'sort_buffer_size',
'read_buffer_size',
'read_rnd_buffer_size',
'myisam_sort_buffer_size',
'thread_cache_size',
'query_cache_size',
'thread_concurrency',
'log-bin',
'binlog_format',
'server-id']

c.get('mysqld','port')
Out[10]: '3306'

可以修改或添加：set(self, section, option, value=None)

保存内容：c.write()

with open('/tmp/mysql.cnf','w') as fd:

　　c.wirte(fd)