Hello, I started development on an older version of Django, and the system Django was subsequently upgraded. The system is presently at 1.1.
I am trying to migrate from sqlite to MySQL. I have tried a few different approaches but none seem to work. Either of these approaches yields the same flavor of failure: python manage.py dumpdata > opsbook.json [Edit settings.py to point at MySQL.] python manage.py syncdb python manage.py loaddata opsbook OR, say, appropriating the dbpickle snippet from http://www.djangosnippets.org/snippets/167/ : ./dbpickle.py --dump --file=opsbook.pickle [Edit settings.py to point at MySQL.] python manage.py syncdb ./dbpickle.py --load --file=opsbook.pickle Either way, I get: 0-10:19 dannh...@ops-dev ~/ironport/opsbook/server/opsbook> ./dbpickle.py --load --file=opsbook.pickle Traceback (most recent call last): File "./dbpickle.py", line 195, in ? load(opts.file, opts.plugin) File "/usr/local/lib/python2.4/site-packages/django/db/transaction.py", line 240, in _commit_on_success res = func(*args, **kw) File "./dbpickle.py", line 118, in load obj.delete() File "/usr/local/lib/python2.4/site-packages/django/db/models/base.py", line 569, in delete delete_objects(seen_objs) File "/usr/local/lib/python2.4/site-packages/django/db/models/query.py", line 1037, in delete_objects del_query.delete_batch_related(pk_list) File "/usr/local/lib/python2.4/site-packages/django/db/models/sql/subqueries.py", line 57, in delete_batch_related self.do_query(related.field.m2m_db_table(), where) File "/usr/local/lib/python2.4/site-packages/django/db/models/sql/subqueries.py", line 35, in do_query self.execute_sql(None) File "/usr/local/lib/python2.4/site-packages/django/db/models/sql/query.py", line 2369, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python2.4/site-packages/django/db/backends/util.py", line 19, in execute return self.cursor.execute(sql, params) File "/usr/local/lib/python2.4/site-packages/django/db/backends/mysql/base.py", line 84, in execute return self.cursor.execute(query, args) File "/usr/local/lib/python2.4/site-packages/MySQLdb/cursors.py", line 166, in execute self.errorhandler(self, exc, value) File "/usr/local/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.ProgrammingError: (1146, "Table 'dannhowa_opsbook.auth_group_permissions' doesn't exist") I am on my second day of trying to find a solution here. I try lobotomizing my database per http://code.djangoproject.com/wiki/RemovingTheMagic#Databasechangesyoullneedtomake but that did not work either. I ran into the "content type" issue allegedly fixed by applying yet another data-cleanup script, at http://code.djangoproject.com/wiki/RemovingTheMagic#EntriesinyourContentTypestablewillnowbewrong but that cleanup script link says "post expired" and really, manually hacking up the database sounds like not the right solution. Can someone please assure me that there is indeed a sane way to migrate my data and set me in the right direction? Thanks! Sincerely, -daniel -- http://dannyman.toldme.com -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
