How to restore Mysql database from backup files

Question

I have a VPS that needs to be remapped. my DB was part of this, and it was fueled since the application was not yet in production. However, there is some data that I want to recover on it. the VPS provider gives me a backup image (Ubunto Linux) which has all the files.

Is there any way to recover my data?

Answer 1

Ubuntu mysql data files are located in /var/lib/mysql

To restore the database you need:

1) old one 2) mysql
3) /var/lib/mysql/your_database_name/
4) mysql

.