On 03.01-02:10, Szymon wrote:
[ ... ]
> So there is any other working solutions for migrating MySQL ->
> Postgre?
i would suggest that you do this via the database not via django.
simply alter your 'settings.py' to point to your new postgres database
and sync it to create all the relevant tables. then export your mysql
database to SQL or CSV and then re-import the data to postgresql.
note:
1. you may wish to drop a couple of tables before exporting (make
sure you do a proper backup before trying that!) to avoid importing
certain things. for example, session data and/or user data.
2. don't backup the whole database, just the data as you are
going to let django define the database (a full backup will also try
to recreate the database and it's not 100% compatible). i believe
you can do this with the 'mysqlbackup' utility.
3. you will need to substitute quotation marks, mysql uses ""
and postgresql uses \". good old 'sed' to the rescue here.
4. you will have to reset the autonumber serial indexes after
importing or it will cause problems when trying to insert new data.
there are a couple of very simple scripts out there if you search
postgresql help forums.
generally you'll find what you need here
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL
good luck
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@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
-~----------~----~----~----~------~----~------~--~---
