Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

249 questions
2
votes
1 answer

An error occurred while importing SQL [SQL Dump on Sequel Pro]

I'm getting an error while trying to import the SQL dump to sequel pro. I exported the dump from the production database. Here's the error I get is a dialog box An error occurred while importing SQL [ERROR in query 39572] Unknown system variable…
anasey
  • 169
  • 12
2
votes
3 answers

Can't connect local database. Sequel Pro encountered an unexpected error

Sequel Pro 1.1.2 + MacOS Mojave 10.14.5 + MySQL 8.0.16 (Homebrew) have a problem when trying to connect to local (and ONLY local) databases. It pops up a feedback dialog and a never ending progress bar. There is no problem when working with remote…
thelawnmowerman
  • 11,956
  • 2
  • 23
  • 36
2
votes
0 answers

Configuration of AWS with Sequel Pro

I am using Sequel Pro 1.1.2 in MacOS Mojave, when trying to configure the AWS database instance getting error as " Unable to connect to host vinay-awsdb.cinbpy8tpejb.eu-west-1.rds.amazonaws.com, or the request timed out. Be sure that the address is…
vinrt
  • 53
  • 8
2
votes
0 answers

Import CSV and Convert datatype in Sequel Pro (using mysql)

I am importing csv data to Sequel pro. One of the columns is called fees and it contains numbers like 1713.192938. In csv the datatype is set to General. When I import it to Sequel Pro the datatype changed to VARCHAR. The numbers will show up in the…
Chelsea
  • 21
  • 2
2
votes
1 answer

Export database with emoji

I would like to export my database with emoji, but I have a problem with the export. When I exported my table, the emoji are replaced by "?". For example : When I export, and import, I have this : I checked my table (utf-8) : I use Sequel Pro to…
Jérémie Chazelle
  • 1,721
  • 4
  • 32
  • 70
2
votes
1 answer

Updating the database schema

So I would like to update my dev version of my database from my live database, I've exported the live database's schema and when I try and import it into the dev database, it is giving errors saying the tables already exist. The tables have data in…
ImANobody
  • 29
  • 4
2
votes
1 answer

How can I pass command-line arguments when creating a new Database connection in SQLPro?

When I start my MySQL client from the command-line, I do the following: $ mysql -u root -p -h 127.0.0.1 --init-command="SET SESSION wait_timeout=300" I set the session wait_timeout to 300 seconds for security purposes. If there is no database…
Saqib Ali
  • 11,931
  • 41
  • 133
  • 272
2
votes
2 answers

Why won't my query let me assign primary key?

Just a note, I'm pretty new to SQL. I'm using MySQL and using the app SequelPro. I receive this error when I try to make a table: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right…
Sebastian
  • 957
  • 3
  • 15
  • 27
2
votes
2 answers

MySQL said: Host '10.10.10.121' is not allowed to connect to this MySQL server

In my office, there is a desktop computer which is CentOS7.2 system, there installed MySQL on it. and in my computer, I have a Sequel Pro on it. I want to use the Sequel Pro to connect the desktop computer's mysql. But there gets this error: Unable…
maer
  • 156
  • 3
  • 15
2
votes
1 answer

utf8mb4 characters lost in export/import in Sequel Pro

I'm using the Encoding UTF-8 Unicode (utf8mb4) and Collation utf8mb4_unicode_520_ci for both tables and fields in my MySQL database. When I export the database from Sequel Pro and open the exported .sql file in a text editor my test character …
SeaBass
  • 1,584
  • 4
  • 20
  • 46
2
votes
3 answers

MySQL error : Variable 'collation_connection' can't be set to the value of 'NULL' when dump .sql file

I got error Variable 'collation_connection' can't be set to the value of 'NULL' when using sequelPro to dump .sql file. Here is the beginning of my .sql file: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET…
yongyu
  • 97
  • 1
  • 8
2
votes
1 answer

What is the equivalent of sequel pro's just checking "connect using ssl" in mycli?

When using SequelPro, I have to check "Connect using SSL" option to connect to a remote mysql database server, but without providing "Key File", "Certificate" or "CA Cert", which is shown as the screenshot below: Is there an equivalent way to do it…
Bruce Sun
  • 631
  • 1
  • 10
  • 26
2
votes
2 answers

Local Backup of MySQL DB with Sequel Pro

I have a MySQL database stored on AWS. I'm using Sequel Pro to manage it. I want to make a local copy for backup. In Sequel Pro, I see an option to File -> Export. I'm selecting SQL as the format. By default, the option to "Include Drop Table…
Leigh Scherrer
  • 123
  • 2
  • 7
2
votes
4 answers

Can't connect to MySQL using SequelPro

I have recently installed MySQL 5.7.16 on an iMac running El Capitan. I had a few minor hiccups initially because I forgot the root password but that has now been reset and I can now log into MySQL as root user using: $ mysql -u root -p However,…
user1718097
  • 4,090
  • 11
  • 48
  • 63
2
votes
1 answer

How do I load geonames.org dataset in mysql

I am having an issue loading the geonomes data set. Heres my process: first i create my database GEONAMES then i create my table: CREATE TABLE `geoname` ( `geonameid` int(11) NOT NULL, `name` varchar(200) DEFAULT NULL, `asciiname` varchar(200)…
Luna
  • 537
  • 1
  • 12
  • 26
1 2 3
…
16 17