Re: localhost vs domain for connection string

2010-11-25 Thread Johan De Meersman
On Wed, Nov 24, 2010 at 4:44 PM, Jerry Schwartz je...@gii.co.jp wrote:

 [JS] This might or might not be enabled by default. I'm running on Windows,
 and I seem to remember having to change it.

 # Enable named pipe, bypassing the network stack
 enable-named-pipe


Windows' named pipes are not the same as unix sockets, although the general
idea is similar. I'm not sure, but I think the Unix socket file is always
created.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel


Uprading of MySQL

2010-11-25 Thread Machiel Richards
Hi Guys

I am looking for some suggestions here please. This is related to a
previous question I had regarding the upgrading of mysql 5.0.51a to
mysql 5.1.53.

The database is running on Ubuntu-8.0.4 and as stated the only
repository was the 5.0.51a version.

In order to be able to upgrade 5.1.53 I have had to download the
linux-generic tarball (not a fan of the source versions).

The tarball installations as far I can remember, basically entailed
creatign of user and groups, untar the file, create link, initialize
database,etc...

What would be the best method to get the database 5.0.51a upgraded
using this new tarball as it was installed via apt-get.

 I am using a VM to test this at the moment so any suggestions would
be appreciated.



PS... the port needs to stay the same as the previous version so I was
thinking about the following:

1. setup new instance in seperate directory with it's parameters and
log files,etc...
2. ensure all is working fine.
3. during downtime, make a backup of the old database (while no load
to db)
4. restore to new db 
5. disable old db from starting up and change new db port to 3306.
6. test connectivity from apps,etc...

Any suggestions?

Regards
Machiel