MySQL

Author: hoowa This script uses Perl to generate excel xls files. Depending on some modules, you can use it in linux to generate xls files. The command line + parameter is used. Very convenient.#! /Usr/bin/perl #====================================#

Technical warehouse Introduction:Transfer server space for the forum today ~~~ First, use phpmyadmin to export the Mysql database ~~After creating a database on the new server, import the database! However, the. SQL file of the MySQL database is

From: Feifei blog Mysql password cracking method mysql cracking tool download Windows:1. log on to the system as a system administrator.2. Stop MySQL services.3. Go to the Command window and enter the MySQL installation directory. For example, if

Menzhi007 I am very grateful for the clear explanation of the mysql comparison operation. Http://www.bkjia.com/database/201003/45294.html When the where condition is executed in mysql, 0 can be used as a wildcard to query the indexed data. Mysql>

It is said that this is a master-optimized mysql for your reference. The number of connections: max_connections = 1500 can be changed based on the server performance. # Set-variable = connect_timeout = 5 # Set-variable = wait_timeout = 5 We

No matter what version of mysql is installed, an error will be reported midway through the mysql service in the management tool. Content: unable to start mysql service on local computer error 1067: Process aborted unexpectedly. The solution is as

When MySQL is used as a site, unknown errors may occur. How can this problem be recorded? The solution is as follows:Class. method   // Create an error log Function error (){ + "); $ Time = date ("Y-m-d H: I: s "); $ Msg = "{VisitedTime: $

In Soundbreak, we play live audio and video continuously 24 hours a day, so we cannot make a convincing test of the new replication feature of MySQL. Through tests, we found that this feature can be used to maintain data synchronization with the

By default, mysqld shields the host after 10 connection errors. You can adjust the value by starting the server as follows: If the following error occurs, mysqld has received many connection requests from the host "host_name", but the host is

Whether in a small free database space or a large e-commerce website, it is necessary to reasonably design the table structure and make full use of the space. This requires us to fully understand the common MySQL Data Types in the database system.

The most basic is mysql's mysqlslowdump Easy to use:   Mysqldumpslow-s c-t 20 host-slow.log   Parameters: 1.-s, sorting, c, t, l, r, and ac, at, al, and ar are sorted by query times, time, lock time, and returned records respectively. Adding a is

Select *, if (sva = 1, "male", "female") as ssva from taname where sva <> "" 12.2. Control Flow FunctionsCASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result...] [ELSE result] end case when [condition] THEN result [WHEN

By default, MySQL supports three engines: ISAM, MyISAM, and HEAP. The other two types are InnoDB and Berkley (BDB )...... ISAM ISAM is a well-defined and time-tested data table management method. It is designed to take into account that the number

This is a class library written in VB.net to connect to MySql. You can use this class library to directly operate MySql databases. Before using this class library, you must installOdbc mysql 3.51:

1. MySQL logical backup backs up the database into a file, which facilitates viewing and editing. In MySQLk, use mysqldump to complete logical backup;1. Back up the specified database or tables in the database;Mysqldump [options] db_name [tables]2.

1. Modify the mysql Log PathVim/etc/my. cnfLog-bin = mysql-binTo:Log-bin =/$ PATH/mysql-binAfter modification, save and exit.Modify the mysql-bin.index file to modify the path to an existing log.The default value is./mysql-bin .....Change to/$

  Mysqldump Back up the entire database Mysqldump-u root-ppassword databasename> data. SQL // Enter the root password. Back up one or more tables Mysqldump-u root-p databasename table1name table2name> data. SQL // Enter the root password.

Varchar occupies 2 bytes for each English (ASCII) character, and only two bytes for one Chinese CharacterChar occupies 1 byte for English (ASCII) characters, and the type of Varchar that occupies 2 bytes for a Chinese character is not filled with

I have studied the high availability of databases and need to use Database Synchronization and backup. Below are some of my studies on MySQL HA.     According to the HA solution provided in MySQL 5.0 Reference Manual, it mainly consists of the

The first method, of course, is to increase your wait-timeout value. This parameter is in my. cnf (my. ini), my database load is slightly larger, so the value I set is 10 (The unit of this value is seconds, this means that when a database connection