Since no-one has suggested avoiding MySQL I should say that I have a few
small websites and every time I check the logs they are full of uglies
trying to access phpmyadmin. Every time I see that I'm glad I went for
PostgreSQL.
From my research it seems Postgres is probably the best option for
Django if you want stability with scalability and atomicity.
YMMV
Mike
On 15/01/2018 10:44 PM, Julio Biason wrote:
Hi Daniel,
Well, in simple terms, all you need to do is change the DATABASE
setting in your settings (here
https://www.coderedcorp.com/blog/django-settings-for-multiple-environments/
is an example of way to keep two different configurations, so you can
have a production setting pointing to MySQL while keeping your dev
setting using SQLite). You may need to create the user and a database
for it, but that's more of a MySQL-specific question than Django.
If you want to migrate your data from SQLite to MySQL, you can use
`dumpdata` to "export" the data from your dev enviroment and
`loaddata` to load it back to the production data. Both are part of
the default manage.py:
https://docs.djangoproject.com/en/2.0/ref/django-admin/#dumpdata
On Sun, Jan 14, 2018 at 12:09 PM, Daniel Cîrstea
<daniel.cirste...@gmail.com <mailto:daniel.cirste...@gmail.com>> wrote:
Hello. I am new to Django and I am trying to use it for my
bachelor thesis. Thing is, I want to use MySQL insted of SQLite.
How do I exactly do it.. I can't find a step-by-step tutorial on
the internet.
Also, I want to deploy project later on Heroku. Can I work on
SQLite on local machine and then is possible to change to MySQL on
Heroku ? In any case, I want to know how to do both, if possible.
Thank you.
--
You received this message because you are subscribed to the Google
Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to django-users+unsubscr...@googlegroups.com
<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to django-users@googlegroups.com
<mailto:django-users@googlegroups.com>.
Visit this group at https://groups.google.com/group/django-users
<https://groups.google.com/group/django-users>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/a7decab1-334e-4f04-a6e9-6ad7bc2cd78b%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/a7decab1-334e-4f04-a6e9-6ad7bc2cd78b%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
*Julio Biason*,Sofware Engineer
*AZION* | Deliver. Accelerate. Protect.
Office: +55 51 3083 8101 <callto:+555130838101> | Mobile: +55 51
<callto:+5551996209291>_99907 0554_
--
You received this message because you are subscribed to the Google
Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to django-users+unsubscr...@googlegroups.com
<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to django-users@googlegroups.com
<mailto:django-users@googlegroups.com>.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAEM7gE32Kg9zKb5t4JzBdoshYA3sCk5Q6xuckwPNtSHt1zuYKA%40mail.gmail.com
<https://groups.google.com/d/msgid/django-users/CAEM7gE32Kg9zKb5t4JzBdoshYA3sCk5Q6xuckwPNtSHt1zuYKA%40mail.gmail.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/9c9beff8-67bc-d0dd-4b2d-42230d858236%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.
