Hello Richard, I just went through something similar with upgrading from 3.23.49 to 4.03. The reason you can't connect to MySQL is >020908 15:53:33 mysqld ended This should obviously not be here. Check the error logs to see if they say anything important and/or helpful there. Most likely found under /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data in your case. Also, have you re-linked the usr/local/mysql link with the new folder? And check to make sure that the data folder is owned by MySQL and that its group is also MySQL with the correct permissions. I also found that once I installed the new MySQL, and got it working, I had to go back and recompile Apache with all the packages you need (of course making sure to add MySQL support) for it to work correctly. I don't know if this is necessary but it's how I resolved the problem. Hope this helps.
-Nick > Update: Now, after rebooting the server, the site can't connect...that's > more like it ;) > > -----Original Message----- > From: Richard W. Berriman [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 08, 2002 4:43 PM > To: [EMAIL PROTECTED] > Subject: Upgrading > > > > Hi! > > I have a number of tables in development in 3.22.32 > > (running in apache_1.3.12 on a linux kernel) > > I'd really like to upgrade to 3.23.49a but my installs in both rpm and > binary have not succeeded in "taking over" from my previous install. > > I've read quite a bit at the mysql.com site, but haven't found the > appropriate documentation ... my last attempt was > > by downloading > > MySQL-3.23.49-1.src.rpm, > > 0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop) > > 1. cp MySQL-3.23.49-1.src.rpm into /usr/local > 2. rpm --recompile MySQL-3.23.49-1.src.rpm > 3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld & // To start > MySQL & use it > > This returns: > > Starting mysqld daemon with databases from /usr/local/m > ysql-3.23.49a-pc-linux-gnu-i686/data > 020908 15:53:33 mysqld ended > > And the Mysql database driven website works... > > Yet, when I want to go into line commands (to alter tables for easy > searching) using: > > mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql > > I get > > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' > (111) > > There is no file by that name there... > > Well thankyou for any help :-) > > Richard > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php