Re: moving from sqlite3 to mysql

2014-02-06 Thread Malik Rumi
Ok, I got it working. And by working, I mean I got it to sync, I imported the database.json into mysql, and when I runserver everything is there as it should be. So, many thanks to all my gracious and more senior django users for your patient guidance and assistance. A note to all newbies who may b

Re: moving from sqlite3 to mysql

2014-02-05 Thread Ariel E. Isidro
1. before exiting mysql, you should grant permission to a user,i.e. grant all privileges on django_1.* to username@'localhost' identified by 'userpassword' replace username, userpassword with your own 2. exit mysql console 3. modify settings.py to add your username, password, host (localhost), and

Re: moving from sqlite3 to mysql

2014-02-05 Thread Drew Ferguson
Hi Just like SQLlite, you tell Django where the MySQL database is in settings.py At the top you should have something like DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'django_1', # Or path to database file if using sqlite3. # 'USER': '', # 'PASSWORD': '', #

Re: moving from sqlite3 to mysql

2014-02-05 Thread Malik Rumi
mysql> CREATE DATABASE django_1; Query OK, 1 row affected (0.24 sec) mysql> SHOW DATABASES; ++ | Database | ++ | information_schema | | django_1 | | mysql | | performance_schema | | test | +--

Re: moving from sqlite3 to mysql

2014-01-28 Thread Ariel E. Isidro
"Or can I create the database, (presumably directly in the shell), and then empty it, as these instructions say, and that will take care of it? I frankly didn't understand why I would need to 'empty' a new and empty database, but that's what it says. " With sql lite, everything will be created for

moving from sqlite3 to mysql

2014-01-28 Thread Daniel Roseman
You're confusing databases with tables. Django will create the tables for you, but they need a database to go in You need to create that yourself with the simple CREATE DATABASE command in mysql. -- DR. -- You received this message because you are subscribed to the Google Groups "Django users

Re: moving from sqlite3 to mysql

2014-01-28 Thread donarb
On Tuesday, January 28, 2014 9:17:32 AM UTC-8, Malik Rumi wrote: > > This is somewhat like the question in "need help moving to production > server" but I think the right procedure is to start a new thread. So I > think I have done well for just starting out. With your help I've gotten > Django

moving from sqlite3 to mysql

2014-01-28 Thread Malik Rumi
This is somewhat like the question in "need help moving to production server" but I think the right procedure is to start a new thread. So I think I have done well for just starting out. With your help I've gotten Django running on Windows, and I completed a tutorial and got my site working loc