My site - RSS feedhttps://askbot.org/en/questions/Open source question and answer forum written in Python and DjangoenCopyright Askbot, 2010-2011.Wed, 13 Feb 2013 17:23:46 -0600Export Import questionshttps://askbot.org/en/question/9997/export-import-questions/How to export all questions from Askbot 0.7.43 with sqlite3 database and import them to other running askbot 0.7.48 with mysql database. ?
ThxWed, 13 Feb 2013 15:33:56 -0600https://askbot.org/en/question/9997/export-import-questions/Answer by Fitoria for <p>How to export all questions from Askbot 0.7.43 with sqlite3 database and import them to other running askbot 0.7.48 with mysql database. ?</p>
<p>Thx</p>
https://askbot.org/en/question/9997/export-import-questions/?answer=9998#post-id-9998You can do the following:
In **version 0.7.43:**
#with your sqlite settings
python manage.py dumpdata > data.json
#with your mysql settings
python manage.py loaddata data.json
The first command will dump the database data into json format then the second one will load them into your mysql database, **always on the 0.7.43 version** this is very important because for loading data the version must be the same from the data dump.
Now after that upgrade to askbot0.7.48 and do the migration.
python manage.py migrate
And after the migration it should work on the new version.Wed, 13 Feb 2013 15:45:27 -0600https://askbot.org/en/question/9997/export-import-questions/?answer=9998#post-id-9998Comment by coldsystem for <p>You can do the following:</p>
<p>In <strong>version 0.7.43:</strong></p>
<pre><code>#with your sqlite settings
python manage.py dumpdata &gt; data.json
#with your mysql settings
python manage.py loaddata data.json
</code></pre>
<p>The first command will dump the database data into json format then the second one will load them into your mysql database, <strong>always on the 0.7.43 version</strong> this is very important because for loading data the version must be the same from the data dump.</p>
<p>Now after that upgrade to askbot0.7.48 and do the migration.</p>
<pre><code>python manage.py migrate
</code></pre>
<p>And after the migration it should work on the new version.</p>
https://askbot.org/en/question/9997/export-import-questions/?comment=9999#post-id-9999is this the same way . to export questions from askbot 0.7.48 SQlite and import them to the same version askbot 0.7.48 with mysql based .??Wed, 13 Feb 2013 17:15:08 -0600https://askbot.org/en/question/9997/export-import-questions/?comment=9999#post-id-9999Comment by Evgeny for <p>You can do the following:</p>
<p>In <strong>version 0.7.43:</strong></p>
<pre><code>#with your sqlite settings
python manage.py dumpdata &gt; data.json
#with your mysql settings
python manage.py loaddata data.json
</code></pre>
<p>The first command will dump the database data into json format then the second one will load them into your mysql database, <strong>always on the 0.7.43 version</strong> this is very important because for loading data the version must be the same from the data dump.</p>
<p>Now after that upgrade to askbot0.7.48 and do the migration.</p>
<pre><code>python manage.py migrate
</code></pre>
<p>And after the migration it should work on the new version.</p>
https://askbot.org/en/question/9997/export-import-questions/?comment=10000#post-id-10000In theory this should work, but for large data sets this may be slow (the json loaddata method). If your sqlite is already on version 0.7.48, then you don't need to migrate afterwards. You can do migrations either before or after. Marked your question as feature request because more robust script would be necessary for larger sites.Wed, 13 Feb 2013 17:23:46 -0600https://askbot.org/en/question/9997/export-import-questions/?comment=10000#post-id-10000