Change Django Database : SQLITE3 to MARIADB

Question

I am new to Django and python! I made a project on Django with the default database which is sqlite3. I want to now transfer the database from sqlite3 to Mariadb.

There is no data which is present in current sqlite3. I just want to know how can I transfer the default database.

I have followed the following documentation:

And added, this to my settings.py :

 DATABASES = {
     'default': {
         'ENGINE': 'django.db.backends.mysql',
         'NAME': 'Techdevio',
         'USER': 'satharkar',
         'PASSWORD': 'root',
         'HOST': 'localhost',
         'PORT': '',
     }
 }

I am not sure, how things will work with this now. I am looking if someone can help me with this. So what I did is by now :

I deleted the db.sqlite3 from my project folder.
Tried to run python manage.py makemigrations but it is throwing error that mysql client is not installed.

I have followed the documentation and installed everything mentioned their. How will things work after this ? So whenever I will try to submit the form in my django project, database, table will be created and data will be then stored under the mariadb?

I am new to all this, looking for a resolution in this case or any suggestions on how to proceed with this situation.

Thanks

JPG · Accepted Answer · 2021-05-29 05:37:44Z

2

Django doesn't come with mysqlclient and hence you may need to install it by

pip install mysqlclient

answered May 29, 2021 at 5:37

JPG

89.4k24 gold badges164 silver badges235 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sameer Atharkar Over a year ago

I am getting so many errors by running that command :( -> dpaste.org/CTH5 I am running this on centos7. I have already installed these packages : sudo yum install python3-devel mysql-devel

Sameer Atharkar Over a year ago

I was able to download the mysqlclient now with the help of this link. Thanks a lot JPG.

Collectives™ on Stack Overflow

Change Django Database : SQLITE3 to MARIADB

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related