Production environment:Operating system: CentOS6.6Database system: MySQL 5.5.41-cll-lveSecure terminal emulation software (telnet tool): Xshell 5Problem: In the learning and practice operation, found fullscreen fast, view inconvenient, so want to
How to obtain mysql help information and mysql help information
When a mysql-related fault occurs in the development or test environment, most of my friends may post on the Forum and discuss the problem with the QQ group. This method is one of the
When a mysql-related fault occurs in the development or test environment, most of my friends may post on the forum and discuss the problem with the QQ group. This method is one of the effective ways to get help. However, in a production environment
Skip this step if you are completely new to the installation.
Find the ragnarok database directory under your Mysql database directory, for example, install Mysql inUnder the D: \ mysql directory, find the ragnarok database directory under the D: \
Install MySQL 5.6.21 in CentOS 6.5Install MySQL
MySQL is the most widely used database in Linux. The version installed using the online yum method lags behind several minor versions on the MySQL website. This section tests and installs the new
PHP MySQL database common cmd command setshow databases; Display DatabaseCreate database name; Create a databaseUse DatabaseName; Select DatabaseDrop database name deletes databases directly and does not alertShow tables; Show TableDescribe
Mysqlhotcopy Use the lock tables, flush tables, and CP or SCP to quickly back up the database. It is the quickest way to back up a database or a single table, which is completely physical, but only used to back up MyISAM storage engines and run in
In daily work, mysql is used simply, so the Common commands are summarized as follows:
In daily work, mysql is used simply, so the Common commands are summarized as follows:
1. Start and exit
1. Go to MySQL: Start MySQL Command Line Client
A variety of MySQL administration Tools <>mysql provides command-line tools mysql_install_db : MySQL Build library tool, in the source installation MySQL link we used. Mysql_safe : MySQL boot tool mysqld : MySQL master process,
MySQL backup tool-mysqlhotcopy
Mysqlhotcopy uses lock tables, flush tables and cp or scp to quickly back up the database. it is the fastest way to back up a database or a single table. It is a physical backup, but it can only be used to back up the
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.