[CWB] Downgrading CQPweb

[Hardie, Andrew]

Jörg has covered most of it, but see also 

https://sourceforge.net/p/cwb/code/HEAD/tree/gui/cqpweb/trunk/lib/sql-definitions.inc.php#l98  

The table names will give you a good idea as to what *else* is in the DB.

best

Andrew. 

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Jörg Knappen
Sent: 12 April 2017 16:54
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] Downgrading CQPweb

Zitat von "Meier-Vieracker, Simon" <simon.meier at tu-berlin.de>:

> What exactly is in the MySQL DB?


You can see everything of the database by creating a mysql dump

mysqldump -u <username> --password=<password> cqpweb >   
/data/mysqlbackup/cqpweb.dump

This mysqldump also functions as a backup of the mysql database. You  
will probably want to do this for your
currently not working cqpweb.


> I work with corpora pre-indexed in the CWB and I could easily  
> recreate my corpora. But what about the registrated users? Will I  
> have to re-register all of them? I could do this, for  
> self-registration is switched of and I don’t have many users, yet.

Yes, you will.

> Anything else that could be lost?


A lot:

  * Any priviledges and group rights (when you use that feature)
  * Everything the users saved (catqueries, queries, macros,  
subcorpora, databases). This is probably the worst loss
  * Frequency tables
  * Metadata

--Jörg Knappen

> Best
>
> Simon
>
>
>
>> Am 12.04.2017 um 16:00 schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk>:
>>
>> There isn't any method to downgrade the database structure - so, if  
>> you go back to an earlier repo version, certain things may break.  
>> (If you do not have any significant data stored yet you could scrub  
>> then recreate the whole MySQL DB. But I guess you would not be  
>> asking the question if you did not have any significant data stored.)
>>
>> In sum: Proceed very much at your own risk...
>>
>> best
>>
>> Andrew
>>
>> -----Original Message-----
>> From: cwb-bounces at sslmit.unibo.it  
>> [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Meier-Vieracker,  
>> Simon
>> Sent: 12 April 2017 13:01
>> To: Open source development of the Corpus WorkBench
>> Subject: [CWB] Downgrading CQPweb
>>
>> Hi,
>>
>> I have installed the trunk version of CQPweb on my server. As  
>> already indicated by Andrew  
>> (http://liste.sslmit.unibo.it/pipermail/cwb/2017-February/002623.html), the  
>> distribution function (and maybe others) is broken. Is it possible  
>> to downgrade to the stable version 3.2.11 or another late but  
>> stable version? Does anyone have experience with this?
>>
>> (Unfortunately I have used  "svn export“ and not „svn co“)
>>
>> Thanks in advance
>> Simon
>> _______________________________________________
>> CWB mailing list
>> CWB at sslmit.unibo.it
>> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>> _______________________________________________
>> CWB mailing list
>> CWB at sslmit.unibo.it
>> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
> -------
>
> Dr. Simon Meier
>
> Technische Universität Berlin
> Institut für Sprache und Kommunikation
> Fachgebiet Allgemeine Linguistik
> Sekretariat H42
> Straße des 17. Juni 135, 10623 Berlin
> +49 (0) 30 314 22323
> simon.meier at tu-berlin.de
> http://www.linguistik.tu-berlin.de/menue/mitarbeiterinnen/wiss_mitarbeiterinnen/simon_meier/
>
>
>
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb



_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://liste.sslmit.unibo.it/mailman/listinfo/cwb