Django MySQL Database location and setup

Question

So I have a MySQL database for my Django project which I think is located in the default directly (wherever that should be). When I want to move my Django project to digital ocean, how do I move that database? The my.cnf file is located inside the same directory as the settings.py file for the Django project. I am using macOS.

In short: How do I copy my database file to my Django project directory and reconfigure its path to that?

@KlausD. How do I do that? Could you maybe provide some link? — arujbansal
– arujbansal, Commented May 13, 2020 at 4:14
This is actually a system administration and not a programming task. It is off-topic for Stack Overflow. But any search engine is able to find leads on how to dump a database. — Klaus D.
– Klaus D., Commented May 13, 2020 at 4:20

danblack · Accepted Answer · 2020-05-13 03:36:37Z

0

Compare the MySQL versions of both servers. Ensure the new version isn't less than the current version. Also check its not two major versions ahead of the current one.

Ensure MySQL is stopped.

Copy/move the entire datadir to the new location. There should be no files in this new location that weren't in the original.

In the my.cnf file set datadir to the new location.

Copy the my.cnf file to the location where mysql is expecting to read this on the new server. Look at top of mysqld --help --verbose if you have doubts where this is.

answered May 13, 2020 at 3:36

danblack

14.9k2 gold badges27 silver badges49 bronze badges

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

Comments

neeraj9194 · Accepted Answer · 2020-05-13 10:43:01Z

0

There are many things to consider here,

In Digital Ocean you would have MySQL server running on same machine as the Django server i.e just like your local machine?
If yes then you might not have to change anything on django settings (if you keep user and password same as local).
If No, you might need to change host in django to IP of that server(there are many things involved here...)
Regarding the data transfer, it is always the best practice to dump MySQL and Import it in new DB. There are many guides available on web. Here is one from Digital ocean.

answered May 13, 2020 at 10:43

neeraj9194

3731 silver badge9 bronze badges

Collectives™ on Stack Overflow

Django MySQL Database location and setup

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related