MySQL

To perform the show slave status from the server, you can view many of the synchronized parameters, and we need to pay special attention to the following parameters:The name of the primary server binary log file that is currently being read by the I/

1, download the compressed package: To download the free installation of MySQL compression package http://dev.mysql.com/downloads/mysql/According to the machine select 64 or 32 bit:2, unzip to the corresponding directory. I extracted it under

MySQL database backup and recovery methodMysql-uroot-pshow databases;1. Export the database1). MySQL command line export entire database (contains data)The export file is present in the Mysql\bin directory by defaultMysqldump-u user name-p database

MySQL version:5.5.40 MySQL Community serverWhether you are connecting from GUI software or Java through JDBC, always prompt for errors:The LastPacket sent successfully to the server was0milliseconds ago. The driver has no received any packets

text CHAR (*): A fixed-length string of up to 255 bytes, whose length must be specified at creation time VARCHAR (*): A variable-length string of up to 255 bytes, whose length must be specified at creation time Text: variable length text

In this era of data explosion, data backup is the most important consideration for each company, the database as the storage Data Warehouse, its importance is self-evident. Mainstream databases are: 1. Large Database Oracle 2. Medium SQL Server 3.

The function returns a string result with a non-null value for a connection from a group. The function is an enhanced Sybase SQL anywhere supported basic list () function.Syntax structure:Group_concat ([DISTINCT] expr [, expr ...] [ORDER by

MySQL Database recovery processA customer update data, mistakenly deleted the contents of the database, because the database did the master and slave, but did not do backup (backup is very important AH!) Fortunately, it opened the Bin-log. Then I

Original Configuration path:/var/lib/mysqlNeed to migrate to:/data/mysql1. Modify the configurationVim/etc/mysql/my.cnfDataDir =/data/=/data/mysql/error.log2. Move the original DataDir directorysudo mv/var/lib/mysql/data/mysql3. Modify sudo

mysql> ALTER TABLE name modify column field name type;For exampleThe Address Table City field in the database is varchar (30)Modification types can be used (careful modification of types may result in errors in existing data)mysql> ALTER TABLE

No installation of mysql configuration, no installation of mysql 1. Download the compressed package: Go to the official website to download the free-of-installation MySQL compressed package http://dev.mysql.com/downloads/mysql/ 64646464646464:   2.

Disk Space Trend Analysis of MySQLschema and binarylog Disk Space Trend Analysis of MySQL schema and binary log [root@skatedb55 dist]# ./mysqlsize --helpusage: Database diskspace usage v0.1 ,(C) Copyright Skate 2014[-h] [--load LOAD] --dbtype DBTYPE

What should I do if I forget the ROOT password of MySQL?1. Open Command Line in CMD, enter net stop mysql, and stop MYSQL service. 2. Enter the MySQL installation directory (for example, you put in E: \ mysql-5.6.14-winx64 \ bin) Run the

Problems with data import in different mysql versions The original mysql version is 3.4.10.1deb1, and the target mysql version is 5.0.51b-community-nt-log. The following error occurs during data import: 1. DELIMITER You have an error in your SQL

Programming MySQL-10-mysql MySQL Programming 1. Statement Terminator There are two default values:; and \ g (which can only be used in the command line) You can use the delimiter command to modify the statement Terminator, for example, delimiter $

How to enable remote connection (multiple backups) for MySQL Databases Note the following three points when enabling the MySQL remote login account: 1. Check whether the firewall on the server does not block port 3306.The default port of MySQL is 330

Install, deploy, and get started with MySQL on CentOS 6.5 ., Centosmysql Install mysql in centos 6.5 yum1. install the software: yum install-y mysql-server mysql-devel2. start the service: service mysqld start Prompt message: [root@localhost init.d]#

How to back up a MySQL database There are two methods to back up data in MySQL: 1. mysqlhotcopy This command locks the table before copying the file and synchronizes the data to the data file to avoid copying to incomplete data files. This is the

Implementation principle of MySQLInnoDB non-blocking read When studying the database introduction course, I learned that at the isolation level of repeatable reading, multiple executions of the same SELECT query in a transaction will return the

Install the MySQL-server and MySQLdb modules in ubuntu14.04 Install Ubuntu14.04 on a VM 1. Check that the IP address can be connected to the Internet. Ii. sudo apt-get install aptitude Note: aptitude features similar to apt-get. You prefer to