1, configure a good MySQL master and slave environment, the server is as follows:
The code is as follows
Copy Code
master:172.16.206.129slave:172.16.206.130amoeba:172.16.206.131
2, Amoeba configuration good JDK
Today back up the data on this site, the resulting SQL file is relatively large, of course, this SQL contains more redundant data. With Navicat direct import words, error MySQL server has gone away. As shown in the following illustration:
(1) Use the ALTER TABLE statement to create an index.The syntax is as follows:
The code is as follows
Copy Code
ALTER TABLE table_name ADD index index_name (column_list);ALTER TABLE table_name add unique
SQL inline Syntax basic syntax (INNER join)
SELECT * FROM table 1 inner JOIN table 2 on table 1.userid= table 2.userid
SQL Inline Syntax Description: The above statement is the query Table 1 and table 22 tables, as long as the UserID field in two
MySQL normal delete table
Definition of DELETE statement:
Children who often work with databases, delete the data most of the time with the DELETE statement. Now let's take a look at the definition of the DELETE statement.
DELETE [low_priority]
1. Storage required for numeric type column types TINYINT 1 bytes SMALLINT 2 bytes mediumint 3 bytes INT 4 bytesInt (m) in the integer data type, m represents the maximum display width.in int (m), the value of M has nothing to do with how much
Unable to terminate MySQL service on local computer error 1053: The service did not respond to startup or control requests several times,
discuz! Info:can not connect to MySQL server
Time:2010-7-8 11:23pmScript:/index.php
Error:lost connection to
Modify the phpmyadminconfig.inc.php files in the phpMyAdmin site for this machine
Find this line and change the ' localhost ' after [' host '] to remote database IP
The code is as follows
Copy Code
$cfg [' Servers ']
How Windows restarts MySQL starts-> run->cmd
Stop: net stop MySQL
Start: net start MySQL
Prerequisite MySQL has been installed as Windows service
Wind Method Two
Start-run-input: services.msc-point OK-find mysql-on top right-reboot. That's fine.
Keyword: apache+mysql+php apache mysql PHP configuration Lamp Server Web
linux+apache+mysql+php Typical Configuration
Debugging environment: Redhat9.0 Apache1.3.29 Mysql3.23.58 PHP4.3.4
Linux system installation I do not say, this is the basic
Based on the previous article method, the batch command is added to automate the backup process. Just because the name of the backup file in the batch command is unique in terms of time, make a special arrangement.
1. Copy Date folder Backup
======
First, view the database encoding format
Mysql> Show variables like ' character_set_database ';
Second, view the data table encoding format
Mysql> Show CREATE table ;
Specifying the character set of a database when creating
Can't find discuz! Forum Data Sheet!
When the 5.5 is upgraded to 6.0, after uploading, the following problems are encountered when running http://*****.com/upgrade9.php:
Can't find discuz! Forum Data Sheet!
Please modify the database settings
This program can be used to browse the data in MySQL, you can do a little modification can make a good MySQL browser.
*/
/*
? cmd=db
? cmd=table&db={}
? cmd=record&db={}&table={}
*/
$host = ' localhost ';
$user = ' Test ';
$password = ';
if (!isset (
Automatic backup MySQL 5.0 has three scenarios:
Backup Scenario One: generate a complete. sql file directly through the mysqldump command
Step 1: Create a batch
(Note: Root is the MySQL default user name, AAAAAA is the MySQL password, bugtracker
First, what is a business?
A transaction is a series of rigorous operations in an application, and all operations must be completed successfully, otherwise all changes made in each operation will be undone. That is, the transaction is atomic, and a
1, through floor error
You can use the following code
and select 1 from (SELECT COUNT (*), concat (version (), Floor (rand (0) *2)) x to Information_schema.tables Group by X);
and (select COUNT (*) from (SELECT 1 Union SELECT NULL UNION SELECT! 1)
MySQL Time function--Get Current dateSelectcurrent_date ();--Get current TimeSelectcurrent_time ();--gets the current date and timeSelectNow ();--get datetime year, month, daySelectYear (now ());--yearsSelectMonth (now ());--MonthSelectDay (now ());-
Unable to load mysql extension, Please check the PHP configuration-documentThe solution is very simple. Find the following code in your php. ini file: The code is as follows:Copy code Extension_dir = "D:/xxx/php/ext" D: xxxphpext is your php
MySQLVersion: 4.1Environment introduction: master database 192.168.0.205 slave database 192.168.0.2061. Create/etc/my. cnf in the master database and modify the key value in [mysqld] to increaseServer-id = 1Log-bin = binlog_name2. Add users to 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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service