Import mysql dump file on startup

Hello, i have a mysql dump file with statements to create tables and insert data and i need to run this script when HA starts to update some information cards. How i can configure this process? I need to create a phyton script to do it?

Other question, where i can find an example to get info about some sensors when data changed to insert on a table? Thanks