1.setting.py文件,修改数据库存储:
说明:注释sqlite3数据库,改用mysql连接DATABASES = {
"default": {
"ENGINE": "django.db.backends.mysql",
"NAME": "cmdb",
"USER": "root",
"PASSWORD": "root",
"HOST": "127.0.0.1",
"PORT": "3306",
}
}
2.安装mysql,创建库cmdb数据库
yum install -y mysql-server
3.删除原来sqlite文件、安装mysql模块文件
rm -rf db.sqlite3
yum list|grep MySQL-python
yum install -y MySQL-python.x86_64
4.使用管理脚本,同步数据库
python manage.py validate
python manage.py syncdb