随笔分类 -  mysql

摘要:Linux: Centos7.9 1.systemctl stop mariadb 2.转移logfile,(先转移到别的目录下备份,等后面重启mysql会自己重新生成) cd /var/lib/mysql mv ib_logfile* /mnt/backup_mysql mv aria_log*  阅读全文
posted @ 2021-09-08 19:20 希曼博客 阅读(895) 评论(0) 推荐(0)
摘要:I'm upgrading my zabbix to a clean install on a new Centos8.4 machine (MariaDB). After import old sql,restart zabbix-server ,Web page can open but can 阅读全文
posted @ 2021-09-01 16:14 希曼博客 阅读(284) 评论(0) 推荐(0)
摘要:1 问题删除有外键关联的数据或者表的时候,mysql出现报错: Cannot delete or update a parent row: a foreign key constraint fails 2 解决方法 SET foreign_key_checks = 0; // 先设置外键约束检查关闭 阅读全文
posted @ 2021-09-01 16:04 希曼博客 阅读(620) 评论(0) 推荐(0)