maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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 <h.reindl@xxxxxxxxxxxxx
> <mailto:h.reindl@xxxxxxxxxxxxx>> 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

Attachment: signature.asc
Description: OpenPGP digital signature