日志

分享备忘笔记簿: admin 2024-7-17 15:28; 1.邮箱已激活未填出生地 SELECT m.*, p.* FROM pre_common_member AS m JOIN pre_common_member_profile AS p ON m.uid = p.uid WHERE m.emailstatus = 1 AND p.birthcountry = ''; 1.批量删除巨量无意义机器留言 DELETE FROM pre_home_comment WHERE authorid = 191103; 1. chmod u+x=7 ...; 749 次阅读|0 个评论

分享 MySQL Synchronization Installation Notes: admin 2022-8-27 20:19; ee /usr/local/etc/mysql/my.cnf server-id=10 log-bin=mysql-bin log-slave-updates slave-skip-errors=1020,1022,1053,1060,1061,1169 slave_exec_mode=idempotent replicate-same-server-id=0 auto_increment_increment=10 auto_increment_offset=1 innodb_flush_log_at_trx_commit=2 sync_binlog=1 slave ...; 1998 次阅读|0 个评论热度 100

分享 FreeBSD13.1+Apache24+PHP74+MySQL57 Installation Notes: admin 2022-8-27 19:57; 一、制作启动U盘从FreeBSD官网（https://www.freebsd.org/）下载安装源程序: FreeBSD-13.1-RELEASE-amd64-dvd1.iso 从rufus官网（https://rufus.akeo.ie/）下载rufus.exe。用rufur制作FreeBSD安装启动盘。二、安装FreeBSD13.1 将电脑设置成U盘启动。启动后，基本自动安装，如遇选择项，全选Y； ...; 2779 次阅读|0 个评论