Alright, we didn't lose data after all! Forums are back online with posts
up through 12/7.
Thanks for pointing me to /var/lib/mysql-upgrade Sebastian. The "DATADIR"
symlink in there is clearly cruft left over from a mysql-5.7 package. It
confused mariadb-server's postinst script:
https://fossies.org/linux/mariadb/debian/dist/Debian/mariadb-server-10.0.postinst
The "# this should never even happen, but just in case..." section ended up
running for us. Neither Garth nor I noticed that in addition to
/tmp/mysql-symlink-restore-forbvv/README, our original /var/lib/mysql
folder was moved there as well. Whew!
On Thu, Dec 8, 2016 at 1:35 PM Thorsten Munsch <thorsten.mun...@synthor.de>
wrote:
Is this fail caused by the Ubuntu packages of MariaDB?
I installed a few MariaDB instances on a fresh Debian server and it was
set to /var/log/mysql everytime. :/
Ubuntu on a desktop = awesome
Ubuntu on a server = pain in the ass
IMHO
Why don't we have backups since 12/3? Was the backupjob not running? Sad..
We do weekly backups -- we're going to move that to daily.
Cheers with a beer
Thorsten
Am 08.12.2016 um 20:10 schrieb RJ Ryan:
> It appears mariadb writes these to /var/lib/mysql, so unfortunately
> those are gone too.
>
> On Thu, Dec 8, 2016 at 10:07 AM, Thorsten Munsch
> <thorsten.mun...@synthor.de <mailto:thorsten.mun...@synthor.de>> wrote:
>
> The binlogs are located in /var/log/mysql if you haven't changed the
> path or disabled binlogging.
>
> I never had to restore from them, but it's possible as far as I know.
>
>
http://dba.stackexchange.com/questions/29414/how-to-restore-data-from-binary-log#29423
> <
http://dba.stackexchange.com/questions/29414/how-to-restore-data-from-binary-log#29423
>
>
> Should be a good start. :)
>
>
>
> Thorsten
>
> Am 08.12.2016 um 19:05 schrieb RJ Ryan:
> > As far as we can tell, an unattended mariadb security unlinked
> > /var/lib/mysql so I don't think that's possible, let me know if you
know
> > otherwise though!
> >
> > On Thu, Dec 8, 2016 at 10:03 AM, Thorsten Munsch
> > <thorsten.mun...@synthor.de <mailto:thorsten.mun...@synthor.de>
> <mailto:thorsten.mun...@synthor.de
> <mailto:thorsten.mun...@synthor.de>>> wrote:
> >
> > No possibility to restore the missing stuff from the Binlogs?
> >
> > Am 08.12.2016 um 18:51 schrieb RJ Ryan:
> > > Ok, back up from 12/3. Unfortunately we lost forums data from
12/3 to 12/7.
> > >
> > > On Thu, Dec 8, 2016 at 9:36 AM, RJ Ryan <rr...@mixxx.org
<mailto:rr...@mixxx.org> <mailto:rr...@mixxx.org
> <mailto:rr...@mixxx.org>>
> > > <mailto:rr...@mixxx.org <mailto:rr...@mixxx.org> <mailto:
rr...@mixxx.org
> <mailto:rr...@mixxx.org>>>> wrote:
> > >
> > > Restoring from a 12/3 backup now.
> > >
> > > On Thu, Dec 8, 2016 at 8:45 AM, Garth Dahlstrom <
ga...@mixxx.org <mailto:ga...@mixxx.org> <mailto:ga...@mixxx.org
> <mailto:ga...@mixxx.org>>
> > > <mailto:ga...@mixxx.org <mailto:ga...@mixxx.org> <mailto:
ga...@mixxx.org
> <mailto:ga...@mixxx.org>>>> wrote:
> > >
> > > Was able to get an old copy of the db working on
mysql-5.7...
> > > mariadb totally f**ked itself up last night. :(
> > >
> > >
> > > On Thu, Dec 8, 2016 at 11:34 AM, Be <b...@gmx.com
<mailto:b...@gmx.com> <mailto:b...@gmx.com
> <mailto:b...@gmx.com>>
> > > <mailto:b...@gmx.com <mailto:b...@gmx.com>
> <mailto:b...@gmx.com <mailto:b...@gmx.com>>>> wrote:
> > >
> > > It's back, but it looks like some recent posts
> got lost in
> > > the process.
> > >
> > > On 12/08/2016 09:01 AM, Garth Dahlstrom wrote:
> > > > The wiki is okay, but the db for the forum got
> moved
> > > during a MariaDB
> > > > unattended security upgrade last night, I'm
> working on it
> > > now...
> > > >
> > > >
> > > > On Thu, Dec 8, 2016 at 6:03 AM, Daniel Schürmann
> > > <dasch...@mixxx.org <mailto:dasch...@mixxx.org>
> <mailto:dasch...@mixxx.org <mailto:dasch...@mixxx.org>>
> > <mailto:dasch...@mixxx.org <mailto:dasch...@mixxx.org>
> <mailto:dasch...@mixxx.org <mailto:dasch...@mixxx.org>>>
> > > > <mailto:dasch...@mixxx.org
> <mailto:dasch...@mixxx.org>
> > <mailto:dasch...@mixxx.org <mailto:dasch...@mixxx.org>>
> <mailto:dasch...@mixxx.org <mailto:dasch...@mixxx.org>
> > <mailto:dasch...@mixxx.org <mailto:dasch...@mixxx.org>>>>>
> > > wrote:
> > > >
> > > > I get this error:
> > > >
> > > >
> > > > General Error
> > > >
> > > > SQL ERROR [ mysqli ]
> > > >
> > > > Access denied for user 'phpbb'@'localhost'
> [1698]
> > > >
> > > > An sql error occurred while fetching this
> page. Please
> > > contact an
> > > > administrator if this problem persists.
> > > >
> > > >
> > > >
> > >
>
------------------------------------------------------------------------------
> > > > Developer Access Program for Intel Xeon
> Phi Processors
> > > > Access to Intel Xeon Phi processor-based
> developer
> > > platforms.
> > > > With one year of Intel Parallel Studio XE.
> > > > Training and support from Colfax.
> > > > Order your platform
> today.http://sdm.link/xeonphi
> > > >
> _______________________________________________
> > > > Get Mixxx, the #1 Free MP3 DJ Mixing
> software Today
> > > > http://mixxx.org
> > > >
> > > >
> > > > Mixxx-devel mailing list
> > > > Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>
> > > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>>
> > > > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>
> > > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>>>
> > > >
> > >
> > https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>
> > >
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>>
> > > >
> > >
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>
> > >
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>>>
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
>
------------------------------------------------------------------------------
> > > > Developer Access Program for Intel Xeon Phi
> Processors
> > > > Access to Intel Xeon Phi processor-based
developer
> > platforms.
> > > > With one year of Intel Parallel Studio XE.
> > > > Training and support from Colfax.
> > > > Order your platform today.
http://sdm.link/xeonphi
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > Get Mixxx, the #1 Free MP3 DJ Mixing software
> Today
> > > > http://mixxx.org
> > > >
> > > >
> > > > Mixxx-devel mailing list
> > > > Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>
> > > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>>
> > > >
> > https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>
> > >
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>>
> > > >
> > >
> > >
> >
>
------------------------------------------------------------------------------
> > > Developer Access Program for Intel Xeon Phi
> Processors
> > > Access to Intel Xeon Phi processor-based developer
> > platforms.
> > > With one year of Intel Parallel Studio XE.
> > > Training and support from Colfax.
> > > Order your platform today.http://sdm.link/xeonphi
> > > _______________________________________________
> > > Get Mixxx, the #1 Free MP3 DJ Mixing software
Today
> > > http://mixxx.org
> > >
> > >
> > > Mixxx-devel mailing list
> > > Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>
> > > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>>
> > >
> > https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>
> > >
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>>
> > >
> > >
> > >
> > >
> >
>
------------------------------------------------------------------------------
> > > Developer Access Program for Intel Xeon Phi Processors
> > > Access to Intel Xeon Phi processor-based developer
> platforms.
> > > With one year of Intel Parallel Studio XE.
> > > Training and support from Colfax.
> > > Order your platform today.http://sdm.link/xeonphi
> > > _______________________________________________
> > > Get Mixxx, the #1 Free MP3 DJ Mixing software Today
> > > http://mixxx.org
> > >
> > >
> > > Mixxx-devel mailing list
> > > Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>
> > > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>>
> > >
> https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>
> > >
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>>
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
------------------------------------------------------------------------------
> > > Developer Access Program for Intel Xeon Phi Processors
> > > Access to Intel Xeon Phi processor-based developer platforms.
> > > With one year of Intel Parallel Studio XE.
> > > Training and support from Colfax.
> > > Order your platform today.http://sdm.link/xeonphi
> > >
> > >
> > >
> > > _______________________________________________
> > > Get Mixxx, the #1 Free MP3 DJ Mixing software Today
> > > http://mixxx.org
> > >
> > >
> > > Mixxx-devel mailing list
> > > Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > <mailto:Mixxx-devel@lists.sourceforge.net
> <mailto:Mixxx-devel@lists.sourceforge.net>>
> > > https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
> > <https://lists.sourceforge.net/lists/listinfo/mixxx-devel
> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>>
> > >
> >
> >
>
>
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/xeonphi
_______________________________________________
Get Mixxx, the #1 Free MP3 DJ Mixing software Today
http://mixxx.org
Mixxx-devel mailing list
Mixxx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mixxx-devel