This document describes how to migrate data in the console or with the command line tool.
There are two modes for migrating data through the console: physical backup and logical backup. For more information, see the following documents:
Note:
- The data files exported using mysqldump must be compatible with the SQL specification of your purchased TencentDB for MySQL version. You can log in to the database and get the MySQL version information by running the
select version();
command. The name of the generated SQL file can contain letters, digits, and underscores but not "test".- Make sure that the same source and target database versions, source and target database character sets, and mysqldump tool versions are used. You can specify the character set using the parameter --default-character-set .
shell > mysqldump [options] db_name [tbl_name ...] > bak_pathname
Here, options
is the export option, db_name
is the database name, tbl_name
is the table name, and bak_pathname
is the export path.
For more information on how to export data with mysqldump, see MySQL official documentation.
2. Import data to the target database with the MySQL command line tool as follows:
shell > mysql -h hostname -P port -u username -p < bak_pathname
Here, hostname
is the target server for data restoration, port
is the port of target server, username
is the username of the database on the target server, and bak_pathname
is the full path to the backup file.
show databases;
command, and you can see that the backup database has been imported into the target database.This document uses a Linux CVM instance as an example. For more information on how to access a database from a CVM instance, see Accessing MySQL Database.
db_blog
database in TencentDB as an example:show databases;
command, and you can see that the backup database has been imported into the target database.For more information, see the character set description in Use Limits.
Was this page helpful?