Python3调用MySQL指令对数据库进行导入导出

最新推荐文章于 2023-12-19 10:54:59 发布

一写代码就困

最新推荐文章于 2023-12-19 10:54:59 发布

阅读量307

点赞数 1

文章标签： python

本文链接：https://blog.csdn.net/qq_37207340/article/details/106243486

版权

import subprocess
import sys

sys.path.append('/usr/local/mysql-5.7.29-macos10.14-x86_64/bin')
print(sys.path)
command_exp = '/usr/local/mysql-5.7.29-macos10.14-x86_64/bin/mysqldump -h127.0.0.1 -uroot -pwyf880701 --add-drop-table --skip-lock-tables synctool tl_log> synctool_test.sql'
exit_code = subprocess.call(command_exp, shell=True)
print(exit_code)


command_imp = '/usr/local/mysql-5.7.29-macos10.14-x86_64/bin/mysql -h127.0.0.1 -uroot -pwyf880701 test < synctool_test.sql'
exit_code = subprocess.call(command_imp, shell=True)
print(exit_code)