<div>
Thanks for your response Dave. &nbsp;When you say &quot;there is also a cache of recent activity and it is not always updated to the files you are listing.&quot; &nbsp;What cache are you referring to and updated to what files? &nbsp;Also, does this happens when MySQL is running?<br />
<br />
Thanks.<br />
Willie
</div>


Thanks for your response Dave.  When you say "there is also a cache of recent activity and it is not always updated to the files you are listing."  What cache are you referring to and updated to what files?  Also, does this happens when MySQL is running?

Thanks.
Willie

<div>
Thanks Dave. &nbsp;This is what I was looking.
</div>


Thanks Dave.  This is what I was looking.

<div>
You're welcome, glad to help.
</div>


<div>
<div class="content wysiwyg-content">
Experts:<br />
<br />
I would like to know where does mysqldump get is information to perform a backup. &nbsp;<br />
<br />
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. &nbsp;<br />
<br />
That is, there is no data loss when restoring from this backup. &nbsp;However, if you restart the database, you lose all data up to the time where you replaced the ibdata1, ib_logifle0, and ib_logfiles1.<br />
<br />
Thanks.<br />
Willie
</div>
</div>


Experts:

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.

Thanks.
Willie

Where Does mysqldump Gets Its Information To Perform Backups

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.