MySQL

MySQL data backup, its importance is self-evident. In general, we typically use mysqldump, xtrabackup, and LVM snapshots for backup, or a dedicated MySQL replication backup server.Characteristics:Logical Backup tool is slower than physical backup,

Create a new user under 1,mysqlGrammar:1.create user username identified by ' password ';Example: Create user Xiaogang identified by ' 123456 ';The newly created user, by default, does not have any permissions.2. How to assign permissions to

MySQL failure:[Email protected]_m ~]#/etc/init.d/mysqld restartStarting MySQL ..... error! Manager of Pid-file quit without updating file.[[Email Protected]_m ~]#Possible one:The Basedir and DataDir directories in the boot profile/etc/init.d/mysqld

MySQL supports dozens of encoding methods, and the default encoding is: LATINL, if MySQL garbled situation, do not panic, to introduce you two ways to solve the encoding:In the console input command, note that the MySQL UTF-8 written in utf8, for

1. When you uninstall the old MySQL database service from your computer, first stop the MySQL service in the Windows service.2. In the control Panel to delete the add-in program, but you can not completely delete the MySQL service,3. Clear your

I. Type of indexB-tree Index:B-tree usually means that later values are stored sequentially, and each leaf page is the same distance from the root.B-tree indexed columns are stored sequentially, so it's good to look for range data.The B-tree index

Step 1: Open navicat official website, download navicat, website:http://www.navicat.com/en/download/download.html Step 2: Go to the download directory, unzip the TarballDecompression command: TAR-ZXVF navicat11_mysql_en.tar.gzSTEP3: Open the

1. View all library sizes under the DB instance, and the result is in megabytesMysql> Select Table_schema,sum (data_length)/1024/1024 as Data_length,sum (index_length)/1024/1024 as Index_length, SUM (data_length+index_length)/1024/1024 as sum from

1.2. Configure MasterModify/ETC/MY.CNF Increase[Mysqld]log-bin = Master-binlog-bin-index = Master-bin.indexserver-id = 1　　3. Master creates a replication userCREATE USER Repl_user; GRANT REPLICATION SLAVE on * * to Repl_user identified by ' 123456 ';

Set the site encoding to Utf-8, which is compatible with all characters in the world.If the site has been working for a long time, there are many old data, can not change the setting of Simplified Chinese, then it is recommended to set the page

Org.gjt.mm.mysql.Driver is the early driver name, later renamed to Com.mysql.jdbc.Driver, now generally recommended to use Com.mysql.jdbc.Driver. In the latest version of MySQL JDBC driver, in order to maintain the old version of compatibility,

①, getting the running MySQL process to use each server parameter and its valuesMariaDB [(None)]> Show Global variables\g# View server global Parameters MariaDB [(none)]> SHOW SESSION variables\gmariadb [(None)]> Show variables\g# View the server

1, do not use Mycat hosting MySQL master server , simple use the following configuration:Writetype= "0" dbtype= "MySQL" dbdriver= "native" switchtype= "1" slavethreshold= ">"selectuser () password= "123456" >2 , using Mycat managed master-slave

1. Uninstall the original mysql-libs of the systemRPM-E [Name]--nodeps2. Install MySQLRPM-IVH mysql-server--ivh mysql-client-xxxxxx3. Initialize and set the password/usr/bin/mysql_install_dbservice mysql startcat /root/-uroot-pmysql>set PASSWORD =

First, install the Sysbench1. Software version sysbench-0.4.12.72. Compiling the installation1) Compile the configuration#./configure--with-mysql-includes=/opt/mysql/include/--with-mysql-libs=/opt/mysql/lib/2) compiling#make......../bin/sh. /libtool-

0, change Password: mysqladmin-u root-p password 123456Export database: Mysqldump-u root-p yunpay>yunpay.sqlImport Database: Mysql–u root-p Yunpay 1, for MySQL add a named admin, host name arbitrary network user, which through the password ' 123 '

MySQL timestamp to date formatSELECT from_unixtime (add_time, '%y-%m-%d%h:%i:%s ') from ' Wh5_username ' where id=23;Show processShow ProcesslistConnecting to a databaseMysql-uroot-ppwd.secret-s/data/mysql/mysql_3306.sockDelete a data tableTRUNCATE

Centos6.4 under Compile and install MySQL5.6. -Overview: CentOS6.4 the version of MySQL installed through Yum is version 5.1, older, so you want to install the high-level 5 through the source code.6.14. Text: One: Uninstall the old version use the

1. Environmental statement System for CentOS 6.5 Need to install Mutt and MSMTP and can send mail Need to install Xtrabackup 2. Backup Scheme Function Module introduction650) this.width=650; "title=" MySQL backup

1. Description of the problem: In the execution CREATE TABLE Goodsandprops (goodsid varchar) NOT NULL, Propsid varchar (+) NOT NULL, Propsvalue varchar (+) NOT NULL, primary key (Goodsid, Propsid, Propsvalue)); When it happens, the three-field key