mysql on intel based Mac
the...@uwm.edu
I've had the contents of the hard disc copied over [except that newer
versions of the mac-provided software, including php, replaced what I
was using with os X 10.3.9]
mysql is not provided for the imac. Should what I already have work on
leopard? I'm getting this error message after it accepts my password:
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)"
Can I make this work w/o replacing it w/ an intel-based mysql?
If so, what do I need to do?
If not, how can I retrieve my databases?
thanks, --thelma
J.O. Aho
> I just replaced my 4 year old imac with a new intel based one.
> I've had the contents of the hard disc copied over [except that newer
> versions of the mac-provided software, including php, replaced what I
> was using with os X 10.3.9]
>
> mysql is not provided for the imac. Should what I already have work on
> leopard? I'm getting this error message after it accepts my password:
>
> "ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)"
That looks like the mysql daemon isn't up and running, you checked that you
have mysqld processes in your ps output?
Check also the mysql log to see what can be the cause it's not running (in
case it's automatically started and died).
--
//Aho
Kees Nuyt
The error message indicates your MySQL command line client
program is running on this intel-based Mac and it tries to
connect via a socket, that is locally. So it expects
mysqld, the daemon (service), to run on the same machine.
Assuming iMac is not intel-based, it is impossible to run
the iMac version of mysqld on intel-based Mac.
You will have to install an intel-based Mac version of
mysqld on your new machine, or connect to a mysqld on some
other machine, via TCP port 3306. You also may have to
edit the my.ini file to acomplish this.
>If not, how can I retrieve my databases?
You should have made a backup with the mysqldump program
on your old machine. Its output is suitable to reconstruct
your database(s) with the mysql command line program.
The old (binary) database files almost certainly cannot be
read by some other mysql version.
Search the mysql site for more information about version
updates. They describe the process pretty well.
> thanks, --thelma
Good luck.
--
) Kees
(
c[_] I'm not a vegetarian, but I eat animals who are.
-- Julius Henry "Groucho" Marx [#478]
the...@uwm.edu
: On Wed, 23 Jul 2008 01:05:32 -0500, the...@uwm.edu wrote:
: >I just replaced my 4 year old imac with a new intel based one.
: >I've had the contents of the hard disc copied over [except that newer
: >versions of the mac-provided software, including php, replaced what I
: >was using with os X 10.3.9]
: >
: >mysql is not provided for the imac. Should what I already have work on
: >leopard? I'm getting this error message after it accepts my password:
: >
: >"ERROR 2002 (HY000): Can't connect to local MySQL server through socket
: >'/tmp/mysql.sock' (2)"
: >
<snip>
: The error message indicates your MySQL command line client
: program is running on this intel-based Mac and it tries to
: connect via a socket, that is locally. So it expects
: mysqld, the daemon (service), to run on the same machine.
: Assuming iMac is not intel-based, it is impossible to run
: the iMac version of mysqld on intel-based Mac.
I haven't needed to install a new version of Mysql after all.
J. Aho suggested that the error message indicated that the
mysql server had not been started. He was right.
[Thank you, J. Aho]
The mysql that I had installed on the pre-intel imac is now
running on the new intel-based Mac.
But the change-preferences utility for Mysql is not compatible
with the intel mac.
: You will have to install an intel-based Mac version of
: mysqld on your new machine, or connect to a mysqld on some
: other machine, via TCP port 3306. You also may have to
: edit the my.ini file to acomplish this.
: >If not, how can I retrieve my databases?
: You should have made a backup with the mysqldump program
: on your old machine. Its output is suitable to reconstruct
: your database(s) with the mysql command line program.
: The old (binary) database files almost certainly cannot be
: read by some other mysql version.
I replaced the old imac because its power supply had just died for
the second time in the 3 1/2 years that I've had it, and it has
had enough other hardware problems [disk failed, logic board
needed replacement] that I wasn't interested in repairing it
yet again, so I didn't get to backup the data.
: > thanks, --thelma
: Good luck.
Sherman Pendley
> I haven't needed to install a new version of Mysql after all.
> J. Aho suggested that the error message indicated that the
> mysql server had not been started. He was right.
> [Thank you, J. Aho]
>
> The mysql that I had installed on the pre-intel imac is now
> running on the new intel-based Mac.
Not surprising - Intel Macs include Rosetta, for running PPC binaries
after translating them for Intel.
> But the change-preferences utility for Mysql is not compatible
> with the intel mac.
That's also not surprising. :-) Rosetta has some limitations, one of
which is that a native app can't use it to load PPC plugins, and vice
versa. Preference panes are implemented as plugins that are loaded by
the preferences app, so the native app on your Intel Mac can't load
the PPC pref pane.
Running the server this way should be good enough to get a text dump
of your data for backup. Once you've done that, your should delete the
old MySQL installation and install one that's Intel native - it will
run slightly faster, and the preference pane will load.
sherm--
--
My blog: http://shermspace.blogspot.com
Cocoa programming in Perl: http://camelbones.sourceforge.net