mysql| data mysql4.1 and later versions include spatial data engines, which can access spatial data and make spatial queries through SQL statements. The MySQL spatial engine saves space data using the WKT (well-known Text)/WKB (well-known Binary)
Copying recordsLower case-insensitive functionsPassword encryption function
CREATE TABLE Employee> CREATE TABLE employee (ID int,name char (), AGI int,sex enum (' M ', ' F '), Department char (10));> INSERT into employee values (g, ' John ', ', ' m
Customer Requirements mysql-5.1.32 is a GBK versionI downloaded the binary source from the mysql.com, do not have to compile their own installation is good. Later I looked at the language of Latin1 ~Online search for a half-day, a useful article
Author:skate
Time:2013/04/11
MySQL's sql_mode reasonable setting
Sql_mode is a very easy to ignore variable, the default value is null, in this setting can allow some illegal operations, such as allowing some illegal data insertion. This value
Without warning, MySQL went on strike. After starting with the Mysql.server startup script, there is no hint that the message ends, and the mysqld process is naturally not up.
Put the mysql.server inside $bindir/mysqld_safe--datadir=
Problem status
Restart MySQL is also a failure, look at the errorlog of MySQL, you can only see the following information similar to:
Forcing close of thread 12232 User: ' Root '
With mysqladmin simple monitoring of the next MySQL situation:
The use of select for update in MySQL must be for InnoDB, and in a transaction to work.
The criteria for a select are different, with row-level or table-level locks.
Because the InnoDB preset is Row-level lock, MySQL executes Row lock (only the
Mysql
Author: Wang Mei (HeartIcy@163.com)
The loss of the password is very distressing things, especially the root password lost: (. Install yourselfPlay lost also lost, but in the event of a production server hanging trouble can be big!
Now
6. Bbsd and cq66 server-side transformation
In Bbsd, the module on the user should be better modified, as long as it will be written. The operation of the passwd file is changed to
You can manipulate the member functions of the Usermanage class of
This script can be done without human intervention to complete the L.A.M.P integration work.
This script applies to the apache2.0.5x,php4.0.x and compiled (binary version) mysql4.0.2x of the consolidated source package approach.
Note that the
1, mysql_create_db ()Format: int mysql_create_db (string database name, int link_identifier);Through the program to build 1 database databases, of course, you can also use the mysql_query () or mysql_db_query () function to create or delete dbBut we
A recent project needs to do a mysql+keepalived high available master-slave synchronization, together with course, but think of how to hang out in the main library, from the library after taking over, to the fastest speed to recover data, and let
Being a DBA requires a rigorous working attitude.
Two test DB server A, server B, default storage engine InnoDB. There is a need to synchronize all the table structures in a to B. It was done at the time: Mysqldump-no-data ...
After exporting the
1, understand the MySQL program path
MySQL Data directory:/home/mysql/data
MySQL Program directory:/USR/LOCAL/MYSQL5
2, modify the MySQL service startup program
[root@lyq314 ~]# Vim/usr/local/mysql5/share/mysql/mysql.server
MySQL permission table refers to the MySQL database under the 5 tables: User, DB, Tables_priv, Columns_priv, Procs_priv, this 5 table records all the users and their permissions information, MySQL is through these 5 tables control user access. This
Based on
/application/search/mysql/mysql-5.5.28/support-files/my-innodb-heavy-4g.cnf
Two times optimization
"Delete--if you do not use master-slave sync" annotation, remove unwanted log files
# Log-bin=mysql-bin
# binlog_format=mixed
"Modify
For MySQL information_schema table, actually just some views, is not a real table, so there is no actual file, not even a database directory. Additions and deletions should not be done in such a way that it is not possible to set up triggers.
This
130: The file format is not correct. (Not very clear of the wrong situation)
145: File cannot be opened.
1005: Failed to create table.
1006: Failed to create database.
1007: Database already exists, database creation failed.
1008: Database does
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service