Jeremy Zawodny wrote:
On Sat, Jun 28, 2003 at 01:14:37PM +0200, Richard Fuchs wrote:
are there any known issues with this combination, or with mysql 4.0.13
or freebsd 5.1 in general? what could be the cause for this, and how
could it be fixed?
You seem to be the first reporting a problem with
On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
> Hello, I've got a situation I'm hoping someone here can help me out with. We
> have a web server serving up data via some PHP programs pulling from MySQL
> (3.23.56 currently) in INNODB tables. There are 40+ (active) databases
> tota
Thanks Salam, but a question: this would mean that I must do by hand
every record ID link, no?
Ted
On Sunday, June 29, 2003, at 02:29 AM, Salam Baker Shanawa wrote:
Hi Ted,
1. Modify the query which presents all records by selecting let's say
the peopleID.
2. When you build your update lin
On Sat, Jun 28, 2003 at 01:14:37PM +0200, Richard Fuchs wrote:
> hi!
>
> i'm using mysql 4.0.13 from the standard freebsd 5.1 ports distribution,
> and i keep getting repeated random table corruptions. the same thing
> happens when building both with the native threading lib, and with
> linuxth
Hi Ted,
1. Modify the query which presents all records by selecting let's say the
peopleID.
2. When you build your update link you can use that ID to ask for a particular
record.
3. Then you can use the same query +
" AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK".
something like
>Description:
When I start up mysqld (4.1.0-alpha), I get the message in the
error log:
mysql.user table is not updated to new password format: Disabling new password
usage until mysql_fix_privilege_tables is run
I *HAVE* run mysql_fix_privilege_tables. At least
From: root <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [mysql-test-run failure Mac OS X 10.2.6]
>Description:
>How-To-Repeat:
< sudo perl mysql-test-run>
>Fix:
< unknown >
>Submitter-Id:
>Originator:System Administrator
>Organization:
>MySQL support: [none]
On Saturday, June 28, 2003, at 07:15 PM, Bruce Feist wrote:
otherguy wrote:
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
That gets me halfway there
BF: Does it?
No, I don't think it does, upon further consideration and testing...
I thought it did b/c I read, and misinterprete
otherguy wrote:
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
That gets me halfway there
BF: Does it?
No, I don't think it does, upon further consideration and testing...
I thought it did b/c I read, and misinterpreted the UNION
documentation
BF: In your original question
I'm writing here in hopes of finding someone who uses this and might be
able to help me.
I am dealing with a recordset who's query is thus:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID
I regularly have users email me reporting that they've hit the max (usually
begging for me to raise or remove the limit)
An example (from this morning) is:
SQL Error : 1226 User 'algalord' has exceeded the 'max_questions' resource
(current value: 800)
I similarly do get reports of connection lim
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
otherguy wrote:
That gets me halfway there
Does it?
Yes, it does.
No, I don't think it does, upon further consideration and testing... I
thought it did b/c I read, and misinterpreted the UNION
documentation
In your original questio
- Original Message -
From: "Bruce Feist" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 6:28 PM
Subject: Re: Advanced Query Help (My brain hurts!)
> otherguy wrote:
>
> > That gets me halfway there
>
> Does it?
Yes, it does.
>In your original que
OK - one more freebie :-)
How about a TEMP table? You can create a temp table, fill it with the
results of your UNION statement and then JOIN it with this new UPDATE
query - that should get you what you need. Note that this is a workaround
for MySQL - in other DBRMS, you can use a sub-SELECT to qu
otherguy wrote:
That gets me halfway there
Does it? In your original question, you'd indicated that you only
wanted zips where *both* criteria were met -- enough CIRGs and enough
CILTs. By using a UNION, you'll be getting zips where *either* is met.
Bruce Feist
--
MySQL General Mailing Li
Thank you!
That gets me halfway there, and not to my surprise, it's not even that
hard! I should've known that it wouldn't be.
So the other part that I truly have no idea how to do the following:
UPDATE this_other_table
SET satus =
WHERE zipcode IN ();
can someone provide me with some poi
At 18:15 -0400 6/28/03, Gary Huntress wrote:
Yes, I am referring to MAX_CONNECTIONS_PER_HOUR, poorly worded on my part
sorry.
Users are granted access to only one database (barring errors in my scripts)
and I did verify that his entry in mysql.user is 200 for max_connections.
And the connections in
Yes, I am referring to MAX_CONNECTIONS_PER_HOUR, poorly worded on my part
sorry.
Users are granted access to only one database (barring errors in my scripts)
and I did verify that his entry in mysql.user is 200 for max_connections.
And the connections in the logfile are for the same user each time
That works perfectly. Thank you.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 2:42 PM
To: Eric Kilgore; [EMAIL PROTECTED]
Subject: Re: left join on more than one field
At 12:29 -0700 6/28/03, Eric Kilgore wrote:
>Anyone know how to perform
Very good question, I believe I do since it does work 90% of the time. Only
occasionally it doesnt work, and thats why I need help
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 4:50 p
At 16:47 -0500 6/28/03, Phil Dowson wrote:
Hi,
I am experiencing a problem creating temporary tables within a MySQL
database. When I run the following query:
CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY
rmmtid;
drop table rmb
I get the error
[server] ERROR 1044: Access
Hi,
I am experiencing a problem creating temporary tables within a MySQL
database. When I run the following query:
CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY
rmmtid;
drop table rmb
I get the error
[server] ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to d
At 17:26 -0400 6/28/03, Gary Huntress wrote:
I have some simple user quotas set to help balance my server load. I think
I've implemented them properly because people do whine to me when they
reach the query limit.
I have max_connections set to 200, but right now I'm watching connections
for 1 use
At 12:29 -0700 6/28/03, Eric Kilgore wrote:
Anyone know how to perform a left join by more than one field?
I have several tables I'm working with. An example query is like this:
SELECT tbl1.Name, tbl1.Location, tbl1.Case, tbl1.Class, tbl1.Type,
tbl3.Identity, tbl2.FileDate, tbl2.Status
FROM tbl2
I have some simple user quotas set to help balance my server load. I think
I've implemented them properly because people do whine to me when they
reach the query limit.
I have max_connections set to 200, but right now I'm watching connections
for 1 user scroll by at an alarming rate. 7800 in le
OK, the picture is now a little bit simpler:
1. Your performance problem is coming mainy from one BIG database.
2. Although your servers have a lot of RAM (at least 4Gb), InnoDB
can only use a small fraction because of addressing limitations of
32 bits CPU.
Some random ideas:
1. Swith to a 64
hi!
i'm using mysql 4.0.13 from the standard freebsd 5.1 ports distribution,
and i keep getting repeated random table corruptions. the same thing
happens when building both with the native threading lib, and with
linuxthreads.
i figured it would be related to threading as it's always happening
Ahh, there's something I could have explained better. Each of the databases
represents a remote office of a different customer. I specifically want/need
to keep the data separate, it doubles as an offsite backup for these offices
as well as would conflict if it were merged. I currently use replicat
Dan Bowkley wrote:
Hey there everyone,
I'm trying to get a table of computer parts manufacturers populated with
a list culled from my distributor and I'm having a devil of a time
getting anything to work. I'm totally new to MySQL and don't really
know my SELECT from a hole in the ground just yet.
Hey there everyone,
I'm trying to get a table of computer parts manufacturers populated with a list culled
from my distributor and I'm having a devil of a time getting anything to work. I'm
totally new to MySQL and don't really know my SELECT from a hole in the ground just
yet...which is proba
El Sáb 28 Jun 2003 12:24, Zachary Perschall escribió:
> Help! I'm trying to do an insert statement where one of the fields
> sometimes contains an apostrophe. The field type is a varchar. Everytime
> that one of these values comes up with an apostrophe, it tells me there is
> an error in my SQL st
Anyone know how to perform a left join by more than one field?
I have several tables I'm working with. An example query is like this:
SELECT tbl1.Name, tbl1.Location, tbl1.Case, tbl1.Class, tbl1.Type,
tbl3.Identity, tbl2.FileDate, tbl2.Status
FROM tbl2, tbl1 LEFT JOIN tbl3 ON tbl1.Case = tbl3.Ca
At 0:42 +0530 6/29/03, harsh wrote:
> >thanks for help..:)
It sounds as though you really want something more like this:
DELETE FROM data WHERE name='harsh';
That will only result in deletion,I want it to be displayed
and simultaneously deleted.more precisely the effect of following
two comman
> >thanks for help..:)
>
> It sounds as though you really want something more like this:
>
> DELETE FROM data WHERE name='harsh';
>
That will only result in deletion,I want it to be displayed
and simultaneously deleted.more precisely the effect of following
two commands in one
SELECT from data
Recently, and pretty consistently our slave's relay logs have been getting
garbage that is not in the master. The symptom is usually a truncated
query with a few characters of garbage. The solution for now is to change
master to to the errored master bin log and position and have it start
re
On Sat, Jun 28, 2003 at 11:35:54AM -0600, Jerry M. Howell II wrote:
> On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
> > lol of course
> >
> > mysqldump -u username -p databasename > databasename.sql
> >
>
> I am atempting to backup a database remotely. I added something like the
Well, the easiest thing is to "escape" any single quotes with a backslash
character (\). PHP includes a function named addslashes() that does this.
http://us4.php.net/manual/en/function.addslashes.php
Same logic applies in other languages.
Hope this helps.
Andrew
> Help! I'm trying to do an
Maybe my question is too obvious but, since you have several databases
instead of only one, have you considered moving some of them to a
separate server ?
Also, have you checked MySQL replication capabilities ?
It is a very efficient way to distribute the load across several
servers unless you do a
why don't you just insert your values after you escaped some special characters?
specifically, you have to replace all ' by \' (prepend a single backslash character),
and everything works fine!
i guess you do your INSERTs from out of some programming language, like PHP, Perl or
C. just use the
Help! I'm trying to do an insert statement where one of the fields sometimes contains
an apostrophe. The field type is a varchar. Everytime that one of these values comes
up with an apostrophe, it tells me there is an error in my SQL statement (obviously
because it thinks there are more informa
Hello, I've got a situation I'm hoping someone here can help me out with. We
have a web server serving up data via some PHP programs pulling from MySQL
(3.23.56 currently) in INNODB tables. There are 40+ (active) databases
totalling a bit over 28 Gigabytes at this point. As we add more users speed
On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
> lol of course
>
> mysqldump -u username -p databasename > databasename.sql
>
I am atempting to backup a database remotely. I added something like the
following.
mysql> GRANT ALL PRIVILEGES ON db.*
-> TO david@'192.58.197.0/255.
At 12:58 -0400 6/28/03, J.A. Jones Tyler III wrote:
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
Where are these instructions found?
Got em here :
http://www.analysisandsolutions.com/code/mybasic.htm#installation
Yes, unless some other user table matches first, which may
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
> >
> >I have gone into the user table in mysql db and placed
> >both 'localhost' and '%' into the host entry. It was
> >my understanding that '%' would allow access from any
> >host for that particular username.
>
> Yes, unless
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
> Where are these instructions found?
Got em here :
http://www.analysisandsolutions.com/code/mybasic.htm#installation
>
> Yes, unless some other user table matches first, which may be
> what is happening in your case.
Cool
- Original Message -
From: "J.A. Jones Tyler III" <[EMAIL PROTECTED]>
>
> I have gone into the user table in mysql db and placed
> both 'localhost' and '%' into the host entry. It was
> my understanding that '%' would allow access from any
> host for that particular username.
>
Well, I f
At 12:20 -0400 6/28/03, J.A. Jones Tyler III wrote:
Greetings,
I have installed MySQL 4.0.13 in a Windows 2000
machine. I am new to this and originally did the
install on a box that was secure from the internet and
ran some tests. I ran a forum software program and
also created a few databases on
At 21:40 +0530 6/28/03, harsh wrote:
Hi,
I need to perform a query which deletes the selected
results from the table,
like
SELECT * from data where name='harsh' (here i want something to delete it
as well)
if its possible with single query...
thanks for help..:)
It sounds as though you really wan
At 18:11 +0200 6/28/03, anders thoresson wrote:
Hi,
I've three tables that my local MySQL server accepts, but when I try
to create the same three tables on my ISP's server, it doesn't work.
These are the three tables:
CREATE TABLE un_user
(
u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
At 17:56 +0900 6/28/03, Itoh Kohji wrote:
Now I have solved the problem I asked you to help me!
The problem was when to invoke mysql_install_db.
I invoked it before l let the daemon start, following the
instruction of a textbook on MySQL.
I have found in a magazine that I shoulld have run the
sc
Greetings,
I have installed MySQL 4.0.13 in a Windows 2000
machine. I am new to this and originally did the
install on a box that was secure from the internet and
ran some tests. I ran a forum software program and
also created a few databases on my own, all
successfully (although some troubleshoot
At 1:08 -0400 6/28/03, Asif Iqbal wrote:
Can I dump a database while the database is running in mysql ?
Yes. You can, for example, use the mysqldump program. mysqldump
is a MySQL client program that, like all MySQL clients, requires
the server to be running.
--
Asif Iqbal
http://pgpkeys.mit.edu:1
Hi,
I need to perform a query which deletes the selected
results from the table,
like
SELECT * from data where name='harsh' (here i want something to delete it
as well)
if its possible with single query...
thanks for help..:)
-
Hi,
I've three tables that my local MySQL server accepts, but when I try to
create the same three tables on my ISP's server, it doesn't work.
These are the three tables:
CREATE TABLE un_user
(
u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
u_uname VARCHAR(20) NOT NULL UNIQUE,
Has any of the MySQL gurus here made any amendments to Oscommerce's DB structure
or added any tailored queries? I have custom made 26 shipping modules for
certain shipping specifications and now I have another one to cater for!
product category type. The problem with this is that the product cate
Well, the only thing that matters is that you are returning the same number
of columns with, presumably, the same data types in both queries. Obviously,
UNION wouldn't be helpful if you had 2 columns in the first query and 8
columns in the second.
I'll leave it to you to find the documentation on
Hello,
I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the
used version. What is the command to do that? (according to mysql.info
it is Version 3.23.42. )
Are foreign keys and referencial integrity supported by MySQL Version
3.23.42. ?
If yes - why is the second "insert into" com
please don't top-post.
# [EMAIL PROTECTED] / 2003-06-27 14:01:58 -0400:
> On Fri, 27 Jun 2003, Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
> > > I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
> > > pthreads-1_60_beta6-mysql.tar.gz from your
Itoh-
Is the MySQL doc incorrect?
Please advise.
Martin
- Original Message -
From: "Itoh Kohji" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 4:56 AM
Subject: Now I have solved my problem!
>
> Now I have solved the problem I asked you to help me!
>
> The
Bob Ramsey <[EMAIL PROTECTED]> wrote:
>
> I'm using 3.23.51 and I'd like to update a field in a certain order. I've
> got a table of images for a slide show and the format of the table is:
>
> image varchar(128) not null
> order_number integer not null primary key
>
> So we might have somethin
Xavier Fern?ndez i Mar?n <[EMAIL PROTECTED]> wrote:
> I am able to start the mysql daemon with:
> # [usr/local/mysql/bin] safe_mysqld &
>
> Then, on /var/lib/mysql appears the 'mysql.sock'.
>
> But the problem is that I want the server running since I start my computer,
> and not having to re-sta
6/27/03 6:37:49 PM, Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
>> My read/update ratio would be something along the lines of 1:3, 3
>> updates for every read. So it is highly unusual, and more or less
>> rules replication out of the picture.
>
>I'm unclear why you can't use replication for this. T
Hello,
I am able to start the mysql daemon with:
# [usr/local/mysql/bin] safe_mysqld &
Then, on /var/lib/mysql appears the 'mysql.sock'.
But the problem is that I want the server running since I start my computer,
and not having to re-start every time.
And when I start my computer, there is no
Now I have solved the problem I asked you to help me!
The problem was when to invoke mysql_install_db.
I invoked it before l let the daemon start, following the
instruction of a textbook on MySQL.
I have found in a magazine that I shoulld have run the
script after letting the mysql daemon st
lol of course
mysqldump -u username -p databasename > databasename.sql
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 3:08 PM
To: [EMAIL PROTECTED]
Subject: mysql database dump
Can I dump a database while the database is running in mysql ?
--
> So, my question is how can multiple values for a single
> field get represented in a single row and receive the
> benefits of an index? How can this data be represented?
Nice puzzle.
At first I thought it couldn't be done, given all your
constraints.
But there is one way.
You will have to bui
66 matches
Mail list logo
