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 -~----------~----~----~----~------~----~------~--~---