upgrading

I'm upgrading from 3.23.53 to 4.0.12 and noticed that 4.0.12 wants to pull data files from /var/lib/mysql. I set the prefix to be /home/mysql4, so why is it wanting to get the data from this new location? When I installed 3.23.53, I set the prefix as /home/mysql3 and it pulls data from

table is read only

I'm trying to update a table and I get this error message. ERROR 1036: Table 'list' is read only J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing

mysqld ending at start up

I installed mysql 4 today and ran mysqld_safe. Here is what I get back... [EMAIL PROTECTED] admin]# Starting mysqld daemon with databases from /var/lib/mysql 030328 05:22:36 mysqld ended What is wrong? Thanks, Joe. __ Do you Yahoo!? Yahoo!

Re: mysqld ending at start up

What's your log say? Should be in /var/lib/mysql/hostname.err I don't have one. But there is a mysql.sock. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL

Re: mysqld ending at start up

I face the same problem a month ago. see your mysql database permission; it should be 750 (minimum) and belong to mysql user and group. YEAH! That did it. Thanks a million! Also, how do I move the var directory to another location? J. __

mysql.sock

The mysql.sock file is being saved at the location below /var/lib/mysql/mysql.sock ...which causes me to get this error... ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) How can I fix this? Thanks, Joseph

Re: mysql.sock

Specify the location in my.conf or ...create a sym link in /tmp. Where is the my.conf file? J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List

Re: mysqld ending at start up

What I mean is the permission of mysql database directory and data. Seems you already solved the problem. Yeah, I figured out what you ment. issue the command 'mv /var/lib/mysql What I ment was, when I installed mysql, I set the prefix as /home/mysql, however, the var directory for

Re: mysql.sock

My mistake. my.cnf. It should be in /etc or /var/lib/mysql. If not, you can create one. Is the my.cnf a new thing? Before today, I'd had never heard of it. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your

Re: mysql.sock

Pretty new: 3.22.2. Only been around, oh, 5 years or so. :-) Well, looks like I've had my head in a hole. Here is my my.cnf file contents. Can you tell me what's wrong? [mysqld] datadir=/home/mysqldb socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib

Re: mysql.sock

What's the full pathname? /etc/my.cnf? Correct. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives:

var directory

How do I set the location of the var directory when I install? Joseph Say I'm Hot! - Post Your Picture! http://www.sayimhot.com __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text

joine

join - 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