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