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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With