I have a system that I developed in Java Spring and that stores data on a MySQL database run locally on windows 10.
Yesterday, I ran the latest windows update, and after 2 hours of grinding my computer crashed... and since then, windows does not want to start, and gives me the option to reinstall windows, with the possibility to keep my personal data. However, I think that it will erase MySQL and all the data that is stored.
I have linux running on the same machine, and so I am trying to use Linux to access the database in order to back it up using mysqldump.
In order to do that, I have tried to mount the directory where the data is saved on windows to the linux directory using the following command:
sudo mount --bind '/media/guillaume/Windows/ProgramData/MySQL/MySQL Server 5.7/Data' /var/lib/mysql
I then restarted the mysql server and I opened an SQL console. I could log in to the SQL Console using the Windows password (it is different from the SQL password on Linux), and I could list all the databases saved on my windows machine.
This when it gets more complicated. The SQL console can list all tables in the database that I am interested in, but for some reason, it cannot query the content of the tables. I can list all tables, but I cannot query the tables. SQL tells me that such a table does not exist, even though it has just listed it.
I have a screenshot of this, there is no typo, but the site does not let me post an image...
How can I resolve this issue? Or is there a smarter way to create a dump from the windows location, even though windows is not starting?
Thank you for your help !