MySQL

The error from synchronization:mysql> Change Master to master_host= ' 192.168.10.151 ', master_user= ' repl ', master_password= ' zrer90 ', Master_log_ File= ' mysql2-bin.000004 ', master_log_pos=98;ERROR 1201 (HY000): Could not initialize master

[email protected] sbin]# more mysqlbackup.sh#If any of your tables run on InnoDB engine#directory to store backups inDst=/backup/dbback# A Regex, passed to Egrep-v, for which databases to ignoreignreg= ' ^snort$ '# The MySQL username and

Customize a MySQL startup script based on your work environment---1. Save As/usr/local/mysql/scripts/mysql_env.ini#set MySQL init variablesMysql_user=system #mysql的用户名mysql_pass= ' Password ' #mysql的登录用户密码#check input parameter or noIf [$#-ne 1];

#!/bin/sh## How to use:#./restore.sh/full path of your backup files#[email protected]Innobackupex=innobackupexinnobackupex_path=/usr/bin/$INNOBACKUPEXTmp_log= "/var/log/restore.$$.log"My_cnf=/usr/local/mysql/my.cnfBackup_dir=/backup # Your backup

PHP5.4 environment with basic processA new version of the PHP environment of a collocation process, and the previous php5.3.x is not much different,This use of the environment with the build

This article is based on the gifted network course collation, web-oriented developers, content to practical, professional DBA can bypass.If you're in a big company, you might have a dedicated DBA to do these things, and if you're an architect or a

1, the type or size of two fields does not match exactly, for example, if one is int (10), then the foreign key must also be set to int (10), not int (11) or TINYINT. You have to use the show command to see the size of the field, because some query

a long time ago in an interview, the interviewer asked this question, due to the usual paging method is not many, only from the index, sub-table, using sub-query precision positioning offset, not used in other methods. Later looked at other blogs to

A very simple and easy-to-use approach has recently been used to solve the problem of an insert throughput on the business, which is summarized here.First we make it clear that the insert throughput does not actually refer to the IPs (insert per

1: Use the show statement to find out what database currently exists on the server:mysql> SHOW DATABASES;2:2. Create a database Mysqldatamysql> CREATE DATABASE mysqldata;3: Select the database you createdmysql> use Mysqldata; (press ENTER to appear

A long time ago, I've seen an architect design a database when all fields use varchar type, then thought to be convenient for storage and migration, today I think of this thing in the design field, it is verified that the varchar type in MySQL,

From the database (MySQL) randomly get a few data is very simple, but if a table of data cardinality is very large, such as 10 million, from 10 million randomly generated 10 data, it is quite slow, if at the same time 100 people to visit the site,

Add skip-grant-tables (only add it) to the My.ini segment [mysqld]650) this.width=650; "src="/HTTP// S3.51cto.com/wyfs02/m00/2d/16/wkiom1oth72c6ewoaaa3oikzlqu262.jpg "title=" 12}mzj0$fmzo1[' W@ ' D0 ' NR.jpg ' alt= '

First, the tableStudent tableCREATE TABLE ' t_student ' (' Stunum ' int (one) not NULL auto_increment,' stuname ' varchar default NULL,' Birthday ' date default NULL,PRIMARY KEY (' Stunum ')) Engine=innodb DEFAULT Charset=utf8Student score

Query Features:Which table data do you look for?Which columns are checked?SELECT * FROM class-----to query data for all rows and columns* represents all columns, the table name does not add a where condition, then all rows are selected, so all rows

PhpMyAdmin: mysql interface management tool.In a linux system, when the system prompts "unable to load MYSQL extensions, please check the PHP configuration file", how can this problem be solved?If php-mysqlOK is not installed in the system, run the

BLOB Data Type in MYSQL BLOB is a large binary object used to store a variable amount of data. BLOB types include TinyBlob, Blob, MediumBlob, and LongBlob, The only difference between these types is that the maximum size of the stored files is

In general, updating mysql configuration my. cnf requires restarting mysql to take effect, but sometimes mysql is online and may not be allowed to be restarted. What should I do at this time?Let's look at an example:Mysql> show variables like 'Log _

In MySQL master-Slave replication, sometimes such a fault occurs: on Slave, Slave_IO_Running and Slave_ SQL _Running are both Yes, and Slave_ SQL _Running_State displays Slave has read all relay log; waiting for the slave I/O thread to update it, it

Transaction processing is widely used in various management systems. For example, in the personnel management system, many synchronous database operations require transaction processing. For example, in the personnel management system, if you delete