Collections:
Restore Tables by Copying MyISAM Files in MySQL
How To Restore Tables by Copying MyISAM Table Files in MySQL?
✍: FYIcenter.com
If you have old copies of MyISAM table files, you can restore them easily by copying them back to the data directory to replace the current table files. However you may need to shut down MySQL server to do this, because the current table files might be locked on MySQL server. But this is not the recommended way to do backups. Read the backup FAQ collections for more details.
The following tutorial exercise shows you how to delete a data row, and restored it by copying back the table files:
>\mysql\bin\mysql -u dev -piyf fyi mysql> DELETE FROM fyi_isam WHERE id = -1; Query OK, 1 row affected (0.07 sec) mysql> SELECT * FROM fyi_isam; +----+-------+-------+ | id | title | count | +----+-------+-------+ | -2 | NULL | 987 | +----+-------+-------+ 1 row in set (0.00 sec) mysql> quit; >copy \mysql\backup\fyi\fyi_isam.* \mysql\data\fyi \mysql\backup\fyi\fyi_isam.frm \mysql\backup\fyi\fyi_isam.MYD \mysql\backup\fyi\fyi_isam.MYI 3 file(s) copied. >\mysql\bin\mysql -u dev -piyf fyi mysql> SELECT * FROM fyi_isam; +----+-------+-------+ | id | title | count | +----+-------+-------+ | -1 | NULL | NULL | +----+-------+-------+ 1 row in set (0.00 sec)
Looks like we restored one row (id=-1). But we also lost one row (id=-2). This will happen if your MySQL server is still running during the backup and storing processes.
⇒ Repair MyISAM Tables in MySQL
⇐ Backup Tables by Copying MyISAM Files in MySQL
2017-09-01, 1669🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...