Export table from SQLite and import to MySQL.

export_table_from_sqlite_import_to_mysql.py

from sqlalchemy import create_engine
from urllib.parse import quote
import sqlite3
import pandas as pd

password = "YOURPASSWORD"
db_name = "YOURDBNAME"
table_name = "YOURTABLENAME"
connection_url = "mysql+pymysql://root:{0}@localhost:3306/{1}".format(quote(password), db_name)
engine = create_engine(connection_url)
sqlite_connection = sqlite3.connect("{}.db".format(db_name))
dataframe = pd.read_sql("""YOURSQLQUERY""", sqlite_connection)
dataframe.to_sql(table_name, con=engine, if_exists="replace")