← Back to team overview

maria-discuss team mailing list archive

Re: After Fedora 22->23 update maria db doesn't start


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.


* 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

Attachment: signature.asc
Description: OpenPGP digital signature

Follow ups