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 Backup Tables by Copying MyISAM Table Files
How To Backup Tables by Copying MyISAM Table Files? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: FYIcenter.com
To easiest way to backup MyISAM tables is to copy the data files to a backup directory. 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 add a new index to "fyi_isam" table, add two rows, and copy "fyi_isam" table files to a backup directory:
>\mysql\bin\mysql -u dev -piyf fyi mysql> CREATE INDEX fyi_isam_count ON fyi_isam (count); Query OK, 1 row affected (0.11 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> INSERT INTO fyi_isam (id) VALUES(-1); Query OK, 1 row affected (0.05 sec) mysql> INSERT INTO fyi_isam (id, count) VALUES(-2, 987); Query OK, 1 row affected (0.03 sec) mysqk> quit >mkdir \mysql\backup >mkdir \mysql\backup\fyi >copy \mysql\data\fyi\my_isam.* \mysql\backup\fyi \mysql\data\fyi\fyi_isam.frm \mysql\data\fyi\fyi_isam.MYD \mysql\data\fyi\fyi_isam.MYI 3 file(s) copied. >dir \mysql\backup\fyi 8,620 fyi_isam.frm 40 fyi_isam.MYD 3,072 fyi_isam.MYI
2007-05-10, 4585👍, 0💬
Popular Posts:
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...
What is thread? A thread is an independent path of execution in a system.
What is the difference between Session State and ViewState? ViewState is specific to a page in a ses...
What is triple constraint triangle in project management ? Project Management triangle is depicted a...