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 /home/mysql
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 List
> 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: http://lists.mysql.com/mysq
> 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
[safe
> 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
> 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
m
> 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
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
_
> 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.
> What's your log say?
>
> Should be in /var/lib/mysql/.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 General Ma
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! Pl
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
---
join
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
-
Before posting, please check:
http://www.mysql.com/manual.ph
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 PRO
14 matches
Mail list logo