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 ?
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
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 ?
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: 690 times
Last updated: Jun 12 '13
Are dump_forum and load_forum supported on 0.7?
How can I get a schema of database models for AskBot?
The 1 Reason For Women Who Live Trouble Fat In Our Culture
How to delete a question from backend?
Is there an option to add prefix to database tablename?
upload questions and answers directly to the database