Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4543👍, 0💬
Popular Posts:
How To Analyze Tables with "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Serve...
What is the value of this expression? +1-2*3/4 -0.5
What is SMC approach of estimation?
How is normally a project management plan document organized ? PMP document forms the bible of a pro...
How can I enable session tracking for JSP pages if the browser has disabled cookies? We know that se...