[CWB] problems with lemma query and corpus word count

[Hardie, Andrew]

You have to select the database first.

http://dev.mysql.com/doc/refman/5.7/en/use.html 

best

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Benedikt Singpiel
Sent: 17 May 2016 13:15
To: cwb at sslmit.unibo.it
Subject: [CWB] problems with lemma query and corpus word count

Hi Andrew,

I managed to type in your query suggestions in the LXterminal of the VM.
Since I'm not sure if what I have done here is all correct I copy my  
queries and the results below:




---
user at CQPwebInABox:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.6.28-0ubuntu0.15.10.1 (Ubuntu)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select count(*) from freq_corpus_pilot_word;
ERROR 1046 (3D000): No database selected
mysql> select sum(freq) from freq_corpus_pilot_word;
ERROR 1046 (3D000): No database selected
mysql> select size_types, size_tokens, size_texts from corpus_info  
where corpus = "PILOT";
ERROR 1046 (3D000): No database selected
mysql>
---



Do I have to specify the location of the database for MySQL somehow  
(Where would it be in CQPwebinabox) or is this the result you were  
asking for?

best

Benedikt








>
> Message: 1
> Date: Tue, 10 May 2016 10:47:18 +0000
> From: "Hardie, Andrew" <a.hardie at lancaster.ac.uk>
> To: Open source development of the Corpus WorkBench
> 	<cwb at sslmit.unibo.it>
> Subject: Re: [CWB] problems with lemma query and corpus word count
> Message-ID:
> 	<28078EC3FBF1B940A3EF3D0D19BE351D7FB35B5D at EX-0-MB1.lancs.local>
> Content-Type: text/plain; charset="utf-8"
>
> Withbout more info on what is going on in your database I can't tell  
> what the problem is.
>
> Try the following queries in the mysql client:
>
>   select count(*) from freq_corpus_YOURCORPUS_word;
>   select sum(freq) from freq_corpus_YOURCORPUS_word;
>
> That will tell you whether or not the frequency table in the  
> database is complete (type/token counts respectively).
>
> Then try
>
>   select size_types, size_tokens, size_texts from corpus_info where  
> corpus = "YOURCORPUS";
>
> That will tell you whether the info in the corpus log is accurate.
>
> best
>
> Andrew.


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