Hello guys, I am trying to port pootle database from 2.0.5 [SQLITE3] to 2.5 [MYSQL].
Here's what I have done so far: [pootle v2.0.5 instance] 1) Copied dbs/pootle.db. [pootle v2.1.6 instance] 2) Downloaded pootle 2.1.6, copied the database in 1 to dbs/pootle.db [v2.1.6 instance] 3) Used "python manage.py dump_data -n > dump.json" to get a dump of the json data. [pootle v2.5 instance] 5) Ran "python manage.py syncdb" 4) Imported this data into v2.5 using "python manage.py loaddata dump.json" At [4] I was getting some IntegrityErrors, which I suppose is because of some duplicate entries, so nothing very serious. I managed to comment out the code that was raising these errors, and after doing that loaddata script ran just fine. 6) Then I ran: $ fab production update_db # Updates DB schema to latest version $ fab production upgrade # Applies various non-schema cleanup & recovery 7) Which gave me some "description_html" row not found error. I don't know why the script was looking for description_html in my pootle_app_language, pootle_app_projects etc, databases. But again, I commented out the lines looking for such rows and the script worked fine there after. ^ as you can see I did a lot of hacks there. *I want to make sure none of those hacks resulted in data loss or something.* -- Thanks Aneesh Dogra (lionaneesh) ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ Translate-pootle mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/translate-pootle
