MySQL

The example of this article describes the PHP implementation of MySQL database backup and restore classes. Share to everyone for your reference. The specific analysis is as follows: This is a very simple use of PHP to back up the MySQL database of

Backup strategy One: Copy database files directly (not recommended)Backup strategy Two: Use Mysqlhotcopy backup Database (full backup, suitable for small database backup)Backup strategy Three: Use mysqldump Backup Database (full + incremental backup,

Solution MySQL does not allow remote access to the method Workaround:1. Change Table method. Your account may not be allowed to log in remotely, only in localhost. This time as long as the computer in localhost, login mysql, change the "MySQL"

MySQL Full-text Search Fulltext match At 3.23.23, MySQL began to support Full-text indexing and searching. Full-text indexing is an fulltext type index in MySQL. The fulltext index is used for MyISAM tables, which can be created on a CHAR, VARCHAR,

1. Environment configuration Download Address:http://www.mysql.com/downloads/mysql/ really trouble, download words also need to register and login and fill in a table. The information above is quite full, the information is also acceptable to fill

1. Date Time function Time Conversion second function: Time_to_sec Mysql> Select Time_to_sec (' 01:01:01 ');+-------------------------+| Time_to_sec (' 01:01:01 ') |+-------------------------+| 3661 |+-------------------------+1 row in Set (0.00

Description Operating system: Windows Server 2003 MySQL version: 5.5.25 MySQL Program installation directory: D:\Program files\mysql\mysql Server 5.5\ MySQL Database directory: C:\Documents and Settings\All Users\Application Data\mysql\mysql

Brief introduction:Mysqlbinlog Flashback function is a very strong work of Taobao Peng Lixun (http://www.penglixun.com/).Main function: The Binlog in the rows format can be operated in reverse. Delete reverse generates INSERT, Update generates

Log file type MySQL has several different log files that can help you find out what's going on inside Mysqld: Log files Type of information entered in a file Error log Log a problem that occurs when you start, run,

Large amount of data backup and restore, is always a difficult point. When MySQL is super 10G, it is slower to export with mysqldump. Recommend Xtrabackup here, this tool is much faster than mysqldump. First, Xtrabackup Introduction 1. What is

In the development or test environment in the face of MySQL-related failures, most friends may be through the forum post, QQ group discussion way to get help. This approach is one of the effective ways to get help. However, in the production

In MySQL, databases and tables are actually directories and texts in the data directory. Thus, the sensitivity of the operating system determines the case sensitivity of database and table naming. This means that the database and table names are

21 minute MySQL Getting Started tutorial Directory Introduction to the relevant concepts of MySQL Second, the configuration of MySQL under Windows Configuration steps Start, stop, and uninstall of MySQL services

Recently help students to do a website, students buy a Aliyun server, Linux distribution is Ubuntu12.04. I wrote the program locally, and I've debugged it all. Then he let me publish and deploy myself. Previously in the University of the operating

Cacti is a set of graphical analysis tools for network traffic monitoring based on PHP, MySQL, SNMP, and RRDtool. It is monitored by graphical analysis tools. It is monitored by graphical analysis tools. It uses SNMP to get data, use it to get data,

The purpose of this article is simply to tell friends how to compile MySQL code, and perhaps some people think that the code compiled from the Windows platform MySQL is somewhat complicated, but it is not. If you have any questions about the

Implementation PrincipleThe concept of flashback first appeared in the Oracle database, which was used to quickly restore the user's misoperation.Flashback for MySQL is used to recover erroneous operations caused by DML statements and currently does

The following is from the MySQL manual:13.5.5.3. Kill syntaxKILL [CONNECTION | QUERY] thread_idEach connection to the mysqld is run in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a

Add user insert into Mysql.user (Host,user,password) VALUES ("localhost", "Test", Password ("1234"));Report the following error 1364 (HY000): Field ' ssl_cipher ' doesn ' t has a default value errormysql5.1 The above version, I was operating on

MySQL High-availability PXC (Percona XtraDB Cluster)ReferenceHttp://www.cnblogs.com/xiaoboluo768/p/5135619.htmlThe server environment information is as follows:Node1 192.168.0.100Node2 192.168.0.101Node3 192.168.0.1021. Install the Software