Stack Overflow
Stack Overflow

Questions tagged [cleardb]

ClearDB is a reliable, fault tolerant database-as-a-service for MySQL. It is also a heroku addon for mysql databases

ClearDB is a heroku addon for managing databases.

More info here: https://devcenter.heroku.com/articles/cleardb

247 questions
1
vote
1 answer

MySQL id not saving in order (Laravel in production)

Hi guys! I'm really confused about this.. So, I created a Laravel app and hosted it on Heroku. I'm using ClearDB extension to be able to use MySQL. Problem is: when I save a new User on my DB, it is not being saved in ID order. I got id 1, then id…
GabrielLearner
  • 25
  • 5
1
vote
0 answers

How do i make laravel auto incement work on clear db

I just deployed my laravel app to heroku. I am using clearDB as MySQL database. The problem is that my migration files work perfectly locally. But when i try to migrate to clearDB database, instead of auto incrementing my primary keys, it just…
Precious Aang
  • 53
  • 1
  • 4
  • 12
1
vote
0 answers

Do you know what CDTU means?

I'm new to ClearDB. In the dashboard is one gauge called CDTU. What does CDTU mean? I already googled but cant find anything. Thanks!
Felix
  • 23
  • 6
1
vote
1 answer

MySQL Workbench and SEQUEL Pro create primary key alphabetically

I have connected with my database through two programs: MySql Workbench and Sequel Pro (It's a ClearDB MySQL database hosted on heroku). I have created a simple table: CREATE TABLE Country( CountryID int AUTO_INCREMENT NOT NULL, Name…
Dominika
  • 187
  • 3
  • 13
1
vote
0 answers

Error fetching SQL with Heroku ClearDB PHP Application

New to PHP and trying out Robin Nixon's social app. I've successfully deployed the app to Heroku but I get the below error when trying to create a new user account. It was working just fine when I was running locally. I am using ClearDB as my MySQL…
user2414833
  • 11
  • 1
1
vote
1 answer

Every time I "git push heroku master" it empties out my cleardb database

I've been testing my routes in postman through my heroku url by adding posts and users. But everytime I find an error, fix it, and push to heroku again it empties out my cleardb database. I use my getmapping route and it just returns an empty array.…
chaosgirly7
  • 21
  • 2
1
vote
0 answers

Cannot run program "mysqldump": error=2, No such file or directory: mysqldump does not seem to exist on Heroku ClearDB

When I try to run mysqldump ... (all the missing parameters are correct for me) in a Heroku worker dyno with ClearDB support, I get this error message SEVERE: null 9-09-01T13:16:14.618354+00:00 app[worker.1]: java.io.IOException: Cannot run program…
coderodde
  • 1,269
  • 4
  • 17
  • 34
1
vote
1 answer

Cannot connect to cleardb from flask app running on heroku

I'm learning flask etc. and created a simple app locally. Everything worked fine with a local mysql database in xammp. I exported this and imported into clearDB on heroku and deployed my app. The app runs, but whenever I try to access a page relying…
JamesB
  • 61
  • 2
  • 5
1
vote
0 answers

Unable to connect to my ClearDB MySQL using from Heroku with MySQL Workbench

As title says, I am unable to connect to the database I created using ClearDB user information in the mysql workbench, however I am able to connect to my local / root database. I inputted username, password,hostname and port. I use port 3306.
bobb1213131
  • 277
  • 1
  • 5
  • 16
1
vote
1 answer

PHP and MySQL connection seems to be working, but table is not updating

I'm using the following code to insert into a MySQL table. I have done some manual testing to determine the variables are all setting correctly. The code is executing the success statement and when I check Heroku logs, it gives status 200. Yet, when…
Brian Hart
  • 74
  • 7
1
vote
0 answers

Heroku No such file or directory in /app/index.php on line 4

2018-08-26T11:53:04.010859+00:00 app[web.1]: [26-Aug-2018 11:53:04 UTC] PHP Warning: require(Connect/Connect.php): failed to open stream: No such file or directory in /app/index.php on line 4 2018-08-26T11:53:04.011186+00:00 app[web.1]:…
Anupam Seal
  • 26
  • 3
1
vote
0 answers

How to issue the SET NAMES on Hibernate Query

I have a problem now. I am using Clear db through Azure. I am not able to store the UTF8 characters to the table. I am using the Spring+Hibernate+Mysql combination. I can make it work locally by updating the my.cnf file but on Azure it is not…
Shams
  • 557
  • 8
  • 15
1
vote
1 answer

Can't connect to MySQL from bash on Heroku for ClearDB

I am trying to access my ClearDB MySQL database on Heroku via mysql. I am using Cloud9 to access Heroku and push my code. I have set up a ClearDB MySQL Ignite as per Heroku's "getting started" guide. The app I am trying to run had some scripts to…
Furrukh Jamal
  • 142
  • 3
  • 14
1
vote
1 answer

Not able add free Ignite clearDB to Heroku app

I am not able to add free Ignite clearDB to my Heroku app. It asked for to give credit card information. Terminal: Not sure how to add it not providing the credit card information. please help.
Ashis Laha
  • 2,176
  • 3
  • 16
  • 17
1
vote
1 answer

Can't add MySQL database to ClearDB, -u command not found

Doing the following, I am unable to import a MySQL database to ClearDB: $mysql -u b4587523b48993 -h us-cdbr-iron-east-05.cleardb.net -p heroku_571df93b7623da9 < ./sql/sql_import.php Whenever I try I get the error -u: command not found If I put…
Derp
  • 143
  • 1
  • 2
  • 11
1 2 3
…
16 17