In general, when we manage the Linux VPS Server Web site database, most of them use the phpMyAdmin panel to visualize the management database. At night a netizen told the original can login phpMyAdmin today, but the website operation is normal,
Product Type Super host 300M (asp-300 type) Web space 300M Database space complimentary MySQL database 20M (independent of web space) Access database free (share database size with web space) Bundle Professional Post Office √
Free Host free200Model: Free host 200M (free200)Current: 0 RMB/monthContent:-Free three domain name, can be bound to 4 domain names-Host Space 200M-Real-time web Interface modification FTP, domain name and home page, etc.-Assign a separate FTP
110MB Space-free (can be upgraded to up to 15GB)10GB of bandwidth-free! (Can be upgraded to 1TB)Dual Xeon and Hao long serverSmall Industry-free!PHP 5-Free!Rent 5-* Must be activatedFTP (Property support)-* Must be activatedIoncube and Zend
Create and delete indexes
The creation of the primer can be done in the CREATE TABLE statement, or you can add indexes to the table separately with the CREATE INDEX or ALTER TABLE. The deletion index can be implemented using ALTER TABLE or DROP
Scenario: Perform a full backup every Sunday and perform an incremental backup 1 o'clock in the afternoon every day
Configuration
The prerequisite for performing an incremental backup is that MySQL opens the log-bin log switch, for example in
Recently also constantly improve the Wblog program, so far, Wblog has not installed the program, the two days are busy writing, to install the program has come to an end, can basically install, but is not yet detect PHP version and MySQL version of
The simplest kind of joint query
The code is as follows
Copy Code
SELECT * FROM table1 N, table2 i WHERE n.itemid = I.itemid
Cases
Promotion Site Table promotion_addr field: Name,id
Telephone report
The format () function is used to format a number of x:###,###,##### truncated to D decimal places in the following format. The following example shows how to use and output the format () function:
The code is as follows
Copy Code
MySQL exceeded the maximum number of connections, I believe many people first reaction is to view the MySQL process, see if there is a slow query, of course, this approach is entirely correct!But most of the time the real problem isn't here.Today
Error Handler ExamplesHere are some examples of handler declarations:If any error condition arises (other than a not FOUND), continue execution after setting L_error=1:DECLARE CONTINUE HANDLER for SQLEXCEPTIONSET l_error=1;If any error condition
Method One
Using mysqldump
The code is as follows
Copy Code
@echo offSet path=c:/"program Files"/winrar;%path%Set mysqlpath=c:/"program Files"/mysql/"MySQL Server 5.0"Set Bakpath=e:/mysql_bakSet Username=rootSet
One, MySQL connection number1. Configure MySQL Connection number:VIM/ETC/MY.CNF [mysqld] modified belowmax_connections=1000 does not write default to 100.Wait_timeout=60 setting the time-out period2. View the current number of connections:Show
1. Reading data from memory is a microsecond level. Read from disk is the millisecond level. The two differ by an order of magnitude. So to optimize the database, the first thing to do is to optimize the IO.2.key_buffer_size[Global] Sets the size of
Summary: MySQL 5.5 supports single-threaded mode replication, MySQL 5.6 supports library-level parallel replication, and MySQL 5.7 supports transactional-level parallel replication. With this mainline we can analyze the causes and consequences of
Installing mysql5.61. DecompressionTAR-ZXVF mysql-5.6.23.tar.gz2, patching, download patch mysql-openssl.patch to MySQL compression package the same pathCD mysql-5.6.23Patch-p1 3. Compile and install, ensure installed ncurses,ncurses-devel,gcc,gcc-c+
Implementing MySQL-based authentication for VSFTPD virtual users (CENTOS6)
Note: This experiment is implemented on two Cento hosts, one as FTP server and one as database serverFTP Server ip:172.16.250.90MySQL server ip:172.16.252.16Install the
Solve the problem related to mysql inserting Chinese Characters in centos 7
After mysql is installed, the database abc is created, and a new abc table is created. There is no problem in English language insertion, but there is a problem in Chinese
MySQL database 1067 error code solution, mysql1067
MySQL 5.6 is installed in Windows Professional 7 64-bit, but an error occurs one day with the error code 1067. How can this problem be solved?
Follow these steps:
1. log in as a system
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