Am 24.11.2015 um 13:34 schrieb Carl Whalley:
I see, well I kinda thought that was a long shot and backed up the mysql data dirs in case. Trouble is, the data is for a bacula installation and the irony is ... well, its not there is no backup, or that a rebuild from the tapes isn't possible, just both are a real pain (last backup too old). If there was some way to repair the current ones it would be much better.
http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-gran... * make a local backup of your whole datadir before start * make sure that the dbserver is only reachable from localhost and stop every webserver which would try to access it * put "skip-grant-tables" into the [mysqld] section of your config * the server now likely starts because it should ignore grants * it no longer needs and password * so "mysql_upgrade" maybe suceeds and repairs the mysql-db * stop the server * remove "skip-grant-tables" * try to start it regulary
On Tue, Nov 24, 2015 at 12:28 PM, Reindl Harald <h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>> wrote:
Am 24.11.2015 um 13:02 schrieb Carl Whalley:
I tried also the obvious, complete removal and reinstallation with the same results :-(
package removal *never ever* would touch the datadir because if it would all your data inlcuding users and permissions would be gone and i doubt that any user would want that
if you are OK with lose the data because you have backups just purge the datadir at your own and run "mysql_install_db" to initalize it before restore your backups from dumpfiles
reinstall packages makes no sense, that's not windows, rpm packages make sure that every file with it's correct permissions and owners exists