In this article, you will get some information on how to use mysqldump command to backup and restore mysql database.
For the sake of clarity, we will use two databases; 'sample_db_1' and 'sample_db_1'. We will also use 'james' as the MySQL user in all examples. Each sample database contains two tables ('table_1' and 'table_2').
Logical MySQL backups using mysqldump only works when a database server is up and running. Also, mysqldump utility can be slow for large databases. So in case you are managing a bulky database or you can't access a MySQL server, taking physical backups is the ideal choice.
In this article, you will learn how to backup and restore RDS for MySQL Database on linux with some information on monitoring the backup and restore process and how to reduce the backup cost.
After you have installed MySQL Client successfully, you can run the command to complete database backup:
mysqldump -h xxx.mysql.aliyun.com -u xxx -P 3306 -p --opt --default-character-set=utf8 --triggers --hex-blob db_name > /tmp/db_name.sql
After the password is entered, Mysqldump will carry out the backup and complete it automatically.
In this article, you will get some information on how to backup data with ApsaraDB for MongoDB, MongoDB replica set and data replication platform, and how to recover the backup MongoDB data.
ApsaraDB for MongoDB automatically backs up data according to the default backup policy. You can also set a backup policy based on business requirements to automatically back up data for your ApsaraDB for MongoDB instances as required.
In this article, you will learn how to restore RDS database from backup files with RDS official extract tool kit and Percona XtraBackup.
In this article, you will learn how to compress data over time with customized PostgreSQL compression algorithms.
The PostgreSQL compression algorithm can be customized. For example, simple mean compression, maximum compression and minimum compression, or compression based on the revolving door compression algorithm.
You can restore files to an ECS instance from a backup stored on it or another ECS instance in the same vault. You can also restore files to an ECS instance from a backup that is created by a backup client.
The topic describes how use backups to restore data of an ApsaraDB RDS for PostgreSQL instance.
You can restore ApsaraDB RDS for PostgreSQL data by backup set or by time. The procedure is as follows:
This topic describes how to back up an ApsaraDB RDS for MySQL instance by using the cross-region backup function. This function automatically replicates the backup files of the RDS instance from the source region to a specified destination region. The backup files in the destination region are used to manage and restore the RDS instance. In this case, the RDS instance is also known as the original RDS instance.
A simple, reliable, cost-efficient backup service for continuous data protection. Performs incremental backups in real time and lowers RPOs to several seconds.
Hybrid Backup Recovery (HBR) is a simple and cost-effective Backup as a Service (BaaS) solution. It protects customer data in a number of scenarios: enterprise level data centers, remote centers, branch offices, or on the cloud. HBR supports data encryption, compression, and deduplication, and helps you back up your data to the cloud securely and efficiently.
Migrate to the Cloud with 450K Database Instances Running | Get up to $100 Rebate and Free Backup Instances
How to Backup and Restore MySQL Database with mysqldump Command
2,599 posts | 763 followers
FollowAlibaba Clouder - August 1, 2019
AlenaS - February 8, 2022
Alibaba Clouder - July 31, 2019
Alibaba Clouder - August 2, 2019
AlenaS - May 13, 2021
Alibaba Clouder - February 24, 2020
2,599 posts | 763 followers
FollowMore Posts by Alibaba Clouder