Error during migration process using GCP's Database Migration Service for MySQL

user_14638532 0
Viewed 666

I'm receiving the following error during migration process using GCP Database Migration Service for MySQL:

failed to run mysqldump: import err = generic::unknown: exit status 1 ERROR 1045 (28000) at line 46092: Access denied for user 'cloudsqlimport'@'127.0.0.1' (using password: NO), mysqldump error = exit status 5, stderr: mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Got errno 2 on write

How can I solve that?

google-cloud-sql database-migration google-cloud-platform
2 Answers
user_146385320

One solution is to do the migration manually.

Run mysqldump yourself to a file.

Then load this text file back into the new database.

Check out this blog.

user_128877560
Related