[DiscordArchive] hi guys I have been disconnected for many months and finally I wanted to get back into things. I sa
[DiscordArchive] hi guys I have been disconnected for many months and finally I wanted to get back into things. I sa
Original source
hi guys I have been disconnected for many months and finally I wanted to get back into things. I saw the announcementy of the MySQL and MariaDB version update requirements.
I ran `mysql --version` and it says `mysql Ver 15.1 Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper`, so am I still good or do I still need to update MySQL?
rektbyfaith
09-30-2024, 04:25 PM #1Archived author: matrix1999 • Posted: 2024-09-30T16:25:28.129000+00:00
Original source
hi guys I have been disconnected for many months and finally I wanted to get back into things. I saw the announcementy of the MySQL and MariaDB version update requirements.
I ran `mysql --version` and it says `mysql Ver 15.1 Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper`, so am I still good or do I still need to update MySQL?
Original source
You are running MariaDB, so you'll need to remove that and instead install a supported version of MySQL (probably 8.4 LTS is your best bet)
rektbyfaith
09-30-2024, 04:26 PM #2Archived author: Bench • Posted: 2024-09-30T16:26:35.755000+00:00
Original source
You are running MariaDB, so you'll need to remove that and instead install a supported version of MySQL (probably 8.4 LTS is your best bet)
Original source
Not sure if there's any particulars to worry about for Debian if that is what you're using though
rektbyfaith
09-30-2024, 04:26 PM #3Archived author: Bench • Posted: 2024-09-30T16:26:57.807000+00:00
Original source
Not sure if there's any particulars to worry about for Debian if that is what you're using though
Original source
I am running Ubuntu 22.04 LTS
rektbyfaith
09-30-2024, 04:27 PM #4Archived author: matrix1999 • Posted: 2024-09-30T16:27:14.081000+00:00
Original source
I am running Ubuntu 22.04 LTS
Original source
Then just removing MariaDB/installing MySQL *should* be fine
rektbyfaith
09-30-2024, 04:27 PM #5Archived author: Bench • Posted: 2024-09-30T16:27:32.490000+00:00
Original source
Then just removing MariaDB/installing MySQL *should* be fine
Original source
I would assume I need to create a new DB for the game, am I correct?
rektbyfaith
09-30-2024, 04:27 PM #6Archived author: matrix1999 • Posted: 2024-09-30T16:27:52.386000+00:00
Original source
I would assume I need to create a new DB for the game, am I correct?
Original source
Yes, but if you care about what exists on your existing server, I would export the data you have and make backups of it. Shouldn't be too hard to import the data to the new DB
rektbyfaith
09-30-2024, 04:28 PM #7Archived author: Bench • Posted: 2024-09-30T16:28:26.122000+00:00
Original source
Yes, but if you care about what exists on your existing server, I would export the data you have and make backups of it. Shouldn't be too hard to import the data to the new DB
Original source
I am not very good with databases. LOL
rektbyfaith
09-30-2024, 04:28 PM #8Archived author: matrix1999 • Posted: 2024-09-30T16:28:50.694000+00:00
Original source
I am not very good with databases. LOL
Original source
Basically dump all on mariadb, import all on MySQL
rektbyfaith
09-30-2024, 04:29 PM #9Archived author: sudlud • Posted: 2024-09-30T16:29:48.481000+00:00
Original source
Basically dump all on mariadb, import all on MySQL
Original source
I would only need to export the following databases, correct?
`MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| acore_auth |
| acore_characters |
| acore_world |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+`
rektbyfaith
09-30-2024, 04:35 PM #10Archived author: matrix1999 • Posted: 2024-09-30T16:35:54.498000+00:00
Original source
I would only need to export the following databases, correct?
`MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| acore_auth |
| acore_characters |
| acore_world |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+`