[Jax.PM] ~9M lines of data

[William C (Bill) Jones]

On 10/14/02 2:45 PM, "Aaron Johnson" wrote:

> I am very curious as to the reason you would want to do this.  You don't
> seem to be excluding any specific information in the rewrite, if you
> just want the create statements you can do a mysqldump -d
> 
> I suppose if you just have the dump and are doing to be creating them
> then this might be a useful process.
> 
> Aaron Johnson

-Sx- wrote:
>> open (RFILE, "<Daily_bb551_20021410000103286.dump") or

You are right - if I wanted to dump the DB and then import it.  That was not
my goal.  The Dump is an actual MySQL dump, but the application environment
that created it is a Blackboard system http://www.blackboard.com/.

By license I am not authorized to screw with the application to "try to
repair things."

So, I have dumped the data itself - which FCCJ owns - and am writing a set
of Perl programs that treat this "dump file" as the database.

My goals are -

1) Write an interface to this file;
2) Cross reference the keys;
3) Rewrite the data in a non-MySQL format.
4) Maybe make this a bridge to other On-Line systems (WebCT, et al.)

If Bb would get off their ass they could have fixed many of the problems
this "resolution discovery" application I am writing would resolve.

It's the lesser of two evils approach to application design.

Maybe. Hopefully.

-Bill-  :]
---Sx------------------------------------------------------
Three virtues of programming: laziness,  impatience, hubris
Three virtues of community  : diligence, patience, humility
                              -- Larry Wall, Author of perl