Friday, May 19, 2017

[google-cloud-sql-discuss] (CloudSql Import) Cannot import ERROR: ASCII '\0' .. Set --binary mode to 1

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 instead
gcloud beta sql instances import jamsai-analytics-sql gs://xxxxxx-bucket-01/xxxxxx-20170517-1803.tar.gz --database analytics
This 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.

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/b87970b8-4e88-4165-b864-f93574023763%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment