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-grant-tables * 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 <[email protected] <mailto:[email protected]>> 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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
