Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Revert all changes made in tables

bibbin's profile image bibbin posted 2 weeks ago in General Permalink

Is there a way to revert a table to the same form as it was when I imported it from sql database file after I have modified it previously?

TTSneko's profile image TTSneko posted 2 weeks ago Permalink

Yes, it's called "backup".

As soon as the database is updated you've literally overwritten old data. In some situations (depending on what you're doing) a typical Ctrl-Z may work for the last step, however if you alter the table structure and then decide to post the update your old state is lost. Except you have a backup, of course.

bibbin's profile image bibbin posted 2 weeks ago Permalink

Thanks for the reply! With backup, does it mean I would duplicate the first table and use that as a backup?

TTSneko's profile image TTSneko posted 2 weeks ago Permalink

Depending on what you are doing it would be better to backup the whole database. Just to be on the safe side.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.