Retrieve MySQL Files before upgrade
So before my inline upgrade from Ubuntu 14.04 to Ubuntu 16.04 that has put me through hell, I backed up the /var/lib/mysql folder of database files. What I didn't realize is that they are .frm and .myd files, not .sql files. Am I able to retrieve those anywhere from my older mysql-server installation? It's the last piece of the puzzle.
1 Reply
Hello,
This page breaks down various mysql data types, as well as steps to recover old files using the MySQL Workbench.
Additionally, this stackoverflow page discusses how to use .frm and .myd files to recover a MySQL database. This should certainly help in solving your existing issue!