MySQL

MySQL Remote table access settings This blog post is reproduced from http://blog.itpub.net/9406448/viewspace-223946Information on the----official websiteUsing the MySQL federated storage Engine, there is no local data file for the table (for example,

1. To view log log, modify the configuration file My.ini and modify it under [mysqld]:2. After the modification, restart the MySQL service to take effect;3. The Error_log,slow_log log timestamp defaults to UTC after the default installation,

In general, when MySQL migrates from Windows to Linux, there are standard tutorials on the Web:1) Enter the/mysql/bin directory on the Windows platform (assuming your database name is MyData)Execute the mysqldump command to export your database,

Reference: Https://pypi.python.org/pypi/py-mysql2pgsqlThe company has a project, originally used MySQL database, now to change to Postgres. So I searched and found a py-mysql2pgsql tool. Here are the notes:Suppose we want to import the 2 libraries

Original address: http://www.cnblogs.com/Ray-xujianguo/p/3322455.htmlMySQL configuration file-my.iniLet me introduce the MySQL my.ini configuration file:What is My.ini?My.ini is the configuration file used in the MySQL database, and modifying this

MySQL version: Mysql-5.6.24-solaris10-sparc-64bit.tarOperating system: Solaris 11g U10Operation User: Use non-root operation installation, a-way server IP address is 192.168.1.1 B IP address is 192.168.1.2 (should be changed to actual IP address)1.

1, installation Zabbix-agentYum-y Install zabbix-2.4.8-1.el6.x86_64.rpm zabbix-agent-2.4.8-1.el6.x86_64.rpmInstallation of the above two packages will be generated in the/ETC/ZABBIX/ZABBIX_AGENTD.D directory userparameter_mysql.conf This

Reprint: http://www.cnblogs.com/picaso/archive/2012/05/17/2505895.html0. User management:1. New User:>create USER name identified by ' Ssapdrow ';2. Change Password:>set PASSWORD for Name=password (' FDDDFD ');3. Rights Management>show GRANTS for

If Table A's primary key is a field in table B, the field is called the Foreign key of Table B, table A is called the primary table, and table B is called from the table. Foreign keys are used to achieve referential integrity, and different foreign

1. BackgroundMysql/innodb's locking analysis has been a difficult topic. In the course of my work, my colleagues have often consulted on this issue. At the same time, the micro-blog also often receive the MySQL lock-related private messages, let me

An introductionTopics in this sectionMulti-Table Connection queryCompound conditional Join QuerySub-queryPrepare tableCompany.employeeCompany.department#Build TableCREATE TABLE Department (ID int,name varchar (20) ; CREATE table employee (ID int

Using Php+mysql+ajax+jquery to realize the three-level linkage function of the provincial urban areaRequirement: Write a three-level linkage between provinces and cities (or months and days) to achieve the drop-down selection of the region or

There are 5 functions in MySQL that need to calculate the value of the current time: Now. Return time, format as: 2012-09-23 06:48:28 Curdate, returns the date of the time, formatted as: 2012-09-23 Curtime, return time, format such

Original address: http://blog.csdn.net/k_scott/article/details/8167018This is my second tool for monitoring MySQL database performance: Spotlight on MySQLOur server database: is on the windows2003.This tool is very fancy, the interface is very

Mysql master-slave deployment and mysql master-slave deployment1. installation environment 1. System Environment System IP Host Name Description Server_id Centos6.7 192.168.0.173 Master Database: Master 173

Mysql learning-> DML and DDL statements, mysqldmlddl statements DDL statements: database definition language, which is generally used for database operations, such as create, drop, and alter. DML statement: data operation language, curd

Detailed description of InnoDB parameters, 1. query InnoDB parameters of MySQL 5.5 and comment on the following:[Root @ localhost etc] # grep-I innodb my. cnf; T_innodb; otherwise, slaves may diverge from the master. Uncomment the following if you

Mysql-High-Performance Index policy, mysql-High-Performance IndexIndependent index: An independent index means that an index Column cannot be part of an expression or a function parameter. 　　Example 1:SELECT actor_id FROM actor WHERE actor_id + 1 = 5

The idea and method of Mysql database Incremental backup, mysql incremental MySQL database Incremental backup. Before that, modify our database configuration file/etc/my. cnf to enable the bin-log function. Next, I have referenced some methods on

A Chinese garbled solution occurs when you operate mysql Databases in CMD. Baidu .. It is said that the chcp command is used to change the cmd character encoding to 65001 (utf8 character encoding). After that, Chinese characters cannot be entered,