[CWB] Export accounts from CQPweb

[Simon Meier-Vieracker]

Hi Andrew,

so I succeeded in exporting the user_info table as user_info.sql from my old server.

Before importing the table to the new system, I want to make sure:

1) How can I do this?

2) Are there any risks? Will it just overwrite the old table? I should do a backup first, I guess?

Thanks in advance, Simon


> Am 08.09.2020 um 22:02 schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk>:
> 
> 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 <mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it <mailto: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 <mailto: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 <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste>
>> .sslmit.unibo.it <http://sslmit.unibo.it/>%2Fmailman%2Flistinfo%2Fcwb&amp;data=02%7C01%7Ca.hardi
>> e%40lancaster.ac.uk <http://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 <mailto: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 <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>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it <mailto:CWB at sslmit.unibo.it>
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb <http://liste.sslmit.unibo.it/mailman/listinfo/cwb>
-------------- n�chster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20201005/04907cee/attachment-0001.html>
-------------- n�chster Teil --------------
Ein Dateianhang mit Bin�rdaten wurde abgetrennt...
Dateiname   : smime.p7s
Dateityp    : application/pkcs7-signature
Dateigr��e  : 5616 bytes
Beschreibung: nicht verf�gbar
URL         : <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20201005/04907cee/attachment-0001.p7s>