Move MySQL database to a new location
Budget: $30 – $250 USD
Greetings. I want to be able to move MySQL 8 database files from /var/lib/mysql/<database> to another location, but when I bring the database back up after symlinking, queries come back with the error "Tablespace is missing for". I know I've done this before, but maybe it was back on MySQL 5. Looking for someone to SHOW/TEACH me how to do this (what's the missing step), not just fix it for me.
Attached are the steps I've tried starting from a fresh Ubuntu 20 LTS installation on DigitalOcean. I suggest testing your solution in the same environment and will include a few bucks for you to spin one up, if you want.
I get a lot of people who seems to quickly respond to projects randomly just to see if they can get awarded the project and then hope to find someone to do it for them. That's not how it should work. Please make the first word of your response "stegosaurus" so I know you actually read the project... then I can move you to the top and ignore the cheaters.
Note that I have limited hours, so I might be slow to respond. This isn't urgent and if it takes a few days to finish because of my schedule, it's okay. I'm available today until 0000 UTC. Monday and Tuesday from 2200-000, Thursday from 2200-0000.
Attached are the steps I've tried starting from a fresh Ubuntu 20 LTS installation on DigitalOcean. I suggest testing your solution in the same environment and will include a few bucks for you to spin one up, if you want.
I get a lot of people who seems to quickly respond to projects randomly just to see if they can get awarded the project and then hope to find someone to do it for them. That's not how it should work. Please make the first word of your response "stegosaurus" so I know you actually read the project... then I can move you to the top and ignore the cheaters.
Note that I have limited hours, so I might be slow to respond. This isn't urgent and if it takes a few days to finish because of my schedule, it's okay. I'm available today until 0000 UTC. Monday and Tuesday from 2200-000, Thursday from 2200-0000.