DataFrame to MySQL

save_db.py

def save_db(df, table):
    try:
        engine = create_engine("mysql+mysqldb://root:"+"password"+"@localhost/"+table, encoding='utf-8')
        conn = engine.connect()

        # Save dataframe to database
        df.to_sql(name=table, con=engine, if_exists='append')
        print("Saved successfully!!")
        
    except:
        traceback.print_exc()
        
    finally:
        conn.close()