Brief introduction
1 • Concept of full and incremental backups2 • Full backup with mysqldump3 · Using Mysqldump for table structure backup4 • Two methods of full backup recovery5 • Incremental backup with flush logs6 • Incremental Backup
Set Change root passwordThe default is no password after installing MySQL (mysql5.7 will randomly generate a root password), you need to manually create a password for the root administrator of MySQLWhen I first use MySQL, there is no MySQL command,
Background NotesThe company's entire e-commerce system is built on the Huawei Cloud, according to Mister Estimates, the online 3 months after the daily order volume will reach millions, conservative estimate 3 months after the total number of orders
Just finished processing "mining" event, in the last MySQL Nbu backup, found that there is a problem from the library, curious is how the master-slave state abnormal no alarm? Regardless of so many, deal with this problem and then improve the alarm
Using MySQL will of course have access to the MySQL storage engine, which you will see when creating a new database and creating a new data table.MySQL default storage engine is MyISAM, other commonly used is innodb.What kind of storage engine is
To support the command load data local infile, add the following settings in/etc/MySQL/My. CNF:
[Mysqld] # server configuration local-Infle = 1 [MySQL] # client configuration local-infile = 1Otherwise, the MySQL service will prompt an error:
Error
Reprinted from cnblogs Changchun Zhou Feng http://www.cnblogs.com/cczhoufeng/archive/2012/12/13/2807648.html
Install centos6.3 + mysql-5.5.28 database on vmware9.0 (currently MySQL stable version is 5.2.29)
OriginalArticle, Please respect the
A sample SQL statement for exporting CSV data in MySQL is as follows:SQL code
Select * From test_info
Into OUTFILE '/tmp/test.csv'
Fields terminated by ', 'optionally enclosed by' "'escaped '"'
Lines terminated by '\ r \ n ';
Select * From
Connect to MySQL using VC
1. Install MySQL
You can consider installing the mysql-5.0.41-win32 (can go to http://www.newhua.com/soft/3573.htm download), of course, you have a better version, pay attention to the choice of "fully installed" (only in
Author: skateTime: 2012/02/18
Simple Introduction: Left connection, right connection, and equivalent connection of MySQL
Three connection syntaxes
To make it easier for more technical staff to quickly understand and understand, we only discuss
Author: skateTime: 2013/03/01
MySQL deletes 7g large tables online without performance impact
How to delete a 7G (or larger) large table in the MySQL database so that it does not affect the I/O of the server, resulting in performance degradation
My MySQL is installed in c: \ mysql
I. Change the password
Method 1:
1. the root account has no password before the change.
C: \ mysql \ bin> mysqladmin-u Root Password "your password"
2. Change the password of the root user if it is 123456.
C: \
1. KeywordsAuto_increment
2. Auto-IncrementUsageExample:
Create Table animals (ID mediumint not null auto_increment,
Name char (30) not null,
Primary Key (ID ));
3.About Auto-Increment
Q: How to obtain the current maximum auto-increment value? A:
Author: Angel
Nature of the article: original
Release date:
Statement: This article has already been published in "x". For more information, see.
Preface
I remember some articles about how to use MySQL to get shell. What I said is to get a root
Steps:1. MySQL Command Line Mode settings:Desktop> my computer> Properties> environment variables> New> Path = "; Path/MySQL/bin;" path indicates the installation path of MySQL.2. How to access MySQL through the command line:1. c: \> mysql-H
Today, VPS access is slow. I restarted lnmp with the/root/lnmp restart command. After the restart, I found that MySQL cannot be connected. Running Service MySQL restrat in SSH causes the MySQL is running but PID file cocould not be found error.
The "
View mysql Character Set and modify table structure
(09:00:36)
The root cause of MySQL garbled characters is that the MySQL character set is improperly set. This article summarizes the commands for viewing the MySQL character set. Including viewing
I read the EXCEL Data and the implementation code of this function has already appeared multiple times on the network. I posted this code because of a problem:Export Excel Data
Code highlighting produced by Actipro CodeHighlighter
I tried it today. In DNN mode, some modules use mysql to store data, while the primary DNN still runs under SQL Server.
The procedure is as follows:
1. Add a connection in web. config:
Name = "SiteMySqlServer"ConnectionString = "Server = 192.168.69.1
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