big sqlite database
i have only 300 Question and 60 registred users. how can that my Sqlite databse is so huge (500MB) is there any way to cleanup the database . or to move it to Mysql ?
i have only 300 Question and 60 registred users. how can that my Sqlite databse is so huge (500MB) is there any way to cleanup the database . or to move it to Mysql ?
Move to PostgresQL - the best option for the production hosting of all available.
Trying to convert my sqlite database postgresql
[root@Centos DEV]# python manage.py shell --database=sqlite
/usr/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/conf/__init__.py:75: DeprecationWarning: The ADMIN_MEDIA_PREFIX setting has been removed; use STATIC_URL instead.
"use STATIC_URL instead.", DeprecationWarning)
Usage: manage.py shell [options]
Runs a Python interactive interpreter. Tries to use IPython, if it's available.
manage.py: error: no such option: --database
How to solve that ?
one way to do it (not 100% reliable) is to do the following:
With sqlite as a database:
python manage.py dumpdata > mydata.json
Change to postgres in settings.py, run sycdb and migrate commands and then:
python manage.py loaddata < mydata.json
Please start posting anonymously - your entry will be published after you log in or create a new account.
Asked: 2013-06-11 11:31:43 -0500
Seen: 808 times
Last updated: Jun 12 '13
Are dump_forum and load_forum supported on 0.7?
upload questions and answers directly to the database
psycopg2 - support for version 2.4.2
Best practices to avoid data inconsistency
null value in column "description"
How to correctly sync database with Askbot app?
How to keep the Askbot database and it's contents in sync using GIT