<div>
<div class="content wysiwyg-content">
I recently had to restore a backup and to say the least it went bad. &nbsp;I have missing records. &nbsp;I now have two tables one is a good backup of the originally lost data (loanFindingReplace) and a live table that has some, but not all of the original findings. &nbsp;I can not just replace the current live table (loanFinding) since I have had number entries since the restore. &nbsp;How is the easiest/quickest query to determine which records don't exist in the loanFinding table that do exist in the loanFindingReplace table and insert those into loanFinding? &nbsp;Both tables have the same fields with the same names. &nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/09_w38/500192/Capture.JPG" target="_blank" title="Fields (35 KB)"><img alt="Fields" class="file-block lazyload" style="max-width: 305px;" data-src="https://filedb.experts-exchange.com/incoming/2011/09_w38/500192/Capture.JPG" /></a><br />
Thank you.
</div>
</div>


Capture.JPG

I recently had to restore a backup and to say the least it went bad.  I have missing records.  I now have two tables one is a good backup of the originally lost data (loanFindingReplace) and a live table that has some, but not all of the original findings.  I can not just replace the current live table (loanFinding) since I have had number entries since the restore.  How is the easiest/quickest query to determine which records don't exist in the loanFinding table that do exist in the loanFindingReplace table and insert those into loanFinding?  Both tables have the same fields with the same names.  

Thank you.

MySql Data Restore

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.