随笔分类 -  Mysql

mariadb-my.cnf
摘要:[client]port = 3306socket = /tmp/mysql.sockdefault-character-set=utf8 [mysqld]port = 3306socket = /tmp/mysql.sockskip-name-resolvecharacter-set-server 阅读全文

posted @ 2018-12-20 01:14 天涯飞鸿 阅读(750) 评论(0) 推荐(0)

Mysql配置文件模板
摘要:来自: http://www.fromdual.com/mysql-configuration-file-sample The MySQL and MariaDB default configuration is not very great for production use. Some of 阅读全文

posted @ 2018-08-02 18:07 天涯飞鸿 阅读(155) 评论(0) 推荐(0)

Mariadb使用xtrabackup工具备份数据脚本
摘要:#!/bin/bash#这个脚本用来备份SQL文件; sql_home="/home/mysql"sql_bak_log="$sql_home/xtrabackup.log"server_conf="/usr/local/sunlight/conf/server.conf"sql_backup_da 阅读全文

posted @ 2018-01-14 12:35 天涯飞鸿 阅读(205) 评论(0) 推荐(0)

卸载Mariadb-报错
摘要:1. rpm -qa|grep aria MariaDB-client-10.1.22-1.x86_64MariaDB-devel-10.1.22-1.x86_64MariaDB-shared-10.1.22-1.x86_64MariaDB-cracklib-password-check-10.1. 阅读全文

posted @ 2017-10-04 13:34 天涯飞鸿 阅读(1454) 评论(0) 推荐(0)

导航