7, MySQL client tools and SQL introduction
mysql client command introduction;
How to get help from mysql;
Management database of DDL statements;
DDL statement management table and case introduction;
Data in management table of DML statement;
SELECT to retrieve data;
2. mysql interface program and SQL introduction
mysql client comma ...
Added by jdimino on Fri, 08 May 2020 16:47:04 +0300
MySQL provides a variety of methods to obtain database metadata (information about the database and various objects in it):
*Various SHOW statements, such as SHOW DATABASES or SHOW TABLES;
*Information? Table in schema database;
*Command line programs, such as mysqlshow or mysqldump.
Use SHOW statement to get metadata
-- List accessible ...
Added by riyaz123 on Thu, 30 Apr 2020 21:47:29 +0300
When exporting, backing up and restoring Mysql database from the master database to the slave database, you need to pay attention to whether to enable GTID mode for the database. If you enable it, you should add the parameter -- set GTID purged = off to mysqldump data.
See reprint for details:
Here are the first 30 lines of a.sql exported with ...
Added by Jack_Slocum on Fri, 03 Apr 2020 08:48:03 +0300
One time when I was helping my friends solve problems, their server's MySQL was multi-instance, on which I made a master-slave configuration. Before I used multiple instances, I used multiple configuration files. This article mainly describes how to start and close multiple instances in a configuration file.
Added by guybrush on Mon, 02 Mar 2020 18:20:49 +0200
1. Install mysql database, and configure the mysql installation directory bin directory to the system environment variable
mysqldump -h (IP) - p (port number) - u (user name) - p (password) - default character set = utf8 database name > where to back up to the local disk
Column: mysqldump - h192.168.1.10 - p330 ...
Added by puckeye on Sun, 05 Jan 2020 18:32:39 +0200
--Using mysql's mysql dump to export and import table structure
--The command is as follows:
mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql
--Where - d means to export only table structure, not data, - h means host, - u means user, - p means password database means to export that database, and d ...
Added by geordie on Sun, 29 Dec 2019 18:56:04 +0200
Database backup statement
mysqldump -S /tmp/mysql3309.sock -u root -pMySQL8.0 \
--quick --flush-logs \
--databases testdb > testdb.dump
The following data exists in table nw during backup
mysql> select * from nw;
| dt ...
Added by Pyrite on Sun, 08 Dec 2019 20:52:47 +0200
In Linux system, the executable commands are usually stored in / bin, / sbin, / user/bin, / user/sbing. The details are as follows:
Store the most basic and necessary execution commands of system operation, that is, the commands that can be executed for all users. The following is the bin directory und ...
Added by alex clone on Sat, 30 Nov 2019 07:29:35 +0200
Create test library and table
create database test;
create table leo (id int,name varchar(10));
insert into leo values (1,"liufeng");
insert into leo values (2,"zhangsan");
insert into leo values (3,"liufeng");
insert into leo values (4,"zhangsan");
mysql> select * from leo;
| id | name |
Added by Zup on Fri, 01 Nov 2019 02:49:35 +0200
Chapter 7 Backup and Recovery
1. What does DBA (Operations and Maintenance) need to do in backup recovery
1.1 Design backup strategy
1.1.1 backup cycle
Day, week, month
1.1.2 Backup Mode
1.1.3 Backup What?
Added by Damien_Buttler on Thu, 15 Aug 2019 14:31:44 +0300