big sqlite database

big
database

asked 2013-06-11 11:31:43 -0500

zulp
31 ●5 ●3 ●7

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 ?

edit retag flag offensive close merge delete

add a comment

2 Answers

Sort by » oldest newest most voted

answered 2013-06-12 10:49:02 -0500

Fitoria

1263 ●7 ●25 http://fitoria.net/

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

edit flag offensive delete link

add a comment

answered 2013-06-11 14:53:26 -0500

Evgeny

14295 ●56 ●103 ●216 http://askbot.org/

Move to PostgresQL - the best option for the production hosting of all available.

edit flag offensive delete link

Comments

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 ?

zulp ( 2013-06-12 10:44:47 -0500 )edit

Use django's dumpdata and loaddata commands.

Evgeny ( 2013-06-12 10:50:01 -0500 )edit

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

big sqlite database

2 Answers

Comments

Your Answer

Question Tools

Stats

Related questions

big sqlite database edit

2 Answers

Comments

Your Answer

Question Tools

Stats

Related questions

big sqlite database