commands to back up the MySQL database Mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sql backing up the MySQL database to a format with a delete table Backing up the MySQL database is a format with a delete table that allows
Log type:First, error log1. Record the information in the server startup and shutdown process2. Error messages during server operation3. Information generated when the event Scheduler runs an event4. Information generated when booting from the
Recently in learning Squeryl, with the MySQL database, programmers are lazy, the program can do, resolute not manual to do. There is a method in scheme that creates a table, when inserting data through a program, it is not possible to insert Chinese,
1 CREATE TABLE' m ' (2`int`int(Ten) unsigned not NULLAuto_increment,3' Name 'varchar(Ten) not NULL,4' CTime 'int(Ten) not NULL,5' Ltime 'int(Ten) not NULL,6 PRIMARY KEY(`int`),7 UNIQUE KEY' name ' (' name '),8 KEY' Idx_ctime ' (' CTime ')
3 ways to create a user:1, create user userName identifed by ' YourPassword ';2. Grant SELECT On * * to [email protected] ' host ' identified by ' YourPassword ';3. Insert into Mysql.user (Host,user,password) VALUES ('% ', ' A ', Password ('
Yesterday turned on the computer MySQL suddenly can't connect, go to the service to find, but can not find the MySQL serviceSolve:Version 5.0:Start-run->cmd, go to the MySQL installation bin directoryD:\mysql\bin>mysqld-nt.exe-installService
Database A as the main service, database B as a synchronous library (note: Both sides of the database library must be one, or there will be constant error information out, change, change, is not successful) 1, configuration master vi/etc/my.cnf
MySQL permissions-related actions: The permissions granted are divided into four groups: column permissions: Related to a specific column in the table, for example, updating the Value table permission for the Name column in the test table with the
MySQL cluster configuration 1 Host Configuration Modify the MySQL configuration file under Windows My.ini,linux for MY.CNF Under the Mysqld node, add: Server-id=1 Log-bin=log BINLOG-DO-DB=DATABASE1//databases that need to be synchronized
This is a problem with Android server-side development:Suddenly found that the string passed into the stored procedure, the argument is ' 1 ', ' 2 ', the execution is invalidSo see the Internet has in the stored procedure directly pieced together
Recently installed in Linux MySQL, according to the information collected online and personal operation process, probably did a collation, in order to conduct a reference review later.1, download mysql-5.1.36.tar.gz, and unzip.TAR-XZVF
Python connects to MySQL database (Debian)The following is a Python 2.* version of the installation method, Mysql-python temporarily does not support Python 3.* versionWhat to do in advance:
Install Setuptools, run in terminalsudo python
QT starts by default is Utf-8, and VS2013 default program is encoded as gb2312;This will find the use of Chinese language when garbled.There are generally two solutions:1. When using Chinese, use QtextcodecQtextcodec *gbk=qtextcodec::codecforname
Use Xtrabackup to back up the mysql database
Use Xtrabackup to back up databases
Xtrabackup is an open source backup tool developed by percona, which is different from ibbackup. Ibbackup is a paid backup tool. In terms of its backup performance,
Mysql_connect v/s mysql_pconnect, mysqlpconnect
Original article: mysql_connect v/s mysql_pconnect
Translation: mysql_connect v/s mysql_pconnect
Translator: dwqs
When you need to use PHP to connect to the MySQL database, you will find two database
Use a timer to call the mysql stored procedure-navicat Client1. Use a cursor to create a stored procedure
SQL creation:
create PROCEDURE daily_max_avg_online()BEGINdeclare max_online int;declare avg_online int;declare time TIMESTAMP;declare cur
Summary of common mysql commands
I. Database-level operations
1. log on to mysql
The common format is mysql-u user_name-p. Press enter and enter the password and press enter again.
2. view all existing databases
Show databases; (Note: The semicolon
In Linux, MySQL forgets the root password 1.11. First confirm that the server is in a secure state, that is, no one can connect to the MySQL database at will.Because during the resetting of the MySQL root Password, the MySQL database is completely
[Mysql] configuration file in mysqlwindows
The environment is win7 mysql5.6
Test whether the configuration file is available (no msyql configuration in windows has been used before)Query the configuration before modification:
mysql> show variables
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