Hi,
I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a
password is required for access.
Both GRANT and REVOKE give errors saying "Table 'User' is read only". A text
search in the manual for "read only" did not yield anything.
Is this an OS attribute that should be dealt with ma
> On Wednesday 22 May 2002 18:44, Dave Watkins wrote:
> > At 16:02 22/05/2002 +0800, Patrick Hsieh wrote:
> > >Hello list,
> > >
> > >I am expecting to have 30,000 http clients visting my website at the
> > >same time. To meet the HA requirement, we use dual firewall, dual
> > >Layer-4 switch and
I figured it out but I'm a bit confused as to why it happened.
I'm running the load as user1. The file resides at /home/user1/data/filename
Permissions:
filename 666
data 777
user1 700
I had to change permissions on user1 to 777 in order for it to work. If I'm
logged in as that user, why would I
I just got ViewPoint, which generates web based graphical stats for firewall
use. It collects syslog data, and it stores the data in mySQL. These web
based stats only display data for one day at a time (you get to choose your
day), and does not serve my needs, so I want to get into the data that i
yes. I tried all of these methods:
1) "//dir1//dir2//file"
2) "/dir1/dir2/file"
running load from file dir using:
"./file"
".//file"
I also check the file permissions and it is all read/write.
I can't remember if I tried to run it using mysqls root yet...that would be
the next step, but I prefer
did you supply the /full/path/to/the/file/ ?
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:15 AM
To: [EMAIL PROTECTED]
Subject: Newbie--Easy data loading question
Hello
Forgive me for being a little naive but.
I a
Hello
Forgive me for being a little naive but.
I am trying to load a table with a text file using the load data infile
command in mysql. I can do it if I place the
text file in the db directory, but I want it to reside in a different dir. I
am getting the error 13: Can't get stat on
What
Dear MySQL Wizards,
I discovered a solution that works to resolve this problem. :-)
Here are the steps I took.
--
1. At the O/S, I copied the three MySQL files to a new name, a_copy.
2. I used mySQLman to delete an index and then to recreate it. I did this
because the syst
Description:
I used mysqldump to create an SQL file containing a dump of all databases on
the server, including all tables and data (using --all-databases). However,
when I tried to restore from this file, the mysql command line tool reported
errors. I guessed that this was due to the --extended-i
Dear Hoa,
RE>>> I have the mysql server running. I can't connect to it though. It
reads,
> "Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock'.
-
Stop it, (either mysqld or mysql), then start again. On my servers, the
mysql startup script is in /e
Hi!
Thanks to your test case a bug with big result sets in UNION's has
been fixed.
This is a patch that fixes a problem :
= sql/sql_insert.cc 1.62 vs edited =
*** /tmp/sql_insert.cc-1.62-31035 Thu May 9 17:30:57 2002
--- edited/sql/sql_insert.ccFri May 24 14:05:51 2002
*
saraswathy,
Friday, May 24, 2002, 5:21:27 AM, you wrote:
ss> Can anybody help me? is there any other specific command instead order by ID
ss> DESC to select all the record from table where the ID is the last ID.The ID
ss> is autoincrement.
ss> Record is like this:-
ss> ID name gender
ss> 1
Taylor,
Thursday, May 23, 2002, 11:46:16 PM, you wrote:
TL> What priviledge does a user need in order to be able to execute the load data
infile command in mysql..? is it FILE?
Yes, you are right. Your user must have file privilege.
Note: MySQL must have permissions on that file in your OS.
T
Anil,
Thursday, May 23, 2002, 8:30:33 PM, you wrote:
AG> when i try to read a table using query
AG> select * from
AG> it shows following error:
AG> cant open file:'anil.MYD'.(errno: 145)
AG> y such an error can come!!
AG> earlier it was fine.
# perror 145
Error code 145: Unknown error 145
1
Eugene,
Thursday, May 23, 2002, 4:42:57 PM, you wrote:
EM> Victoria
EM> Thanks for the quick response. If I enter what you provided using a 'dos'
EM> command, I get "Access is denied".
Check your permissions! If you get any error you should include full
error message! Besides, if you use user n
Ritu,
Thursday, May 23, 2002, 5:04:29 PM, you wrote:
RS> REALFROM: Ritu Singla <[EMAIL PROTECTED]>
RS> HOUR: 2002052320
RS> hello,
RS> i'm trying to install mysql-max...using binaryver 3.23.49
RS> i change the [mysqld] options in /etc/my.cnf as foollows to enable InnoDB
RS> table options:
You have written the following:
[snip]
> I have a file(transfile) that has 2 fields(cust# and item#)
>
> CUST# ITEM#
> 1 '12a'
> 1 '13a'
> 2 '12a'
> 3 '13a'
> 4 '15a'
>
> If I want to select customers that have ordered item '12a' but not '13a'
> How can I do this?
SELECT CUST#, ITEM#
FROM
Here's one way. Assumes that cust/item pairs are unique.
select cust, sum((item='12a')+2*(item='13a')) as IND from transfile
group by cust having IND=1;
Alternatively, you could build a temporary table with cust's who ordered
13a,
the use a left join.
> From: "Smith, Mike" <[EMAIL PROTECTED]>
Hello,
i'm running mysqld-max ver 3.23.49. When i see the
process status (ps), there are 10 processes running of
mysqld. is this fine or something wrong???
Thanks!
Ritu Singla
Everything you always wanted to know about ca
Hello, all!
I'm working on some perl script and have problem connecting to mysql
server.
The problem is: it's ok if connecting to localhost, but can't connect
to other server.
Example:
### RDB.pm
require RErrorHandler;
require RHash;
require DBI;
package RDB;
@ISA=qw{ RHash };
my $connection='_
Hi
I'm new with mySQl and I'm experiencing problems when using it with
myODBC (my OS is W2000).
I developped a short program which uses myODBC to insert and
retrieves values from a mySql table. The problem I have is : When I
send,threw myODBC,
a query such that:
insert into table1 values('é
Hi!
I want to create a table, using a select statement to fill it.
Iam using a Database called Listeria_monocytogenes_EGD_int:
>From that I want to select the following: There is a table in which a
code-hitcode pair is stored. I want to select a additional value
(funcat) to each code and hitcode
I am thinking of running a web based survey in which
the data from each participant's responses go into a
single row in a table. Some of the responses (around
10) are free text so I will be using text/blobs to
store them. There are about 35 columns in the table in
all (out of which 10 are text). E
23 matches
Mail list logo
