Nice.
Now, install and configure duplicity ;)
sb
Le 08/12/2016 à 22:43, RJ Ryan a écrit :
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
------------------------------------------------------------------------------
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
