>90 # this should never even happen, but just in case...
LMAO :D Glad you could fix this. Please don't forget to edit the backup cronjob to daily. Am 08.12.2016 um 22:43 schrieb RJ Ryan: > 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 <mailto: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> > <mailto: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>> > > <mailto: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>>> > > > > <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 <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>>> > > > > <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 <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>>> > > > > <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 <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>>>> > > > > > <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 <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>>>> > > > > > > <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 > <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>>> > > > > <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>>> > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > > 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>>> > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > > 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>>> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > > 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>> > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ 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