Why don't you simply re-install MySQL. Re-installation of MySQL or installation of a new version of MySQL should not damage the existing database. Unless one of the database files has been damaged (iddata1?), MySQL should be back up and running with the old database intact. There is a repair program that will fix in most cases any inconsistencies with databases (see the manual).
I have never heard of a case of uninstalling mysql leading to corrupted databases, so something else is going on as well. Yes, you can use bscan to recover the job that backed up the database, if there was one. Best regards, Kern On 10/02/2016 11:22 PM, Michael Munger wrote: > I foolishly installed KDE on Debian, which ... for some reason ... > decided to uninstall mysql-server, and in the course of doing so, > corrupted some tables (ibdata1, for example). Since these files are > corrupt, innodb won't start. I now have checksum failures, and mysql > won't start unless I delete these files. > > This machine is the bacula director and storage daemon. My /etc/bacula/ > conf files are all fine. it's the databases I need to recover. > > Long story short, is it possible to use bscan to pull the most recent > copy of /var/lib/mysql/*? > > If so, then I can grab the most recent set of databases, and use those > to restore some other things that the installation of KDE broke. But, > this database is by far the most important. > ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
