Re: getting error when i changed database sqllite3 to mysql

2019-10-07 Thread Desh Deepak
You can't use above version of django 2.0 with pymysql. On Mon, 7 Oct 2019, 03:24 'Dick in Texas' via Django users, < django-users@googlegroups.com> wrote: > I have tried to use a new, empty database, but that did not work. Still > got the question if I have installed MySQLclient. > > Tried the

Re: getting error when i changed database sqllite3 to mysql

2019-10-07 Thread Tosin Ayoola
Hello in your settings.py files, you still have, sqlite3 as your db engine instead of MySQL so probably try changing that then see if it's works On Oct 5, 2019 22:35, "Gulsher Khan" wrote: > I trying to change default database(sqllite) which is given by the Django. > I want to use mysql databa

Re: getting error when i changed database sqllite3 to mysql

2019-10-06 Thread 'Dick in Texas' via Django users
I just got by the ' 'install_as_MySqldb' error. SQL needed to be in upper case. Now, got new error. new error: mysqlclient 1.3.13 or newer is required; you have 0.9.3. Does it ever end? On Saturday, October 5, 2019 at 4:37:11 PM UTC-5, Gulsher Khan wrote: > > I trying to change default dat

Re: getting error when i changed database sqllite3 to mysql

2019-10-06 Thread 'Dick in Texas' via Django users
I have tried to use a new, empty database, but that did not work. Still got the question if I have installed MySQLclient. Tried the statements from Desh Deepak. The install and import went well. However, when I tried to migrate, I got the message: module 'pymysql' has no attribute 'install_

Re: getting error when i changed database sqllite3 to mysql

2019-10-06 Thread Joseph Emeka
I think you need to create the database "django" on you database back-end. And try making migrations again. On Sat, Oct 5, 2019, 22:36 Gulsher Khan wrote: > I trying to change default database(sqllite) which is given by the Django. > I want to use mysql database. I put lots of effort but nothin

Re: getting error when i changed database sqllite3 to mysql

2019-10-05 Thread Desh Deepak
pip install pymysql And then, setting.py import pymysql pymysql.install_as_MySqldb() And edit DATABASE: = { 'default' :{ 'ENGINE': 'django.db.backends.mysql', 'NAME': 'database name', 'USER': 'username', 'PASSWORD': 'password', 'HOST' : 'localhost', 'PORT' : '3306'

Re: getting error when i changed database sqllite3 to mysql

2019-10-05 Thread Motaz Hejaze
If you have data , export it to csv , then after creating the mysql database populate it with data ftom csv file On Sun, 6 Oct 2019, 1:16 am Aldian Fazrihady, wrote: > Have you created the database on MySQL? > > On Sun, Oct 6, 2019 at 4:36 AM Gulsher Khan > wrote: > >> I trying to change defaul

Re: getting error when i changed database sqllite3 to mysql

2019-10-05 Thread Aldian Fazrihady
Have you created the database on MySQL? On Sun, Oct 6, 2019 at 4:36 AM Gulsher Khan wrote: > I trying to change default database(sqllite) which is given by the Django. > I want to use mysql database. I put lots of effort but nothing went well. I > successfully has been install mysql, mysqlclient

Re: getting error when i changed database sqllite3 to mysql

2019-10-05 Thread Gil Obradors
HI! Maybe this tutorial can help you https://medium.com/@a01207543/django-conecta-tu-proyecto-con-la-base-de-datos-mysql-2d329c73192a (in Spanish) Missatge de Gulsher Khan del dia ds., 5 d’oct. 2019 a les 23:36: > I trying to change default database(sqllite) which is given by the Django. > I