Home Python sending data to a MySQL DB
 I have a script running, updating certain values in a DB once a second. At the start of the script I first connect to the DB: conn = pymysql.connect(host= "server", user="user", passwd="pw", db="db", charset='utf8') x = conn.cursor()  I leave the connection open for the running time of the script (around 30min) With this code I update certain values once every second: query = "UPDATE missionFilesDelDro SET landLat = '%s', landLon='%s',landHea='%s' WHERE displayName='%s'" % (lat, lon, heading, mission) x.execute(query) conn.ping(True)  However now when my Internet connection breaks the script also crashes since It can't update the variables. My connection normally reestablishes within one minute. (the script runs on a vehicle which is moving. Internet connection is established via a GSM Modem) Is it better to re-open every time the connection to the server prior an update of the variable so I can see if the connection has been established or is there a better way?