Is your file a gzipped .sql file? Was this uncompressed file created with mysqldump? Where did this file come from?
On Friday, May 19, 2017 at 9:15:49 AM UTC-4, Michael Chambers wrote:
-- On Friday, May 19, 2017 at 9:15:49 AM UTC-4, Michael Chambers wrote:
I was trying to import an sql dump file. However I have this error when I import file from 'cloud storage bucket'
ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: 'xxxxxx-20170517-1803.sql'.Then i tried using the shell insteadThis will then give the same error previously. So I added --binery-mode 1 to the end of the command, which turns out gcloud not supported it.
gcloud beta sql instances import jamsai-analytics-sql gs://xxxxxx-bucket-01/xxxxxx-20170517-1803.tar.gz --database analytics
ERROR: (gcloud.beta.sql.instances.import ) unrecognized arguments:
--binary-mode
1
Any suggestion method to import the database?
Currently the import file is compressed at 5GB, It will be very trouble some to modify
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/60f6888d-d452-424f-995a-fc0b5050715b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment