Shulou(Shulou.com)06/03 Report--

How to upload local database files to the CVM? It's not particularly difficult, but why do users always like to upload local database files to the cloud server? Because it is more secure to store data files on CVM ecs than locally, it can be backed up in real time and is easy to recover. As a result, many users choose to migrate the database to the cloud.

Specific steps for database migration to CVM:

Step 1: shut down the database source

Step 2: export database backup

Step 3: data import and recovery

Step 4: change the configuration

Step 5: restore the database application

In the case of SQL Serve migration, the tools or commands to be used are Navicat Premium, sqlserver management studio, and full backup export data (file type bak)

If MYSQL is migrated, the tools or commands to be used are Navicat, Mysqldump, phpmyadmin, etc., and SQL is exported from the source side.

The CVM is a distributed storage system, with 4 copies of each data, combined with multiple snapshot backups to form a backup strategy to cover software and hardware failures, subvert the traditional operation and maintenance mode, and ensure data security in an all-round way.

If you want to know more about cloud products, you can visit the CVM product link https://www.yisu.com/cloud/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.