How to backtest options strategy? How to add options data to MySQL database from csv?

[Amol-Gupta]

Hi
I have 1 min weekly options data for 4 years. How can I use that data/ push it to MySQL table? What is the schema?

How can I backtest options strategy over a long span when options will expire each week? How do I select the option with the nearest expiry?