I met 'got file handler' error while accessing the
database. I couldn't repair the damage on the related
file and I lost the damaged part. What could be the reason?
__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/vide
I installed MySQL in my local dir (~) (RH Linux7.2). Created database
successfully. No problems in operating on this database at mysql> prompt.
When I run my JDBC (Java) program it gives SQLException
"Server configuration denies access to data source". I am running the MySQL
server using followin
Gokhan Yenikaya writes:
> I met 'got file handler' error while accessing the
> database. I couldn't repair the damage on the related
> file and I lost the damaged part. What could be the reason?
Just about anything, I'd say. Are you using the latest
version of MySQL? Was it MyISAM, InnoDB, or s
Trond Eivind Glomsrød wrote:
>Dennis Jacobfeuerborn <[EMAIL PROTECTED]> writes:
>
>>We are running MySQL version 3.23.43 on one of our servers and have some
>>stability
>>
>
>Where did you get that? The MySQL site?
>
>>Some info about the system:
>> Dell PowerEdge 8450
>> 4 x Xeon 700
>
On Tue, 08 Jan 2002 20:03:07 -0500
Dennis <[EMAIL PROTECTED]> wrote:
> At 07:07 PM 01/08/2002, you wrote:
> >Dennis,
> >
> >You may want to look into using InnoDB tables. I believe InnoDB tables
> >are immune to the 2gb limit (which usually comes from the filesystem).
> >Also, InnoDB claims that
Hi
i've a particular select to do...
here is the order i want :
select *,count(*) as counted from database group by field_to_count order by
counted
this query works but only returns one record per field_to_count (normal
behaviour)
i would want to get all the records (so, "group by" doesn't
Hello
Recently we have installed mysql ver 4.0.1(from
binaries).We loaded about 1.6 million records in a table.
One of the fields 'ti' is text field. We created fulltext
index on this field.
on giving following :-
1. select ti from p8387 where match ti against ('computer');
1701 rows were
Hi all
I was thinking of hosting our MySQL database on a cluster of Sun Netra's
either tmX1 or tmT1 and was wondering if anyone had any experience of these
boxes and how well they work with MySQL. Our database has about 30 tables
and about a million rows. Anyone have any ballpark figures on the n
another approach is using the str_replace() function, just replace the
single quote ' with two single quotes '' and database inserts should be
fine.
http://www.php.net/manual/en/function.str-replace.php
Regards,
Sherwin Ang
Web Programmer / Systems Administrator
Alchemy Solutions
http://www.al
It should also be made clear that MySQL users is different from System
Users. MySQL root account is also different with the System Root Account.
You can restrict users to certain databases with the appropriate parameters
on what the db user can and cannot do.
mysql> user mysql;
mysql> grant ins
you can run it by issuing the command in the dos command prompt like
mysql -u username -p < textfile.sql
but place use yourdatabasename; at the beginning of your text file.
USE YOURDATABASENAMEHERE;
DROP TABLE IF EXISTS NAME;
CREATE TABLE NAME
(KD NUMERIC(3),
OO CHAR(30));
insert into name valu
Sherwin Ang writes:
> another approach is using the str_replace() function, just replace the
> single quote ' with two single quotes '' and database inserts should be
> fine.
Very funny. Let's say you're making this query:
DELETE FROM t1 WHERE str_field = '$value'
with your way of doing things
>Description:
myisamchk -foe /mail/torba/bucho
- recovering (with keycache) MyISAM-table '/mail/torba/bucho.MYI'
Data records: 66
Found block with too small length at 1928; Skipped
Found block that points outside data file at 1320584
Found block that points outside data file at 1590764
Found blo
I have clustered Netra's together before using SUN HA and Vertias VCS.
I found for large content avoid the Netra X1 - more so for webstuff, they
run on a very slow IDE bus. They work excellently for say processing like
the middleware box, or actual webservers but disk heavy apps I would avoid
as
Thanks Matthew...
Have you or anyone else tried running MySQL on them?
thanks again
Chris
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 12:12 PM
To: Christopher Thorpe; [EMAIL PROTECTED]
Subject: RE: Sun netra's and MySQL
I have
[EMAIL PROTECTED] writes:
> >Description:
> Found block with too small length at 1928; Skipped
>
> >How-To-Repeat:
There's no real point in sending bug reports that don't
say anything about what's wrong or how to reproduce the
error. That your table is corrupted could be because of
a power out
Chambon writes:
> Hello,
>
> No there's no thread in my application,
> the program use fork but of course a new connection is create after each fork()
>
> Today before running another test I do the following
> - drop then create the tables
> - increase the limit for opened file from 102
Ok, I had a problem compiling Mysql 3.23.47 on RH 7.1. I kept getting:
checking return type of sprintf... configure: error: can not run test
program while cross compilingany way, i tried updating gcc to 3.0.3
which didn't help. So i installed all the RPM's for gcc 2.96-85 and it
solved the
EDA Peach writes:
> Hi,
>
> Thanks ... I got to work, briefly .. then it logged me
> out. I got MysqlTool running reliably.
>
> Regards, Mike
>
All you had to do is follow instructions from README.
Simply click on Options button, fill up all entries and click on
'Save'. Then restart mysql
Have you installed ncurses or termcap rpm's?
Jonas Arvidsson
-Ursprungligt meddelande-
Från: Steve Mansfield [mailto:[EMAIL PROTECTED]]
Skickat: den 9 januari 2002 13:48
Till: [EMAIL PROTECTED]
Ämne: More compile errors
Ok, I had a problem compiling Mysql 3.23.47 on RH 7.1. I kept gett
http://home.earthlink.net/~jaymzh666/mysql.html
This page mite help?
Simon
-Original Message-
From: Jonas Arvidsson [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 13:29
To: Steve Mansfield
Cc: [EMAIL PROTECTED]
Subject: SV: More compile errors
Have you installed ncurses or termcap r
Hi All,
I have about 15GB of xml files each ranging from about 400bytes to 4k (some
exceptions being up to a few MB, but mainly small), and am planning to stick
these files in a database for better mainteance.
Does anyone have advice on the best way in which to import so many files or
any advic
Il Tue, 08 Jan 2002 13:23:09 -0500, Stephen Abshire andava dicendo...
>>SELECT count(distinct ip) FROM pole_voti
>>
>>It does'nt work. Why ?
>>
>>PhpMyAdmin says: You have an error in your SQL syntax near
>>'distinct ip)
>>FROM pole_voti' at line 1
>I don't have MySQL on the computer I am on to
Jörgen Winqvist writes:
> I run RH supported kernel 2.4.7-10enterprise on such a server with
> similar problems. All four CPU's runs off with a lot off system. I can
> provoke this behaviour by generating disk i/o. A 'cp' might be it. I
> often get it when the full backup is running. I've also
Hi,
What about a 2.4.17 with 'aa' patch, as it seems to have much less VM
problem than vanilla kernel or rmap-10c patched kernel... (I have personnaly
installed 2.4.17rc2 + patch rc2aa2 with no problem :
http://www.kernel.org/pub/linux/kernel/people/andrea/kernels/v2.4/2.4.17rc2a
a2.bz2 )
Best R
Please help
Hi, I have downloaded and installed mySQL, but when I enter in
"c:\mysql\bin> mysqld-max --standalone" I get an error. What am I doing
wrong? The error is attached as a jpg file.
Many Thanks
Andrew
-
Before postin
Hello,
My boss is going through the mysql.com tutorials starting at ...
http://www.mysql.com/articles/ddws/12.html
... and currently stuck at ...
http://www.mysql.com/articles/ddws/13.html
The boss is using phpMyAdmin to access the database, and everything
has been working just fine
You may need to search the Windows registry if WinMySQLAdmin
is not in your startup folder. Run regedit and search for
'WinMySqlAdmin', and if the key is something like 'Run', then
remove it.
> Each time that I reboot and logon to my windows 98 server,
> WinMySQLAdmin starts and then starts my
Andrew,
please do not send attachments to the mailing list. They do not come
through.
I have copied parts from the InnoDB online manual, section 2, below. I hope
they help in installation.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.co
Clive Bredenkamp wrote:
> Hi All,
>
> I have about 15GB of xml files each ranging from about 400bytes to 4k (some
> exceptions being up to a few MB, but mainly small), and am planning to stick
> these files in a database for better mainteance.
>
> Does anyone have advice on the best way in which
Ivan,
currently InnoDB allows a NULL in the child column only if there is a NULL
in the parent column.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
...
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> What about a 2.4.17 with 'aa' patch, as it seems to have much less VM
> problem than vanilla kernel or rmap-10c patched kernel... (I have personnaly
> installed 2.4.17rc2 + patch rc2aa2 with no problem :
> http://www.kernel.org/pub/linux/kernel/peo
Can anybody help !!
$ uname -a
HP-UX dtsipp04 B.11.00 A 9000/871 2004025707 two-user license
$ gcc --version
3.0.1
$ ./configure --prefix=/app/IPPHost/mysql
This runs through ok
i then
$ make
and ultimately get
: warning: "__STDC_EXT__" redefined
: warning: this is the location of the prev
F:\MySQL\bin>mysql -uroot -e "select distinct count(*) from user \G" mysql
*** 1. row ***
count(*): 4
Xi2 ('sE-'tü)
-Original Message-
From: Ilic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 5:54 AM
To: [EMAIL PROTECTED]
Su
Hi,
I have connect to the mysql database as root, and added a user called test
one with the host field containing a % and all the other options with a Y.
In theory I should be able to connect to a remote database as test1 form any
host ? is this correct ?
I am have tried using mysqlgui and mysq
* Ilic
> >>SELECT count(distinct ip) FROM pole_voti
> >>
> >>It does'nt work. Why ?
> >>
> >>PhpMyAdmin says: You have an error in your SQL syntax near
> >>'distinct ip) FROM pole_voti' at line 1
>
> >I don't have MySQL on the computer I am on to test this but you
> >might try rewriting it this
Two quick qux for the gurus on the list!
1. If I needed to do date calculations based upon a TIME STAMP field, what's
the most efficient way to accomplish this with respect to data types (field
types...I already understand how to use the DATE functions and am aware of
locale time and UNIX time tr
Try, adding
master-port=3306 (or the numebr you are using)
to my.ini (slave file) under [mysqld].
I think it is in the manual.
Andrés.
- Original Message -
From: Remco Ploeg <[EMAIL PROTECTED]>
To: Mysql (E-mail) <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 8:59 AM
Subject: mysq
Hi,
I'd like to alter a field and change it from being Unique using the alter
table command but can't seem to get the syntax correct? Can someone give
me an example? IE:
alter table hrcontact modify login varchar(70) not null default'' _NOT
UNIQUE';
thanks,
Dan
---
in the db table there is the db field.
if I put in db1 in this field then the user test1 will only be able to
connect to db1.
the questions I have (I can't quite figure it out from the manual)
1.) how can I get it so test1 can connect to db1 and db2 but not db3. Do I
have to put in 2 entries fo
I am inclined to think (actually guess) it may be the version of MySQL you
are using. I am using MySQL 3.23.39 and I am able to successfully execute:
select count(distinct field) or select count(distinct(field))
I tried to make a quick check of the docs to see if a certain version was
required
I have a database of financial data that I am try to
match a holdings file against... The holdings file has
cusips that I look up in a lookup table to identify
what dataset/table they are in.
I need to check that the cusip is in the lookup
table, and that it has the proper type before
I gra
I have 3 UNIX users on my server.
test1, test2, and test3.
I have created 3 users for mysql test1, test2, and test3 (shock horror)
If I want to connect to the database as root then I understand I must do
mysql -u root -p
but I would like test1 2 and 3 to be able to type mysql and be either l
I think it's like this...
alter table hrcontract drop index login
... assuming the name of the key is "login". You can
have key names (which is what a unique constraint
is) and column names of the same name.
If you do a ...
show index from hrcontract
... it'll show you all of the "key_na
Matthew Darcy wrote:
>
>I have 3 UNIX users on my server.
>
>test1, test2, and test3.
>
>I have created 3 users for mysql test1, test2, and test3 (shock horror)
>
>If I want to connect to the database as root then I understand I must do
>mysql -u root -p
>
>but I would like test1 2 and 3 to be
Matthew Darcy writes:
> If I want to connect to the database as root then I understand I must do
> mysql -u root -p
Unless you're logged in as root, in which case mysql -p is enough.
> but I would like test1 2 and 3 to be able to type mysql and be either
logged
> in as their unix username, ie
I read similar notes on this in the manual, saying that invoking mysql
without the username will try to take the unix username if it exists in the
database.
I tried this with test2, it opened an mysql session no problem, but when I
did a connect mysql it said "access is denyed for user @localhost
Same here:
F:\MySQL\bin>mysql -uroot -e "select count(distinct Host) from user \G"
mysql
*** 1. row ***
count(distinct Host): 2
F:\MySQL\bin>mysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server
You can also try replacing quote marks with their HTML-equivalent entities.
Put this function in your code somewhere:
function PrepareQuotes($Var)
{
$Var = str_replace("'","'",$Var);
$Var = str_replace('"',""",$Var);
return $Var;
}
And on variables that might have apost
COUNT(DISTINCT was introduced in 3.23.2:
http://www.mysql.com/doc/N/e/News-3.23.2.html >
--
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
This will help, it seems: http://www.mysql.com/articles/wizard/page3.html
Xi2
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 10:11 AM
To: [EMAIL PROTECTED]
Subject: mysql query
I am trying to write a query that gets the name of eve
Rember that the sum function sums the total of all
of the colum specified. Is there multiple rows where
the same c.cid_no occurs many times? If so, then you
need a "group by" and "having" clauses. If not,
then you don't need the sum function.
With a group by, it'd look like this... I think ..
Hi!
i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in
one string separated with ';' but i does not work.
some ideas?
blestan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
* Jonathan Hilgeman
> So something like Joe's Farm will look like Joe's Farm. It gets
> inserted into the database without any addslashes, and when you
> retrieve it from the database, it should work fine without any
> converting to this or that.
...and when you search the database, you must do t
Hi,
I have a problem to re-import sql dump from Linux 2.2.19 running
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
into the same mysqld under different database.
while running the same commandline on the source at least.
$ mysqldump --extended-insert Bordetella_pertussis_Tohama_
At 11:26 PM 01/08/2002, you wrote:
>On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
> > At 07:07 PM 01/08/2002, you wrote:
> > >Dennis,
> > >
> > >You may want to look into using InnoDB tables. I believe InnoDB tables
> > >are immune to the 2gb limit (which usually comes from the filesyst
When you are told to fill in fuel and turn the key to drive, I suppose
you don't care how the fuel runs the car. Do the same things in any lib
you use, pushing the "buttons" in told order would work. Well, you may
dig deeper if you like since the code is available.
Alex Shi wrote:
>
> Yesterday
tired that but I am getting
Query OK, 0 rows affected (0.00 sec)
don't understand why it is not granting to the user ?
Matt.
-Original Message-
From: Ho, Kam [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 16:10
To: '[EMAIL PROTECTED]'; Gerald Clark
Cc: MySql List
Subject: RE: comma
I have a table with the columns names and id. I want to be able to find all
names with an id of '03' that do not have other records with id values of
'10','20' or '37'.
Is this even possible to do?
name id
a03
a11
a12
a13 I want 'a' because it has a 03 and
The "Query OK, 0 rows affected" indicate that the user table is updated so
test2 on localhost can access the mysql databases.
Do you still get the "access is denyed for user @localhostto database mysql"
message?
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wed
Hi;
Mysql is not like the Linux/Unix command line. You can't perform such an operation.
Sun
root wrote:
> Hi!
> i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in
> one string separated with ';' but i does not work.
> some ideas?
>
> blestan
>
> -
* blestan (root)
> i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in
> one string separated with ';' but i does not work.
> some ideas?
Where are you trying to send it to/from?
The mysql client (or 'monitor') accepts statements separated by ";", but for
instance the PHP func
In the last episode (Jan 08), Dennis said:
> We have a database that seems to have grown too large, and now any
> operation fails on it. How can we fix this?
If you can SELECT from it, create a new MYISAM table with the RAID
option, or create an INNODB table with multiple 2gb tablespace files.
T
Enable large file support:
[root@xxx array0]# du -h bigfile
2.9Gbigfile
[root@xxx array0]# ls -al bigfile
-rw-rw-r--1 root root 30 Jan 9 11:06 bigfile
[root@xxx array0]# uname -a
Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown
Hello, everyone --
I have received a great deal of help from many members of this list, so
I'd like to acknowledge that now. Someday, when I have my head wrapped
around this stuff, I hope to return the favor. In the meantime,
however, I have come across my worst brainbuster yet. Any help on
Dear Friend:
The first time I received this in my e-mail I deleted it! And later
wished I had it back! I had to wait months before someone E-mailed me
again with this offer! I always thought I would wait until later to try
this. I
wish I had done it sooner now! Don't do what I did! Make Sure y
Can't be done. I know. I tried. I asked the same question several months
ago.
I wish we could do so.
-Original Message-
From: root [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:36 AM
To: [EMAIL PROTECTED]
Subject: How to send multiple statements to the server?
Hi!
i
At 12:09 PM 01/09/2002, Dan Nelson wrote:
>In the last episode (Jan 08), Dennis said:
> > We have a database that seems to have grown too large, and now any
> > operation fails on it. How can we fix this?
>
>If you can SELECT from it, create a new MYISAM table with the RAID
>option, or create an I
Basically, the "mysql_query" submits the sql statement
to the database engine, and the "mysql_fetch_array"
allows retrieval of selected information returned from
the query into an associative array with each columnname
of the query an associative "key" in the array
Example...
--login-to
Hi
I have a table that I want to add a new field to while running on the
server, however, when I try to add a new field, it comes up with the
error13 message, saying it doesn't have permission, yet the files and
folder are all chmod 777. Can it be due to the fact that there is a
permanent conn
Hi,
Can anyone shed some light on this problem I got when trying to compile on a
Linux platform?
/usr/local/mysql/lib/mysql
../libmysql/.libs/libmysqlclient.so: undefined reference to `atexit'
collect2: ld returned 1 exit status
Thanks,
Kevin
-
Needs to be done programmatically
-Original Message-
From: Jerry Rehak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 10:53 AM
To: [EMAIL PROTECTED]
Subject: Complicated Query?
I have a table with the columns names and id. I want to be able to find all
names with an id of
I like the explanation using the automobile and key. Very good :-) Yet at
the same time if I understand what effect using the different grades of fuel
in my car will have on its performance, I can optimize how the car operates.
Much like the original question, if I know when MySQL caches result
On Wed, Jan 09, 2002 at 12:23:27PM -0500, Dennis wrote:
> is the 2GB limit only in linux 2.2? (ie does 2.4 not have that
> limit?). Running a 2.4 kernel is the easiest option in that case.
Right.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 F
I deleted it too! Guess what, I don't miss it either!
-Original Message-
From: Reports [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:12 AM
To: [EMAIL PROTECTED]
Subject: AS SEEN ON NATIONAL TV: MAKE OVER $500,000 EVERY 20 WEEKS!!
Dear Friend:
The first time I receive
Hello!
I use a MySQL database table to store the name of several countries in
several languages. This table is used to create a country list for a
registration form on a website. As the list contains the names in several
languages they are sorted alphabetically only in one language but not in
all
As I said in my message (although I've still not had time to look further
into this) this will not solve your problem completely. My 2.4.17 testbox
will happily create >4gig flies - but as soon as my mysql myisam table
reached 4gig I got a "Table full" error when trying to insert.
Going InnoDB i
Hi, have two tables. One contains the names of ppl along with an id for
each person and a date of the entry. The second table contains some
added info for those ppl, and I would like to have one of the fields in
the 2nd table to be in the first table in irder to make it easier to manage.
The p
I've had no problems with MySQL RAID, and the performance is excellent
as long as you have your indices set up properly. One caveat I might add
is that MySQL RAID does not apply to index files (.MYI). If your index
files are going to grow > 4 GB, you'll need to consider alternate
filesystems anywa
Hello,
while using the MySqlGui 1.7.5, I cannot get the
"create table Menu Option (F9)" to work. Is there
anything I've missed.
thanks
chris
__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-
chc chc writes:
> Hello,
> while using the MySqlGui 1.7.5, I cannot get the
> "create table Menu Option (F9)" to work. Is there
> anything I've missed.
>
> thanks
> chris
>
Nope.
It hass not been implemented.
You can use CREATE TABLE comand ...
--
Regards,
__ ___ ___ __
/
I'm new to MySQL. Does MySQL have archive logging and can you recover to
the point in time of failure in the event of disk crashes? Also, Besides
the manual and classes, what is the fastest way to get up and running on
MySQL considering I am a seasoned Oracle DBA. Are there practical books
Hi Roger,
Thanks for your reply and I apologize for my lack of specificity on my
previous email, thanks for your patience :).
I have a people object that has 4 entities. name, pword, user_id, picurl
This data is stored in the people table. Each user is identified by
a unique user_id. I would li
I recently switched to InnoDB & persistent connections from PHP.
Lately I've been getting these errors "Lock wait timeout exceeded; Try
restarting transaction" on an UPDATE on table. The system is in
development so there is at most one other user ( a back end Perl script).
When I switched PHP
Hi All:
I have problem linking my c++ program in solaris. The same program link
correctly in Redhat linux.
I'm using mysql 3.23.47 source build using gcc 2.95.3 (source build on
solaris using Sun pre-build gcc 2.95.3)
Here's the output from gcc:
Undefined first referenced
Hi,
I had this too - in the documentation, although maybe not highlighted
enough, there are instructions for overcoming 4G - you have to set MAX_ROWS
for you table to a 'large' number to tell mysqld to use > 4 byte pointers
for the file.
Regards
Quentin
-Original Message-
From: Chris W
Hi,
MySQL, being a relational database (quiet, you guys from other camps), is
good at storing relational data.
To store purely XML data, you may be better off using an XML database e.g.
Tomino from Software AG.
The line is a fine one, though. If your XML is purely a representation of
relational
query ok I would expect to see, but "no rows affected" ??? this must mean it
has not altered the database at all ??
I created a 2 new users, dba and matt
I did grant all privileges to *.* to dba@"%"
I cannot conntect from anything host as dba.
I then did
grant all privileges to *.* to matt@"j
Hi
Error 13 is from the OS - nothing to do with locks or whatever.
However, when you add a new field (or change the table structure in (nearly)
any way), mysqld will create a temporary table in the database directory -
are you sure that the permissions on the directory are correct?
Remember, it
Hi SAm,
I actually had a similar problem myself, but was unable to prove it was
the persistent connection itself causing this. I'm wondering if this
means that INNODB thinks that a connection that is now 'sleeping' (ie.
where a connection was created, used, but is now unused but still open)
m
Matt:
Try the following:
Use mysql
select * from user (take a note on users that you're granting rights to)
run the grant command
select * from user (see if there is any differences)
OR
try
grant all privileges to *.* to matt@"ipaddress" (where ipaddress ==
999.999.999.999 your real ip address
Your new best friend:
http://www.phpwizard.net/projects/phpMyAdmin/
Original Message Follows
From: "P.Agenbag" <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Subject: Error 13
Date: Wed, 09 Jan 2002 19:13:51 +0200
Hi
I have a table that I want to add a new field to while running on
* David V. Edelstein
> I would like to create a mySQL query that will find the max
> user_id, use this value to calculate a random value of the
> user_id from [1 thru max], then return the entire row for
> that person(user_id) filled in with that persons(row) four
> entities, which I can use to po
I've found that using PreparedStatement.setString() takes care of any
apostrophe's within a given sql string field.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Are you doing 'flush privileges' are documented?
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 8:26 a.m.
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
query ok I would expect to see,
You must do a "FLUSH PRIVILEGES" after making any changes to the user
permissions before they will actually take effect. This is documented.
james montebello
On Wed, 9 Jan 2002, Matthew Darcy wrote:
> query ok I would expect to see, but "no rows affected" ??? this must mean it
> has not alter
I installed the binary rpm version of MySQL 3.23.47 yesterday and set
up the necessary permissions. This is a single user computer, not on a
network, so I'm both 'root' and 'user'.
Today I tried to start working on the tutorial in the manual and found
that I couldn't create a database and could
Hi!
Looks like your are not committing your transactions. Every UPDATE and
INSERT automatically sets row level locks, which are only removed when you
do a COMMIT or ROLLBACK.
Or you have set innodb_lock_wait_timeout too small in my.cnf.
InnoDB does not set table level locks. Only LOCK TABLES se
>From the Manual (21.11 Problems with File Permissions)
By default MySQL will create database and RAID directories with permission
type 0700. You can modify this behavior by setting the UMASK_DIR variable.
If you set this, new directories are created with the combined UMASK and
UMASK_DIR. For exa
I'm having trouble bulk-loading data into a table. I have a file which
contains:
AYL01ôAYL01-1ôChloeô1979-12-1 0:0:0ôF*END*
AYL01ôAYL01-2ôMelissaô1985-3-2 0:0:0ôF*END*
AYL01ôAYL01-3ôDavidô1979-1-12 0:0:0ôM*END*
COL01ôCOL01-1ôSimeonô1989-12-14 0:0:0ôF*END*
DAV01ôDAV01-1ôMurialô1990-2-2 0:0:0ôF*EN
1 - 100 of 158 matches
Mail list logo
