كيفية نقل البيانات من SQLite3 إلى MySQL و العكس؟

def convert_to_sqlite3(): try: # Connect to MySQL database mysql_engine = create_engine(f'mysql+mysqlconnector://root:{hashed_password1}@localhost/color_group') query = "SELECT * FROM color_numbers" df = pd.read_sql(query, con=mysql_engine) # Connect to SQLite3 database sqlite_conn = sqlite3.connect('your_database_name.db') # Write the data into SQLite3 database df.to_sql('color_numbers', sqlite_conn, if_exists='replace', index=False) # Close the connections #mysql_engine.close() sqlite_conn.close() except Exception as e: la.configure(text=f"{e}")

def convert_sqlite_to_mysql(): try: # Connect to SQLite3 database sqlite_conn = sqlite3.connect('your_database_name.db') # Read data from SQLite3 database sqlite_df = pd.read_sql("SELECT * FROM color_numbers", con=sqlite_conn) # Close the SQLite3 connection sqlite_conn.close() mysql_engine = create_engine(f'mysql+mysqlconnector://root:{hashed_password1}@localhost/color_group?charset=utf8mb4') # Write data into MySQL database sqlite_df.to_sql('color_numbers', con=mysql_engine, if_exists='replace', index=False, chunksize=500) # Close the MySQL engine connection # mysql_engine.dispose() # Uncomment this if you want to explicitly close the connection, though it's not strictly necessary la.configure(text="Data successfully converted to MySQL.") except Exception as e: la.configure(text=f"Error: {e}") print(e)

(mysql.connector.errors.DatabaseError) 1366 (HY000): Incorrect string value: '\x89PNG\x0D\x0A...' for column 'image' at row 1 [SQL: INSERlanguage:java T INTO color_numbers (id, id_name, ingred1, ingred2, ....etc