将Heroku中的sql文件转储到ClearDB [英] Dump sql file to ClearDB in Heroku

问题描述

我有一个sql文件，我想使用ClearDB插件将其转储到Heroku中的MySQL数据库中。当在本地进行倾销时，我执行以下操作：

  mysql -u my_user -p mydatabasename< my_dump_file.sql 
  

然而，我不知道如何将它转储到Heroku MySQL数据库。我所知道的是这个地址：

  mysql：// b5xxxxx7：[e-mail]/heroku_xxxxxx ？reconnect = true 
  

但是，如果我尝试做：

  mysql：// b5xxxxx7：[e-mail]/heroku_xxxxxx？reconnect = true< my_dump_file.sql 
  

我得到没有这样的文件或目录。

我应该怎么做？ >你也许可以做这样的事情

  mysql --host = us-cdbr-east.cleardb.com  - user = b5xxxxx7 --password = 37d8faad --reconnect heroku_xxxxxx< my_dump_file.sql 
  

I have a sql file that I want to be dumped into a MySQL database that I have in Heroku using the ClearDB addon. When dumping in local I do the following:

mysql -u my_user -p mydatabasename < my_dump_file.sql

However, I don't have any clue on how to dump it to the Heroku MySQL database. All I know is this address:

mysql://b5xxxxx7:[e-mail]/heroku_xxxxxx?reconnect=true

But if I try to do:

mysql://b5xxxxx7:[e-mail]/heroku_xxxxxx?reconnect=true < my_dump_file.sql

I get No such file or directory.

How am I supposed to do it?

解决方案

You might be able to do something like this

mysql --host=us-cdbr-east.cleardb.com --user=b5xxxxx7 --password=37d8faad --reconnect heroku_xxxxxx < my_dump_file.sql

这篇关于将Heroku中的sql文件转储到ClearDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！