Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Backup Tables by Copying MyISAM Files

By: FYIcenter.com

(Continued from previous topic...)

How To Backup Tables by Copying MyISAM Table Files?

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

(Continued on next topic...)

1. What Are Storage Engines?
2. How To Create a New Table Using MyISAM Storage Engine?
3. Where Table Data Is Stored by the MyISAM Storage Engine?
4. How To Backup Tables by Copying MyISAM Table Files?
5. How To Restore Tables by Copying MyISAM Table Files?
6. How To Check and Repair MyISAM Tables?
7. How To Create a New Table Using the InnoDB Storage Engine?
8. Where Table Data Is Stored by the InnoDB Storage Engine?
9. How To Create a New Table Using the BDB Storage Engine?
10. How To Start mysqld to Support the BDB Storage Engine?
11. Where Table Data Is Stored by the BDB Storage Engine?
12. How To Create a New Table Using the CSV Storage Engine?
13. How To Create a New Table Using the MEMORY Storage Engine?
14. What Happens to MEMORY Tables When MySQL Server Is Stopped?
15. How To See Which Storage Engines Are Supported in Your MySQL Server?