ADz83 Posted January 3, 2017 Share Posted January 3, 2017 (edited) I wanted to delete some old inactive clients and used a SQL query to do this. However it had some inadvertent results and cleared some clients I did not wish to delete so would like to merge them back from full backup I took if possible. Does anybody know how to merge the tblclients table from backup into current database? I just want to bring back the clients that were deleted so missing from current database. Any help/advice would be appreciated. This is the sql I used... DELETE FROM `tblclients` WHERE status='inactive' Edited January 4, 2017 by ADz83 0 Quote Link to comment Share on other sites More sharing options...
ADz83 Posted January 4, 2017 Author Share Posted January 4, 2017 SOLVED! Thanks to support who provided a very helpful link I think I have managed to restore the missing tables. Here was solution for anybody else who may have similar issue.. http://www.gfisk.com/merge-data-from-two-databases/ 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.