0

I often backup my mysql db. But recently I have imported wrong dump file. Is there any way to revert the situation?

BR,

5
  • import the right one? – nbk Jun 21 at 17:16
  • But, The wrong dump file affects my whole data. I need to revert. I mean, need to delete the imported data from wrong dump file. – Samrat Jun 21 at 17:18
  • you can't revert. You can only use one dump. Some hiosters make Backups as well see if the have your data – nbk Jun 21 at 17:21
  • The dump file contains insert statements. To reverse inserts you will need to delete the inserted records, identifying them by unique keys for each table. Are you having difficulties running the delete statements? – mustaccio Jun 21 at 17:34
  • you can import the back into another table, and remove the data, but as i don't know if you can removed , you must first a complete vackup before trying this – nbk Jun 21 at 17:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.