The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
27 views

Cannot locally import UTF-8 encoded SQL database on Mac

I was importing a confirmed UTF-8 encoded SQL database into Sequel Pro on Mac and got thrown this error halfway through: An error occurred when reading the file, as it could not be read in the ...
2
votes
3answers
776 views

Mac OS X 10.10 mySQL 5.6.26 accessible from CLI but not port 3306

I did a fresh install of mySQL 5.6.26 on my Mac today. I was able to access mySQL from Terminal.app as expected, however I could not get mySQL workbench to attach to 127.0.0.1 port 3306. What really ...
2
votes
1answer
38 views

unable to shutdown mysql server

I am using yosemite, if that matters. I have tried using the system preferences and then shutting down mysql there, but to no avail. I also tried typing killall -9 and -11. Both failed :(. I also ...
2
votes
1answer
67 views

How to download Oracle Database 11g release 2 for Mac OS

I have been trying to download Oracle Database 11g release 2 for mac os but in the given link by oracle I can only see Linux x86 and Linux x86-64. Is this ok to use this Linux file for installing ...
0
votes
1answer
83 views

Oracle database for learning purposes

I would like to know if I can download Oracle Database on my Mac OS X and use it for learning purposes? I know that Oracle Database Express Edition 11g is free, but is it free for OS X?
0
votes
1answer
24 views

Change MySQL default installation directory in OS X

I install mysql in default installation directory /usr/local/mysql Is it possible to change mysql installation directory to another path? I am running OS X 10.10 & MySQL 5.6
0
votes
0answers
45 views

Start MySQL Server in mac

I do not install mysql in /usr/local/mysql/ i move mysql to other folder when i start mysql server from terminal by this command: sudo MySQLDir/support-files/mysql.server start return me ERROR! ...
0
votes
1answer
196 views

How do I change the MySQL data folder path in a Mac?

How do I change the MySQL data folder path in a Mac? I am running OS X 10.10 & MySQL 5.6 In Windows I can edit datadir in my.ini For Mac, mysqld does not have parameter for --defaults-file=
0
votes
1answer
51 views

How to peer to a new domain?

How do I peer to a new domain? I'm using NuoDB on MacOS http://dev.nuodb.com/download-nuodb/request/download
1
vote
1answer
44 views

MySQL, can't find MYD files on OS X, MAMP

Try as I may I can't find the data files for my MAMP installation! FRM files are here: /Applications/MAMP/db/mysql/database_name/ but, there are no corresponding MYD or MYI files anywhere. The ...
1
vote
1answer
96 views

Can't connect to EC2 Postgresql instance unless I change the default port 5432 [closed]

I just created a brand new EC2 instance with a default security group allowing All Traffic from Anywhere. My listen_address is set to * I can SSH to it but I can't connect to the pgsql instance ...
1
vote
1answer
94 views

Installing PostgreSQL and PostGis on Mac OS X

I downloaded and installed PostgreSQL and PostGis from http://www.kyngchaos.com/software/postgres, I work on OS X 10.10. When I go into the terminal now and type psql it says -bash: psql: command ...
0
votes
0answers
474 views

pg_hba.conf and postgresql.conf in old installation directory

I have installed the PostgreSQL 9.4 on my MacBook via MacPorts, and I am trying to edit pg_hba.conf, but I don't see it in my current installation. Furthermore, psql is reporting that config_file is ...
0
votes
0answers
176 views

How to automatically start MySQL server on Mac OS X 10.10.2

I installed MySQL 5.6 using dmg on Mac OS X 10.10.2. I also installed the Preference Pane. I checked the checkbox "Automatically Start MySQL Server on Startup". But every time I start the computer ...
0
votes
0answers
43 views

Does Postgres shutdown gracefully when I restart my Mac?

When I restart my Mac OS X computer, I assume the daemon controlling Postgres (the "Postmaster" as I recall) is notified by the OS and performs a graceful shutdown of any running databases with ...
0
votes
1answer
494 views

Change MAMP to use a lower Mysql 5.1 version

I need to have the same development environment for my PHP program. My clients test server is running on Mysql 5.1 while my local is using MAMP running Mysql 5.5. How do downgrade my mysql database ...
1
vote
1answer
325 views

mysqldump drop create use case sensitivity

Dumped sql from MySQL is showing inconsistencies in the name of the database. Using the following bog standard method to dump a database: mysqldump --add-drop-database -u someuser --databases ...
0
votes
1answer
117 views

installing mysql 5.1 alongside mysql 5.5

mysql 5.5 is installed. I need 5.1 to install an old website so it can be updated. The installer refuses to let me install onto the disk with 5.5. I don't have any other disks. I downloaded the ...
1
vote
1answer
899 views

Issue when connecting to open shift via mysql workbench on Mac

I am trying to connect to open shift with mysql workbench on an iMac. A colleague has shown me his setup on Windows which looks exactly as follows (other than the usernames / passwords changing) ...
0
votes
0answers
1k views

How to fix “Access denied for user 'root'@'localhost'” error for MySQL using Mac OS X?

After reading a few of the similar problems to mine and none of them working, I thought I'd attempt to be more specific to see if my root problem needed to be fixed differently than the others. I've ...
0
votes
1answer
1k views

pgAdmin on a fresh OS X Server installation

I know for sure postgresql is running (checked with ps ax), but when I install pgAdmin and try to make a server connection to localhost I get this error: Server doesn't listen The server doesn't ...
6
votes
1answer
687 views

Is there a psql equivalent of bash's reverse-search-history?

I am very fond of bash's reverse-search-history (C-r) (command-line feature): Search backward starting at the current line and moving ‘up’ through the history as necessary. This is an incremental ...
4
votes
2answers
8k views

SQL Server on Mac

Can SQL Server engine express edition be installed in a Mac OS? I use a MacBook at home and would like to use it as a testing/learning platform for SQL Server.
2
votes
1answer
66 views

What does 'Vacuum' do in Menial's Base 2 application?

I've had a look at the help documentation for Base 2, as well as Menial's product page, but haven't found an answer there. I've even clicked on the vacuum button and not noticed any change. What does ...
1
vote
1answer
542 views

Connecting to a MySQL database on Mac from a VMWare fusion Virtual Machine

I have MariaDB (5.5.34-MariaDB) installed on a Mac (OS 10.8.5) I can connect to the database fine locally (127.0.0.1) on port 3306. But when I try to connect to the database from windows 7 64bit ...
3
votes
1answer
1k views

What PL/pgSQL debugger can I use?

I'm building a lot of PL/pgSQL functions and a debugger would really come in handy because RAISE NOTICE is not enough. I read about a pgAdmin plugin you can install but it was only on Windows and I'm ...
1
vote
0answers
205 views

MySQL database problems all of a sudden— users' programs can't connect, I saw error 2013, error 32

I am editing my problem, based on what I've researched and done: Hi This is mysql running on an osx server. We suddenly have an issue where only one of anything can seem to connect to mysql at ...
0
votes
0answers
211 views

Can’t connect to local PostgresSQL server

I have the Postres app installed an running on my Mac. And it has worked beautifully. I don’t know what changed, but now I cannot connect to it from Rails, PG Commander, PG Admin or the command psql ...
2
votes
1answer
7k views

Can't remote access MySQL server running on Mac OS X

I have a MySQL server running on my work computer, which runs Mac OS X Maverick. I want to access it from home computer, which also has Mac OS Maverick. From terminal, if in 1 tab, I ssh into my ...
0
votes
1answer
839 views

Connecting to remote oracle db

I am very new to system and db admin stuffs. Infact, I need to have my skills more improved in those areas. Anyways, I was trying to connect to a remote oracle database and use php oci8 library to ...
2
votes
1answer
94 views

Why does PostgreSQL require its own user/group for installation?

When installing PostgreSQL via MacPorts (and I assume via other means too), a postgres:postgres user/group is created. Are there any reasons why this user/group is needed?
0
votes
1answer
4k views

“SQL1042C An unexpected system error” when creating a database

I installed DB2 Express-C 10.1 on OS X 10.8.4. I installed it in user mode, and it seems to have created an instance with my username (avernet). I checked the instance is indeed there by running ...
2
votes
0answers
326 views

Remove Mac OSX Lion pre-installation of PostgreSQL

I'm running Lion 10.7.5, and I'm trying to install Postgresql 9.2.4 for use with Django. I have hit countless roadblocks and errors, so I would like to start with a totally clean slate. I did a brew ...
5
votes
2answers
2k views

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3 [closed]

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither ...
0
votes
1answer
50 views

Creating database/tables in SequelPro (or MySQL) from External FTP Server

I just started getting a backup file (*.7z) from the folks that run our database once a week. They're sending it to me through an FTP server (I use FileZilla) -- but the file is pretty huge: 5.8 ...
6
votes
2answers
2k views

Seeting up a PostgreSQL database on another hard drive than my system one on OS X?

I am on OS X 10.8.3, I've install PostgreSQL from macports, but I've realized that I have not enough space on my system drive for the DB I am about to populate with data. Is there a way to create new ...
1
vote
0answers
134 views

PostgreSQL datasource URL?

My first attempt to use PostgreSQL: I have the elephant icon on the top right: running on port 5432. I want to use LibreOffice as an interface: Connect to an existing database: PostgreSQL ...
1
vote
1answer
2k views

Why would SequelPro only import 23k rows out of 130k?

I use SequelPro for mysql on a Mac OS X -- and I used the import function to upload a 130k .csv file to my database. Everything seems to work fine, then I get the message File Read Error: An error ...
1
vote
0answers
302 views

System Preferences quits unexpectedly due to MySQL plug-in

I've installed MySQL Preference Pane on my MacBook to start/stop MySQL from my System Preferences and it works ok, except that once in a while System Preferences just quits and shows this message: ...
3
votes
1answer
1k views

PostgreSQL CREATE EXTENSION file not found error on Mac OS

On PostgreSQL 9.2.3 when trying this: CREATE EXTENSION btree_gist; I get this error: ERROR: could not open extension control file "/opt/local/share/postgresql92/extension/btree_gist.control": ...
1
vote
2answers
436 views

MySQL5.6 on Mac OS X 10.6.8 problems when granting permissions to root

I'm having serious problems with a MySQL 5.6 instance on a Mac Server. We had to upgrade MySQL to a newer version, but it turned to be a bad idea, as we lost control to it. We had a backup of the ...
2
votes
0answers
1k views

“custom archiver out of memory” error when restoring large DB using pg_restore

I'm trying to a restore a local copy of a 30GB DB (with only one table) dumped using the Heroku wrappers (described here) using pg_restore. The Heroku DB is using 9.1.7 and I have had the same result ...
2
votes
1answer
609 views

Is it okay to have different lower_case_table_names value on master and slave?

I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1. I haven't started replication on the slave, but everything looks ...
2
votes
1answer
1k views

Connecting to Oracle SQL Developer locally on Mac?

I'm trying to connect to Oracle SQL Developer locally on my Mac. How exactly is this done? I've looked all over the network, and can't find anything helpful. The only thing I did is installing the ...
0
votes
1answer
2k views

MySQL General log not working on Mac OS X [duplicate]

I want to log all queries to the database running on my MacBook Pro (Mac OS X 10.8.1). I created a file /etc/my.cnf with the following content: [mysqld] general_log=1 ...
0
votes
1answer
463 views

Permission Denied Copy [closed]

I am a beginner learning how to load data and I can't figure out why I can't load this data into postgres. I am using postgres 8.4 on MAC OS. copy tname from '/Users/Shared/folder/file.cxv' ...
5
votes
1answer
3k views

Backup a database with a huge number of tables

Is there a way to backup a PostgreSQL database with a huge number of tables? An attempt with pg_dump for a database of about 28000 tables resulted in the following error message: pg_dump: WARNING: ...
1
vote
1answer
101 views

MySQL 5 on Mac 10.5: “problem connecting to the database”

I have worked with MySQL for years but I am stuck on a seemingly trivial problem. I installed MySQL 5.0.96 on Mac 10.5, created a database, created a user with privileges on everything, and problem: ...
1
vote
3answers
4k views

Is there a free software that can import excel into mysql on mac? [closed]

not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?
2
votes
3answers
2k views

how to install mysql on mac?

My Mac runs Mac OS X, version 10.7.5., so it's a 64 bit system. First, I downloaded mysql-5.5.28-osx10.6-x86_64.dmg. Then I double clicked mysql-5.5.28-osx10.6-x86_64.dmg, it's mounted, and shows ...