Importing Data

Generate test data by using the BenchMarkSQL tool to verify the data correctness and consistency after MySQL is migrated.

1. Log in to the primary database server.
2. Install BenchMarkSQL and ensure that all dependencies and configurations are correct. For details, see BenchMarkSQL Test Guide.
3. Import TPC-C data through BenchMarkSQL. The number of warehouses is 1,000 and the data volume is about 90 GB. For details, see steps 1 to 3 in Testing MySQL of BenchMarkSQL Test Guide.
   

   • If the following time zone problem occurs during data import, see Time Zone Problem Occurs When Data Is Imported to MySQL to solve the problem.

     ERROR: The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to       use a more specifc time zone value if you want to utilize time zone support.

   • If the message "Public Key Retrieval is not allowed" is displayed during data import, rectify the public key retrieval error by referring to Public Key Retrieval Error Occurs When Data Is Imported to MySQL.

     ERROR: Public Key Retrieval is not allowed

   • If the message "invalid number of terminals" is displayed during data import, rectify the invalid number problem by referring to "invalid number of terminals" Is Displayed When Data Is Imported to MySQL.