pip install mysql-python
python
import MySQLdb
def backup_data(database, host, user, password, output_path):
try:
db = MySQLdb.connect(host=host, user=user, passwd=password, db=database)
cursor = db.cursor()
cursor.execute("SHOW TABLES")
tables = cursor.fetchall()
for table in tables:
table_name = table[0]
cmd = f"mysqldump -h {host} -u {user} -p{password} {database} {table_name} > {output_path}/{table_name}.sql"
os.system(cmd)
db.close()
except Exception as e:
python
import os
def restore_data(database, host, user, password, backup_path):
try:
db = MySQLdb.connect(host=host, user=user, passwd=password, db=database)
files = os.listdir(backup_path)
for file_name in files:
if file_name.endswith('.sql'):
file_path = os.path.join(backup_path, file_name)
cmd = f"mysql -h {host} -u {user} -p{password} {database} < {file_path}"
os.system(cmd)
db.close()
except Exception as e:
