The mac-os-x tag has no wiki summary.
8
votes
6answers
11k views
PostgreSQL is running locally but I cannot connect. Why?
Recently updated my machine from Mac OS X Lion (10.7.4) to Mountain Lion (10.8) and I think it borked my PostgreSQL installation. It was installed originally via Homebrew. I'm not a DBA, but hoping ...
8
votes
5answers
8k views
MySQL server has gone away obstructing import of large dumps
I am trying to import a large sql dump (2GB) to my local mysql on my mac. I have been able to do this in the past (I was using MAMP), but now I get a
ERROR 2006 (HY000) at line 7758: MySQL server ...
4
votes
4answers
1k views
Trouble setting up Postgres for the first time
I have some, albeit limited, experience with MySQL and MongoDB (both running fine on server) but having trouble with Postgres and find the documentation lacking for newbies, like myself.
Postgres is ...
4
votes
2answers
47 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 ...
3
votes
2answers
7k views
How to run psql on Mac OS X?
I installed PostgreSQL on a computer with Mac OS X using the One click installer. Then I try to access PostgreSQL using the psql command, but it doesn't seem to be available.
I get this message:
...
3
votes
2answers
1k views
DB2 Express-C on Mac OS X
I have followed all the steps described on the Getting Started with DB2 Express v9.7 e-book and installed DB2 Express-C on my Mac. The installation succeeded without a problem.
I did setup OS X ...
3
votes
2answers
1k views
Creating and editing my.cnf by MySQL Workbench?
I just installed MySQL Server and MySQL Workbench on a clean Snow Leopard MacBook. I hooked up Workbench with the server and was able to start the MySQL Server from within the Workbench. I enter the ...
3
votes
1answer
213 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: ...
3
votes
1answer
367 views
How to set datadir to different values based on the hostname in my.cnf?
How to set datadir to different values based on the hostname in my.cnf? I want to use the same my.cnf file on a Linux machine and a Mac OS X machine where the datadir should have different values.
2
votes
3answers
447 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
...
2
votes
1answer
932 views
MySQL Workbench - Create new server instance error
When attempting to create a new server instance I get an error at the 'Test Settings' step of the creation wizard.
The error:
What check_admin_commands/local
Operation failed: ...
2
votes
1answer
74 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": ...
2
votes
1answer
685 views
SQL on Mac OS X
I'm looking for something like "Oracle database express" to be used on a mac.
I hope this question won't offend anyone though.
I'm absolute beginner on sql.
Your suggestions are most welcome.
2
votes
1answer
157 views
MySQL performance on Mac vs Linux
I know that MySQL is tested more on Linux (Oracle has it's own linux distribution and you canot have LAMP wit MySQL (meaning MySQL has always focused more on Linux)
My intuition says that MySQL has a ...
2
votes
0answers
177 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
3answers
7k views
How to initiate MySQL on Mac OS X 10.6.8?
I followed this tutorial to install MySQL on Mac OS X 10.6.8. Now I get he following errors:
$ mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: ...
1
vote
2answers
1k views
Running postgresql in Mac Terminal
I have a production SQL dump file that I want to restore to my local psql db for debugging reasons.
I can't access psql via the terminal though pgAdmin3 works just fine. Here is the error I'm ...
1
vote
1answer
2k views
What GUI tools can be used for PostgreSQL in Mac OS X?
I have recently started using PostgreSQL with my rails app.
I was looking for a SQL GUI to the PostgreSQL database (for Mac).
Anything better than pgadmin3?
1
vote
2answers
403 views
Is there a free software that can import excel into mysql on mac?
not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?
1
vote
1answer
82 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 ...
1
vote
1answer
162 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 ...
1
vote
1answer
61 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
1answer
869 views
Install db2 express c on Mac OSX
I have posted the question yesterday, then I was able to figure it out by myself. As I haven't found any complete guide, I'm writing down the steps just in case.
So the question is: "How do I ...
1
vote
1answer
166 views
db2 express c mac osx
I'm experiencing some troubles with the execution of DB2 express c on Mac OSX 10.6 Snow Leopard.
I have installed the db system, creating two users, db2 and db2-user. The latter is the instance ...
1
vote
1answer
2k views
How to properly stop MySQL server on Mac OS X?
I installed MySQL Community Server following instructions at
http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html
with the Startup Item and the MySQL Preference Pane.
I can stop the ...
1
vote
1answer
203 views
Installing Sphinx on Mac OS with XAMPP
We have:
Sphinx 2.0.3
Mac OS 10.6.8
XAMPP 1.7.3 (with MySQL 5.1.44)
Here is PATH:
user:sphinx-2.0.3-release user$ echo $PATH
...
1
vote
0answers
28 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
32 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
76 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
52 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
961 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
1answer
22 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
47 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 ...
0
votes
2answers
62 views
Need Permissions Granted: INTO OUTFILE for Mac OS X [closed]
Sorry for potential duplicate questioning, because I've seen this asked many times (notably from Mac users) -- but none of the answers seemed to help me.
I'm using Mac OS X with Sequel Pro (or I can ...
0
votes
1answer
173 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 ...
0
votes
0answers
65 views
Migrating database from OSX to Linux
I followed the setup in below link, to setup mysql. Basically, I am have a master on OS X server and want to setup a linux slave.
Create a mysql slave database from master database
After I copied ...
0
votes
1answer
78 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
0answers
30 views
SQL Server connection failed for normal domain user [duplicate]
I have SQL Server 2008 R2 SP1. I am using connection string to connect to SQL Server.
In connection string I am passing the driver path, server name, TCP port number, user name with which I want to ...
0
votes
1answer
324 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
289 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 ...
