Regarding mysql backup

Tutor
1

sorry for my very late follow-up of the thread: Utfmb4 instead of utf8mb3? (#442) - #27 by regis

Why are we exporting the mysql database as well?

2

Wait what? I’m not sure I understand your question. In the topic you linked to, we export the database in order to migrate from utfmb3 to the utfmb4 locale.

3

sorry for not making myself clear. I was talking about the last replies in that thread:
Utfmb4 instead of utf8mb3? (#442) - #24 by regis.
Why are we exporting the mysql database when making a backup? and how is backup and migration (I suppose it meas, moving to a new machine) different?

Thanks in advance for your reply

4

Because the Mysql database contains precious data. If the server goes out in flames, you really want to have the content of your database backed up.

You got it: making a backup is when you want to keep your platform on the same server. Migration means switching to a new server.

5

I’m sorry that my wordings are confusing:

I am talking about the database named mysql, like when you do show databases:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| openedx            |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.04 sec)

I am talking about the line between information_schema and openedx, I feel like the data in this db is not related with openedx, as they can be easily rebuilt when importing a sqldump?

What I mean is, isn’t migration = backup + import? Why are there different steps for getting data out of mysql when migrating and backing up?

6

Right! I’m not sure that exporting the “mysql” database from MySQL is actually necessary. It’s just much simpler, from an ops perspective.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.