I. database backup and recovery policies
A) Directly copy the object
Directly copy the/usr/share/TSMIS/MySQL/test folder to another place.
Mysqlhotcopy db_name/path/to/Some/Dir
Only suitable for MyISAM tables. In fact, it is used to copy
MySQL installation file can be downloaded directly to the http://www.mysql.com, get for win32.zip package, it is recommended to select 4.0.20d. It is not described in detail here. Download and obtain the MySQL for win32installation package,
With the soaring amount of information, information storage has become a crucial technology in this era. How to ensure that the data storage technology can adapt to the increasing speed of information and our high dependence on information has
1. Chinese garbled characters occurred when using MySQL and PHP.
(1) Any Character Set supporting multi-byte encoding, such as gb2312, GBK, and utf8, can store Chinese characters. Of course, the number of Chinese Characters in gb2312 is much
MySQL real-time synchronization-master-slave mode.
Setting method:Step 1 create a synchronization user on the master Service server and grant permissionsGrant replication slave on *. * to backup @ '%' identified by '123 ';Grant the replication
I. Introduction
I have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in windows and thought it would be
MySQL Log File
MySQL has different types of log files (each storing different types of logs), from which you can query what MySQL has done and manage MySQL, these log files are indispensable.1. The error log records the error information during
InnoDB and MyISAM are the two most commonly used table types in MySQL, each with its own advantages and disadvantages, depending on the specific application. The basic difference is that the MyISAM type does not support advanced processing such as
Use Dev-CPP to build a MySQL ++ programming environment The younger brother needs to write a letter in the past two days.ProgramIt involves a lot of data storage and processing, and you want to install a database. I used ms SQL Server 2000 for a
Using indexes in database tables can greatly improve the query speed.
Suppose we have created a testindex table:Create Table testindex (I _testid int not null, vc_name varchar (16) not null );
We randomly inserted 1000 records into it, one of
MySQL has two common engine types: MyISAM and InnoDB. Currently, only the InnoDB Engine type supports foreign key constraints. The syntax for defining foreign key constraints in InnoDB is as follows:
[Constraint [Symbol] foreign key[Index_name]
[mysqld] Port = 3306 socket =/tmp/MySQL. sock # set the MySQL installation directory basedir = F: \ hzq soft \ mysql server 51ga # Set the data storage directory of the MySQL database, which must be data or \ XXX-data datadir = f :\\
From: http://gisqimeng.blog.163.com/blog/static/71242398200861455248465/
1. Open the software and enterDatabase IP Address,User NameAndPassword
2. After successful login, the following screen will appear
3. view existing databases
From: http://www.uini.net/2010/03/mysql-create-function-problem.html
Http://blog.csdn.net/wuhuiran/archive/2007/12/14/1935220.aspx
During data sorting today, I encountered the problem that MySQL functions cannot be created. I have encountered
Four features of transactions
1. atomicity refers to the fact that the entire database transaction is an inseparable unit of work.
2. Consistency: A transaction changes a database from one State to the following consistent state. The integrity
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