Using mysqldump to back up multiple libraries

mysqldump backs up multiple libraries at a time There are 20 + databases in a database instance, and 10 + of them need to be backed up in this backup. Use mysqldump to directly back up and step on a warning and an error. Database version: 5.7.26 The process is as follows: action1 mysqldump -hrm-2ze04c849v9m32bzj.mysql.rds.aliyuncs.com -uadminr ...

Posted on Tue, 26 May 2020 07:57:51 -0700 by ponies3387

shell script 14: Enterprise case

14. Enterprise Actual Warfare Cases (1) Use the for loop to create 10 html files in batch in the / oldboy directory, where the file name contains 10 random lowercase letters to reinforce the fixed string 0ldoby. Idea analysis to generate random numbers: The core is to create 10 random lower case letters. Method 1: echo $RANDOM range is 0-32767 ...

Posted on Wed, 29 Apr 2020 09:37:56 -0700 by kparker

Mysql commands commonly used in operation and maintenance

1. Check which libraries are available > show databases; 2. View the table of a library > use db1; show tables; 3. View the fields of the table > desc tb1; 4. View the statement of table creation > show create table tb1; 5. Which user is it currently > select user(); 6. View the current library > select databa ...

Posted on Wed, 01 Apr 2020 09:42:57 -0700 by phil88

mariadb (data password management, user authorization, backup)

1. Database password management: Data password management; database password cracking. Experimental background When deleting the original mariadb database, please note that when deleting the service, the data will remain in the / var/lib/mysql / directory, and all files need to be deleted. a. Data password management mysqladmin -uroot -plee ...

Posted on Tue, 24 Mar 2020 07:40:30 -0700 by tonga

MySQL Data Backup and Restore

Accidents involving database deletion are now common, and the need for data backup is an extremely important task in enterprise data management.There are also many scenarios and methods for data backup and recovery, and several of the main tools in this series will be demonstrated through cases. This series will start with logical backup and re ...

Posted on Sat, 21 Mar 2020 19:44:50 -0700 by cobalt30

MySQL database migration to MSSQLSERVER

Method 1: use mysqldump --Example:take mysql Of CHL Database migration to MSSQLserver in --1,Use mysqldump Tool export mysql Of CHL All table structures of the database; mysqldump -uroot -p --databases CHL --no-data>/chl/CHLtomssql_nodata.sql --2,Use mysqldump Tool export mysql Of CHL All data in the database. Consider tha ...

Posted on Tue, 31 Dec 2019 05:24:19 -0800 by Chetan

MySQL Full, Incremental Backup and Recovery (Theory + Practice)

Importance of data backup In a production environment, data security is critical, and any loss of data can have serious consequences Causes of data loss Program error Artificial error Computer Failure Disk failure Disasters (such as fires, earthquakes) and theft Classification of database backups From a physical and logical perspective, b ...

Posted on Thu, 12 Dec 2019 17:17:41 -0800 by greekuser

Elasticsearch log alert

Elasticsearch log alarm elastalert use posture correctly Preface In May, Github found an open-source software, elastalert, to find an ELK log alert solution online Portal Look at the latest update for two years ago, so have been in a semi questioning state to look at the software, until further... In depth Latest news: as of the time of relea ...

Posted on Sun, 08 Dec 2019 20:50:57 -0800 by alex.hughson

MySQL: pro test backup strategy instance (online real backup case) recommendation

Xiaosheng blog: http://xsboke.blog.51cto.com If in doubt, please Click here The author will reply in time (or comment directly in the current article). -------Thank you for your reference. If you have any questions, welcome to exchange Have you ever worried about the backup of online database? Here is a complete backup ...

Posted on Sat, 07 Dec 2019 06:25:10 -0800 by Dilb

Do you remember these common Mysql commands?

Preface Recording Common Command Operations of mysql Basic operation Command line login mysql Mysql-u username-p user password Increase creation time and update time for tables ALTER TABLE order_info_tbl ADD COLUMN create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation time'; ALTER TABLE order_info_tbl ADD COLUMN update_time TIMESTA ...

Posted on Wed, 25 Sep 2019 08:09:44 -0700 by WilliamNz