Running a Mac G4, OS/X.. I previously had a problem where mysql 5 came
up.Tim suggested I modify my path. And that worked. But then all of a
sudden stoped (again). Now 'mysql' shows mysql 5.0.18. And of course
no databases are found.

So I'm willing to run 5, if I can get my data from 4. Tim McNamara's
solution was to add /usr/local/mysql/bin and /usr/local/mysql to my
path. That worked, for a while. My path (yeah, I need to clean it up)
is:

/usr/local/mysql:/usr/local/mysql/bin:/usr/local/mysql:/usr/local/bin:/opt/local/bin:/sw/share/phpmyadmin:/usr/local/rrdtool-1.2.11/bin:/sw/ImageMagick-6.2.4/bin:/usr/local/mysql/bin:/usr/local/mysql:/Library/Apache2/bin:/sw/bin:
/sw/bin /sw/sbin /usr/local/mysql/bin /usr/local/mysql
/usr/local/mysql /usr/local/bin /opt/local/bin /sw/share/phpmyadmin/
/usr/local/rrdtool-1.2.11/bin /sw/ImageMagick-6.2.4/bin
/Library/Apache2/bin . /bin /sbin /usr/bin /usr/sbin /usr/X11R6/bin

So is there an easy way to export my databases from 4 (not sure which
4.X.XX) to 5?

I'm not a mysql expert, so please bear with me and appreciate any
help.

If it helps:

If I type /usr/local/mysql/bin/mysql from the command line, it says
5.0.18, so I guess first I'd need to figure out where my 4 data is?

Thanks for any help.

Oh, and I do have phpmyadmin, so if I can somehow get that to go to my
4 database, I can then export / import.

Evan
--
To reply, remove TheObvious from my e-mail address.

On Wed, 05 Apr 2006 23:53:09 -0700, Evan Platt wrote:
> Running a Mac G4, OS/X.. I previously had a problem where mysql 5 came
> up.Tim suggested I modify my path. And that worked. But then all of a
> sudden stoped (again). Now 'mysql' shows mysql 5.0.18. And of course
> no databases are found.

This is your mysql client, not your mysqld server. The client can point
to and access a different version of the server (at least, most of the
time).

> So I'm willing to run 5, if I can get my data from 4. Tim McNamara's
> solution was to add /usr/local/mysql/bin and /usr/local/mysql to my
> path. That worked, for a while. My path (yeah, I need to clean it up)
> is:
>
> /usr/local/mysql:/usr/local/mysql/bin:/usr/local/mysql:/usr/local/bin:/opt/local/bin:/sw/share/phpmyadmin:/usr/local/rrdtool-1.2.11/bin:/sw/ImageMagick-6.2.4/bin:/usr/local/mysql/bin:/usr/local/mysql:/Library/Apache2/bin:/sw/bin:
> /sw/bin /sw/sbin /usr/local/mysql/bin /usr/local/mysql
> /usr/local/mysql /usr/local/bin /opt/local/bin /sw/share/phpmyadmin/
> /usr/local/rrdtool-1.2.11/bin /sw/ImageMagick-6.2.4/bin
> /Library/Apache2/bin . /bin /sbin /usr/bin /usr/sbin /usr/X11R6/bin
>
> So is there an easy way to export my databases from 4 (not sure which
> 4.X.XX) to 5?

mysqldump, then run the resulting script through the mysql client.

> I'm not a mysql expert, so please bear with me and appreciate any
> help.
>
> If it helps:
>
> If I type /usr/local/mysql/bin/mysql from the command line, it says
> 5.0.18, so I guess first I'd need to figure out where my 4 data is?
>
> Thanks for any help.
>
> Oh, and I do have phpmyadmin, so if I can somehow get that to go to my
> 4 database, I can then export / import.

I suspect your mysqld server isn't even running. Check find the install
walkthrough for instructions on starting the server.

--
39. If I absolutely must ride into battle, I will certainly not ride at the
forefront of my Legions of Terror, nor will I seek out my opposite number
among his army.
--Peter Anspach's list of things to do as an Evil Overlord