Communication is very important, the channel of communication is very important. When the team needs to cooperate, it is necessary to find ways to inform other members of the team in the most effective way of what it is doing to avoid unnecessary harm.
For example, the following has just happened:There is a test system. The historical task is t ...
Posted on Sat, 02 Nov 2019 07:22:17 -0400 by amyhughes
Next: MySQL database master slave synchronization process
mysql command introduction
mysql is a database management command
adopt mysql --help To view relevant parameters and instructions
#mysql database management command
Usage: mysql [OPTIONS] [database]
--help #View help d ...
Posted on Tue, 15 Oct 2019 15:50:10 -0400 by jblallement
Last time: MySQL database entry multi-instance configuration
When it comes to data, we are nervous. There are many types of data, but the total normalization point, data is very important and very important. Therefore, the daily data backup work has become the focus of the operation and maintenance work.
Let's first look at the data in the dat ...
Posted on Sun, 13 Oct 2019 22:05:58 -0400 by skeetley
1. First create a backup folder
2. Create. sh execution file and write code
Posted on Thu, 03 Oct 2019 05:15:06 -0400 by signer
I. Demand Background
A friend's company needs to synchronize part of the data from the source to the target at regular intervals every day. There are tables of company_id column in the library, which only import the specified company_id column into the target database; there are tables of company_id column, which import all the data from the t ...
Posted on Thu, 03 Oct 2019 04:48:46 -0400 by aaronhall
Joint table queries do not require foreign key constraints
1. inner join
1.1 Thinking Logic
What do I need to check?
Where to check? Which form links which table?
What are the query conditions? Conditions between tables? Additional screening con ...
Posted on Sat, 24 Aug 2019 08:51:58 -0400 by akabugeyes
This article is the fifth in a series of articles on database optimization: "Database optimization - backup and recovery"
See more articles
Database optimization: http://blog.csdn.net/leyounger/article/details/70157087
Backup and Recovery
1. Backup/Recovery Strategy
For a DBA, it is very important to customi ...
Posted on Fri, 28 Jun 2019 16:11:31 -0400 by Sera
Reprinted from: http://blog.csdn.net/jesseyoung/article/details/41078947
Introduction to 1 mysqldump
mysqldump clients can be used to dump or collect databases for backup or transfer data to another SQL server (not necessarily a MySQL server). Dumps contain SQL statements that create and/or load tables.mysqldump can provide file output in t ...
Posted on Tue, 21 May 2019 19:16:14 -0400 by grandadevans
Contents of this article:1.insert and replace insert data 1.1 insert into values() 1.2 insert into set 1.3 insert into select_statement 1.4 create table select 1.5 Dealing with Repetition of Key Values 1.6 Complete insert grammar2. Export and import data 2.1 select into outfile export data 2.2 load data infile imports data 2.3 mysqldum ...
Posted on Sun, 19 May 2019 15:50:46 -0400 by stuartbrown20
PostgreSQL , MySQL , rds_dbsync , mysql , mysqldump , copy , mysql_fdw
Import MySQL data into PostgreSQL in a landless manner.
MySQL Quasi-Real-Time Synchronization to PostgreSQL, One of Greenplum's Solutions - rds_dbsync
This is the most efficient, supports no landing, supports streaming import, ...
Posted on Tue, 14 May 2019 20:29:09 -0400 by Hardwarez