R1Soft Restoring a mySql file from server from .frm- no .sql file available

Every MySQL table you create is represented, on disk, by a .frm file, which describes the table’s format (i.e. the table definition).

Those files are essentially the core files for MySQL

MySQL reads the files to create your databases.

If you need to restore a database, your best bet would be to restore /var/lib/mysql/(database)

This works in R1Soft

Leave a comment