Where Does mysqldump Gets Its Information To Perform Backups
Posted on 2015-02-19
I would like to know where does mysqldump get is information to perform a backup.
If you replace the ibdata1, ib_logfile0, and ib_logfile1 from a MySQL database, while it is running, and make a backup with mysqldump, you still get all of the data when restoring from that backup.
That is, there is no data loss when restoring from this backup. However, if you restart the database, you lose all data up to the time where you replaced the ibdata1, ib_logifle0, and ib_logfiles1.