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