mysql| Backup | script
Operating system: Windows2000 Professional
Database: MySQL server4.0.18
First create a batch file, where it is named Dbbackup.bat
Then add the following in the file:
REM Determines whether the MySQL service is started,
1: Check whether redundant software to remove the system from MySQL
2: Download source, build directory
3: Hanging share decompression installation directory, into the source package
4: Configuration
5: Compiling
6: Installation
7: Add service
A materialized view
Materialized views, which are the result of time-consuming operations that are used to calculate and save table joins or aggregates, so that when you execute a query, you can avoid these time-consuming operations and get results
Replicated schemas
The basic problem with MySQL replication is to keep the data of one server synchronized with other servers, which has the following characteristics:
1) Asynchronous: This means that data from the repository at the same point in
Basic Configuration
Primary database
configuration files, modifying server_id=1
Create an account for slave to use synchronously
GRANT REPLICATION SLAVE on *.* to ' repl ' @ ' 192.168.56.3 ' identified by ' repl ';
Mysql> Show master status;
+-
Test how to store the video file in MySQL data, of course, do not recommend direct storage, because the migration will be cumbersome and prone to problems, the following is just a test function, import jpg, PNG and other pictures similar.
Create a
We are not unfamiliar with the join statements for SQL statements. This is noteworthy for content filtering in the where statement, or for filtering in the on statement or having.
Case: To find a period of time to register new users, not through
Back_log:
The operating system maintains a listening queue, which is done before the MySQL thread is connected
If you have a lot of connections and there are connection refused error prompts, adding this value is certainly true.
Skip-networking:
Vi. Complete Procedures
Before the end of the lesson, we'll add everything to a program that has the ability to add, edit, and delete records. This is an extension of all the previous content, and can also be an excellent review method. Look at the
How to restore MySQL password
If you forget the MySQL root password, you can reset it in the following ways:
1. Kill off the MySQL process in the system;
Killall-term mysqld
2. Use the following command to start MySQL, to do not check the
When working on a very large table, you may occasionally need to run many queries to get a small subset of a large amount of data, instead of running the query on the entire table, instead of having MySQL find the few records needed each time, it
Optimizing MySQL at compile timeIf you install MySQL from the source code, note that the compilation process will have an important impact on the performance of future target programs, different compilation methods may get similar target files, but
Modify the script to make the necessary configuration, and then execute it as the root user.
1. First when performing a remote backup.
2. Local Backup
3. Remote backup without parameters
Note: You need to add users to a MySQL user on another
There are many operators and functions in MySQL that can return strings. This section answers the question: What character set and collation rules are used for the returned string?
For a simple function, a function that receives a string input and
Let's start with this section to learn how to apply Smarty to actual examples. To illustrate this, I'll take a site that I wrote before as an example. First of all, I am not very strong in art, so the design out of the page is not very good-looking,
It is important to back up your database if your database tables are missing or corrupted. If a system crash occurs, you will want to be able to recover as few data from your table as possible to the state at which the crash occurred. Sometimes it
If you're running a Web application that uses MySQL, it's a great opportunity to keep passwords or other sensitive information in your application. Protecting this data from hackers or prying eyes is an important concern because you cannot allow
Today's corporate database has stalled and blocked problems, check the database when found, show processlist; you can see a lot of:
.... : 3436942 : unauthenticated user : 192.168.0.4:49607 : : Connect : : login : : 3436943 : unauthenticated user
Use the Data database table address data (China region) For example (using Windows please GBK!!) )
Can be run directly (remove annotations)
Stored procedures:
DELIMITER//drop procedure if exists findlchild///* IID Recursive parent node, layer
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