Home > Archive > PHP SQL > March 2005 > Can't lock tables for writing, host says it's because of nfs file system
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can't lock tables for writing, host says it's because of nfs file system
|
|
| Jonathan 2005-03-04, 8:56 am |
| I can create a db through the hosts control panel. I can login to it, I can
create a table, but as soon as the table is locked for writing with the LOCK
TABLE command, it gives an error
Here's what happens:
------------------------------------------------------
LOCK TABLES `address_book` WRITE
MySQL said:
#1044 - Access denied for user 'mydbuser'@'%' to database 'mydbname'
------------------------------------------------------
He also asked me to this this:
------------------------------------------------------
GRANT SELECT , INSERT , DELETE ON mydbname . * TO 'mydbuser'@'%'
IDENTIFIED BY 'thepassword'
------------------------------------------------------
Which resulted in
------------------------------------------------------
MySQL said:
#1044 - Access denied for user 'mydbuser'@'%' to database 'mydbname'
------------------------------------------------------
If I manually edit out the "lock tables" command, it imports OK, but this is
going to mean reworking all of the db sections of my php apps.
He finally said this morning that this is because they use an NFS filesystem
which doesn't support file locking. Um...is he right? If not, what does he
have to type?!
Thanks!
| |
| Jonathan 2005-03-04, 3:58 pm |
| "NSpam" <chris.newey@gmail.com> wrote in message
news:0e1Wd.290590$K7.203395@fe2.news.blueyonder.co.uk...
> Jonathan wrote:
[color=darkred]
> you don't need locks, thats precisely what an RDBMS manages for you. As
> long as the user has SELECT, UPDATE, INSERT amd DELETE permissions on the
> database then the database content is manageble.
But I can't find a way of exporting a database via mysqldump without it
adding the "lock" command before it writes data to the table.
How do I get round this?
| |
| Jonathan 2005-03-12, 8:57 am |
| "Jonathan" <digitaltoast@gmail.com> wrote in message
news:4228a445$1_5@x-privat.org...
> "NSpam" <chris.newey@gmail.com> wrote in message
> news:0e1Wd.290590$K7.203395@fe2.news.blueyonder.co.uk...
>
>
> But I can't find a way of exporting a database via mysqldump without it
> adding the "lock" command before it writes data to the table.
> How do I get round this?
Help - I really need this. My host is saying that priviledges won't be
granted to lock tables ("for security" - ?!?!).
Can someone explain why this is, how it helps security, and how I can get
round it?
|
|
|
|
|