Backup Of Individual Files

• To make selective backups of individual files:
  • Dump the table

    SELECT * INTO OUTFILE 'file' FROM tbl_name

  • Reload the table

    LOAD DATA INFILE 'file' REPLACE ....

    • To avoid duplicate rows, the table must have a PRIMARY KEY or a UNIQUE index.
    • The REPLACE clause causes old rows to be replaced with new ones when a new row duplicates an old row on a unique key value.

How do I backup data stored in an InnoDB storage engine?

---

---

© 2007 John Michael Pierobon

Notes