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 <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
------------------------------------------------------------------------------
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