Put mysql.exe in the binary directory under mysqldirectory under c: \ windows. You can run the following command:
Connection: mysql-H host address-u user name-P User Password (Note: U and root do not need to add spaces, the same is true for
CopyCode The Code is as follows: Decompress MySQL to D: \ mysql and edit my. ini.
[Mysqld]Port = 3306Basedir = "D:/MySQL /"Datadir = "D:/MySQL/data /"Tmpdir = "D:/MySQL/tmp /"Default-character-set = utf8Default-storage-engine =
Installation environment
Centos 1, 5.4
MySQL 5.1.xx is directly installed using rpm
Xtrabackup 1.2.22 directly installed with RPM
CopyCode The Code is as follows: [mysqld]
Server-id = 1
Log-bin
Innodb_flush_log_at_trx_commit = 1
Sync_binlog =
At noon yesterday, I helped the carp transfer database servers to a large group buying website. This article
ArticleIt was supposed to be summarized after the transfer was completed yesterday, but it was not written in time for some reasons. Now we
1. view the Mysqld (/var/log/mysqld. log) log and find the following error:
InnoDB: Error: log file/usr/local/mysql/data/ib_logfile0 is of different size 0
5242880 bytes
InnoDB: than specified in the. cnf file 0 104857600 bytes!
030826 1:42:15 Can't
When testing whether mysql is synchronized today, check the database and find that a MySQL Slave is not synchronized with the host. Check the Slave status:
Mysql> show slave status \ G
Slave_IO_Running: Yes
Slave_ SQL _Running: No
Last_errno.: 1062
.
Copy codeThe Code is as follows: DELIMITER $
USE 'servant _ 591up' $
Drop procedure if exists 'SP _ move_data '$
Create procedure 'SP _ move_data '()
BEGIN
DECLARE v_exit int default 0;
DECLARE v_spid BIGINT;
DECLARE v_id BIGINT;
DECLARE I INT
MyISAM tables emphasize performance, and the execution speed is faster than that of InnoDB, but transactions are not supported. InnoDB provides advanced database functions such as external keys for transactions.
MyIASM is a new version of the
My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what shoshould be tuned in MySQL Server straight after installation, assuming it was installed with default
SQL statement:
Copy codeThe Code is as follows: update item I, resource_library r, resource_review_link l set I. name = CONCAT ('review: ', r. resource_name) where I. item_id = l. instance_id
And l. level = 'item' and r. resource_id = l. resource_id
LEN (string_expression) parameter: string to be calculatedReturnsCharacter Count, Which does not contain trailing spaces.If the expression data type is varchar (max), nvarchar (max), or varbinary (max), it is bigint; otherwise, it is int.Ntext
In database optimization, it is one of the most common and effective methods to minimize the data size and minimize the space occupied by tables on the hard disk. Because of data reduction, the read/write speed of the hard disk can be improved, and
After the 64-bit Windows 7 system is installed, many things are arranged, which is always the same. Yesterday, when we started to configure php + apache, echo phpinfo () was no problem, however, when you connect to mysql, the page is reset. The
The solution to reduce such problems is to minimize the server power failure without reason. When the server is shut down, the mysql database is closed manually.
Let's take a look at this problem:
Can't open file: '×××. myi' (errno: 145). This
This means that the database and table names are case-insensitive in Windows and are case-sensitive in most types of Unix systems. A special case is Mac OS X, which is used by the default HFS + file system. However, Mac OS x also supports UFS
We often use the MySQL replace function. The following describes the usage of the MySQL replace function in detail, hoping to enlighten you in learning the MySQL replace function.
I recently studied CMS and used mysql replace function during data
A beginner often asks me how to back up the database. The following describes three methods to back up the database:(1) Back up database files
Each database and data table in MySQL correspond to the directory in the file system and the files under
In general, read/write operations in MyISAM are serial, but when querying and inserting the same table, to reduce the frequency of lock competition, according to the settings of concurrent_insert, myISAM can process queries and inserts in parallel:
Php saves data to mysql
We plan to clean up data before warehouse receiving at the dao layer, such as varchar trim and int for intval.
One day, I suddenly remembered that the value range of php intval is the same as that of mysql's int type?
I
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