Почему MySQL не включается?

Question

[walkerstech]

Установил mysql-server на ubuntu 22.04 и перенес директорию с файлами .frm .ibd в папку /var/lib/mysql, пытался перезапустить вылетала ошибка. Удалил директорию и повторно попытался не получилось.
С помощью команды autoremove mysql-server удалил, и вручную сами директорий.
Повторно установил, но уже не запускается и соответствующих директорий нет

spoiler

root@18214:~# journalctl -u mysql.service
-- Logs begin at Sun 2023-03-26 12:48:07 UTC, end at Wed 2023-07-19 05:18:15 UTC. --
Jul 18 09:02:20 18214 systemd[1]: Starting MySQL Community Server...
Jul 18 09:02:21 18214 systemd[1]: Started MySQL Community Server.
Jul 19 04:34:22 18214 systemd[1]: Stopping MySQL Community Server...
Jul 19 04:34:24 18214 systemd[1]: mysql.service: Succeeded.
Jul 19 04:34:24 18214 systemd[1]: Stopped MySQL Community Server.
Jul 19 04:34:24 18214 systemd[1]: Starting MySQL Community Server...
Jul 19 04:34:25 18214 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 19 04:34:25 18214 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 19 04:34:25 18214 systemd[1]: Failed to start MySQL Community Server.
Jul 19 04:34:25 18214 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Jul 19 04:34:25 18214 systemd[1]: Stopped MySQL Community Server.
Jul 19 04:34:25 18214 systemd[1]: Starting MySQL Community Server...
Jul 19 04:34:26 18214 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 19 04:34:26 18214 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 19 04:34:26 18214 systemd[1]: Failed to start MySQL Community Server.
Jul 19 04:34:27 18214 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 2.
Jul 19 04:34:27 18214 systemd[1]: Stopped MySQL Community Server.
Jul 19 04:34:27 18214 systemd[1]: Starting MySQL Community Server...
Jul 19 04:34:27 18214 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 19 04:34:27 18214 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 19 04:34:27 18214 systemd[1]: Failed to start MySQL Community Server.
Jul 19 04:34:28 18214 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3.
Jul 19 04:34:28 18214 systemd[1]: Stopped MySQL Community Server.
Jul 19 04:34:28 18214 systemd[1]: Starting MySQL Community Server...
Jul 19 04:34:28 18214 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 19 04:34:28 18214 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 19 04:34:28 18214 systemd[1]: Failed to start MySQL Community Server.
Jul 19 04:34:29 18214 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
Jul 19 04:34:29 18214 systemd[1]: Stopped MySQL Community Server.
Jul 19 04:34:29 18214 systemd[1]: Starting MySQL Community Server...
Jul 19 04:34:29 18214 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 19 04:34:29 18214 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 19 04:34:29 18214 systemd[1]: Failed to start MySQL Community Server.
Jul 19 04:34:30 18214 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Jul 19 04:34:30 18214 systemd[1]: Stopped MySQL Community Server.
Jul 19 04:34:30 18214 systemd[1]: mysql.service: Start request repeated too quickly.
Jul 19 04:34:30 18214 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 19 04:34:30 18214 systemd[1]: Failed to start MySQL Community Server.
Jul 19 04:34:41 18214 systemd[1]: Starting MySQL Community Server...
Jul 19 04:34:42 18214 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 19 04:34:42 18214 systemd[1]: mysql.service: Failed with result 'exit-code'.

Comments

[walkerstech]

Justa Gain, пусто

[walkerstech]

sudo apt-get remove --purge mysql*
sudo apt-get autoremove
sudo apt-get autoclean
Помогло, повторно установил и заработал

[Alexey Dmitriev]

Это "перенес директорию с файлами .frm .ibd в папку /var/lib/mysql" в корне неправильно.

[walkerstech]

Alexey Dmitriev, а как в таком случае делать?

[Дмитрий]

Снимать дамп надо, может там дамп от 8, а ставите на 5.7

[walkerstech]

Дмитрий, dump 5.7, сама бд 8

[Alex G.]

Чекай лог /var/log/mysql/error.log

[Alexey Dmitriev]

walkerstech, mysqldump\restore. Либо при переносе файлов обеспечить консистентность переноса, перенеся ibdata и файлы логов транзакций