First modify the script for necessary configuration, and then run it as the root user.
1. The first parameter is used for remote backup.2. local Parameters for local backup3. No parameter is required for remote backup. Note: You need to add a user
VSFTPD is a secure and fast FTP server in UNIX/Linux and has been used by many large websites. VSFTPD supports saving user names and passwords in database files or database servers. VSFTPD calls this form of user as a virtual user. Compared with a
The following articles mainly describe the problems arising from the destruction of a MySQL index and their actual solutions. If you are interested in the actual operation scheme, you can browse the following articles. The following describes the
The above article describes the first three steps for optimizing SQL statements in the MySQL database. Today, we will share with you the fourth step for optimizing SQL statements in the MySQL database, the following describes the specific content of
The following articles mainly introduce the practical operation solutions that allow MySQL to support Chinese characters. MySQL to support Chinese characters is also favored to some extent as MySQL databases are generated, the following is a
The following articles mainly describe the actual operation process of installing and detaching the MySQL database, as well as the example of the SC Command Used in the command line during the running process, the following describes the specific
Today, we will share with you the differences between the actual application of InnoDB and MyISAM In the MySQL storage engine, as well as the differences in related functions and their advantages and disadvantages, if you are interested, you can
The following articles mainly introduce the actual solution to slow remote connection to MySQL, that is, using skip-name-resolve to cancel DNS reverse resolution, the following describes the specific content of the article, hoping to help you in
In the previous article, we talked about how to correctly install the MySQL database. Next we will talk about the correct use of the database. We mainly learn some common MySQL commands from the following aspects: connecting to the MySQL database,
The following German text mainly describes the actual steps for MySQL batch import and execution, as well as the actual application code for MySQL batch import and execution, the following article describes the specific operation steps and specific
The following articles mainly introduce the MySQL slow query analysis method. A few days ago, I set a record to query SQL statements that are slower than 1 second in the MySQL database. There are several very well-configured methods, and the names
This article describes how to use the MySQL encryption function to protect sensitive website data, in practice, all of us sometimes need to protect sensitive website data. Today we are going to talk about how to protect it through the MySQL
This version of MySQL continues to improve the InnoDB Storage engine, mainly including:
The InnoDB Storage engine is upgraded to version 1.1.1, which is also the latest development version.
InnoDB uses a hash table to store redo logs during
PairMySQL databaseIt is very necessary to back up and restore data. It can be implemented in many ways. This article describes how to useXtrabackupNext, let's take a look at this part of the backup process.
Xtrabackup is an open-source project of
This article starts from the execution process of a select statement and traverses multiple subsystems of MySQL.
First, let's take a picture to start our adventure.
After the client connects to the MySQL server and sends a request, the server thread
Use two functions: length and char_length.
Length: the length of a calculated field. A Chinese character is counted as three characters. A number or letter is counted as one character.
Char_length: whether it is a Chinese character, a number, or a
You can see this article on my new page.
Recently I installed the latest MySQL version on OSX and studied it. For example, Chinese garbled characters and full uninstallation problems often occur in the past, so thanks for having nothing to do today.
Author: Tie
Date: January 1, December 27, 2013
For more information, see install MariaDB using YUM in Centos.
Note: First, you must be able to connect to the Internet. If you cannot directly access it, You can also set a proxy. For details, refer to:
1. Preparations
Download mysql's latest free installation unzip mysql-noinstall-5.1.53-win32.zip, decompress to the relevant directory, such as: d: \ mysql-noinstall-5.1.53-win32. This is the root directory of mysql.
2. Configuration
There are
When creating a stored procedure
Error message:Copy codeThe Code is as follows:ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you * might * want to use the
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