Upgrade to mysql 8 removed symbolic link to database folder
Hello, after upgrading all databases show 0 bytes. I had created a symlink to /home/mysql. The data is still there but the symlink is gone. There is data in the new mysql folder so I am not sure how to proceed.
Maybe copy the new files to /home/mysql and recreate the symlink?
Thanks for any help!
-
Upgrading all databases means that you upgraded MySQL? from what version to what version?
Andrew N. - cPanel Plesk VMWare Certified Professional
Do you need immediate assistance? 20 minutes response time!* Open a ticket
EmergencySupport - Professional Server Management and One-time Services0 -
Yes from 5. Thanks!
0 -
I would renamed the /var/lib/mysql folder, re-create the symlink then start MySQL and see what the version is.
Andrew N. - cPanel Plesk VMWare Certified Professional
Do you need immediate assistance? 20 minutes response time!* Open a ticket
EmergencySupport - Professional Server Management and One-time Services0 -
Mysql would not start. Version is 8.0
0 -
Does it start with the new content in /var/lib/mysql? What is the version in that case?
Andrew N. - cPanel Plesk VMWare Certified Professional
Do you need immediate assistance? 20 minutes response time!* Open a ticket
EmergencySupport - Professional Server Management and One-time Services0 -
Yes, I renamed it back and it starts.
0 -
Still have the issue...
0 -
Have you tried using the details outlined here to properly configure /home/mysql as the datadir?
https://support.cpanel.net/hc/en-us/articles/360057909913-How-to-Move-MySQL-Datadir
0 -
Andrew was able to fix this for me. Turns out there was a corrupt database in the mix that I had not seen. Andrew was able to diagnose it in no time and got things back up and running. Highly recommend his service.
1
Please sign in to leave a comment.
Comments
9 comments