2022-08-23发表2023-12-26更新notes几秒读完 (大约24个字)

Note for python

mysqldb.constants.field_type’ has no attribute ‘json’

install/upgrade mysqlclient
refer: https://docs.djangoproject.com/en/3.2/ref/databases/#mysql-db-api-drivers

2022-07-31发表2023-12-26更新notes13 分钟读完 (大约2000个字)

Note for mysql

单个多库备份 sql 文件中分离单个库

1
2
3

sed -n '/^-- Current Database: bk_nodeman/,/^-- Current Database: `/p' fulldump.sql

nohup gunzip -c < mysql-backup.sql | mysql -h0.0.0.1 -uroot -ppassword --default-character-set=utf8 2>err.log &