The following is a file used to back up a MySQL database through Apache + PHP in Linux.Code:
File 1. listtable. php (the file lists all tables in the database for backup)
Select the table to back up:$ Con = mysql_connect ('localhost', 'root',
Do you think this website is worth 2 million RMB? There are 1000 bullet cells on it. One bullet cell only sells for 50 yuan, but it can sell for 2 million yuan in total. Why? It's called yixiao bullet box, www.1ktag.com. Let's take a look!
The first
SQL in MySQL
For MySQL, the first thing you must remember is that every line of its command is ended with a semicolon (;), ...... There is no such thing as absolute. The same is true here.
As I mentioned earlier, when a MySQL row is inserted
When phpMyAdmin is used, an error is reported:
Client does not support Authentication Protocol requested
By server; consider upgrading MYSQL client
The official statement is:
MySQL 4.1 and up uses an authentication protocol based on a password
1. System Architecture:
The modular concept is divided into three layers:
A. Data storage layer: MySQL is used to store all BBS data, including user information,
Article Data, user mail, user message, system data (?), Key issues:
Database
1. Establish a connection to the MySQL database.
First, we should create a database in MySQL to create an infostar table:
Follow the steps to test MySQL, see the "mysql>" prompt and manually create the table we need:
Mysql> Create Database
5. Layout module design
The so-called classification is mostly for the Telnet server. In cq66 mode, you can press
Classification according to your own wishes. In the end, access is directly based on the version.
For Layout
Article When stored, the
1. $ ROW = mysql_fetch_row ($ result );
Returns a regular array $ row. $ row [0] is the first element, $ row [1] is the second element, and so on...
The number of elements returned by mysql_num_fields ($ result.
2. $ ROW = mysql_fetch_array ($
Show databases;Show tables from db_name;
Show columns from table_name from db_name;Show index from talbe_name [from db_name];Show status;Show variables;Show [full] processlist;Show table status [from db_name];Show grants for user;
In addition to
1. You can set collation for a table or row to binary or case sensitive. In MySQL, the naming conventions for Column Collate are as follows:* _ Bin: binary case sensitive collation, that is, case sensitive.* _ Cs: case sensitive collation, case
1. Download the MYSQL source code version from the MYSQL official website [must be the source code version]2. Press the following code to type the LINUX Command LineCopy codeThe Code is as follows:[Note] adding mysql groups and users# Groupadd mysql#
Mysql 5.0.45 (modified) DoS Vulnerability/** MySQL * Kristian Erik Hermansen* Credit: Joe Gallo* You must have Alter permissions to exploit this bug!* Scenario: You found SQL injection, but you want to punch backend server* In the nuts just for fun.
1. MySQL Common commandsCreate database name; create a databaseUse databasename; select databaseDrop database name directly deletes the database, no reminderShow tables; displays tablesDescribe tablename; Detailed description of the tableAdd
These things are just a bit confusing for new users. Here is my installation notes. It is successfully installed on the Centos virtual machine. For more information about How to Install MySQL 5.0 on Linux, How to Install PHP 5 on Linux, How to
Myisam_max _ [extra] _ sort_file_size is large enoughDelay_key_write reduces io and improves Write PerformanceBulk_insert_buffer_sizeSet concurrent_insert to 2.Read_rnd_buffer_size random scanRead_buffer_size sequential table ScanThree key cache
The table sharding logic here is based on the number of user_name groups in the t_group table.In this case, the index on the user_name field is a bad index. It does not have any obvious effect.1. test PROCEDURE.DELIMITER $Drop procedure't _ girl '. '
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