MENU


Physical Backups

Different storage engines store a database in different file formats. Storing data from the MEMORY storage engine is not that straightforward because the contents are not stored on disk. MySQL Enterprise Backup allows you to retrieve data from MEMORY tables during a backup.

In Windows, for instance, a database using the InnoDB storage engine may be stored in:  
C:\ProgramData\MySQL\MySQL Server 5.6\data
. Each database is represented by a directory. Each table is stored as tbl.frm and tbl.ibd in the directory.
If the server is running during a physical backup, appropriate locking needs to be done so that the database contents do not change during the backup. When you try to restore a physical backup by copying the files back, you may need to stop MySQL Server first.