Restore from MySQLDump
Posted on 2011-05-03
I have a service database with Access 2003 front-end (30Mb) and MySQL 5 back-end (200Mb). A MySQL dump of the back-end is taken every night and retained for some months.
Occasionally, one of the users will accidentally delete a record from one of the tables and need to have it recovered from backup.
Can someone please recommend a GUI app which will allow me to restore a single table from the relevant MySQLDump and store it somewhere other than the current version of the database? I just need to be able to link-in to that table and append the missing record back into the current version.