python django 无法 syncdb 到线上

[chuck wu]

添加

from sae._restful_mysql import monkey
monkey.patch()

运行  python manage.py syncdb

报如下错误:

django.db.utils.ProgrammingError: Invalid host or port

具体log

{'kwargs': {u'passwd': 'password', u'db': 'app_dailybuy', u'client_flag': 196610, u'host': 'localhost', u'user': 'root', u'port': 3306}, 'args': (), 'connection_id': None, 'op': 'open'}

Traceback (most recent call last):

  File "manage.py", line 10, in <module>

    execute_from_command_line(sys.argv)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 385, in execute_from_command_line

    utility.execute()

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 377, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 288, in run_from_argv

    self.execute(*args, **options.__dict__)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 338, in execute

    output = self.handle(*args, **options)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 533, in handle

    return self.handle_noargs(**options)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/syncdb.py", line 27, in handle_noargs

    call_command("migrate", **options)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 115, in call_command

    return klass.execute(*args, **defaults)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 338, in execute

    output = self.handle(*args, **options)

  File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 63, in handle

    executor = MigrationExecutor(connection, self.migration_progress_callback)

  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/executor.py", line 17, in __init__

    self.loader = MigrationLoader(self.connection)

  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 48, in __init__

    self.build_graph()

  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 179, in build_graph

    self.applied_migrations = recorder.applied_migrations()

  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 59, in applied_migrations

    self.ensure_schema()

  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 49, in ensure_schema

    if self.Migration._meta.db_table in self.connection.introspection.get_table_list(self.connection.cursor()):

  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py", line 165, in cursor

    cursor = self.make_debug_cursor(self._cursor())

  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py", line 138, in _cursor

    self.ensure_connection()

  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py", line 133, in ensure_connection

    self.connect()

  File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 94, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py", line 133, in ensure_connection

    self.connect()

  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py", line 122, in connect

    self.connection = self.get_new_connection(conn_params)

  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 471, in get_new_connection

    conn = Database.connect(**conn_params)

  File "/usr/local/lib/python2.7/dist-packages/sae_python_dev-1.3.2-py2.7.egg/sae/_restful_mysql/__init__.py", line 81, in Connect

    return Connection(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/sae_python_dev-1.3.2-py2.7.egg/sae/_restful_mysql/connections.py", line 187, in __init__

    super(Connection, self).__init__(*args, **kwargs2)

  File "/usr/local/lib/python2.7/dist-packages/sae_python_dev-1.3.2-py2.7.egg/sae/_restful_mysql/_mysql.py", line 39, in __init__

    self._open_connection()

  File "/usr/local/lib/python2.7/dist-packages/sae_python_dev-1.3.2-py2.7.egg/sae/_restful_mysql/_mysql.py", line 133, in _open_connection

    retval = self._request('open', *self._conn_args, **self._conn_kwargs)

  File "/usr/local/lib/python2.7/dist-packages/sae_python_dev-1.3.2-py2.7.egg/sae/_restful_mysql/_mysql.py", line 152, in _request

    raise rep.get('sql_exception')

django.db.utils.ProgrammingError: Invalid host or port

[chuck wu]

migrate 命令 也报同样的错误

[Guanghui Zhang]

mysqldump -u root -p db_name > mydb.sql直接把本地数据库里面的数据导出为 sql文件，然后通过sae的数据库管理PHPMyAdmin导入就可以了。这个方法的前提是你的数据很少。