pip install MySQL-python
import MySQLdb
db = MySQLdb.connect(
)
python
cursor = db.cursor()
query = "LOAD DATA INFILE '/path/to/file.csv' INTO TABLE table_name"
cursor.execute(query)
db.commit()
python
cursor = db.cursor()
query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
data = [("value1", "value2"), ("value3", "value4")]
cursor.executemany(query, data)
db.commit()
python
cursor = db.cursor()
query = "SELECT * FROM table_name"
cursor.execute(query)
results = cursor.fetchall()
with open('/path/to/file.csv', 'w') as file:
for row in results:
file.write(",".join(str(column) for column in row) + "
")
python
import subprocess
subprocess.call(
f'mysqldump -h localhost -u username -ppassword database_name > /path/to/backup.sql', shell=True)
