Data migration to Rds-mysql using the RDS management Console

MySQL using the RDS management Console
Data migration to Rds-mysql using the RDS management Console
This method is a kind of MySQL online migration method, can not stop service to complete the migration of the database, support MySQL 5.1 5.5, 5.6 (5.0 version only support full-scale migration) migration. More information on migration can be found in: how to quickly and smoothly move into rds>>
Migration considerations
1) The MySQL system library will not be allowed to migrate to RDS and the databases that are not allowed to migrate include
: Mysql,information_schema,perfermance_schema. These databases will not be displayed in the migration list;
2) does not support the migration of stored procedures and functions, if there are stored procedures and functions in the library to be migrated, will ignore the migration;
3) The self-built database must have the same name as the database in the RDS instance. Otherwise, the self-built database is "temporarily not migrated" status;
4) Self-built library migration account password is not allowed to contain%￥#! and other special characters;
5) The use of DDL operations such as creating tables, deleting tables, modifying indexes, etc. is prohibited in migration;
6) The view of the self-built database cannot be migrated to RDS and requires you to recreate it.

Migration steps
1) Create a migration account in the built-in database
Command format:
Grant all privileges the db.* to ' userName ' @ '% ' identified by ' password ';
Note: a) Username:mysql database account number, B) password:mysql the password of the database account.
2) Set the migration account permissions

Command format:
Grant Super,process,select,reload,lock tables,replication slave,replication Client on * * to ' userName ' @ '% ';
Note: This command gives the database account username Super, process, select, reload, lock tables, replication
Slave, replication client permissions.
3) Verify that the configuration file in the built-in database is correct
Verify that the MySQL configuration file my.cnf has the following settings:

A) Open binary log, log_bin=mysql-bin;
b) Set the Binlog format to "ROW" mode, Binlog_format=row;
c) server_id to be greater than 1, such as server_id=2;
d) Restart the MySQL process after the modification is complete.

4) Log in to the built-in database and see if it is "ROW" mode by command
Execute command:
Show variables like ' binlog_format% ';

In the corresponding instance page of the RDS Management console, click the "Migrate Data to RDS" button and fill out the database connection to be migrated in the popup box.
Database connection port, database account, database password, as shown in:
Note: If your table is the MyISAM engine, regardless of whether the lock table is selected, the migration process will lock the table, the next version we will provide
MyISAM does not lock the table support.

This article from "My Sky" blog, declined reprint!

Data migration to Rds-mysql using the RDS management Console