how to restore a mysql dump FOLDER

After having a vps crash, I asked my hosting to give me the dumped file of my drupal database. It is a folder filled with of *.frm *.MYD files of the database tables. I used to restore mydb.sql files thru command line (mysqldupm …) but I have no idea how I can restore the current folder. Your help is much appreciated.

The best thing you could do would be to ask them to run mysqldump and give you a proper backup file, as this will be more robust to potential versioning issues in both mysql and the host OS. If they’re not willing to do this, you can try copying the files they gave you directly to the data directory (e.g., /var/lib/mysql) with the server stopped, then starting the server and GRANTing privileges to appropriate users.

Check more discussion of this question.

Related posts:

1. Unable to restore a Mysql database using an sql dump file
2. How to restore mysql database from the physical files?
3. MySQL Database Restore error
4. Restore 200+ mysql databases
5. how to restore access to MySQL after deleting all privileges?