[CWB] Export accounts from CQPweb

[Hardie, Andrew]

This approach will only work if EVERYTHING is being transferred, IE, all corpora and all other data, into the new installation at a point when it is completely blank. 

This is because as of 3.3.1 the database structure relies a lot more on the use of integer foreign keys for cross references than it used to, and these may not be properly restored if things are moved piecemeal. 

My suggestion to Simon would be to export/import just the user_info table. 

best

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Jörg Knappen
Sent: 08 September 2020 14:25
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Export accounts from CQPweb


Am 2020-09-08 14:19, schrieb Simon Meier-Vieracker:
> Hi,
>
> we are setting up a new CQPweb server at my new university. Is there a 
> way to export all the user accounts from my old mysql database and 
> import them to the new one? Or will I have to ask the users to 
> register again?

You can dump the whole mysql database using the mysqldump utility and import the dump into your new mysql instance on the new cqpweb server. I have successfully migrated cqpweb installations this way. The dump contains more than just the user registrations, e.g., saved query histories and saved catqueries. You want to conserve these data, too.

--Jörg Knappen

> Thanks and best regards
> Simon
>
>
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste
> .sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=02%7C01%7Ca.hardi
> e%40lancaster.ac.uk%7C38ec820ff74c4a67c84408d85403d52b%7C9c9bcd11977a4
> e9ca9a0bc734090164a%7C0%7C1%7C637351722741422359&amp;sdata=usH1Cqafn%2
> FccZVU3IUD0ddxSSsKSeZCuhljKJNmauMU%3D&amp;reserved=0
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C38ec820ff74c4a67c84408d85403d52b%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637351722741422359&amp;sdata=usH1Cqafn%2FccZVU3IUD0ddxSSsKSeZCuhljKJNmauMU%3D&amp;reserved=0