Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

249 questions
1
vote
1 answer

'image upload' not writing to MySql database or public folder with Laravel 4.1 (with Croppa) on Fortrabbit

newbie alert! i’ve recently moved my Laravel site to Fortrabbit but when i post new images to the site, they do not write to the database or the upload\images directory. other changes such as posting text, adding users, changing passwords etc,…
zod
  • 131
  • 6
1
vote
1 answer

Installed different distro in Vagrant. Now can't SSH into MySQL

I was using Ubuntu precise32 and switched to 14.04. I use Jeffrey Way's setup (https://github.com/JeffreyWay/Vagrant-Setup) and that works. I can do 'vagrant ssh' and log in, and log into root with username/password root/root. When I try using…
Chris Farrugia
  • 1,024
  • 3
  • 17
  • 35
1
vote
3 answers

why isn't this if statement working in my query?

I am querying the database, and the query I wrote isn't working. I have researched using google, but made no progress. Help please! ${$name} = array(); ${$name} = $db->query('SELECT', " SELECT SUM(IF(`date`=‘2014-01’, `value`, 0.00)) as…
justjoe300
  • 81
  • 1
  • 9
1
vote
1 answer

How do I get the first 160 characters from a SQL query and remove HTML?

I've looked around to see if I could find a solution that directly addresses my question, but I can't seem to find it. I'm querying my old DB and creating a new table that I can import into my new DB. I want to create a new field named…
Vaughn D. Taylor
  • 617
  • 1
  • 8
  • 20
1
vote
1 answer

MySQL said: Table doesn't exist in Sequel Pro

I have created a GameCenter type database in sequel pro using root, but for some reason every now and again I get the following errors when connecting to the database and trying to access the tables: An error occurred while retrieving the…
James Baker
  • 331
  • 3
  • 8
  • 26
1
vote
2 answers

Error when try to create a VIEW in MySQL

I like Sequel Pro to handle MySQL databases on Mac. Now I'm triying to create a view with this: CREATE VIEW '_view_userlist' AS SELECT u.userid,u.fullname,u.username,e.userid,e.listid,e.title,e.status FROM users u LEFT OUTER JOIN list e ON…
junihh
  • 502
  • 1
  • 9
  • 25
1
vote
1 answer

Connecting to Remote MySQL using Sequel Pro and MAMP

I am trying to create a local development environment using MAMP that's connected to a remote MySQL database using Sequel Pro. I am connected to the remote database via an SSH connection in Sequel Pro. From what I understand I need to do some kind…
bruce_e_kinesis
  • 11
  • 1
  • 3
1
vote
0 answers

DROP TABLE not working?

I have tried relentlessly to drop a table, but it doesnt seem to work. It doesn't give me any error message, but it seems like its taking a long time (6+ hrs). The table has around 800K rows with two columns. Additionally, I can't even access the…
msakya
  • 9,311
  • 5
  • 23
  • 31
1
vote
0 answers

Is there any way I can import to Sequel Pro?

I have four files (.ldf; .mdf; fdb;.fbk)-files that I have to import to MySql using Sequel Pro. Is it possible for me to import those type of files and if not could it work with MySQL Workbench?
Eskipo
  • 51
  • 4
  • 10
1
vote
1 answer

Alert for MySQL jobs

This might be either a simple or exceedingly complex question and searching has produced no results. I use Sequel Pro on OSX to run a lot of queries some of which can take, e.g. >8 hours. A lot of times I can't predict how long a job will take,…
ben
  • 207
  • 3
  • 9
1
vote
1 answer

Import of older MySQL databases (5.6.10) into 5.6.12 generates errors

I created what I thought was a simple sql dump from the older database before installing the latest version, 5.6.12 on Mac OS X Server. Now I'm trying to import the files but they produce all produce endless numbers of syntax errors. Example of…
Levi
  • 301
  • 3
  • 12
1
vote
1 answer

Sequel Pro - Socket connection failed

I use Sequel Pro and MAMP on my Mac to develop wordpress sites locally. This morning when I tried to start up Sequel Pro it kept asking for my password to make changes (it has never done this before). I first tried rebooting my machine but it kept…
designlobby
  • 35
  • 1
  • 7
1
vote
1 answer

connecting to sequel pro database remote server via RMySQL

I'm running Sequel Pro 0.9.9.1 and can connect to a remote mySQL (v 14.14) database hosted on a server that only allows SSH connections. When I connect via Sequel Pro, I only need to fill out the ssh user and password to connect without issue. I am…
dhendrickson
  • 1,247
  • 1
  • 9
  • 8
0
votes
1 answer

ODBC Driver to Connect Sequel Pro to R

I'm attempting connect my Sequel Pro database to R. In Joseph Adler's "R in a Nutshell"- page 164- he lists various ODBC drivers for different databases, but I can't find one for Sequel Pro. Any help on which driver to use would be greatly…
Burton Guster
  • 2,213
  • 8
  • 31
  • 29
0
votes
3 answers

MySQL localhost confusion connecting via sequel

I'm trying to connect to my MySQL database using Sequel-Pro and I'm kinda confused what to use as my host. My hosting provider only gave me 'localhost' as my host then some user and password.
Pennf0lio
  • 3,888
  • 8
  • 46
  • 70
1 2 3
…
16 17