Ubuntu broken need to recover mysql db
If you want to recover by filetype, please note the following structure in MySql database file system:

A MySQL table is the combination of three files:

The FRM file is the table definition.

The MYD file is where the actual data is stored.

The MYI file is where the indexes created on the table are stored.



Source:
[1] https://stackoverflow.com/questions/484750/restoring-mysql-database-from-physical-files
What this does not provide are the views. I did search a while and could not find where they are.
Same source tells how to restore the database from files. Copy them to  /var/lib/mysql/ on machine that has same version of Mysql installed.
That is needed to get more complex structures out of the files, and if the file sizes don't limit you, it would be also the most convenient way to do this.
Note you should close the server from running before changes in filesystem.