Hello all.
I have recently finished my migration from an older server to a newer
server running RHEL 6. The MySQL version went from 5.0.77 to 5.1.52.
In my application, this query used to work just fine:
$paid_query = mysql_query("UPDATE $table_name SET owed = 0 WHERE s_id
= $student");
Where t
lp me align my scope with my
equipment/location in mind, kinda doing through the process step by step? I
would really appreciate any input since I´m a dummie about these things.
Thanx !!
Newton Varella, Jr.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I apologize for asking this question.
I am somewhat confused by Microsoft's Licensing and I personally can not
justify to senior management why
MS SQL should be procured instead of procuring software more urgent
requirements.
I had the not so bright idea that maybe a MS SQL emulator or
compatibili
column equals the value in the
modification column? I don't want to specify a specific id in either
of the columns.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi there !
Does anyone knows if there is a specific MySQL ERROR (SQLSATE)
for DELETE of a not found key?
I have tried MySQL Error 1032 e 1176 (SQLSTATE HY000) but it
does not seems to work ..
Thanks in advance
Ni
I have a table:
Id |path1 | display| value
1 | ostype | os|windows
1 | ostype | ver |NT4
2 | ostype | os | linux
2 | ostype | ver | RHEL 5.4
That I would like to tranform into
Id | os| ver
1 |windows | NT4
2| linux |RHEL 5.4
Thank you,
Raymond
smime.p7s
I am using MySql 5.1.14-beta with Java/ConnectorJ on the client.
Section '5.14. The MySQL Query Cache' states 'The query
cache is not used for server-side prepared statements' and I
have confirmed that the results of a stored procedure that
makes use of a passed in parameter are not in fact stored
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 10:24
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Adding and Removing tables from MERGE tables dynamically
I've got a similar setup, total records across about 8 tables ho
Problem: I use two applications one called snort, the client that
inserts data into eleven(11) tables.
The other application BASE joins the tables into one table. When the
tables become 4GB in size,
deleting records for one month becomes unbearably slow(20-30days). The
search(Select ) is slow too
recedence with
the comma operator and the join, I realized there was a
simple fix and that I had misinterpreted the section on the first read.
The revised query works.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
db.tab_f WHERE tab_a.id = 'value' AND tab_a.id2 = tab_e.id2 AND tab_e.id3 =
tab_f.id3 LIMIT 1; <- this is ok
Why doesn't the original query work in MySQL 5.0? What do I need to do to
make it work?
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For l
Thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 18:07
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: I ran of disk space running optimize on table Now I can
not open "data.MYI"
Hmmm. Do
Now, I when I do a desc on data table, I get the error
ERROR 1016 (HY000): Can't open file: 'data.MYI' (errorno: 144).
As I recall I ran:
optimize data;
The Optimize command did not complete the error as I recall was /var
filesystem full.
Running the following commands:
ls data.*
data.MYD
When I try to retrieve all rows in the event table that are in a
particular range and then
try to determine if the cid is in the data table the join takes
forever.
So I tried just tried adding the table to see if the where clause was
slowing things down. Below is a portion on my session.
mys
It appears that every time I start query the event or the data table
gets Locked.
Could this have any affect on why it takes so long to delete records.
Grasping at straws,
Thank you,
Raymond
mysql> show processlist;
+-+---+---+---+-
Could the problem the Locked data table in this case?
mysql> show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
I started the operation below on Friday at 1300hrs EST
DELETE data
FROM data, event
WHERE data.cid = event.cid
AND event.timestamp < "2006-05-01"
It is now Sunday 22:00hrs EST and the operation is still running.
Question: Should it take this long to delete 7.5 million records from a
4.5GB
T
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, July 07, 2006 15:48
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: How does one speed up delete.
Raymond, I would expect that adding an index on 'cid' column in your
'sidte
Env: Freebsd 6.0
MySql 4.1.18
Mem: 1GB(?) can not tell without rebooting
Disk Avail: 4GB
Problem: the table data is 4.5GB.
I created a temporary table sidtemp in the database snort by typing:
CREATE TEMPORARY TABLE sidtemp
SELECT cid FROM event
WHERE timestamp < '2006-05-01';
Query OK, 7501376
Thanks again,
raymond
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006 14:54
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Temporary table ERROR 1109 (42S02) where are temporary
tables kept?
Jacob, Raymond A Jr wrote
Thank you,
I was definitely on the wrong track on this one.
I annotated your commands to make sure that I understood what they
were doing. Are my comments correct?
---
You have the wrong syntax. You can't mention a table in the WHERE
clause that wasn't in the FROM clause. Try
DELE
I ran the following commands:
USE snort;
CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp <
'2006-05-01';
...
SELECT count(*) from sidtemp;
count(*)
7501376
DELETE FROM data WHERE data.cid = sidtemp.cid;
ERROR 1109 (42S02): Unkown table 'sidtemp' in where clause
SHOW ta
Baisley [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 8:49
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Wow, I'm really sorry about that. Left out a zero. I should stop
answering questions before the holiday weekend.
I was suggesting a
]
Sent: Thursday, June 29, 2006 17:55
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Client still reports table full
I'm not sure that avg_row_length has a bearing on your problem right now
... the output of show table status you posted earlier shows that you
have:
current
y, June 29, 2006 15:53
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Oops, left out an important part. You should change the Avg_row_length
also.
ALTER TABLE AVG_ROW_LENGTH = 50
You need to specify an average row length if you have dynamic length
fie
Yesterday:
I ran the following command:
ALTER TABLE data max_rows=1100
Today:
The client still reported table is full.
I rebooted the client and stopped and started the mysql server.
I still get the table is full error on the data table.
I ran the command:
\ echo "SHOW TABLE STATUS LIKE 'da
thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 16:07
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
I agree it's not very clear. I think Br
12:43
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
Raymond, can you post the output of
SHOW TABLE STATUS LIKE 'data';
that should show how big your table is and how big it can be...
Dan
On 6/28/06, Jacob, Raym
Environment: Freebsd 6.0
Mysql : mysql Ver 14.7 Distrib 4.1.18, for porbld-freebsd6.0 (i386)
using 5.0
On the client, I get /var/log/messages, I get the errors:
kernel: 9643D22706C
and
database: mysql_error: The table 'data' is full SQL=INSERT INTO data
(sid,cid,data_payload) VALUES"
I hav
Thank you
Raymond
that did the trick.
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 03, 2006 14:39
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Can I delete old -bin.x files in order to free up some
space?
I believe the
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 03, 2006 14:10
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Can I delete old -bin.x files in order to free up some
space?
Yes you can. Be sure not to delete the one the
I have not been monitoring my databases now I am using a 100% disk space.
thank you,
Raymond
y doesn't work - it finds ALL the rows in Project table and hence
repeats the sites..
I do have an index on the Site table, it is the Site_ID. The
Project.Site_ID is also indexed.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s query is now
frequently in the slow query log.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Several of my DISTINCT searches are frequently showing up in the slow query
log. These queries use multiple table joins. Using EXPLAIN shows that the
queries are using the appropriate keys, as far as I know. Are DISTINCT
searches using multiple joins slow?
TIA.
Stephen P. Fracek, Jr.
[EMAIL
Ferindo Middleton Jr wrote:
Hank wrote:
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated
Hank wrote:
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated field also. Just a
thought.
Yes, I
jonathan wrote:
are you having two timestamp fields in a table (ie a created and a
last_updated)?
-j
On Mar 30, 2006, at 5:17 PM, Ferindo Middleton Jr wrote:
I think I've seen this complaint posted before but I ignored but now
I realize that in some of my db tables' last_updated
I think I've seen this complaint posted before but I ignored but now I
realize that in some of my db tables' last_updated field the value is
automatically updating on UPDATEs to records while in other tables the
last_updated fields for some strange reason aren't automatically updating.
I'll us
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Question: Have I made some err
I have the following query which counts the records from a table called
registration that have an schedule_id that matches a record in another
table called schedules. The below query works fine but how can I get it
to return a COUNT() of 0 each instance where there is no record in the
registr
If say something like the following from the mysql command line tool:
SELECT * FROM dognames INTO OUTFILE 'C:/outfiles/dognames.tab';
How do I get mysql to include the column names in the file's output?
Ferindo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Paul DuBois wrote:
At 20:41 -0500 1/30/06, Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 18:03 -0500 1/29/06, Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables
Paul DuBois wrote:
At 18:03 -0500 1/29/06, Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registra
Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UN
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UN
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
firstnameVARCHAR(256)
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
firstnameVARCHAR(256) NOT NULL,
middlenameTEXT,
la
I have three(3) instances of an application inserting data into a MYSQL (4.X)
database. I have to change the password.
I would like to know, if I can change the password of the application on the
server without disrupting existing
connections then modify the password in the startup file for the
I have the following table where I have a CHECK CONSTRAINT to check for
logical data values but for some reason it's not working on INSERTs to
the table. MySQL doesn't give any error message when I CREATE TABLE. Any
ideas what I'm doing wrong?... or Is this type of declaration not
supported...
Ferindo Middleton Jr wrote:
Gleb Paharenko wrote:
Hello.
It seems that you forgot to OPEN the cursor. The trigger should be
similar to this one:
CREATE TRIGGER trigger_registration_and_attendance_before_insert
BEFORE INSERT
ON registration_and_attendance
FOR EACH ROW
BEGIN
DECLARE
Middleton Jr wrote:
Is it possible to SET values on fields that involve the TABLE that
invoked the TRIGGER with SET actions.
I have the following lines in my trigger:
delimiter //
CREATE TRIGGER trigger_registration_and_attendance_before_insert
BEFORE INSERT
ON registration_and_attendance
FOR EACH ROW
Is it possible to SET values on fields that involve the TABLE that
invoked the TRIGGER with SET actions.
I have the following lines in my trigger:
delimiter //
CREATE TRIGGER trigger_registration_and_attendance_before_insert
BEFORE INSERT
ON registration_and_attendance
FOR EACH ROW
BEGIN
DECL
I have these two tables: 'registration_and attendance' and 'schedules'
They both share a common class_id field. I'm trying to write a Trigger
which will set the class_id field for 'registration_and attendance'
equal to the schedules.class_id matching the
registration_and_attendance.schedule_id
-resetting of
the timestamp on updates. Is
that what you want? To get auto-setting on INSERTs and UPDATEs, just
write
last_updated TIMESTAMP,
Also the manual doesn't mention TIME WITHOUT TIME ZONE. Are you
thinking of PostgreSQL?
PB
-
Ferindo Middleton Jr wrote:
I have been tryi
I have been trying to create a table but mysql 5.0.15-nt-max is having a
problem parsing the statement. Anyone know what the problem is in the
syntax of the following table creation statement:
CREATE TABLE registration_and_attendance (
idSERIAL NOT NU
I have this SQL statement:
CREATE TABLE rooms (
idSERIAL,
room_name TEXT UNIQUE,
location TEXT,
last_updated TIMESTAMP DEFAULT
CURRENT_TIMESTAMP NOT NULL,
400 MB.
Any insights would be greatly appreciated.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
running: mysql Ver 12.22 Distrib 4.0.23, for Win95/Win98(i32) downloaded from
www.devside.net/web/servers/free/download.
When I run a script with the following commands I get sql syntax errors:
Create table 'test' ( 'helper' varchar(22) )
ENGINE=MYISAM DEFAULT CHARSET=latin1;
I get a sql error
Does such a JOIN exist that can create a pivot table?
Thank you:
182361 by: Dan Bolser
182362 by: Peter Brawley
Now I must go into my cave and meditate on these queries: Ommm,Ommm,...Ommm :-)
raymond
Question: I frequently would like to summarize the results of my query in
heiarchical layout also
known as a Pivot table.
Here is an example of what I would like output. NULL will be printed as a space
when output.
sum of broken| source of | qty |reseller of |qty |customer with |qty
How does one insert records based on some kind of meta data or key in
particular table belonging to a merge table?
I have a network logging program and would like to partition the table so that
analysts can query certain tables belonging
to the merge table instead of the whold table to corelate e
Jr
Cc: [EMAIL PROTECTED]
Subject: Re: Is their still any reason why Stored Procedure calls are
not supported in MySql?
Stored procedures are in the works for MySQL 5.0:
http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html
The manual is your friend.
Cheers,
--V
Jacob, Raymond A Jr wrote
Firstly,
I do appologize for my ignorance in advance. I read the message regarding PRODUCT()
and
thought to myself:"A perl interpreter can be run in a C program. Some one must have
written
a userdefined function that can execute perl code. Googling I found
http://software.tangent.org/downloa
-Original Message-
From: Jacob, Raymond A Jr
Sent: Monday, August 02, 2004 21:17
To: [EMAIL PROTECTED]
Subject: archive db daily- Rough Draft
I am new to Databases and would appreciate a second set of eyes looking over my sql
script.
The script takes the existing snort database and
memory?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 9:03
To: Jacob, Raymond A Jr
Cc: [EMAIL PROTECTED]
Subject: Re: How do you archive db daily?
Why not keep your server running and just use scripted SQL to migrate the records from
one
I am running MySql 3.23.58-1 on a snort database containing IDS alerts.
At 12:00am I would like move the previous day's alerts from four tables to
a backup database named for the previous day.
Has anyone implemented such a backup schedule? And if so can someone
send me a script?
I had the follow
can I improve
my query?
thank you,
Raymond
-Original Message-
From: Raymond Jacob
Sent: Monday, July 26, 2004 19:50
To: Jacob, Raymond A Jr
Subject: query analysis
version: MySQL-Max-3.23.58-1
DESC iphdr;
DESC event;
DESC signature;
DESC acid_event
EXPLAIN
select count(ip_ds
Hi,
I'm having a problem every so often with the following error message:
040718 15:21:59 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.16-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306
Number of processes running now: 1
mysqld process hanging, pid 12141 - ki
On Mon, Jul 12, 2004 at 05:28:04PM +0300, Heikki Tuuri wrote the following:
> Ian,
>
> note that the MySQL mailing list is also forwarded to the
> mailing.database.myodbc Usenet group, as well as to several mailing list
> archiving websites. Spam robots and viruses have plenty of places from which
t I definitely come to a grinding halt when I
> try to reach www.mysql.com. I can't do a tracert because the university
> has shut that off here. But I guess it is working for everyone else.
www.trace-route.org ;)
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political
I am getting the following error when trying to dump my DBs.
/usr/bin/mysqldump: Got error: 1103: Incorrect table name
'/home/jr/backups/20040420/wcp.sql' when doing LOCK TABLES
Version is: 4.0.18-standard
These DBs where on another box running the same version. MySQL was
shutdown o
The PHP page that was being reported at being in error wasn't the one in
error.
Sorry for wasting everyone's bandwidth and time.
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
"The only fallacy is the
hp to / for the vhost and it still wants
to try and use [EMAIL PROTECTED] instead of what is defined in my
dbconnect file. I'm out of idea's and am no longer sure this is a mysql
problem but I don't know where else to go. ):
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.or
db so
completely?
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
"The only fallacy is the inaction on our part to stave off the worst of
horrors, the stripping of personal freedom." -- Joseph A. Nagy, Jr. January 2004
On Fri, Apr 16, 2004 at 12:07:39AM -0400, Mark Susol | Ultimate Creative Media wrote
the following:
> On 4/15/04 11:46 PM, "Joseph A. Nagy, Jr."
> <[EMAIL PROTECTED]> wrote:
>
> > So I'm using PHP and MySQL to serve up a game and all is going well until
&g
o I look to fix it?
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
"The only fallacy is the inaction on our part to stave off the worst of
horrors, the stripping of personal freedom." -- Joseph A. Nagy, Jr. Ja
th of which work from my command line.
Neither of the above worked for me with the possible exception of the user
field as I had not had any problems with it. That's okay though as I'm now
having problems with the mysqlaccess command.
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homeli
On Sun, Apr 11, 2004 at 06:34:28PM -0500, Joseph A. Nagy, Jr. wrote the following:
> Problem solved. ):
Well, it wasn't a problem with mysql per sey but a problem with how I was
entering the command.
The man page says
/usr/bin/mysqladmin -u user -p somepassword
is correct as is
Problem solved. ):
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
"The only fallacy is the inaction on our part to stave off the worst of
horrors, the stripping of personal freedom." -- Joseph A. Nagy, Jr. Ja
Okay, I've been googling for about half an hour, found several useful links
but I'm still having a problem with the password for the initial mysql db
that is created when you follow the install instructions.
Here is the problem I'm having:
joseph-a-nagy-jr root # /usr/bin/mysqla
This is for those who love a challenge.
I am trying to come up with a query that would calculate the Standard
Deviation and Variance for 15 fields. Although in theory this is easily done
in Access, MySQL does not have the same mathematical calculations that
Access/SQL does.
Here is the query as i
You have to run the 'mysqld_safe &' command before you run 'mysql'. That
creates the socket for you.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We do not allow SSH access to our virtual hosts but we have dedicated
servers starting at $49 per month.
JR
--
RHCE #808003122507415 MySQL #206067847
Ask Me About Top Notch Web Hosting & Programming!
--
"Computers are like air conditioners:
They stop working properly if you ope
Carmichael [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 11:44 PM
To: Michael Cupp, Jr.
Subject: Re: Installing
> I'm attempting to install using INSTALL-BINARIES and get this message
> while executing mysql_install_db:
Did you download the binaries or compile from source?
> [
I'm attempting to install using INSTALL-BINARIES and get this message
while executing mysql_install_db:
[cuppjr mysql]$ scripts/mysql_install_db
scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary
file
WARNING: The host 'raq2.homeunix.org' could not be looked up with
resolveip.
How do I compare blank spaces in a string using LIKE ?
I tried the following:
SELECT * FROM table WHERE name LIKE '% John %';
But it didn't work.
To explain: I don't want the string 'Johnson' to be shown when running the query
above.
Th
r:
'@localhost' to database 'desenv''
The directory "/usr/local/mysql" and subfiles owner and group are "mysql"
Anybody can help me!
Thanks!
Paulo Fonseca Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysq
"Brian Austin" says:
> Have you read the following page in the Manual on their site?
> http://www.mysql.com/doc/en/Linux.html
>
> This gives you some tips to increase thread allocation. Especially
> interesting is the part about the LinuxThreads hack.
That's where I started, and it's why I compile
I'm baffled by reaching a limit of between 1456 and 1458 connections, at
which
point I can no longer make new connections. I've tried compiling my own
MySQL and using the stock MySql RPM's. I've experimented with ulimits,
values in my.cnf, and kernel parameters, and all the permutations of the
Successfully removed the services. I rechecked and, no mysqld, just
MySQL and mysqld2. Thanks!
That should close out this thread!
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:30 AM
To: Degan, George E, JR, MGSVC; Stefan Hinz
Cc: [EMAIL
9:45 AM
To: Stefan Hinz; Degan, George E, JR, MGSVC
Cc: Paul DuBois; [EMAIL PROTECTED]; Mark Matthews
Subject: Re[4]: Can run two versions of MySQL in Windows 2000?
At 14:47 24/7/2003 +0200, Stefan Hinz wrote:
Hi,
> > (I think I messed up here. I decided to start from scratch, I removed
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 5:15 PM
To: Degan, George E, JR, MGSVC
Cc: Paul DuBois; [EMAIL PROTECTED]
Subject: Re[2]: Can run two versions of MySQL in Windows 2000?
Degan,
jumping in to try and solve some problems that
My responses are "parenthesied" in the text below.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 2:56 PM
To: Degan, George E, JR, MGSVC
Cc: [EMAIL PROTECTED]
Subject: RE: Can run two versions of MySQL in Windows 2000?
At 13:01
nks for not giving up on me!
George
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 12:59 PM
To: Degan, George E, JR, MGSVC
Cc: [EMAIL PROTECTED]
Subject: RE: Can run two versions of MySQL in Windows 2000?
At 6:32 -0500 7/23/03, Degan, George E
f this is not a correct answer to your
question, please clarify.
Finally, thank you, I will change the name of the folder as you suggest.
George
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:42 PM
To: Degan, George E, JR, MGSVC; [EMAIL PRO
s the 4.0.13 database?
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 12:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Can run two versions of MySQL in Windows 2000?
"Degan, George E, JR, MGSVC" <[EMAIL PROTECTED]> wrote:
I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0.
4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to
launch mysql it brings me to the old version, how do I access the new one without
killing the old one? (I have also tried p
I am attempting to create a temporary table to do a complex query and I get an error:
error 1044: Access denied for user: '@localhost' to database 'shopsample'
what can I do to keep this from happening? I am using the production version of mySQL
4.0.13 in windows 2000.
Here is the query:
create
I am finally able to enter data and am going through the Tutorial in section 3 of the
mySQL manual. It suggests that I create a .txt file from which to load date into a
table. Where does mySQL look for data to load in the default installation? I thought
it would be in the data folder under my
1 - 100 of 172 matches
Mail list logo