Is it possible to restore a MySQL database from physical database files? I have a directory that has the following file types:
client.frm
client.MYD
client.MYI
but for about 20 more tables.
I usually use mysqldump or a similar tool to get everything in 1 SCL file, so what's the way to deal with these types of files?
- The definition of the FRM file table. < Li> The MYD file where the actual data is stored.
- The MYI file is where the indexes created on the table are stored.
Copy them to you by copying them You should be able to do your database folder (in Linux, the default location is / var / lib / mysql / )
while you should do this Servers requires is not running.
Comments
Post a Comment