6 months ago
I am trying to mount my volume to /var/lib/mysql but the server keeps crashing because there is data in the directory and it aborts.
6 Replies
6 months ago
Hi there - I think you need to ensure that the /var/lib/mysql directory is empty before mounting the volume. What's in that directory currently / how is it being used?
Status changed to Awaiting User Response Railway • 6 months ago
sarahkb125
Hi there - I think you need to ensure that the /var/lib/mysql directory is empty before mounting the volume. What's in that directory currently / how is it being used?
6 months ago
I have no idea. It is a fresh deployment, so there shouldn't be anything. It is the default directory for mysql data, so I don't understand why it won't work.
How can I even see the contents of the directory? There is no way to access the file structure.
Status changed to Awaiting Railway Response Railway • 6 months ago
6 months ago
Hello,
For MySQL 5.7 you want to mount your volume to /var/lib/mysql and use the following start command -
docker-entrypoint.sh mysqld --innodb-use-native-aio=0 --disable-log-bin --performance_schema=0 --ignore-db-dir=lost+found --bind-address=::Status changed to Awaiting User Response Railway • 6 months ago
brody
Hello,For MySQL 5.7 you want to mount your volume to /var/lib/mysql and use the following start command -docker-entrypoint.sh mysqld --innodb-use-native-aio=0 --disable-log-bin --performance_schema=0 --ignore-db-dir=lost+found --bind-address=::
6 months ago
thank you! that seems to have worked! how was i supposed to get that info? just so i know for the future...
Status changed to Awaiting Railway Response Railway • 6 months ago
6 months ago
Brody's a mysql pro, comes from being in the trenches
glad the fix worked!
Status changed to Awaiting User Response Railway • 6 months ago
Status changed to Solved sarahkb125 • 6 months ago
