<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Folks,<br>
<br>
There are several versions of the CCDB in sqlite form in the web
directory<br>
<br>
<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/dist">https://halldweb.jlab.org/dist</a><br>
<div class="moz-forward-container"><br>
See the _second_ list of files in the forwarded message below. In
principle, we only need one of these, since each file contains the
current as well as all past versions of constants. Note that we
keep several backups already, albeit in a non-web-accessible
location. See the _first_ list of files in the message.<br>
<br>
I plan to delete the extraneous versions in the web directory
sometime this week. Let me know if you have objections.<br>
<br>
For more information on the sqlite form of the ccdb, see
<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database">https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database</a>
.<br>
<br>
-- Mark<br>
<br>
-------- Forwarded Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Subject:
</th>
<td>Cron <gluex@jlabl1>
/home/gluex/bin/ccdb_sqlite_create.sh</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Date: </th>
<td>Sun, 26 Apr 2015 00:00:11 -0400 (EDT)</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">From: </th>
<td>Cron Daemon <a class="moz-txt-link-rfc2396E" href="mailto:root@jlab.org"><root@jlab.org></a></td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">To: </th>
<td><a class="moz-txt-link-abbreviated" href="mailto:marki@jlab.org">marki@jlab.org</a></td>
</tr>
</tbody>
</table>
<br>
<br>
<pre>memory
size = 123464704
`/group/halld/Software/calib/ccdb_sqlite/ccdb_2015-04-26.sqlite' -> `/group/halld/www/halldweb/html/dist/ccdb.sqlite.tmp'
/group/halld/www/halldweb/html/dist /u/home/gluex
`ccdb.sqlite.tmp' -> `ccdb.sqlite'
listing showing access time:
total 2416776
-rw-r--r-- 1 gluex halld-1 60019712 Jan 16 2014 ccdb_2013-01-17.sqlite
-rw-r--r-- 1 gluex halld-1 60244992 Feb 7 2014 ccdb_2014-02-07.sqlite
-rw-r--r-- 1 gluex halld-1 65053696 Jun 25 2014 ccdb_2014-03-07.sqlite
-rw-r--r-- 1 gluex halld-1 65239040 Apr 7 2014 ccdb_2014-04-07.sqlite
-rw-r--r-- 1 gluex halld-1 67514368 May 7 2014 ccdb_2014-05-07.sqlite
-rw-r--r-- 1 gluex halld-1 72564736 Jun 7 2014 ccdb_2014-06-07.sqlite
-rw-r--r-- 1 gluex halld-1 72759296 Jul 19 2014 ccdb_2014-07-07.sqlite
-rw-r--r-- 1 gluex halld-1 75183104 Aug 7 2014 ccdb_2014-08-07.sqlite
-rw-r--r-- 1 gluex halld-1 81966080 Mar 30 10:15 ccdb_2014-09-07.sqlite
-rw-r--r-- 1 gluex halld-1 82026496 Oct 7 2014 ccdb_2014-10-07.sqlite
-rw-r--r-- 1 gluex halld-1 88827904 Nov 7 13:26 ccdb_2014-11-07.sqlite
-rw-r--r-- 1 gluex halld-1 95682560 Dec 11 17:59 ccdb_2014-12-07.sqlite
-rw-r--r-- 1 gluex halld-1 98486272 Jan 7 09:56 ccdb_2015-01-07.sqlite
-rw-r--r-- 1 gluex halld-1 102086656 Feb 7 00:00 ccdb_2015-02-07.sqlite
-rw-r--r-- 1 gluex halld-1 102086656 Apr 22 15:06 ccdb_2015-02-08.sqlite
-rw-r--r-- 1 gluex halld-1 104499200 Mar 7 00:00 ccdb_2015-03-07.sqlite
-rw-r--r-- 1 gluex halld-1 104559616 Mar 28 00:00 ccdb_2015-03-28.sqlite
-rw-r--r-- 1 gluex halld-1 108991488 Apr 15 09:31 ccdb_2015-04-07.sqlite
-rw-r--r-- 1 gluex halld-1 111870976 Apr 14 00:00 ccdb_2015-04-14.sqlite
-rw-r--r-- 1 gluex halld-1 111879168 Apr 20 07:59 ccdb_2015-04-20.sqlite
-rw-r--r-- 1 gluex halld-1 120992768 Apr 21 18:36 ccdb_2015-04-21.sqlite
-rw-r--r-- 1 gluex halld-1 120994816 Apr 22 16:21 ccdb_2015-04-22.sqlite
-rw-r--r-- 1 gluex halld-1 120994816 Apr 23 00:00 ccdb_2015-04-23.sqlite
-rw-r--r-- 1 gluex halld-1 123442176 Apr 24 17:18 ccdb_2015-04-24.sqlite
-rw-r--r-- 1 gluex halld-1 123464704 Apr 25 00:00 ccdb_2015-04-25.sqlite
-rw-r--r-- 1 gluex halld-1 123464704 Apr 26 00:00 ccdb_2015-04-26.sqlite
listing in dist directory showing modified time:
-rw-r--r-- 1 gluex halld-1 60244992 Feb 6 2014 /group/halld/www/halldweb/html/dist/ccdb_2014-02-06.sqlite
-rw-r--r-- 1 mstaib enp 72559616 May 28 2014 /group/halld/www/halldweb/html/dist/ccdb_2014-05-28.sqlite
-rw-r--r-- 1 sdobbs users-1 81966080 Sep 11 2014 /group/halld/www/halldweb/html/dist/ccdb_2014-09-11.sqlite
-rw-r--r-- 1 gluex halld-1 82022400 Sep 30 2014 /group/halld/www/halldweb/html/dist/ccdb_2014-09-30.sqlite
-rw-r--r-- 1 gluex halld-1 86545408 Oct 14 2014 /group/halld/www/halldweb/html/dist/ccdb_2014-10-14.sqlite
-rw-r--r-- 1 gluex halld-1 88827904 Nov 6 17:02 /group/halld/www/halldweb/html/dist/ccdb_2014-11-06.sqlite
-rw-r--r-- 1 gluex halld-1 88844288 Nov 14 21:34 /group/halld/www/halldweb/html/dist/ccdb_2014-11-14.sqlite
-rw-r--r-- 1 gluex halld-1 91121664 Nov 20 16:02 /group/halld/www/halldweb/html/dist/ccdb_2014-11-20.sqlite
-rw-r--r-- 1 gluex halld-1 91121664 Nov 21 19:44 /group/halld/www/halldweb/html/dist/ccdb_2014-11-21.sqlite
-rw-r--r-- 1 gluex halld-1 93400064 Nov 25 17:39 /group/halld/www/halldweb/html/dist/ccdb_2014-11-25.sqlite
-rw-r--r-- 1 gluex halld-1 95676416 Nov 28 20:39 /group/halld/www/halldweb/html/dist/ccdb_2014-11-28.sqlite
-rw-r--r-- 1 gluex halld-1 95682560 Dec 5 22:26 /group/halld/www/halldweb/html/dist/ccdb_2014-12-05.sqlite
-rw-r--r-- 1 wmcginle enp 0 Dec 11 10:24 /group/halld/www/halldweb/html/dist/ccdb_2014-12-10.sqlite
-rw-r--r-- 1 wmcginle enp 0 Dec 11 10:23 /group/halld/www/halldweb/html/dist/ccdb_2014-12-11.sqlite
-rw-r--r-- 1 gxproj1 halld-1 96005120 Dec 12 21:19 /group/halld/www/halldweb/html/dist/ccdb_2014-12-12.sqlite
-rw-r--r-- 1 gxproj1 halld-1 96152576 Dec 19 18:01 /group/halld/www/halldweb/html/dist/ccdb_2014-12-19.sqlite
-rw-r--r-- 1 gluex halld-1 123464704 Apr 26 00:00 /group/halld/www/halldweb/html/dist/ccdb.sqlite
</pre>
<br>
</div>
<br>
</body>
</html>