I first introduce the environment I use:
1. Windows;
2. php Service Manager wamp5;
Let's talk about the following:
1. Open the task manager and end the process mysqld-nt.exe
2. Run Command window
1). Run the "bin" directory in
1. Add default-character-set = gb2312 to the [client] In my. ini under the MySQL installation directory.
[Client]Default-character-set = gb2312Port = 33062. Copy my. ini to the C root directory and change the name to my. CNF.
3. When configuring
1. myisamchkTo use myisamchk, you must temporarily stop the MySQL server. For example, we want to repair the discuz database. Perform the following operations:# Service MySQL stop (stop MySQL );# Myisamchk-r/absolute path of the database file/* myi#
My personal practice is: phpMyAdmin exports ABC. SQL in UTF-8 insert mode
Ftp abc. SQL to server
SSH to server
Mysql-u ABC-P use KKK (database name, if not, create database kkk) set names 'utf8' source ABC. SQL
Note: I have seen the set Character
// Page is a user-submitted parameter used to control paging. The allowed values are positive integers and negative integers.
Int I = count/15; // total page, 15 records per page
Int J = I/10; // The total size of the page. If there are no 10 pages,
MySQL's built-in engine must be enough, but in some cases, other engines may be more suitable for completing tasks than they are used at hand. If you want to, you can even use MySQL ++ API to create your own database engine, just like hitting the
Method 1: More detailed The following
Article This article mainly introduces the operation process of enabling the remote connection of MySQL database. In fact, it is not difficult to start the actual operation steps of the remote connection of
The following
Article It mainly describes how to correctly install MySQL through the RPM package and configure and uninstall MySQL. The following describes how to configure MySQL and uninstall MySQL (the best combination with PHP) detailed
Regular mysql backup
Put/etc/cron. hourly/
Copy codeThe Code is as follows :#! /Bin/bash
DUMP =/usr/local/webserver/mysql/bin/mysqldump
OUT_DIR =/data1/backup/
DB_NAME = Database Name
DB_USER = Database User
DB_PASS = Database Password
# How much
The following error occurs: "Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file', or the Master/Slave database is not synchronized due to data clearing. The
1. Add a user with the permission to access the master database on the master database server:
Grant replication slave on *. * TO 'test' @ '%' identified by 'test ';
(% Indicates that all IP addresses are allowed. You can specify the slave server IP
Next, let's take a look at how to restore the two ..
If slave_io_running is no, I personally think there are three situations. One is that there is a network problem and the connection fails. For example, I once used a virtual machine to build
Implementation of mysql two-way synchronous backup in windowsThe following articles mainly describe the correct operation solution for implementing master-slave synchronous backup of MySQL Databases in windows, on some related websites, I saw the
Usage of the is null statement in the mysql database
Note that in mysql, 0 or null means false while other values mean true. The default true value of Boolean operations is 1.
The special processing of null is in the previous chapter. To determine
I first introduce the environment I use:
1. windows;
2. php Service Manager wamp5;
Let's talk about the following:
1. Open the task manager and end the process mysqld-nt.exe
2. Run Command window
1). Run the "bin" directory in the php Service
1. Are you still using a primary key for association between two tables?For example, there are two tables, one for news topic and one for news. Now the two tables need to be associated, I think most people must create a news topic id in the News
1. Data capacity: the total number of data records and the total number of bytes of each data record within 1-3 years;2. Data items: whether there are large fields and whether the values of those fields are updated frequently;3. SQL condition for
When an external program accesses a database (such as PHP), many SQL statements need to be organized.Especially when the business logic is complex, a lot of SQL statements and conditions are mixed in PHP code, which is chilling. With the MySQL
There is a database online, and there are a lot of records similar to the following in slow log:Copy codeThe Code is as follows:# Time: 130823 13:56:08# User @ Host: repl [repl] @ slave [10. x]# Query_time: 9.000833 Lock_time: 0.000000 Rows_sent: 1
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