Small and medium site simple backup policy The small and Medium line Web site based on Drupal, we can use the Backup_migrate module, which provides the function of regular backups, the time of backup, how many backups to keep, and so on, Once you'
Turn on caching, set cache size, and implement the following:
1, modify the configuration file, Windows under the My.ini,linux is my.cnf;
On the last append to the configuration file:
The code is as follows
Copy Code
Many times, in order to be simple, we need to set the Time field to the current time when designing the datasheet. In MySQL, however, the default value cannot be used, that is, you cannot set a column, and the default value is now (). What about it?
Do MySQL master and slave will certainly encounter a lot of synchronization problems, most of them are due to machine downtime, restart, or the primary key conflict caused by the server to stop work, here specifically to collect similar problems and
MySQL database backup
If you store any database in MySQL, you do not want to lose, you should do weekly or even daily backups. Depending on the database you are using-whether it is storing forum information, employee information, or your expense
VPS System CentOS5.2Add a common accountThe location of the VPS quantum data http://www.111cn.net
Useradd Lrenwangpasswd Lrenwang
--------------------------------------------------------------------------------
One installation
The default results are not according to the order of Chinese pinyin, to be sorted by the pinyin of Chinese characters, the character set of the database needs to be UTF8, and then the order is forced to convert the field information into GBK, so
MySQL Query Cache Query_cache_size
Starting with MySQL 4.0.1, MySQL server has an important feature: Query Cache. When in use, the query cache stores the text of a SELECT query and the corresponding results that are delivered to the client. If you
With regard to the benefits of MySQL indexing, if the correct and reasonable design and use of the index MySQL is a Lamborghini, then there is no design and use of the index MySQL is a human tricycle. For tables with no indexes, a single table query
1. Write the main MySQL docker file
Create a new folder named Mysql-master-v1. Create a new file Dockerfile and master.cnf in the folder Mysql-master-v1. The editor that I recommend is Visual Studio Code. Use the editor to set the encoding of these
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
Docker Introduction:
Docker is an open source application container engine that allows developers to package their apps and dependencies into a portable container, and then publish it to any popular Linux machine or virtualization. Containers are
Since MySQL supports Unicode, our web programs are starting to think about using UTF8 to keep up with the times. In fact, UTF8 also used for several years, the basic program can run, no big problem, but the data switching, always encounter
This article for you to share a solution to the MySQL storage engine MyISAM common problems, for your reference, the specific content as follows
One, processing the MyISAM storage engine table damage
When using MySQL, you may experience a MyISAM
A common web site often need to query n SQL statements to get the results of the page, when the Web site access speed is slow and the front-end done a lot of optimization work, the database bottleneck of the search is also an important part of the
One, the connection databaseFormat: mysql-h host address-u user name-P user Password 1.1. Connect to MySQL on this computer. first open the DOS window, and then enter the directory Mysql\bin, and then type the command Mysql-u root-p, after the
The problem and solution of MySQL table index being corruptedAfternoon work, surprised to smell my Dedecms website problem, visit a look, really full screen error, check MySQL log, error message is:Table '. \dedecmsv4\dede_archives ' is marked as
MySQL query with quotes and no quotes difference
When the database field ID is an integral type
Select ID from table where id=1
And
Select ID from table where id= ' 1 '
Two SQL is OK, but the first SQL does not have to be implicitly converted,
This example describes a method for using a while loop statement in a MySQL stored procedure. Share to everyone for your reference. Specifically as follows:
mysql>
mysql> delimiter $$
mysql>
mysql> CREATE PROCEDURE myProc ()
-> BEGIN
->
->
Recently tried PHP7, in compiling and supporting MySQL have encountered some problems, I believe many students also encountered, so here to chat about this process. In simple terms, compiling PHP7 takes only 3 steps:
1./buildconf--force2./configure3
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