The project needs to back up the database regularly. Here are your own operation notes
1. Check the disk space
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 40G 3.6G 34G 10% /
tmpfs 16G 0 16G 0% /dev/shm
This is my current situation of linux server. I don't know why it's like this (I'm ...
Posted by joozt on Sat, 02 May 2020 07:56:12 -0700
1. Set the relevant database connection statements in the jdbc.properties file
jdbc_url=jdbc:mysql://ip address: port / database name? Characterencoding = utf8 & zerodatetimebehavior = round
2. Read the modified properties file in applicationContext.xml
Posted by oscar2 on Fri, 03 Apr 2020 01:52:07 -0700
tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
#Copy the extracted mysql directory
cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql
#Add user group
#Add user mysql to user group mysql
useradd -g mysql mysql
chown -R ...
Posted by shock on Fri, 20 Mar 2020 11:21:03 -0700
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
Core: success or failureAtomicity
Both succeed or fail
The data integrity before and after the transaction should be consistent, 1000
Principle: ACID1. Atomicity
Either they succeed or they fail;
Data integrity before and after transactions should be consiste ...
Posted by nawal on Tue, 11 Feb 2020 02:41:44 -0800
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
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.
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 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
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
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
Author: old farmer (Liu Qihua)
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