طريقة إنشاء نسخة إحتياطية من قاعدة بيانات MySQL و استرجاع النسخة الإحتياطية في بايثون؟

1136 (21S01): Column count doesn't match value count at row 1

def restore_database(self): # Encryption key key = b'wWU9Yh3Q7JN5XXpbK43YuMYQtA9yUI3wdDzmADMUOzk=wq' # Initialize the Fernet cipher with the key cipher = Fernet(key) try: conn = mysql.connector.connect( host="localhost", user="root", password=self.hashed_password1, database="color_group" ) c = conn.cursor() c.execute("CREATE DATABASE IF NOT EXISTS color_group") c.execute("USE color_group") # Define the table structure without the image column table_structure = """CREATE TABLE IF NOT EXISTS color_numbers ( id INTEGER PRIMARY KEY AUTO_INCREMENT, id_name varchar(255), ingred1 varchar(255), ingred2 varchar(255), ingred3 varchar(255), ingred4 varchar(255), ingred5 varchar(255), ingred6 varchar(255), ingred7 varchar(255), ingred8 varchar(255), ingred9 varchar(255), info1 varchar(255), info2 varchar(255), info3 varchar(255), info4 varchar(255), info5 varchar(255), info6 varchar(255), info7 varchar(255), info8 varchar(255), info9 varchar(255), quantity_no1 float, quantity_no2 float, quantity_no3 float, quantity_no4 float, quantity_no5 float, quantity_no6 float, quantity_no7 float, quantity_no8 float, quantity_no9 float, puplic_name varchar(255), client1 varchar(255), client2 varchar(255), client3 varchar(255), client4 varchar(255), client5 varchar(255), client6 varchar(255), image LONGBLOB, word VARCHAR(255), tof TINYINT, colorid VARCHAR(255) )""" backup_file_path = filedialog.askopenfilename() # Prompt user to select a database file if backup_file_path: c.execute("DROP TABLE IF EXISTS color_numbers") c.execute(table_structure) with open(backup_file_path, "rb") as backup_file: encrypted_data = backup_file.read() # Decrypt the data decrypted_data = cipher.decrypt(encrypted_data).decode('"ISO-8859-1"') # Remove the image column from the SQL commands sql_commands = re.sub(r'`image` LONGBLOB,?', '', decrypted_data) sql_commands = sql_commands.split(';') for command in sql_commands: if command.strip() and "INSERT INTO color_numbers" in command: c.execute(command) c.execute("ALTER USER 'root'@'localhost' IDENTIFIED BY %s", (self.hashed_password1,)) c.execute("update color_numbers set tof = 0") else: self.create_database() return conn.commit() c.close() conn.close() msg.showinfo("قاعدة البيانات", " تم استعادة قاعدة البيانات بنجاح. سيتم الخروج الان") self.on_closing() except Exception as e: msg.showerror("خطأ", f"{e}") print(e)

def create_copy_of_database(self): try: conn = self.connect_to_database() cursor = conn.cursor() # Prompt the user to select a backup location backup_folder = filedialog.askdirectory() if backup_folder: # Ensure a folder was selected # Generate backup file name with timestamp backup_file_name = f"Database_Backup_{datetime.now().strftime('%Y-%m-%d_%H-%S')}.sql" backup_location = os.path.join(backup_folder, backup_file_name) # Creating backup file with open(backup_location, "w") as backup_file: # rest of the function remains the same cursor.execute("SHOW TABLES") tables = cursor.fetchall() for table in tables: table_name = table[0] cursor.execute(f"SELECT * FROM {table_name}") rows = cursor.fetchall() backup_file.write(f"\n-- Table structure for table {table_name}\n") cursor.execute(f"SHOW CREATE TABLE {table_name}") create_table = cursor.fetchone()[1] backup_file.write(f"{create_table};\n") backup_file.write(f"\n-- Data for table {table_name}\n") for row in rows: values = [] for value in row: if isinstance(value, str): values.append(f"'{value}'") elif isinstance(value, bytes): values.append(f"x'{value.hex()}'") elif value is None: values.append("NULL") elif isinstance(value, float): values.append(repr(value)) else: values.append(str(value)) insert_query = f"INSERT INTO {table_name} VALUES ({', '.join(values)});\n" backup_file.write(insert_query) # Perform encryption encryption_key = b'wWU9Yh3Q7JN5XXpbK43YuMYQtA9yUI3wdDzmADMUOzk=wq' # Encryption key with open(backup_location, 'rb') as f: data = f.read() fernet = Fernet(encryption_key) encrypted_data = fernet.encrypt(data) encrypted_backup_file_name = f"Encrypted_Database_Backup_{datetime.now().strftime('%Y-%m-%d_%H-%S')}.enc" encrypted_backup_location = os.path.join(backup_folder, encrypted_backup_file_name) with open(encrypted_backup_location, 'wb') as f: f.write(encrypted_data) os.unlink(backup_location) # Permanently delete the unencrypted .sql file cursor.close() conn.close() msg.showinfo("Success", "تمت العملية بنجاح.") os.startfile(backup_folder) else: self.general_manager() return except Exception as e: msg.showerror("خطأ في إجراء العملية", f"{e}")