Re: localhost vs domain for connection string
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
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