Regular backup of linux mysql

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

Java Web database backup and restore

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 jdbc_username=User name jdbc_password=User password 2. Read the modified properties file in applicationContext.xml <context:pr ...

Posted by oscar2 on Fri, 03 Apr 2020 01:52:07 -0700

Linux centos install mysql

Installation steps #decompression 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 groupadd mysql #Add user mysql to user group mysql useradd -g mysql mysql #install cd /usr/local/mysql/ mkdir ./data/mysql chown -R ...

Posted by shock on Fri, 20 Mar 2020 11:21:03 -0700

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