Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Restore Tables by Copying MyISAM Table Files
How To Restore Tables by Copying MyISAM Table Files? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: 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 shutdown 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.
2007-05-10, 5354👍, 0💬
Popular Posts:
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the da...
In below sample code if we create a object of class2 which constructor will fire first? Public Class...
What are different properties provided by Objectoriented systems ? Following are characteristic’s of...
How To List All Values of Submitted Fields? - PHP Script Tips - Processing Web Forms If you want lis...
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...