Import and export data using into outfile and load data infileThe advantage of this method is that the exported data can be self-defined format, and the export is pure data, there is no table information, you can directly import another database
1. InstallationI am using CentOS 7, the default Yum installation, but the default Yum installation version is a bit low, you can choose to upgrade as needed, I choose to upgrade and install first.Update YumUpdate Yum Package yum-y updateConfiguring
1, new data directory, check the directory is the host permissions, under normal circumstances belong to the MySQL group, MYQL users, because we install MySQL will create a new account and group.2, the directory permission check is complete, stop
Change the password to update mysql. user set authentication_string= password 123456 ( ‘123456‘ ) where user = ‘root‘ andHost = ‘localhost‘;Change Password to update mysql. user set authentication_string= empty password ( ‘‘ ) where user = ‘root‘
Objective: To monitor MySQL's status from the library, if you copy the exception from the Library and alarmIdeas:1, first find MySQL from the library of 4 parameter values (show slave status according to this command), respectively, the IO thread
The previous article is about the basic MySQL operation, this one will be a little difficult to understand, this section of the main content of MySQL view, stored procedures, functions, transactions, triggers, and dynamic execution of SQLViews ViewA
About MySQL1. What is a database?A database is a warehouse that organizes, stores, and manages data according to its structure, which is generated more than more than 60 years ago, with the development of information technology and markets,
First, MySQL database systemMySQL database system is used to the database, some of the data managementSecond, the database system1. Databaseis used to store a variety of data2. Database management Systemis a system used to manage data from various
If an error occurs cannot connect service on ' IP ' (110)Can be considered from the following aspects:1, the connection command has no write error y (especially-P 3306 "p is uppercase")2, the password is not written wrong3, the remote database
Xtrabackup is an online hot backup tool developed by Percona company, which is open source and free of charge. Do not support Windowsxtrabackup website: www.percona.com need to go to the official website to download this tool:
Install MySQL Baidu experience Address: (the default installation, in addition to choose not to update and choose Save Path, the other basic is the next step)Http://jingyan.baidu.com/article/7e440953d6f0702fc1e2ef61.htmlCannot connect remotely after
1. Download the JDK and Tomcat.Jdk:Http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.htmlTomcat:http://tomcat.apache.org/download-70.cgi2.JDK installation and configuration.(1) JDK installationRPM Package:# RPM-IVH
. Cascade WaySynchronize update/delete out a matching record of a child table when Update/delete records on the parent table. Set NULL modeSet the column of the matching record on the child table to NULL when the record is update/delete on the
1. Install MySQL using the installation packagedouble-click to open the installation fileDouble-click Pkg file Installation
All the way down, remember to save the last pop-up box password (it's your MySQL root account password)
under
First, the basic queryQuerying all Columns SELECT * from table name; Querying a specified column Select field 1, Field 2 from table name; Second, the conditions of inquiryThe WHERE clause is given when querying to limit the results of the query
Quick install test version Mysql and test version Mysql
Operating System: CentOS 7.2.1511 x86_64MySQL version: 5.7.131. Uninstall the built-in mariadb-lib
[root@centos-linux ~]# rpm -qa|grep mariadbmariadb-libs-5.5.44-2.el7.centos.x86_64[root@centos-
MySql installation and configuration on Mac
1. Download and install
Download Community version dmg installation files: https://dev.mysql.com/downloads/mysql/
1. Execute the installation file and follow the steps to complete the installation.
2.
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