Instance: db-n1-standard-1 - 200gig - us-central - Second Generation
I have a mysql database on an external production server I'm trying to get into Google Cloud SQL. It's approx 130 gigs (uncompressed).
I dumped the file - moved to google storage - ran the import. I got a notification during the import with a "unknown error". I was watching the storage meter, and it kept increasing so it appeared as though it was still processing.
It apparently picked itself back up and completed successfully.
If I go into the "Operations" tab for the instance, it makes no mention of the "error" notification (that is still available with a "RETRY" option from the notifications area at the top of the page), but instead says "Import from gs://[bucket_name]/mysqld.sql.gz succeeded."
I exported the binlog changes and ran it in the same fashion. Another error in notification but it appeared to continue. Operations tab again has a successful message with no mention of any errors.
This is a large dataset. Not sure how to validate that all is well, or which notification I should trust..
Any suggestions?
Sorry :(
There's a known issue with the status timing out in the notification panel and showing an error. You can trust the status in the operation list.