1
vote
1answer
187 views

Mysqltuner, how to speed up optimize table? [closed]

I used mysql tuner and here are the statistics. The recommendation says to optimize tables. I have 96 GB of memory on the machine. Is there anyway I can speed up the optimization process? The tables ...
0
votes
1answer
569 views

Mountain Lion: mysql stopped working after installing homebrew

So I had installed MySQL from a download. It was working fine. My socket file mysql.sock was located at /private/tmp After installing homebrew (don't know if it's directly related to homebrew) my ...
1
vote
3answers
2k views

ERROR 2002 MYSQL socket /tmp/mysql.sock

A have already read everything about this error but I coundn't solve the problem. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) I'm trying to install ...
0
votes
1answer
394 views

How to activate XAMPP's apache and mysql for non-admin account on Mac OSX [closed]

I have Mac systems with os x10.6.8 and above. Installed XAMPP. Is there any way to START xampp's apache and mysql by non-amdin user or group? I searched alot but came up with no solutions. All i ...
-1
votes
1answer
64 views

Who can provide a mysql 4.0 on Mac OS? [closed]

I need a very old version of mysql(4.0.x) on my Mac OS for debugging and I know the file name format is: mysql-standard-4.0.X-apple-darwinX-powerpc.tar.gz I google some download links,but all ...
1
vote
0answers
72 views

Mysql client hangs when returning large result sets

I have a strange problem on one Mac: when doing selects that return large result sets (> 10.000 rows), the sql client on that machine hangs. It does not return anything and just waits. All other ...
0
votes
1answer
304 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 ...
4
votes
2answers
290 views

Manually transfer MySQL databases

I have an external hard drive that has a non-bootable clone of an old machine (that I no longer have). One of the things that was present on that machine was a MySQL installation (v 5.5.19) with ...
0
votes
1answer
179 views

MySQL running but not connecting to Drupal Database.

Our School Drupal site died after upgrade. MySQL is running but cannot connect to database. MyphpAdmin returns Error 2002.![Screenshot of MySQL activity.][1] Drupal 6.22 (after attempted upgrade) with ...
1
vote
1answer
881 views

Mac 10.6.8 Zend Server CE MySQL does not start — “ERROR! Manager of pid-file quit without updating file”

MySQL does not start, I have previously installed zend server on the same Mac and MySQL worked. I have reinstalled after rm -r /usr/local/zend . Are there any other directories I need to clear? Or do ...
2
votes
2answers
1k views

MySQL won't start in MAMP server

I had MAMP successfully running in one of the user, but since I have created a new user to separate things between two developers, its throwing tantrums. I am pretty new to Mac itself but managed to ...
0
votes
1answer
104 views

Revert all changes make to Mac OS X web sharing [closed]

I've been messing about with apache2 php and mysql today and I've taken a few wrong turns. I'd rather install XAMPP than try to figure out all the problems. I did a time machine backup a few days ago ...
0
votes
1answer
92 views

Mysql on mac installed but broken

I have MySql installed as part of MAMP on my MacBook Pro OS X 10.6.4. But Terminal responds to the mysql command with: -bash: mysql: command not found This: sudo find / -name "mysql" brings this: ...
1
vote
1answer
132 views

What is the best option for a MySQL server host?

I am a noob in the world of servers. I understand SQL databases but I don't know how to setup a server. I would like to setup a MySQL server that I can talk to (read/write) from an app that I wrote ...
0
votes
2answers
119 views

MySQL Install trouble Mac OSX 10.6

I have tried installing versions 5.5.11 and 5.1.56 of the MySQL Community Server DMG on my new MacBook Pro 2GHz Intel Core i7 running OS X 10.6.6. It claims that installation is successful, and the ...
0
votes
1answer
209 views

Mac OS 10.6 and MySQL 5.5.8 Shutdown

I was just wondering, if MySQL is running when you shutdown does the OS shut it down cleanly or does it just kill the process? I Installed via the .DMG image from the MySQL site. Also started it with ...
0
votes
1answer
515 views

MAMP on mac with existing mysql server

I am facing some issue in getting MAMP work with existing mysql database on my mac? Sometimes the problem is permission, sometimes it is not able to find the problem or something else. I will be more ...
1
vote
1answer
1k views

Mac OS X, MySQL Preference Pane doesn't work

I downloaded and installed MySQL 5.1.47 for OS X 10.6 using the DMG archive: mysql-5.1.47-osx10.6-x86_64.dmg I also installed MySQL.prefPane and MySQLStartupItem.pkg. MySQL.prefPane is a Preference ...
2
votes
1answer
752 views

Installing XAMPP on Mac OS X as a daemon ( service ) [closed]

Until now, I've been running Xampp by having a script with xampp start run as a login item. Is there a better way to make Xampp ( Apache & MySQL ) run as daemons?
3
votes
2answers
2k views

Snow Leopard: MySQL doesn't start

I have updated to Snow Leopard and I removed mysql by following this post: http://forums.mysql.com/read.php?11,75256,255853#msg-255853 After that I have installed the mysql 64 bit community edition, ...
1
vote
2answers
131 views

Snow Leopard update Dec 09. Did anyone else lose their MySQL data?

Initially I had to re-install MySQL when I upgraded to Snow. I managed to get everything backed up to .csv file and was able to migrate to the new install. It worked fine! Earlier this week Mac issued ...
0
votes
4answers
416 views

can no longer access MySQL via PHP

I have a mySQL / PHP setup that I've used on several systems. I just recently upgraded my system to Max OSX 10.6, and now it cannot connect. I get the error: mysqlnd cannot connect to MySQL 4.1+ ...
3
votes
1answer
411 views

PDO_mysql for mac

Has anybody gotten PDO_mysql working on the default PHP installation on a mac? It works with MAMP but that's inconvenient. I'm developing for Zend Framework and mysql, and Zend_db uses PDO. The ...