[ts-gen] historical data format

[Mike Thornton]

Hi Bill,

OK, no problem.

Regarding the database query.  Apparently my testing database had become
corrupt -- I am not sure whether this was a result of my tinkering with the
database or from the scripts.  I suspect that the corruption was not a
result of the scripts.  After your email, I started mysql manually, and
mysql detected that the "testing" database was corrupt.  I am not sure why
mysql did not detect this earlier since I had started mysql manually a few
times, albeit with a different user name and not "shim".  Mysql said
something about needing to repair the database, which it did behind the
scenes.  I did not need to run any of the scripts again.  Then, when I
started the shim, it just started working.

Before I had run the latest sql scripts for the first time (I had an older
version of the shim database setup from over 1 year ago), I manually deleted
the trading database.  The testing database would not "drop" for some reason
-- I cannot remember the error message.  However, the setup.sql script had
run OK, and the testing database looked fine upon running queries so I had
initially assumed it was OK.

So to answer your question, I am not sure what I did to fix it.  Somehow
mysql detected the database corruption.  Perhaps I should rerun the
"setup.sql" script, but I have not done this since the shim says it connects
OK.

Thanks.
Mike

On Tue, Mar 23, 2010 at 10:21 AM, Bill Pippin <pippin at owlriver.net> wrote:

> Mike,
>
> Before I respond to your new question about history data, would
> you please be so kind as to let us know what the result was with
> respect to your previous query?
>
> In particular, I'm interested in whether you corrected the database
> permissions by using the setup.sql script, or whether you avoided
> the problem by manually entering the account code, offline, and in
> either case, what happended when you next started the shim.
>
> Your answer may also be of later interest to readers browsing our
> list archives.
>
> Thanks,
>
> Bill
>
> _______________________________________________
> ts-general mailing list
> ts-general at trading-shim.org
> http://www.trading-shim.org/mailman/listinfo/ts-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.trading-shim.org/pipermail/ts-general/attachments/20100323/cb54c67f/attachment.html