Re: Failed to import from Cloud Storage as of June 6th

I separated the structure import from the data import and made it work. I´d try that!

Den måndagen den 11:e juni 2012 kl. 06:28:58 UTC+2 skrev Abhishek Mathur:

Did you checked for foreign key dependencies, that might be preventing your table from getting dropped.
 Does your dump file contains options to disable foreign key checks?

On Fri, Jun 8, 2012 at 1:23 PM, Wilco Tomassen <wi...@cleverfranke.com> wrote:

Hi Razvan and Tony,

Thank you for your reply, the dump file does include a database selection command (USE `google_ccb`;)

Wilco

On Thu, Jun 7, 2012 at 5:31 PM, Razvan Musaloiu-E. <raz...@google.com> wrote:

The import fails with the following error:

Could not execute statement: DROP TABLE IF EXISTS `abs_metric_cache`

Does your dump properly selects the database (USE ...)?

-- Razvan ME

On Thu, Jun 7, 2012 at 7:25 AM, Wilco Tomassen <wi...@cleverfranke.com> wrote:

Hi,

The instance is consumerbarometer:ccb 

On Thu, Jun 7, 2012 at 4:09 PM, Tony Tseng <t...@google.com> wrote:

Hi,

What is the name of your cloud sql instance?

On Thu, Jun 7, 2012 at 3:27 AM, wilco <cfwilco...@gmail.com> wrote:

As of yesterday (June 6th 2012), the process of synchronizing my development database ( MySQL 5.1 on Debian Squeeze) to Google Cloud SQL (MySQL 5.5) permanently results in the error Failed to import gs://effectivemysql/dump1.sql: An unknown problem occurred (ERROR_RDBMS), while this has worked flawlessly for the last 2 months.

The shell script I use to create and transfer the dump to Google Cloud Storage:

clear

echo "Creating dump of database"

echo "MySQL root password required"

mysqldump -v -u root -p --databases my_database > /root/my_database.sql

echo "Database dump done, gzipping output"

gzip -1 /root/my_database.sql

echo "GZipping done, starting transfer to Cloud Storage"

gsutil cp /root/my_database.sql.gz gs://my_bucket/

echo "Transfer done, removing dump file"

rm /root/my_database.sql.gz

echo "Done"

I've tried separate tables, no gzipping, other mysqldump options (complete inserts, skip-comments etc), to no avail. The generated dump files have also been imported to other database without problems, just Cloud SQL seems to have this problem.

--
Met vriendelijke groet,

Wilco Tomassen

--
Met vriendelijke groet,

Wilco Tomassen