Re: Mysql on os/x 10.4 server

On Mar 11, 1:55 pm, Evan Platt <e...@theobvious.espphotography.com>
wrote:
> Finally bit the bullet and upgraded to os/x server. Had to do a clean
> install (non upgrade). So now I'm back at square one. have a few
> questions:
>
> I installed 5.0.37 for OS/X (DMG format). I started getting the error
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/mysql/mysql.sock' (38)
>
> Googling gave a number of suggestions, none really OS/X specific, but
> involved editing my /etc/php.ini and putting in
>
> mysql.default_socket = /var/mysql/mysql.sock
>
> /etc/my.cnf , and putting
> [mysqld]
> socket=/var/mysql/mysql.sock
>
> Yesterday, it worked. Granted, I had no databases, but it worked.
>
> So my multi part question is:
>
> What am I doing wrong?

Perhaps you have no global MySQL conf (e.g. /etc/my.cnf) which would
set parameters like socket path, data directory, etc.?

> I've tried creating just that directory, creating the directory and a
> empty file, no go.
>
> When I do get it up and running, is there a way to import everything
> from say
> /Volumes/Macintosh HD/usr/local/mysql-max-5.0.27-osx10.4-powerpc/data/
> (That's where all my .frm and other data is.)

If you can't run your old server any more, then mysqldump'ing won't be
possible. You could try (making a backup, then...) setting the data
directory of your new installation to the old data directory (in
global conf, referred to above).

I haven't often used an OS X installation of MySQL but I am happy to
look at this further on my own OS X systems if you want more specific
help.

>
> Thanks.
>
> Evan

On Mar 13, 1:52 am, Evan Platt <e...@theobvious.espphotography.com>
wrote:
> On 11 Mar 2007 13:25:41 -0700, "toby" <t...@telegraphics.com.au>
> wrote:
>
> >If you can't run your old server any more, then mysqldump'ing won't be
> >possible. You could try (making a backup, then...) setting the data
> >directory of your new installation to the old data directory (in
> >global conf, referred to above).
>
> >I haven't often used an OS X installation of MySQL but I am happy to
> >look at this further on my own OS X systems if you want more specific
> >help.
>
> Ok, I've got mysql 5 up and running (5.0.37 I believe).
>
> What's the easiest way now to import data from, according to the
> directory name, 4.1.21? Can I simply copy everything over?

The safest way is to mysqldump from the 4.1 server, which would mean
installing 4.1 to do so.

Since you probably don't want to go to that trouble, you could try
accessing your existing data files in 5.0. I would do something like
this:
* back up your 4.1 data files.
* change the datadir in v5.0 my.cnf to the 4.1 data directory.
* follow the recommendations in http://dev.mysql.com/doc/refman/5.0/...-from-4-1.html
in particular, see http://dev.mysql.com/doc/refman/5.0/...l-upgrade.html

>
> Also, where is the ... settings, such as usernames and passwords
> stored? In those directories?

Yes, that's all in the existing 'mysql' database.

>
> Thanks. :)

HTH
--Toby

>
> Evan