将django项目移植到mysql

django 1.4, mysql5.5, mysql_for_python1.2.1

将已创建好的项目由sqlite3移植到mysql。已创建好的django项目，详见

http://blog.csdn.net/ppdouble/article/details/7718594

http://blog.csdn.net/ppdouble/article/details/7673359

一、首先创建数据库

mysql> CREATE DATABASE tdata_mysql    -> CHARACTER SET utf8    -> COLLATE utf8_general_ci;

二、修改项目的数据库配置

DATABASES = {    'default': {        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.        'NAME': 'tdata_mysql',                      # Or path to database file if using sqlite3.        'USER': 'root',                      # Not used with sqlite3.        'PASSWORD': 'python',                  # Not used with sqlite3.        'HOST': 'python.centos',                      # Set to empty string for localhost. Not used with sqlite3.        'PORT': '3306',                      # Set to empty string for default. Not used with sqlite3.    }}

注意：NAME只需使用数据库名，python.centos是我的本地主机名

三、使用python的数据库API创建数据表，进入项目所在目录运行python manage.py syncdb

# python manage.py syncdbCreating tables ...Creating table auth_permissionCreating table auth_group_permissionsCreating table auth_groupCreating table auth_user_user_permissionsCreating table auth_user_groupsCreating table auth_userCreating table django_content_typeCreating table django_sessionCreating table django_siteCreating table tjob_locationCreating table tjob_jobCreating table django_admin_logYou just installed Django's auth system, which means you don't have any superusers defined.Would you like to create one now? (yes/no): yes Username (leave blank to use 'python'): djrootE-mail address: [e-mail]: Password (again): Superuser created successfully.Installing custom SQL ...Installing indexes ...Installed 0 object(s) from 0 fixture(s)

四、使用python的web管理工具http://127.0.0.1/tdjproj/admin/添加数据后，使用mysql客户端工具登录到数据库查看数据变化

mysql> show tables;+----------------------------+| Tables_in_tdata_mysql      |+----------------------------+| auth_group                 || auth_group_permissions     || auth_permission            || auth_user                  || auth_user_groups           || auth_user_user_permissions || django_admin_log           || django_content_type        || django_session             || django_site                || tjob_job                   || tjob_location              |+----------------------------+12 rows in set (0.00 sec)mysql> select * from tjob_job;+----+------------+-------------+-----------------+-------------+| id | pub_date   | job_title   | job_description | location_id |+----+------------+-------------+-----------------+-------------+|  1 | 2012-07-16 | SW_engineer | SW_engineer     |           1 |+----+------------+-------------+-----------------+-------------+1 row in set (0.00 sec)mysql> select * from tjob_location;+----+------+-------+---------+| id | city | state | country |+----+------+-------+---------+|  1 | NY   | NY    | US      |+----+------+-------+---------+1 row in set (0.00 sec)