dboonthego Posted January 4, 2019 Share Posted January 4, 2019 Is there anything special I need to do with the MySQL docker to preserve data before upgrading the Unraid OS? At one time, I had a working instance of MySQL with some users, databases, tables, data, etc... Now, I see sad empty MySQL. I assume it disappeared after upgrading the Unraid OS. I thought the databases were saved to the appdata share, but I don't see any of my database files if navigate to /config within the docker. Quote Link to comment
saarg Posted January 4, 2019 Share Posted January 4, 2019 3 hours ago, dboonthego said: Is there anything special I need to do with the MySQL docker to preserve data before upgrading the Unraid OS? At one time, I had a working instance of MySQL with some users, databases, tables, data, etc... Now, I see sad empty MySQL. I assume it disappeared after upgrading the Unraid OS. I thought the databases were saved to the appdata share, but I don't see any of my database files if navigate to /config within the docker. This container is deprecated, in case you didn't know. But for your issue, an update shouldn't wipe your database. From which version to which version did you upgrade? Quote Link to comment
dboonthego Posted January 5, 2019 Share Posted January 5, 2019 (edited) 10 hours ago, saarg said: From which version to which version did you upgrade? 6.2.4 to 6.6.5 to 6.6.6. Edited January 5, 2019 by dboonthego Quote Link to comment
dboonthego Posted January 5, 2019 Share Posted January 5, 2019 10 hours ago, saarg said: But for your issue, an update shouldn't wipe your database. I didn't think so. It turns out my cache pool got hosed after the OS update. I have an unmountable disk and the databases are on it. Not a MySQL problem. Thanks! Quote Link to comment
fireb1adex Posted March 7, 2019 Share Posted March 7, 2019 (edited) Gahhh - I have changed the config of MySQL and now it wont start. SO i think i have a catch22, i cannot edit the config file unless the docker is running, but it boots out and stops because of the issue (I set lowercase table names = 1 but there are uppercase tables in the DB) Any ideas on how to fix this? [edit - turns out the changes weren't upgrade safe, forced an upgrade and now back up and running..] though, any ideas on how to make cnf changes that stick? Edited March 7, 2019 by fireb1adex Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.