MySQL cmd Common commands

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

MySQL Security Settings graphic tutorial

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 =

Quick Setting of MySQL master-slave Synchronization

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 =

Full Export and Import implementation in MySQL

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

Mysql Error about "InnoDB Error ib_logfile0 of different size"

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

MYSQL synchronization Slave_IO_Running: No or Slave_ SQL _Running: No solution [tested]

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 .

Share data migration stored procedures in mysql

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

Differences between MySQL InnoDB and MyISAM data engines

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

How to adjust the performance of a MySQL server after it is installed by default

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

How to update data during mysql multi-table join

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

Difference between LEN () and DATALENGTH () in mySQL

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

Allows MySQL databases to run faster to lose weight for Data

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

Mysql database backup and recovery command mysqldump, source usage

Restore A Database: mysql-h localhost-u root-p123456 www Back up a database: mysqldump-h localhost-u root-p123456 www> d: \ www2008-2-26. SQL // Test in the program // $ Command = "mysqldump -- opt-h $ dbhost-u $ dbuser-p $ dbpass $ dbname | gzip> $

Php connection to mysql Connection Reset Solution

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

MYSQL error: Can't open file: '×××. myi' (errno: 145) Solution

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

Mysql Database Name and table name are case sensitive in different systems

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

MySQL replace function replacement string statement usage

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

MySQL database backup and recovery methods

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

Mysql Data insertion Optimization Method

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:

Clear php Data before warehouse receiving. Note that the int value range of php intval is different from that of mysql.

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

Total Pages: 3233 1 .... 2131 2132 2133 2134 2135 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.