i have the permissions set as close as i can to all the other databases
there. my thought was the .ISD/.ISM file extentions arent whawt the rest of
the mysql databases use, could this be part of the problem, or are my
permissions incorrect ?
root@city [/var/lib/mysql]# ls -al vsdadmsite
total 56
drwx------ 2 mysql mysql 4096 Aug 17 13:20 ./
drwxrwxr-x 6 mysql root 4096 Aug 16 22:53 ../
-rw-rw---- 1 mysql mysql 0 Aug 17 13:20 siteusers.ISD
-rw-rw---- 1 mysql mysql 1024 Aug 17 13:20 siteusers.ISM
-rw-rw---- 1 mysql mysql 8630 Aug 2 2000 siteusers.frm
-rw-rw---- 1 mysql mysql 0 Aug 17 13:20 user_vs.ISD
-rw-rw---- 1 mysql mysql 1024 Aug 17 13:20 user_vs.ISM
-rw-rw---- 1 mysql mysql 8574 Aug 2 2000 user_vs.frm
-rw-rw---- 1 mysql mysql 0 Aug 17 13:20 vs.ISD
-rw-rw---- 1 mysql mysql 1024 Aug 17 13:20 vs.ISM
-rw-rw---- 1 mysql mysql 8718 Aug 2 2000 vs.frm
root@city [/var/lib/mysql]#
----- Original Message -----
From: "Chris Warner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 3:20 PM
Subject: Re: web admin scripts install
> Change the ownership on the directory to mysql, and mysql should be able
to read
> it..
>
> Joe Huss wrote:
>
> > While installing the web admin scripts, I noticed that the mysql
database
> > files are .ISD and .ISM files when the normal MySQL database files are
.MYD
> > and .MYI, i tried copying over all the files like the documentation said
but
> > when i tried to do the insert lines i got an ERROR 1035: Table
'siteusers'
> > is read only
> > After some further investigation it looks like mysql thinks the database
> > doesnt exist, which to a large extent makes sense because all the
> > documentation tells you si to move the directory over (im under the
> > assumption this is enough to create the database, the directory being
under
> > /var/lib/mysql/).
> >
> > ------------------------- The freeVSD Support
List --------------------------
> > Subscribe:
mailto:[EMAIL PROTECTED]?body=subscribe%20freevsd-support
> > Unsubscribe:
mailto:[EMAIL PROTECTED]?body=unsubscribe%20freevsd-support
> > Archives: http://freevsd.org/support/mail-archives/freevsd-support
>
> --------------------------------------------------------------------------
---
>
> ------------------------- The freeVSD Support
List --------------------------
> Subscribe: mailto:[EMAIL PROTECTED]?body=subscribe%20freevsd-support
> Unsubscribe:
mailto:[EMAIL PROTECTED]?body=unsubscribe%20freevsd-support
> Archives: http://freevsd.org/support/mail-archives/freevsd-support
> --------------------------------------------------------------------------
---
>
>
------------------------- The freeVSD Support List --------------------------
Subscribe: mailto:[EMAIL PROTECTED]?body=subscribe%20freevsd-support
Unsubscribe: mailto:[EMAIL PROTECTED]?body=unsubscribe%20freevsd-support
Archives: http://freevsd.org/support/mail-archives/freevsd-support
-----------------------------------------------------------------------------
