使用schemasync同步数据库表结构

 

安装方式

wget http://www.schemasync.org/downloads/SchemaSync-0.9.4.tar.gz
tar -xf SchemaSync-0.9.4.tar.gz
cd SchemaSync-0.9.4
python setup.py install


wget http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz
unzip MySQL-python-1.2.5.zip 
cd MySQL-python-1.2.5/
python setup.py build
python setup.py install

 

FAQ

一、如果报以下错误：
Error: Missing Required Dependency MySQLdb.
结构一致，不需要Migration操作

解决方法：
yum install MySQL-python -y

添加数据库的动态库文件
cat >> /etc/ld.so.conf.d/mysql-x86_64.conf<<EOF
/usr/local/mysql/lib
EOF

ldconfig

二、如果报字符集问题

# 在命令中添加utf8
cat /usr/bin/schemasync 
#!/usr/bin/python
# EASY-INSTALL-ENTRY-SCRIPT: 'SchemaSync==0.9.4','console_scripts','schemasync'
__requires__ = 'SchemaSync==0.9.4'
import sys
from pkg_resources import load_entry_point
reload(sys)
sys.setdefaultencoding('utf8')

if __name__ == '__main__':
    sys.exit(
        load_entry_point('SchemaSync==0.9.4', 'console_scripts', 'schemasync')()
    )