mysql database technology 1 - Basic addition, deletion and alteration sql statements

1. Classification of database languages DDL: Database Definition Language Used to create, modify, and delete data structures within a database, such as: 1: Create and delete databases (CREATE DATABASE || DROP DATABASE); 2: Create, modify, rename, delete tables (CREATE TABLE | ALTER TABLE | RENAME TABLE | DROP TABLE, TRUNCATE TABLE); 3: Create a ...

Posted by timmerk on Tue, 11 Feb 2020 20:46:07 -0800

MySQL transaction, permission, index and specification

One transaction Core: success or failureAtomicity Both succeed or fail Consistency The data integrity before and after the transaction should be consistent, 1000 Principle: ACID1. Atomicity Either they succeed or they fail; 2. Consistency Data integrity before and after transactions should be consiste ...

Posted by nawal on Tue, 11 Feb 2020 02:41:44 -0800

MySQL Database - Functions, Transactions, Indexes, Rights Management and Backup, Specifications for Databases

1. MySQL functions Official website: https://dev.mysql.com/doc/refman/5.7/en/func-op-summary-ref.html 1.1. Common Functions -- ==================== Common Functions ============================= -- Mathematical operations SELECT ABS(-8) -- absolute value SELECT CEILING(9.4) -- ceil SELECT FLOOR(9. ...

Posted by undecided name 01 on Wed, 05 Feb 2020 20:01:33 -0800

Copy / copy database without mysqldump

Without local access to the server, is there any way to copy / clone MySQL database (including content and excluding content) to another database without using mysqldump? I am currently using MySQL 4.0. #1 building If you're using Linux, you can use the following bash script: (it may need some other code cleansing capabilities, but it ...

Posted by kel on Fri, 31 Jan 2020 03:16:41 -0800

MySQL Data Backup and Recovery

Preface MySQL backup generally uses full library backup plus log backup. Depending on business needs, you can use full backup at 1 a.m. every Sunday and incremental backup every hour to recover the most complete data when MySQL fails. 1. Bilog Log Recovery MySQL's binary logs record all additions and deletions to the database (provided you hav ...

Posted by NickG21 on Fri, 10 Jan 2020 20:14:04 -0800

MySQL Full Backup and Recovery Concepts and Actual Operations

MySQL Full Backup and Recovery The main content of this paper Classification of database backups MySQL Full Backup and Recovery MySQL Differential Backup and Recovery MySQL Incremental Backup Concept MySQL backup recovery operation 1. Preface With the rapid development of office automation and e-commerce, enterprises rely more and more on in ...

Posted by The MA on Tue, 07 Jan 2020 17:26:01 -0800

MySQL database whole database backup script

MySQL database whole database backup script Author: old farmer (Liu Qihua) QQ: 46715422 Email: 46715422@qq.com Wechat: 46715422 Test operating system environment: CentOS 6/7, Debian 8/9, FreeBSD 11/12 Test MySQL version: 5.7.23 User name and password: mysql The database we need to back up this time: test Script required for backup: bac ...

Posted by ViN86 on Fri, 03 Jan 2020 21:39:36 -0800

MySQL learning -- backup and restore with mysqldump command

Absrtact: This paper mainly studied how to use mysqldump command to backup and restore database. Derived data Export all data Parameters: 1 --all-databases, -A Give an example: 1 mysqldump -h127.0.0.1 -uroot -p -A > db_back.sql Export the specified database Parameters: 1 --databases, -B Give an example: 1 mysqldump -h127.0.0.1 -uroot ...

Posted by gaza165 on Tue, 24 Dec 2019 02:58:30 -0800

MySQL - full, incremental backup and recovery (Theory + Practice)

The importance of data backup 1. In the production environment, the safety of data is very important, and any loss of data may have serious consequences 2. Causes of data loss Program error Human error Computer failure Disk failure Disaster and theft Classification of database backup From a physical and logical point of view, backup can be d ...

Posted by cyberdesi on Thu, 12 Dec 2019 00:15:01 -0800

MySQL restores single table data with full database backup data

When backing up the database, a full database backup is used, but for some reasons, the data of a table needs to be rolled back to the backup database. If the entire database needs to be rolled back, it will take time, because this table may only have tens of meters, but other tables may have tens of hundreds of G, so the tables that need to be ...

Posted by paulchen on Tue, 03 Dec 2019 11:20:06 -0800