MySQL
小散伞
这个作者很懒,什么都没留下…
展开
-
xtrabackup 恢复全备份
安装xtrabackup2.4yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpmyum list | grep percona 列出所有版本yum install percona-xtrabackup-24 安装innobackupex --user=root --password=1...原创 2020-03-24 13:40:43 · 191 阅读 · 0 评论 -
mysqldump 备份恢复mysql
1,先完全备份mysqldump -uroot -p123456 --single-transaction --flush-logs --master-data=2 -B db_name> /home/backup/back-$(date +%F).sql操作删除添加之类恢复完全备份mysql -uroot -p123456 < back.sql (指定路径)cp /...原创 2019-08-13 10:55:19 · 101 阅读 · 0 评论 -
开启log_bin后 mysql服务启不起来
show variables like ‘log_bin’;查看为OFF开启vim /etc/my.cnf在[mysqld]下面增加log-bin=mysql-bin重启报错[root@localhost ~]# service mysqld startRedirecting to /bin/systemctl start mysqld.serviceJob for mysqld...原创 2019-08-16 10:07:09 · 862 阅读 · 0 评论 -
centos6.9安装xtrabackup2.4
yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpmyum list | grep percona 列出所有版本yum install percona-xtrabackup-24 安装2.4报错:[root@localhost home]# yum install percona-xt...原创 2019-08-21 10:19:10 · 292 阅读 · 0 评论 -
mysql报错:Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
卸载mysql5.1后安装mysql5.7安装好后服务启不起来查看日志显示:Fatal error: mysql.user table is damaged. Please run mysql_upgrade.解决办法:[root@localhost ~]# rm -fr /var/lib/mysql[root@localhost ~]# service mysqld restart...原创 2019-08-21 09:57:00 · 1195 阅读 · 0 评论 -
MySQL报错 Error: Access denied for user 'root'@'localhost' (using password: NO)
新装的MySQL运行 mysql_secure_installation报错 Error: Access denied for user ‘root’@‘localhost’ (using password: NO)编辑/etc/my.cnf[mysqld]后面任意一行添加“skip-grant-tables”重启服务mysql -uroot 登录flush privileg...原创 2019-08-15 13:51:25 · 340 阅读 · 0 评论 -
mysql配置主从服务器
最好两台机器mysql版本一致,master的版本一定不能高过slave的版本1.修改master机器相关配置修改master机器中mysql配置文件my.cnf在[mysqld]配置段添加server-id=1log-bin=mysql-binlog-slave-updates=1binlog-do-db=repl 需要同步的数据库,如果没有本行表示同步所有的数据库binlog...原创 2019-08-14 15:46:31 · 136 阅读 · 0 评论 -
show table status like 'home'\G;详解
mysql> show table status like ‘home’\G;*************************** 1. row ***************************Name: home 表名Engine: MyISAM ...原创 2019-08-07 11:35:05 · 490 阅读 · 0 评论 -
安装mySQL5.7
官网下载yum源centos6.Xrpm -Uvh https://repo.mysql.com//mysql80-community-release-el6-3.noarch.rpm[root@localhost ~]# yum repolist all | grep mysqlmysql-cluster-7.5-community MySQL Cluster 7.5 Co...原创 2019-08-08 17:59:31 · 151 阅读 · 0 评论 -
MySQL 报错
mysql: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No suc h file or directoryldconfig -v | grep mysqllocate libmysqlclient.soyum install mysql-devel ...原创 2019-07-25 13:50:14 · 128 阅读 · 0 评论