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
