List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 9 2002 7:52pm
Subject:Re: Upgrading
View as plain text  
It means mysql does not own its directories and files.

chown -R mysql 
 /usr/local/that-long-directory-name-that-should-have-been -symlinked


Richard W. Berriman wrote:

>The contents of the error log in
>
>mysql-3.23.49a-pc-linux-gnu-i686/data is:
>
>
>020908 17:00:27  mysqld started
>
>
>020908 17:00:28  /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld:
>Can't c
>reate/write to file
>'/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data/accesscomm
>.ca.pid' (Errcode: 13)
>
>020908 17:00:28  /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld:
>Can't f
>ind file: './mysql/host.frm' (errno: 13)
>
>
>020908 17:00:28  /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld:
>Error o
>n delete of
>'/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data/accesscomm.ca.pid'
> (Errcode: 13)
>
>020908 17:00:28  /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld:
>Normal
>shutdown
>
>mysqld got signal 11;
>This could be because you hit a bug. It is also possible that this binary
>
>or one of the libraries it was linked agaist is corrupt, improperly built,
>or one of the libraries it was linked agaist is corrupt, improperly built,
>or misconfigured. This error can also be caused by malfunctioning hardware.
>We will try our best to scrape up some info that will hopefully help
>diagnose
>the problem, but since we have already crashed, something is definitely
>wrong
>
>and this may fail
>
>key_buffer_size=8388600
>record_buffer=131072
>sort_buffer=2097144
>max_used_connections=0
>
>
>max_connections=100
>threads_connected=0
>max_connections=100
>threads_connected=0
>It is possible that mysqld could use up to
>
>key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
>key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
>bytes of memory
>
>
>Hope that's ok, if not, decrease some variables in the equation
>
>Hope that's ok, if not, decrease some variables in the equation
>
>020908 17:00:28  mysqld ended
>
>End Log
>
>Could it be perhaps because I am installing 3.23 into a new directory?
>Would I be wiser to just install 4.x and be done with it? I am installing
>3.23 primarily to access search capabilities...which I am now slugging out
>in php...
>
>Perhaps I need to reinstall the other associated packages (Apache and PHP)
>in order for compatibilty, but my now aging documentation for 3.22 had me
>test out the MySQL install before proceeding...
>
>Thanks Everyone for helping me out! I'm still hammering at this one :-)
>
>Richard
>
>-----Original Message-----
>From: Nicholas Stuart [mailto:nick@stripped]
>Sent: Monday, September 09, 2002 5:48 AM
>To: richardwberriman@stripped
>Cc: mysql@stripped
>Subject: RE: Upgrading
>
>
>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:richardwberriman@stripped]
>>Sent: Sunday, September 08, 2002 4:43 PM
>>To: mysql@stripped
>>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 <mysql-thread119077@stripped>
>>To unsubscribe, e-mail
>><mysql-unsubscribe-richardwberriman=accesscomm.ca@stripped>
>>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 <mysql-thread119078@stripped>
>>To unsubscribe, e-mail
>>
><mysql-unsubscribe-nick=newtsplace.com@stripped>
>
>>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 <mysql-thread119139@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Problem compiling a MySQL client in C languageJean-Marc Godart8 Sep
  • UpgradingRichard W. Berriman9 Sep
    • RE: UpgradingRichard W. Berriman9 Sep
      • RE: UpgradingNicholas Stuart9 Sep
        • RE: UpgradingRichard W. Berriman9 Sep
          • Re: UpgradingGerald Clark9 Sep