<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:Helvetica;
        panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
span.apple-converted-space
        {mso-style-name:apple-converted-space;}
span.EmailStyle19
        {mso-style-type:personal-reply;
        font-family:"Verdana",sans-serif;
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Re 1: if your file is SQL insert statements, which from the extension I guess is the case, you just run them. If it’s a tabular file,
 then “load data local infile …”<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Re 2: yes, many. Insert statements won’t overwrite. BUT they will fail in case of primary key violation. That will definitely happen
 if ANY users have signed up on your new server, because the primary key is an auto increment integer starting at 1. You really need ot do this before creating accounts on the new server. &nbsp;&nbsp;Note also, your dump file may contain drop/create table statements
 that would wipe all existing accounts &nbsp;(and import the old database structure to boot).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">So, no guarantee it will work.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">If you want to maintain old data in a new server, probably a less dangerous path would be to copy everything across (WITHOUT doing
 any pre installation; IE copying the whole database, indexes,&nbsp; web scripts, everything) then tinker with the settings till it works again, then &nbsp;upgrade the code via the normal process. Apart from anything else, that’s the only way to preserve user saved queries
 etc.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> cwb-bounces@sslmit.unibo.it &lt;cwb-bounces@sslmit.unibo.it&gt;
<b>On Behalf Of </b>Simon Meier-Vieracker<br>
<b>Sent:</b> 05 October 2020 08:04<br>
<b>To:</b> Open source development of the Corpus WorkBench &lt;cwb@sslmit.unibo.it&gt;<br>
<b>Subject:</b> Re: [CWB] Export accounts from CQPweb<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<p class="MsoNormal">Hi Andrew, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">so I succeeded in exporting the user_info table as user_info.sql from my old server.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Before importing the table to the new system, I want to make sure:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">1) How can I do this?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">2) Are there any risks? Will it just overwrite the old table? I should do a backup first, I guess?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance, Simon<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">Am 08.09.2020 um 22:02 schrieb Hardie, Andrew &lt;<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>&gt;:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">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.<span class="apple-converted-space">&nbsp;</span><br>
<br>
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.<span class="apple-converted-space">&nbsp;</span><br>
<br>
My suggestion to Simon would be to export/import just the user_info table.<span class="apple-converted-space">&nbsp;</span><br>
<br>
best<br>
<br>
Andrew.<br>
<br>
-----Original Message-----<br>
From:<span class="apple-converted-space">&nbsp;</span></span><a href="mailto:cwb-bounces@sslmit.unibo.it"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">cwb-bounces@sslmit.unibo.it</span></a><span class="apple-converted-space"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">&nbsp;</span></span><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">&lt;</span><a href="mailto:cwb-bounces@sslmit.unibo.it"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">cwb-bounces@sslmit.unibo.it</span></a><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">&gt;
 On Behalf Of Jörg Knappen<br>
Sent: 08 September 2020 14:25<br>
To: Open source development of the Corpus WorkBench &lt;</span><a href="mailto:cwb@sslmit.unibo.it"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">cwb@sslmit.unibo.it</span></a><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">&gt;<br>
Subject: Re: [CWB] Export accounts from CQPweb<br>
<br>
<br>
Am 2020-09-08 14:19, schrieb Simon Meier-Vieracker:<br style="caret-color: rgb(0, 0, 0);font-variant-caps: normal;text-align:start;-webkit-text-stroke-width: 0px;word-spacing:0px">
<br>
</span><o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">Hi,<br>
<br>
we are setting up a new CQPweb server at my new university. Is there a<span class="apple-converted-space">&nbsp;</span><br>
way to export all the user accounts from my old mysql database and<span class="apple-converted-space">&nbsp;</span><br>
import them to the new one? Or will I have to ask the users to<span class="apple-converted-space">&nbsp;</span><br>
register again?<o:p></o:p></span></p>
</blockquote>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif"><br>
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.<br>
<br>
--Jörg Knappen<br>
<br style="caret-color: rgb(0, 0, 0);font-variant-caps: normal;text-align:start;-webkit-text-stroke-width: 0px;word-spacing:0px">
<br>
</span><o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">Thanks and best regards<br>
Simon<br>
<br>
<br>
<br>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a><br>
<a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste">https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste</a><br>
.<a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fsslmit.unibo.it%2F&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cc920a3e70204480c75dd08d868fce86a%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637374782738312369&amp;sdata=c7DEj5PEd%2FUMK9K9FJRuEhE8c5HHLWs66EpW%2BvZF%2F1Y%3D&amp;reserved=0">sslmit.unibo.it</a>%2Fmailman%2Flistinfo%2Fcwb&amp;amp;data=02%7C01%7Ca.hardi<br>
e%<a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2F40lancaster.ac.uk%2F&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cc920a3e70204480c75dd08d868fce86a%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637374782738312369&amp;sdata=qV0EwVD%2BypdyBjDDpyTx0V0fIUncL0%2FMAjvZqkLI%2FoE%3D&amp;reserved=0">40lancaster.ac.uk</a>%7C38ec820ff74c4a67c84408d85403d52b%7C9c9bcd11977a4<br>
e9ca9a0bc734090164a%7C0%7C1%7C637351722741422359&amp;amp;sdata=usH1Cqafn%2<br>
FccZVU3IUD0ddxSSsKSeZCuhljKJNmauMU%3D&amp;amp;reserved=0<o:p></o:p></span></p>
</blockquote>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">_______________________________________________<br>
CWB mailing list<br>
</span><a href="mailto:CWB@sslmit.unibo.it"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">CWB@sslmit.unibo.it</span></a><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif"><br>
</span><a href="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%7Cc920a3e70204480c75dd08d868fce86a%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637374782738322320&amp;sdata=dZpoZHqYy3h4XD2x44EklWQKLZWFM4K9LjPal3gAwz0%3D&amp;reserved=0"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C38ec820ff74c4a67c84408d85403d52b%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637351722741422359&amp;amp;sdata=usH1Cqafn%2FccZVU3IUD0ddxSSsKSeZCuhljKJNmauMU%3D&amp;amp;reserved=0</span></a><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif"><br>
_______________________________________________<br>
CWB mailing list<br>
</span><a href="mailto:CWB@sslmit.unibo.it"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">CWB@sslmit.unibo.it</span></a><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif"><br>
</span><a href="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%7Cc920a3e70204480c75dd08d868fce86a%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637374782738322320&amp;sdata=dZpoZHqYy3h4XD2x44EklWQKLZWFM4K9LjPal3gAwz0%3D&amp;reserved=0"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</span></a><o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</body>
</html>