Home / server / Questions / 472578
Accepted
virtualeyes
Asked: 2013-01-26 17:07:47 +0800 CST

MySQL InnoDB Backup: are dump files enough?

  • 772

What exactly does the default ibdata1 file store that does not exist in a mysqldump?

I've got a backup/rsync job that stores dump files of a MySQL 5.5 database on a remote server for rotating daily/weekly backups.

However, I am not currently backing up the ibdata1 file itself -- is this a nightmare waiting to happen or are dump files enough?

Thanks

mysql

1 Answers

  1. Best Answer

    No, if you are doing proper mysqldumps the information necessary to rebuild the database will be present. You don't have to backup the ibdata1 file.

    • 2