Re: [Mixxx-devel] wiki down

On Thu, Dec 8, 2016 at 2:15 PM Thorsten Munsch wrote: > How big is the gzipped file of one full sql dump? > > Is diskspace really a problem here? > A backup is 1GB (forum SQL database, forum files, wiki files). We use Google Cloud "coldline" storage which is

Re: [Mixxx-devel] wiki down

How big is the gzipped file of one full sql dump? Is diskspace really a problem here? Am 08.12.2016 um 23:01 schrieb Garth Dahlstrom: > Nice spot RJ (the data was dropped off in /tmp next to that README) > > On Dec 8, 2016 4:36 PM, "Thorsten Munsch"

Re: [Mixxx-devel] wiki down

Nice spot RJ (the data was dropped off in /tmp next to that README) On Dec 8, 2016 4:36 PM, "Thorsten Munsch" wrote: > Why don't we have backups since 12/3? Was the backupjob not running? Sad.. > Frankly, I don't feel the forum data really warrants the space

Re: [Mixxx-devel] wiki down

>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

Re: [Mixxx-devel] wiki down

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

Re: [Mixxx-devel] wiki down

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

Re: [Mixxx-devel] wiki down

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:

Re: [Mixxx-devel] wiki down

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

Re: [Mixxx-devel] wiki down

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

Re: [Mixxx-devel] wiki down

/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 wrote: A symlink to mysql-5.7: $ ls -al

Re: [Mixxx-devel] wiki down

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

Re: [Mixxx-devel] wiki down

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 wrote: > The binlogs are located in /var/log/mysql if you haven't changed the > path or disabled binlogging. > > I never had to

Re: [Mixxx-devel] wiki down

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

Re: [Mixxx-devel] wiki down

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 wrote: > Restoring from a 12/3 backup now. > > On Thu, Dec 8, 2016 at 8:45 AM, Garth Dahlstrom wrote: > >> Was able to get an old copy of the db

Re: [Mixxx-devel] wiki down

Restoring from a 12/3 backup now. On Thu, Dec 8, 2016 at 8:45 AM, Garth Dahlstrom 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 wrote: > >> It's

Re: [Mixxx-devel] wiki down

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

Re: [Mixxx-devel] wiki down

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 wrote: > I get this error: > > General Error > SQL ERROR [ mysqli ] > > Access denied for

[Mixxx-devel] wiki down

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