Incredinot Posted April 7, 2010 Share Posted April 7, 2010 Hi.. So i really got into some problems today, and i REALLY need some help.. About a week ago i finished a store and made an export of the db so i had an backup of that, and could re-use it if needed for another site.. Then within the last week the store owner have put up alot of products.. Now today i had to do some changes, so i made a backup of the db again I THOUGHT... And then something went wrong.. So i would just resuse the backup - but it have only saved like 50% of the db :/ .. So is it posible to use the first backup, and then put in all new values from the other backup? When i try to do it phpmyadmin tels me i cant make duplicate.. Quote Link to comment https://forums.phpfreaks.com/topic/197879-2db-backups-how-can-i-merge-them/ Share on other sites More sharing options...
kmaid Posted April 7, 2010 Share Posted April 7, 2010 Most backups are simply SQL dumps to recreate all the tables. Decompress it if required using 7zip if your archiver doesn't support the format. Once you have a .sql files or whatever open it up the file in your favorite text editor and cut out the insert portions. If you just run the queries in order it won't put the duplicate fields in twice so use the latest one first. Hope that helps Edited for *better* clarity Quote Link to comment https://forums.phpfreaks.com/topic/197879-2db-backups-how-can-i-merge-them/#findComment-1038655 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.