无法导入gs://bucket_name/Cloud.sql [英] Failed to import gs://bucket_name/Cloud.sql

问题描述

我已将数据库所需的一切存储在phpmyadmin中，并从中导出了我的数据库.该文件另存为Cloud.sql，因此现在我将此SQL文件借助此链接 https://developers.google.com/cloud-sql/docs/import_export .

I have stored everything needed for my database in phpmyadmin , and exported the my database from it. That was saved as Cloud.sql , so now this sql file I imported it to the Google Cloud Storage with the help of this link https://developers.google.com/cloud-sql/docs/import_export.

现在，使用实例操作中存在的导入"选项导入.sql的内容之后，它显示绿色的工作符号，并且停止一会儿后，当我检查日志"时，它显示 无法导入gs://bucket_name/Cloud.sql:发生未知问题(ERROR_RDBMS) 所以 ， 我无法找出错误背后的原因(不清楚)，以及如何解决

Now after importing the Contents of .sql using the Import option present in the action of the instance, it shows the green working sign , and after a while it stops, when I check in the Logs , it shows Failed to import gs://bucket_name/Cloud.sql: An unknown problem occurred (ERROR_RDBMS) So , I am unable to find out the reason behind the error as its not clear, and how can this be solved

推荐答案

Google Cloud Sql可能不知道gs://bucket_name/Cloud.sql命令适用于哪个数据库.

Google Cloud Sql probably doesn't know to which database the gs://bucket_name/Cloud.sql commands apply.

来自 https://groups.google.com /forum/#！topic/google-cloud-sql-discuss/pFGe7LsbUaw :

问题是转储不包含要使用的数据库的名称.如果您在转储的顶部添加了"USE XXX"，其中XXX是您要使用的数据库，我希望导入成功.

The problem is the dump doesn't contain the name of the database to use. If you add a 'USE XXX' at the top the dump where XXX is the database you want to use I would expect the import to succeed.

这篇关于无法导入gs://bucket_name/Cloud.sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！