/var/lib/mysql-5.7 is the old database from when we were using mysql
(before the MariaDB upgrade) on Nov 10th. That's what Garth reverted us to
before I restored Dec 3rd from backup.
On Thu, Dec 8, 2016 at 1:10 PM RJ Ryan <rr...@mixxx.org> wrote:
A symlink to mysql-5.7:
$ ls -al /var/lib/mysql-upgrade
drwxr-xr-x 2 root root 4096 Nov 10 23:21 .
drwxr-xr-x 50 root root 4096 Dec 8 11:34 ..
lrwxrwxrwx 1 root root 10 Nov 10 23:21 DATADIR.link -> mysql-5.7/
On Thu, Dec 8, 2016 at 12:56 PM Sébastien Blaisot <mi...@blaisot.org> wrote:
Is there something in /var/lib/mysql-upgrade ?
sb
Le 08/12/2016 à 20:10, RJ Ryan a écrit :
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
> 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
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>> 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>>> 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>>> 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>>> 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>>>>
> > 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>>>
> > >
> >
> 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
> <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
> <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
> <mailto:Mixxx-devel@lists.sourceforge.net>
> > 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 Todayhttp://mixxx.org
Mixxx-devel mailing
listMixxx-devel@lists.sourceforge.nethttps://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
------------------------------------------------------------------------------
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
