Hi,
I managed to get a Fedora install up and running. Apache+PHP4+MyS ql.
Copied a database from online server (RedHat) to my own, set permissions
(chown mysql, chmod 777 mysql) so all files are (should be) RW. However,
when trying to execute an Insert (or Update) query, it raises an error
'table is readonly'.
How to solve this problem?
Thanks in advance! 3 5180
Sjaakie Helderhorst wrote: I managed to get a Fedora install up and running. Apache+PHP4+MyS ql. Copied a database from online server (RedHat) to my own, set permissions (chown mysql, chmod 777 mysql) so all files are (should be) RW. However, when trying to execute an Insert (or Update) query, it raises an error 'table is readonly'.
How to solve this problem?
Check what permissions you have for database folders and table files
inside them. If you don't have correct permissions, fix them. It is
operating system issue how to do that, and it should be asked in a more
suitable newsgroup about your operating system.
I personally have permission 600 for database folders and 660 for table
files. 777 sounds dangerous to me, since it gives anyone permission to
write and read your database files and execute them.
"Aggro" <sp**********@y ahoo.com> schreef in bericht
news:5Y******** ******@read3.in et.fi... Sjaakie Helderhorst wrote:
I managed to get a Fedora install up and running. Apache+PHP4+MyS ql. Copied a database from online server (RedHat) to my own, set permissions (chown mysql, chmod 777 mysql) so all files are (should be) RW. However, when trying to execute an Insert (or Update) query, it raises an error 'table is readonly'.
How to solve this problem?
Check what permissions you have for database folders and table files inside them. If you don't have correct permissions, fix them. It is operating system issue how to do that, and it should be asked in a more suitable newsgroup about your operating system.
I personally have permission 600 for database folders and 660 for table files. 777 sounds dangerous to me, since it gives anyone permission to write and read your database files and execute them.
I agree 777 is dangerous, but it's a desperate attempt to solve this
read-only prob.
I'll try another group, thanks for you support.
"Sjaakie Helderhorst" <pr**********@t ell.you> wrote in message
news:40******** *************** @news.xs4all.nl ... Hi,
I managed to get a Fedora install up and running. Apache+PHP4+MyS ql. Copied a database from online server (RedHat) to my own, set permissions (chown mysql, chmod 777 mysql) so all files are (should be) RW. However, when trying to execute an Insert (or Update) query, it raises an error 'table is readonly'.
How to solve this problem?
Sounds to me like you haven't set the mysql permissions. These are different
from the file/directory permissions. Visit http://dev.mysql.com/doc/mysql/en/Privilege_system.html and review the
priveleges your db user has for the db tables.
- Virgil This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: harry |
last post by:
<input type="text" name="actreqto" maxlength="20" value=""
onkeypress="changedDetails();" onchange="changedDetails();"
readonly="readonly">
Any ideas why doesn't this work?
alert(top.document.forms.actreqto.readonly);
displays 'undefined'
|
by: Matt |
last post by:
I want to know if readOnly attribute doesn't work for drop down list?
If I try disabled attribute, it works fine for drop down list. When I
try text box, it works fine for both disabled and readOnly attribute.
For example, #1 will work, but #2 doesn't work
1) <SELECT name="streetDirection" class="FormInput" DISABLED>
In JavaScript, I have InputForm.streetDirection.disabled = false;
2) <SELECT name="streetDirection" class="FormInput"...
|
by: Michael SL |
last post by:
I have a text area in which I have a client side javascript to process a "onclick". Because it is client side, I used a HtmlTextArea
<TextArea id="Summary" onmouseup="SumMouseUp()" style="WIDTH: 90%" name="Summary" rows="25" runat="server" /
Depending on the circumstance the user can sometimes edit the contents and at other time they cannot. There is a readonly parameter I can use at definition time
<TextArea id="Summary"...
|
by: cjobes |
last post by:
Hi all,
I'm trying to create a dataset as a component to make it accessable from all
forms. I have used that following code so far in the component designer:
Inherits System.ComponentModel.Component
Dim _TryDs As dataSet = NewTry
Public Property dataSet() As dataSet
Get
|
by: blueapricot416 |
last post by:
I am on a team designing the front end of an Intranet application. The
backend guys will be using JSP and AJAX-like functionality to make
server requests that must dynamically change elements on a page.
What is the best way to create and populate tables, which will exist in
floating DIVs (with drag and drop capability)? It only has to work
with IE6.
I know of two ways:
| |
by: Hitesh Joshi |
last post by:
Hi,
I have a prod database (main bread & bread DB) and have a small access
database that sales team is using... I created a login inside SQL 2000
and gave db_read permission and SELECT permissions... and public.
Role of public is EXEC store procs and view some systables...
I linked those tables that I gave permissions through ODBC link into
access db with the user that I created inside SQL as readonly user...
but to my surprise when I...
|
by: sunil |
last post by:
Hello,
I am new to c# . I have some basic programming doubts. Please help me
in clarifying these doubts.
I want to initialize a static and readonly field with a value returned
by a static method. How ever, when I am debugging, that method is not
being called. So I am not able to figure out, whether the field is
getting initialized properly or not. Please explain this behavior
Thanks in advance
|
by: Peter |
last post by:
I have the following web page and I am trying to have the Field lables NOT
to wrap. It looks fine in a designer but when I run the program in a
browser the lables that have a space wrap. How do I prevent this? Also, is
there a better way to design an data entry web page without using tables,
(it's a realy paint in you know what to do that with tables), but I don't
know how to line up the fields any other way.
Thank You
|
by: nzkks |
last post by:
Hi I am using these: ASP.Net 2.0 with VB.Net, Visual Studio 2005, SQL Server 2005
I suspect, there is something missing in BLL class.
I created the ASP.Net form also and checked whether it is working or not. When I submit after entering the data, an error comes.
Please help me to solve this problem. Thanks
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |