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


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!


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct