Why do I need to use the mysqldump or other tools to migrate databases?
The mysqldump tool is a common and easy-to-use database migration tool and is suitable for data migration with a small amount of data because it is likely to cause long-term database downtime.
The services provided by eSurfing Cloud RDS for MySQL are compatible with the original databases. The process for migrating the local database to the cloud database is the same as migrating the database from one server to another. You can also use other database migration schemes for database migration according to your needs.
What should I do if the binlog files generated during a database instance migration cause insufficient storage space?
The database instance will periodically clear the expired binlog. However, a large number of binlog files are generated in a short period of time during the migration process of the database instance, causing insufficient storage space and affecting the operation of the service. Before ordering an instance and migrating the database, refer to the recommendations:
• Clear expired data periodically.
• Consider the size of the data file and the size of the log file, and reserve some redundancy for the storage space when selecting the storage space size of the instance.
• If the original database disk capacity is insufficient, it is recommended that you scale up the disk space to ensure that the disk space is sufficient. For details, see User Guide-Instance Management-Storage Space Scaling.
How do I import data from another database engine into RDS for MySQL?
Importing or exporting data between engine databases of the same type is called homogeneous database import or export. Homogeneous database imports or exports can be implemented using database migration tools such as mysqldump.
Importing or exporting data between engine databases of different types is called heterogeneous database import or export. Generally, data cannot be directly exported or imported between heterogeneous databases due to the different data formats involved. Third-party software is usually required for import or export through data replication. For example, you can use the tool to export table records in text format from Oracle, and then use the Load statement to import them into the InnoDB engine.