Document Center
Search Search by Current Product
  • remote login
  • data migration
  • reset password
  • MySQL
  • server
  • Document Center
  • ApsaraDB for RDS
  • Product Usage
  • Backup recovery

    ApsaraDB for RDS

    • Product Introduction
      • What is RDS
      • Benefits
        • Inexpensive and easy-to-use
        • High performance
        • High reliability
        • High security
        • Comparison between ApsaraDB for RDS and local databases
      • System architecture
        • Data link service
        • High-availability service
        • Backup and recovery service
        • Monitoring service
        • Scheduling service
      • Product series
        • Product series overview
        • Basic Edition
        • Cluster Edition (AlwaysOn Edition)
      • Instance types
        • Instance type overview
        • Instance type list
      • Storage types
      • Typical applications
        • Diversified data storage
        • Open search
        • Read/write splitting function
        • Big data analysis
      • RDS usage instructions
    • Purchase Guide
      • Billing items and billing methods
      • Billing details about configuration change
      • Renewal
      • Impact of expiration and overdue payment
      • View purchase details
    • Quick Start for MySQL
      • Limits
      • General process to use RDS
      • Create an instance
      • Initial configuration
        • Set the whitelist
        • Apply for an Internet IP address
        • Create accounts and databases
      • Connect to an instance
      • Scale instances
        • Read-only instance
          • Introduction to read-only instances
          • Create a read-only instance
        • Disaster recovery instances
    • Quick Start for SQL Server
      • Limits
      • General procedure to use RDS
      • Create an instance
      • Initial configuration
        • Set the whitelist
        • Apply for an Internet address
        • Creating accounts and databases
          • Create accounts and databases (SQL Server 2008 R2)
          • Create accounts and databases (SQL Server 2012 or 2016)
          • Create accounts and databases (SQL Server 2017)
      • Connect to an instance
      • Read-only instances
        • Introduction to read-only instances
        • Create a read-only instance
      • Function differences between SQL Server versions
      • API differences between SQL Server versions
      • Stored procedures
    • Quick Start for PostgreSQL
      • Limits
      • General procedure to use RDS
      • Create an instance
      • Initial configuration
        • Set a whitelist
        • Create database and account
      • Connect to an instance
      • Read/write external data files using oss_fdw
      • Appendix
        • Appendix: User and schema management
        • Release notes
      • Apply for an Internet IP address
    • Quick Start for PPAS
      • Limits
      • General procedure to use RDS
      • Create an instance
      • Initial configuration
        • Set a whitelist
        • Create databases and accounts
      • Connect to an instance
      • Read/write external data files using oss_fdw
      • Appendix
        • User and schema management
        • PPAS development driver
        • Appendix: PPAS compatibility description
        • Common management functions
      • Apply for an Internet IP address
    • Quick Start for MariaDB TX
      • Create an instance
      • Initial configuration
        • Set the whitelist
        • Apply for an Internet IP address
        • Create accounts and databases
      • Connect to an instance
    • User Guide
      • Preface
      • Quick start
      • Data migration
        • Migrate from other cloud databases to ApsaraDB RDS
        • Use mysqldump to migrate MySQL data
        • Migrate RDS data to the local database
          • Migrate RDS for MySQL data to a local MySQL database
          • Migrate RDS for SQL Server data to a local SQL Server database
          • Migrate RDS for PostgreSQL data to a local PostgreSQL database
          • Migrate RDS for PPAS data to a local Oracle database
          • Migrate RDS for PPAS data to a local PPAS database
        • Compress data
        • Use psql to migrate PostgreSQL data
        • Migrate SQL Server to cloud
          • Migrate data to RDS for SQL Server 2008 R2
          • Migrate data to RDS for SQL Server 2012/2016
        • Migrate a MySQL database from Tencent Cloud to Alibaba Cloud
        • Migrate a MySQL database from Google Cloud to Alibaba Cloud
      • Billing management
        • Change the billing method
        • Enable auto-renewal for a Subscription instance
        • Manually renew a Subscription instance
      • Instance management
        • Restart an instance
        • Configure the maintenance period
        • Migrate instance across zones
        • Switch between master and slave instances
        • Modify the data replication mode
        • Create a read-only instance
        • Release an instance
        • Upgrade the database version
        • RDS for MySQL release notes
        • Change configurations
        • SQL Server DBCC function
        • End connections for SQL Server instances
        • Set instance parameters
          • Set parameters through the RDS console
          • Use SQL commands to set parameters
      • Read/write splitting
        • Introduction to read/write splitting
        • Enable read/write splitting
        • Modify the latency threshold and read weights
        • Switch read/write splitting address type
        • Disable read/write splitting
        • Monitor read/write splitting performance
        • Test read/write splitting performance
        • Verify read/write splitting effect
          • Use SQL audit to verify read/write splitting effects
          • Use internal SQL statements to verify read/write splitting effects
        • Verify read weight distribution
        • Rules of weight distribution by system
      • Account management
        • Create an account
        • Reset the instance password
        • Change account permissions
        • Authorize a service account
        • Delete an account
        • Manage the LOGIN user for SQL Server instances
        • Manage users for SQL Server instances
      • Database management
        • Create a database
        • Delete a database
        • Copy a database for SQL Server
          • Copy data between instances
          • Copy a database to SQL Server 2008 R2
          • Copy a database to SQL Server 2012 or later
        • Manage databases of SQL Server instances
      • Connection management
        • Set the access mode
        • Set network type
        • Hybrid access solution for smooth migration from classic networks to VPCs
        • Set intranet and Internet addresses
      • Monitoring and Alarming
        • Set the monitoring frequency
        • Set monitoring rules
      • Security
        • SQL audit
        • Switch the IP whitelist to enhanced security mode
        • Set the whitelist
        • Set SSL encryption
        • Set TDE
      • Log management
      • Backup
        • Back up RDS data
        • View the free quota of the backup space
        • Download data and log backup files
        • Logical backup and recovery for PPAS
      • Recovery
        • Create a clone instance
        • Recover data directly to an instance
        • Recover data to the master instance through a temporary instance
      • Tag management
        • Create tags
        • Delete tags
        • Filter instances by tag
      • Typical applications
        • Cached data persistence
        • Multi-structure data storage
      • Appendix
        • Commonly used SQL statements for MySQL
        • View intranet/Internet IP addresses and port number of an instance
    • Performance White Paper
      • For MySQL
        • Product overview
        • Test approach
          • Test environment
          • Test tool
          • Test commands
          • Test model
          • Test indicators
        • For MySQL 5.6
          • Instance types
          • Test result
      • For SQL Server
        • Product overview
        • Test approach
          • Test environment
          • Test tool
          • Test approach
          • Test model
          • Test indicators
        • Test result
          • SQL Server 2008 R2 High-Availability Edition
          • SQL Server 2012 Enterprise edition
    • Security White Paper
      • Product overview
      • Security solutions
        • Access control
        • Network isolation
        • Data Encryption
        • Backup and recovery
        • Disaster tolerance
        • Software upgrade
        • Service authorization
    • Best Practices
      • MySQL
        • Precautions on comparing ECS user-created databases and ApsaraDB for RDS instances in terms of performance
        • Select and create an optimal index for faster data access
        • Parameter optimization for MySQL instances
      • SQL Server
        • Use SSMS and BCP to migrate a SQL Server database
      • PostgreSQL
        • CREATE DATABASE usage instructions
        • Set the localized information and string sorting rules for a database
        • Functions and usage of PostgreSQL UPSERT
        • Update, delete, and insert data in batches
        • Locate the SQL statements with the greatest resource consumption
    • API Reference
      • API overview
      • Use APIs
        • Public parameters
        • Request structure
        • Signature
      • Instance management
        • CreateDBInstance
        • DeleteDBInstance
        • RestartDBInstance
        • RenewInstance
        • View instance attributes
        • View the RDS instance list
        • Change the RDS instance type
        • View RDS region and zone information
        • View RDS zone information and data replication statuses
        • Migrate RDS instance zone
        • Clear RDS instance logs
        • Upgrade the database version of RDS instance
        • Modify the description of an RDS instance
        • Modify the RDS instance maintenance time
        • Modify the instance data replication mode and high availability switching rules
        • Switch between the master and slave databases of an RDS instance
        • Create a read-only instance
      • Database management
        • Create a database
        • Delete database
        • View the database list
        • Modify database remarks
        • Copy a database for SQL Server 2008 R2
        • Copy databases between instances
      • Read/Write splitting
        • Apply for a read/write splitting address
        • Check system-distributed weights
        • Modify the basic information of read/write splitting
        • Release a read/write splitting address
      • Account management
        • Create an account
        • Delete an account
        • View the account list
        • Grant account permissions
        • Revoke account permissions
        • Modify account description
        • Reset the instance password
        • Reset an account
      • Security management
        • View the IP address whitelist of an RDS instance
        • View SSL information
        • View the data encryption status of an instance
        • Modify SSL links of an instance
        • Modify the data encryption status of an instance
        • Modify the IP address whitelist of an RDS instance
      • Network management
        • Apply for an Internet connection string
        • View all connection strings
        • Change the expiration time of the original classic endpoint
        • Modify connection string
        • Modify the network type of an RDS instance
        • Release an internet connection string
        • Apply for an intranet connection string (Originally, switch between the intranet and Internet)
      • Log management
        • View the slow log list
        • View slow log details
        • View error logs
        • View binlogs
        • Query whether SQL audit is enabled
        • ModifySQLCollectorPolicy
        • Query SQL audit logs
        • Query the SQL audit file list
      • Backup and recovery
        • Create backup
        • Clone RDS instances
        • View the backup list
        • Create a temporary instance
        • View the backup policy
        • Modify the backup policy
        • Recover a backup set to an instance
        • Delete data backup files
        • View log files
      • Migrate SQL Server to the cloud
        • Create a task of migrating data to RDS
        • Get the task list of migrating data to RDS
        • Check the file details about the task of migrating data to RDS
      • Monitoring management
        • View instance resource usage
        • View instance performance data
        • Query monitoring behaviors
        • Modify monitoring behaviors
      • Parameter management
        • View database parameter templates
        • View the list of currently running instance database parameters
        • Modify the database parameter list
      • Data migration
        • Obtain a file upload address
        • View the database file list
        • View the import list
        • Migrate from other RDS instances
        • CancelImport
      • Tag management
        • Bind tags
        • Query tags
        • Unbind tags
      • Appendix
        • Client error code table
        • Server error code table
        • Instance status table
        • Performance parameter table
        • Forbidden keywords table
    • SDK Reference
      • SDK reference
    • FAQs
      • Network/IP
      • Functions and billing methods
    • Technical Operation and Maintenance
      • Use MySQL
      • Use SQL Server
      • Use PostgreSQL
      • Network connection
    • Product Usage
      • Backup recovery
      • Use DMS
      • Console
      • Performance monitoring
    • General Reference
      • Guidelines for the use of documentation
        • Alibaba Cloud documentation
        • Instructions for open source documentation
          • Open-Source Documentation Code of Conduct
          • Editing Open-Source Documentation
      • Alibaba Cloud console
      • Regions and Zones
      • Service limits
      • Best practice of primary account security
      • Create an AccessKey
      • ICP Filing
      • Glossary
  • How to back up databases on ApsaraDB for RDS to ECS
Free Trial Free Trial