Are you sure it's really the "old" one ? not just THE ONE ?

sb

Le 08/12/2016 à 22:12, RJ Ryan a écrit :
/var/lib/mysql-5.7 is the old database from when we were using mysql (before the MariaDB upgrade) on Nov 10th. That's what Garth reverted us to before I restored Dec 3rd from backup.

On Thu, Dec 8, 2016 at 1:10 PM RJ Ryan <rr...@mixxx.org <mailto:rr...@mixxx.org>> wrote:

    A symlink to mysql-5.7:

    $ ls -al /var/lib/mysql-upgrade
    drwxr-xr-x  2 root root 4096 Nov 10 23:21 .
    drwxr-xr-x 50 root root 4096 Dec  8 11:34 ..
    lrwxrwxrwx  1 root root   10 Nov 10 23:21 DATADIR.link -> mysql-5.7/

    On Thu, Dec 8, 2016 at 12:56 PM Sébastien Blaisot
    <mi...@blaisot.org <mailto:mi...@blaisot.org>> wrote:


        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

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




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

Reply via email to