myraja
I agree with the previous posts. If you want more you need to give more, show your work. We don't mind sharing code, we just need to see where you are to help you take the next step.

Now, this is what I'm going to give to you. What you are attempting to do is what I do quite often.

As you notice the data you are looking for comes in triplets.

• > <Formula>
• C10H15N
• > <MolWeight>
• 149.23284
• > <ChemBankID>
• 1568

Each triplet makes one record and lucky you it's looks like a set pattern: Formula, MolWeight then ChemBankID. Recurse through your file and look for the pattern capture the data. After you capture each data set print then load. You don't need to hold on to the data unless you can batch it in(me not knowing how MySQL works) or you need to prevent duplicates, there you can use a hash.

As far as MySQL - read the docs, here's a good start if you are using perl to load it: DBI and DBD::mysql.
Cheers,
Gyro