jmac11 / googlecloudsql

Automatically exported from code.google.com/p/googlecloudsql
0 stars 0 forks source link

Import of a mysqldump with (a lot of) binary data is silently ignored #22

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Import the file gs://zapcatelliebucket/laraappserver.sql
2. select count(*) from Changeset;

What is the name of your database instance?

zapcatellieinstance

What is the expected output? What do you see instead?

A number that is significantly larger than zero

Please provide any additional information below.

The above mentioned sql dump contains a LOT of binary data which normally works 
fine to import. However, although the log claims that the import has been 
successful, only the tables before Changeset contain data. Lack of error 
messages makes it hard to dig through this - initially some of the tables where 
dumped in a bad order, but as far as I can tell the current version doesn't 
have that problem.

Original issue reported on code.google.com by catel...@gmail.com on 24 Nov 2011 at 3:08

GoogleCodeExporter commented 9 years ago
Did you try creating the dump with --hex-blob ?
http://code.google.com/apis/sql/docs/advanced_tasks.html#importexport

Original comment by k...@google.com on 24 Nov 2011 at 3:15

GoogleCodeExporter commented 9 years ago
Oops, sorry. You are right, I missed that one, my fault. Some kind of error 
message would have been nice though...

Original comment by catel...@gmail.com on 24 Nov 2011 at 3:35

GoogleCodeExporter commented 9 years ago
Yes, the error reporting during import/export could definitely be improved in 
general.  We're working on it and tracking that separately.  Thanks for the 
feedback.

Original comment by k...@google.com on 24 Nov 2011 at 4:16