The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
331 views

mysqld keeps automatically restarting

I am running mysqld on Mac OSX Al Capitan. After boot up, I ran mysql.server start to start mysqld server. But when I ran mysql.server stop, or sudo mysql.server stop, it just stopped for a while, ...
1
vote
1answer
188 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
333 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
0answers
266 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 ...
1
vote
0answers
181 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
0answers
449 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: ...
0
votes
1answer
7k 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 ...
0
votes
1answer
101 views

Is there a Portable MySQL

For teaching and testing purposes I would like to run MySQL without actually having to install it. I have found portable PostgreSQL for both Macintosh and Windows, which is good, but have been unable ...
0
votes
1answer
69 views

Start, stop, configure PostgreSQL through Mac terminal

I am having basic problems using PostgreSQL on my Mac OSX Yosemite, through the terminal. I tried google-ing but this is becoming increasingly difficult and info very scattered so I keep running into ...
0
votes
1answer
776 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 ...
0
votes
2answers
293 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
61 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
0
votes
1answer
988 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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
53 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 ...
0
votes
1answer
584 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' ...
0
votes
1answer
777 views

What's included in the default OSX 10.8 install of Postgres?

I've seen several sites claim that Postgres is installed by default for OSX 10.7 and above and I see there's a psql command in /usr/bin/, but there doesn't seem to be a pg_ctl anywhere. So is the ...
0
votes
1answer
60 views

Move databases on same Mac

I have just updated my MacBook to Mountain Lion. Since then, my MAMP installation does not work properly so I decided to use the build httpd/php stuff. For this, I have additionally installed a new ...
0
votes
1answer
2k views

How to create a new instance of PostgresSQL on OS-X 10.8 Server

After upgrading my MacMini home server from OS-X 10.7 (Lion) Server to OS-X 10.8 (ML) + Server.app, I saw PostgreSQL 9.1.4 was released. Unfortunately, the setup process for PostgreSQL 9.1.4 has ...
0
votes
0answers
25 views

After crash, lost Postgresql data

I was developing a Rails application with pg when there was a power loss. After turning on my computer again I was having: psql: could not connect to server: No such file or directory. Is the ...
0
votes
1answer
104 views

mysql: unknown variable 'table_definition_cache=400'

I added lines to ~/.my.cnf which worked fine for weeks. Now I receive complaints when I run myqsl CLI. System specs: MAC OS X - El Capitan 10.11.13 Mysql Version: mysql Ver 14.14 Distrib 5.6.29,...
0
votes
1answer
220 views

mysql launch fails after upgrade to 5.7.11

After upgrading a Mac to OS X 10.11.3, mysql was gone, so I downloaded and installed 5.7.11. It installed as usual but fails to launch with; (com.oracle.oss.mysql.mysqld[1560]): Service exited with ...
0
votes
1answer
158 views

mac os - virtualbox - oracle connection error - invalid username/password; logon denied

I have followed the below step guide(URL) to setup Oracle on Mac OS. Everything is fine on the guest side. But, I am facing some issues in host level. I can connect database in Guest (Virtual box) ...
0
votes
0answers
92 views

How to restore database from a Mac OS X disk image?

So I did take the ship with brave Capitan, and the ship ran aground... My Mac OS 10.11 tried to upgrade to 10.11.1 and freeze my Macbook! There was no backup, Time Machine stop working, so I did a dmg ...
0
votes
0answers
55 views

What role for plpythonu function's in the file system?

As a preliminary test for a further work I'm trying to use a simple plpythonu function in Postgresql 9.2 to create a folder in my filesystem. So I have this code : CREATE OR REPLACE FUNCTION "...
0
votes
3answers
2k views

mongoimport error - Failed: error connecting to db server: no reachable servers

I am currently trying to learn mongodb and I am having trouble finding a solution for this problem. When I run a mongoimport command it I get the following error: ~ mongoimport --host localhost --...
0
votes
1answer
59 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
1answer
2k 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
0answers
2k 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
1answer
205 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 ...
0
votes
0answers
334 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 -...
0
votes
1answer
329 views

Update Postgres on server that already has version included with system

Mac OS X (Lion) Server includes Postgres (9.0.5) that it uses for some system utilities (Wiki server, caldav, etc.). I'm about to start using this server for some Rails applications and am wondering ...
0
votes
1answer
5k 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 ...