MySQL

How many types of MySQL backups are available, please describe briefly:Database logical backup \ Physical BackupPhysical backup is divided into Lengbei and hot standby A. Direct copying of data files to a safe place for preservationB. Use of

I. Basic CONCEPTSThe mysql5.1 version begins to introduce the event concept. Event is both a "time trigger", unlike triggers event triggers, the event is similar to the Linux crontab scheduled task for TIME triggers. Triggers the associated SQL

MyISAM is the default storage engine for MySQL. MyISAM does not support transactions or foreign keys, but it is fast to access and does not require transactional integrity. The InnoDB storage engine provides transaction security with commit,

Test table level; Copy Code code as follows: CREATE TABLE Test.level (name varchar (20)); Insert some data again; Code Class Copy Code code as follows: drop procedure if exists usecursor// Create a

InnoDB This engine is very different from the MyISAM engine. In particular, its data storage format and so on. For a INNODB data structure, you first need to address two conceptual issues: shared table space and exclusive tablespace. What is shared

Backup Data method:One: SQL statements.LOCKS TABLES tablename read;//read lockLock tables are not transaction-safe until you attempt to lock the table, implicitly committing all active transactions, and implicitly starting a transaction (for example,

MySQL Common paging stored procedure Process Parameters Copy Code code as follows: P_cloumns varchar, p_tables varchar (MB), P_where varchar (4000), P_order varchar (MB), P_pageindex int,p_pagesize Int,out p_recordcount int,out

Recently replaced the server, to do the database migration, the data in the database from server A to Server B. Because of the large amount of data, it takes too long to make the dump directly, so it is handled as follows:First of all, on Server B

All along, I have been looking for a more humane way to access the database (not to say the default way is bad, but sometimes it is not convenient in the modular design).Later fortunately in PHP to find CodeIgniter Activereord, detailed reference to

One, the MySQL builds the table, the field needs to set is not empty, needs to set the field default value.Second, the MySQL table, the field to NULL, you need to set the default value of the field, the default value is not NULL.Third, the MySQL

With the popularization of network, more and more web-based applications are used. The network database is one of them. Through one or several servers can provide services for many customers, this way to bring people a lot of convenience, but also

Some time ago purchased the Aliyun host. Because you need to use the Java environment instead of Php+apache this one-button installation of things, so did not download the Aliyun official online said Sh.zip. Besides, there is no gzip in this

1, phpMyAdminphpMyAdmin is the most common MySQL maintenance tool, is a PHP development based on the web-style architecture on the Web site MySQL management tools, support Chinese, management database is very convenient. The disadvantage is that it

When using MySQL, there are times when you need to query for records that are not duplicated in a field, although MySQL provides a distinct keyword to filter out excess duplicates, but it often only uses it to return the number of records that are

Recently started to do a lab management system, because a few tables for storage · So to maintain the relationship between tables · Studied the foreign key of MySQL. (1) Only innodb types of tables can use foreign keys, mysql default is MyISAM,

MySQL 5.5.13 Parameter description: [Client] Character-set-server = UTF8 Port = 3306 Socket =/data/mysql/3306/mysql.sock [Mysqld] Character-set-server = UTF8 user = MySQL Port = 3306 Socket =/data/mysql/3306/mysql.sock Basedir =/usr/local/

Why does the title have this name? Commen sence refers to things that everyone should know about, but often people will skip these things, or have a smattering of these things, today I summarize some of the commen sense types of problems I have

Importing SQL today always prompts for errors Copy Code code as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect ... ERROR 2002 (

MySQL Delete limit benefits: The MySQL unique limit row_count option for delete tells the server the maximum value of the row that was deleted before the control command was returned to the client. This option is used to ensure that a DELETE

I used the centos6,mysql let me complete a variety of problems, I would like to reload a new Mysql,yum remove mysql-server mysql install and can not get a clean MySQL, the original/etc/ My.cnf still unchanged, datadir inside the data has no change,