My suggestion would be to chown the database files to the same ownership of the mysqld
daemon. This should solve your persmission issues.
-----Original Message-----
From: Adam Douglas [EMAIL PROTECTED]
Sent: Thu, 9 Aug 2001 10:11:44 -0600
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Upgrading to 3.23.37 from 3.22.32
Ok but I've have chmod 777 on a couple of tables and I still receive table
in read only message. Plus I was under the understanding that you only need
say 700 because the mysql daemon it self would be modifying the files
directly and not the client using MySQL.
> -----Original Message-----
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 08, 2001 7:38 AM
> To: Adam Douglas
> Cc: [EMAIL PROTECTED]
> Subject: Re: Upgrading to 3.23.37 from 3.22.32
>
>
> Except, mysql needs write permission.
>
> Adam Douglas wrote:
>
> > MySQL reports read only table. As for file permissions,
> everything is fine.
> > Everyone has read and execute privileges.
> >
> >
> >> They are probably not owned by mysql anymore.
> >>
> >> Adam Douglas wrote:
> >>
> >>
> >>> I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was
> >>> pkg_delete the old MySQL and install the new one. Before I
> >>
> >> delete the old
> >>
> >>> MySQL I copied all the database files to a temporary
> >>
> >> location. Once the new
> >>
> >>> installation was successful I copied over all the database
> >>
> >> files into the
> >>
> >>> proper location.
> >>>
> >>> My problem is I seem to have 3 extra tables now, A-1, A-9
> >>
> >> and A-ce. The
> >>
> >>> funny thing is they all seem to be linked to my tables.
> >>
> >> These tables to my
> >>
> >>> knowledge were not present in the MySQL 3.22.32. Also I
> >>
> >> can't seem to remove
> >>
> >>> the test user from mysql->db, MySQL says it's read only. I
> >>
> >> never made the
> >>
> >>> table read only and doesn't seem to be.
---------------------------------------------------------------------
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
___________________________________________________________________________
Visit http://www.visto.com.
Find out how companies are linking mobile users to the
enterprise with Visto.
---------------------------------------------------------------------
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