I'll show you how to quickly build a running environment under UNIX (LINUX, Mac configuration method, which is the same):1. Install Pythonwget http://www.python.org/ftp/python/2.7.5/Python-2.7.5.tgz tar xvfz python-2.7.5.tgzcd Python-2.7.5.
1. Update and see if the current CentOS version is 5.6Yum UpdateLsb_release-a2. Download the fileDownload bison-2.4.3.tar.gz to/usr/local/srcDownload cmake-2.8.4.tar.gz to/usr/local/srcDownload mysql-5.5.11.tar.gz to/usr/local/src3. Update the
1. Download MySQL (64-bit version of DMG format )Http://dev.mysql.com/downloads/mysql/5.5.html2. Install MySQLRun DMG and you will find 4 files inside. First click Install Mysql-5.5.27-osx10.6-x86_64.pkg, this is the main MySQL installation package.
Change the structure of the data table:ALTER TABLE Tb_name Action,[action,action] (before using ALTER TABLE, you need to see the current definition of the data table and need to execute the show CREATE TABLE statement)ALTER TABLE Tb_name modify
I used the Mac system, originally wanted to install a Mac system, but found that the MAC system is always unable to log in with password to the native server, very strange problem (in the Stackflow to see some replies, and did not find the reason),
In the actual enterprise application environment, the single MySQL database is insufficient to meet the future business requirements. For example, if a server fails and there is no backup server to provide the service, the business will have to stop.
1. CD/switch to the root directory.2. cd/root switch to the root directory under roots.3. cd. Switch to the parent directory of the current directory.4. RPM--QA MySQL query has been installed MySQL.5. Setup to view the files that have been installed.
1. MySQL 5.1 Reference Manual2. Basic Tutorials3, commonly used examples into the following:1 Connect to the database:MySQL-H Host Address-u user name-P user password2 Prompt for database:MySQL> 3 Exit Database:Exit(carriage return)4Display database:
ZRM is an acronym for Zmanda Recovery Manager, an open source software for backing up MySQL.It is http://dl.fedoraproject.org/pub/epel/6/x86_64/repoview/MySQL-zrm.htmlFirst, installation#yum install-y MYSQL-ZRMSecond, create an alternate
Click Start to open cmd, enter CD pointIn the new line, enter D:\Program files\mysql\mysql Server 5.7\bin (the folder where Mysql.exe is located), click EnterAt this point, the content is entered, the template is: mysql-hlocalhost (server IP)-p3306 (
1. How to export the database of MySQL
Go to command line, use "CMD"
CD C:\Program files\mysql\mysql Server 5.5\bin
mysqldump-hx.x.x.x (IP)-p3306-uroot-pxxx db_nls > D:/db_nls.sql
Finish the export, SQL file is Db_nls.sql
2.
Querying for data that is not case-sensitive in MySQL often uses subqueries and uses the upper function in a subquery to convert the condition to uppercase. Such as:SELECT * FROM Staticcatalogue WHERE UPPER (source) in (select UPPER (source) from
MySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, causing the write or update to fail.View current configurationShow
MySQL Fabric has recently been used, which is the utility after MySQL5.6.10. The machine on hand is MySQL5.1, so you need to upgrade the old version of MySQL to version 5.6 first. I haven't played MySQL before, so it's a little bit of a thing this
Using phpMyAdmin to log in to MySQL database, there are some ways to summarize there are two kinds:One is through config.inc.php to modify, but this method every time I want to log on the host need to modify the code, it is troublesome;The other is
PHP multiple calls to the MySQL database stored procedures will be problematic, the main problem is that the stored procedure executes multiple SQL statements can not be released, the web found some solutions, such as the use of multi_query and then
Troubleshooting of mysql garbled characters in centosRecently, the website data has been imported to phpmyadmin because of the large data size. If you do not believe this, you can try it. Even if you lift the upload restrictions, a large number of
MySQL master-slave configuration, mysql master-slave Configuration1. Configure the master database. Assume that the master database IP address is 192.168.1.1. modify my. cnf and add the configuration server-id = 1 under [mysqld ].Log-bin = syslog ###
Xin Xing makes mysql run faster. Section 1 Optimization Direction and Database Modeling
I plan to write a set of bibliography recently, that is, about mysql optimization. First, I will write it on my blog and then sort it into a pdf document. Of
Xin Xing makes mysql run faster. The second part is the index.
If we regard our database information as a book or dictionary, the index can be understood as its directory. If we create an excellent directory, We will retrieve the information much
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