mysql
zuoye1010
这个作者很懒,什么都没留下…
展开
-
mysql主从同步因字段类型不一致导致主从失败
@[TOC](Column 3 of table ‘xxxxx’ cannot be converted from type ‘int’ to type ‘varchar(32)’) Slave SQL 报错信息如下: Column 3 of table ‘xxxxx’ cannot be converted from type ‘int’ to type ‘varchar(32)’ 这个错误是指:Column 3 字段类型由主库的int类型字段写入到从库时,字段是varchar类型中,是属于类型不一致导致原创 2020-11-24 11:47:25 · 1263 阅读 · 0 评论 -
xtrabackup备份与恢复的脚本
xtrabackup备份与恢复的脚步 01 02 * * * cd /home/xtrabackup_mysql && ./bk_mysql.sh fullbackup >> log/run.log 2>&1 & #!/bin/bash echo "==============new backup=================" echo "===============arg:[$@]==================" date export原创 2020-12-08 17:11:39 · 297 阅读 · 0 评论