iated.
_____
Jamie DelleMonache | Solutions Specialist
MEI | 610 Old York Rd, Suite 250 | Jenkintown, PA 19046
P: 215-886-5662 x282 | F: 215-886-5681
E-Mail: jdellemona...@maned.com
http://www.maned.com
o a fixed date?
Thanks
Jamie Madill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It's probably much faster to do this in perl, since the use of @row
means MySQL can't use its query cache.
--
Jamie McCarthy
http://mccarthy.vg/
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
How do the OS statistics look on both boxes. Do top, sar, vmstat or
iostat show any CPU, memory or I/O performance issues? Does anything
odd appear in the /var/log/messages file?
-Jamie
On Thu, 11 Nov 2004 18:42:48 -, Graham Cossey
<[EMAIL PROTECTED]> wrote:
>
>
,
Jamie
Hi Guys,
I am running winxp with mysql 5.0.
I am attempting to run this statement
mysql> load data infile "c:\\mysql\\pop.txt" into table population
(lastname,firstname,age,sickness);
after waiting about a minute I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
and then a m
If you resize the password column to what it was pre 4.1 it will store a
hash the same length as the old algo used to produce and users will be able
to log in just fine.
Michael Stassen pointed me to this link
http://www.mysql.com/doc/en/Password_hashing.html>. and it has a number of
work arounds
.
cheers!
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "jamie murray" <[EMAIL PROTECTED]>
Cc: "Gerald R. Jensen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, January 04, 2
rant all privileges on *.* to [EMAIL PROTECTED] ;
I can access mysql from command line and these ->(php,perl,odbc,python
etc...)
- Original Message -
From: "Gerald R. Jensen" <[EMAIL PROTECTED]>
To: "jamie murray" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
Hi guys,
I posted a similar question on this the other day but received no answers.
I'm running 5.0 and have a possible security/password problem. If i run from command
line all users work with or without passwords.
If I try and connect to mysql through php,perl,python or odbc with a user that ha
Hi Guys,
I am running winxp with mysql. Seeing this is a home machine there is no workstation
just one computer which I guess at this point is acting as my server and client for
mysql. I am just getting acquainted with mysql so I have been playing around with both
4.1 and 5.0. Neither database is
can you show the actual code for php that does this.
- Original Message -
From: "Reza Milan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 26, 2003 1:55 PM
Subject: SQL Support
> Dear sirs,
>
> I installed PHP and MYSQL on my XP system.
> All commands supported excep
Plinio,
Hence my suggestion for use of a flat file. The file can be located on the
db server middle tier wherever it doesnt matter.
The important part is that you control what goes in the file and its done
ahead of time not when an enduser presses a button.
What about creating tables the users can
What about creating a flat file on the middle tier from the database system
tables that the clients can view with your gui or web page.
Only things is keeping the file in sync with the system tables. But access
will be faster to the flat file and no security risks
because there won't even be a conn
I'm new to MySql as well but the "LOAD DATA" statement is probably what
your looking for. It's a bulk loader and dumps the data from a flat file
into a designated table for you. You could easily automate this by writing a
simple perl script(probably php also but im not to familiar with that
langua
You still need to flush the privileges. Changes in permissions are not
automatically committed. Also you should add the host to the username.
grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
grant option;
flush privileges;
Jamie
On Sun, 2003-08-03 at 09:52,
Sorry, sent it to the wrong address. Thought I had the right one on it.
On Wed, 2003-07-23 at 20:48, Jeremy Zawodny wrote:
> On Wed, Jul 23, 2003 at 08:31:21PM -0700, Jamie Krasnoo wrote:
> > Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in
> > startup
in the module code and still work as normal.
Jamie Krasnoo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
be safely ignored? Any help would be appreciated.
Thanks,
Jamie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'[dir_stuff]/master.pid file was not created in 30 seconds;
Aborting.' and the test dies. It's compiled on RedHat 9 if that makes a
difference. I'd like to be able to get by this error and make a full
test before moving on and would appreciate any help.
Thanks,
Jamie
--
MySQL
I'm trying to use a INSERT INTO table1 (column1,
column2, column3) SELECT 'value', 'value2',
table2.value3 FROM table2 WHERE table2.value4='name';
This query fails from C, but if I copy and paste it
exactly to the mysql client, it works.
If I run mysql_info(), it tells me:
Records: 0 Duplicates
This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov <[EMAIL PROTECTED]>
wrote: > Hello mysql,
> I have 2 tables :
>
> Table1:
TED]> wrote: > On Tuesday
04 March 2003 16:51, Jamie Jennings
> wrote:
>
> > Hi. I've got two mediumint columns in a mysql
> table,
> > and I'm trying to subtract them like this:
> >
> > SELECT column1-column2 FROM table WHERE
> > name='john
Hi. I've got two mediumint columns in a mysql table,
and I'm trying to subtract them like this:
SELECT column1-column2 FROM table WHERE
name='johndoe';
This works some of the time, however, I get weird
results for negative numbers. For example, when
column1=0 and column2=4995, I get:
18446744073
0800, you wrote:
On Mon, Dec 16, 2002 at 10:43:28AM -0600, Jamie Sullivan wrote:
> Hello,
>
> I am setting up a mySQL box in my development environment and have
> noticed that even under little usage mysql will consume a couple
> hundred MB's of swap space even though I have a
At 09:20 AM 12/16/2002 -0800, you wrote:
On Mon, Dec 16, 2002 at 10:43:28AM -0600, Jamie Sullivan wrote:
> Hello,
>
> I am setting up a mySQL box in my development environment and have
> noticed that even under little usage mysql will consume a couple
> hundred MB's of swap
7; configuration file and otherwise
haven't modified anything. The server is a 400Mhz sparc w/ 2GB ram and 1
SCSI disk. Can someone please provide some guidance as to whether this is
normal or am I not configuring something properly.
Thanks,
Jamie Sullivan
EOS, Inc.
717 South Grand Avenue West
st, and do periodic "LOAD
DATA INFILE" commands, so as to bulk insert records.
Are there any websites/webpages or books that detail optimizing writes to
MySQL databases (aside from "more memory" or "faster CPU" or "faster hard
drive").
Thanx,
Jamie Beu
Loc
want to run some benchmark tests, but I need precision greater than 1 sec
(the automatic timing output from MySQL is to the hundredth of a second,
which will suffice).
Please help. I am not using PHP at all - just sourcing MySQL query scripts.
Jamie Beu
Lockheed-Martin Information Systems
Software
r/lib/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
---
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 08, 2002 3:45 PM
To: Jamie Beu
Cc: [EMAIL PROTECTED]
Subject: Re: Replication problem: slave can't lo
the
MySQL online manual.
Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484
"The true soldier fights not because he hates what is in
front of him, but because he loves what is behind him."
G. K. Chesterton - Illustrated London News, 1/14/11
-Origin
ue'
GROUP BY id
HAVING count(correct)=4
This should work (*although I have not tried it yet*).
Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484
"The true soldier fights not because he hates what is in
front of him, but because he loves what is behi
sh. I just can't seem to get
replication to work.
I even tried creating a Linux user account for "repl" on ctiadb1 (the master
server), in order to enable file
access for replication. This seemed to work for allowing "load data local
infile" commands, but it did nothin
[safe_mysqld]
err-log=/var/lib/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
---
Thank you.
Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484
"The true soldier fights not because he hates what is in
front of him
rror message is as follows:
You have an error in your SQL syntax near 'RAND() LIMIT 3' at line 1
Jamie
Jamie Tibbetts.[EMAIL PROTECTED]
Epigroove .http://www.epigroove.com/
-
B
from the query, it
works in PHP.
Doesn't work:
SELECT * FROM products WHERE sale_price IS NOT NULL ORDER BY RAND() LIMIT 3
Works:
SELECT * FROM products WHERE sale_price IS NOT NULL LIMIT 3
Does anyone have any idea why this is happening?
Thanks,
Jamie
Jamie Tibbetts.[EMAIL
d be included in the found set of the query above. He
would be removed because he ordered product #23 on order #1, but he would
also be included because he didn't order product #23 on order #2.
Any ideas on how to exclude these multi-order customers?
Jamie
Jamie Tibbetts.[EMAIL PROT
sure if it is a problem with the query or the
optimization of my MySQL databases. There are 30,000+ records in the
Customers database, but the query should have finished by now, right?
Jamie
Jamie Tibbetts.[EMAIL PROTECTED]
Epigroove .http://www.epigroove.com/
-
QL expert, so if you start using too much
technical specifics, my head might explode. ;)
Thanks in advance!
Jamie
Jamie Tibbetts.[EMAIL PROTECTED]
Epigroove .http://www.epigroove.com/
Success .http://www.success.com/
---
I looked at the same message you got and at the bottom it says to try
this address:
[EMAIL PROTECTED]
So perhaps eliminating the "digest" part in your address will work.
Also, you have to do it from the same email account that you signed up
with but you probably did that.
>>> Bob Purvy <[EMAIL
Is there a way to develop buttons on a webpage that can send command
line instructions to MySQL, such as to run a script in a file that
already exists on the server? The command line instruction would be as
follows: >mysql database_name < file_name
Is it feasible to get this sent to MySQL throug
hit by the user
would initiate the reading of the file somehow? This might be easier but
I was not sure how to exactly send command line directions from a
webpage.
Thank you,
Jamie Buck
-
Before posting, please check:
hit by the user
would initiate the reading of the file somehow? This might be easier but
I was not sure how to exactly send command line directions from a
webpage.
Thank you,
Jamie Buck
-
Before posting, please check:
nd DBD modules AFAIK :)
cheers
Jamie...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** This message was transmitted on 100
i actually need the id's with no row returned as if they were there (but
with default values)... they do not need to be inserted into the table, just
returned as if they were in there.
j
- Original Message -
From: "sherzodR" <[EMAIL PROTECTED]>
To: "Jamie Bur
9 because they didnt
exist in the table.
Can anybody give me any clues how to achieve this?
Thanks,
Jamie Burns.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
hat and if none then null or zero.
TIA
Jamie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PRO
o find anything on this in the manual or previous
posts.
TIA
Jamie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Ok, i have figured it out...
SELECT COUNT(DISTINCT name) from tester WHERE team = 'support'
But this doesnt work on my development box which runs an older version of
mysql! Does anybody know how to get this type of functionality without the
DISTINCT keyword inside count?
this doesnt work as i need either :o(
it returns 3 rows, each with a count of 3 inside. i just want to get a
*single row* with the number 3 in it (for my example).
:o(
thanks for trying though...
- Original Message -
From: "Lezz Giles" <[EMAIL PROTECTED]>
To: "
times (this is where your query
gets 9 from).
:o(
- Original Message -
From: "Stefan Pinkert" <[EMAIL PROTECTED]>
To: "Jamie Burns" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 2:25 PM
Subject: Re: surely an easy quick one
group. So if I wanted to find all individual people in
support the answer in this case it would be 3 (bill, bob and pat). I dont
need their names, just the count.
Thanks,
Jamie.
-
Before posting, please check:
http
a default value to the 'rating' column if actual
row(s) do not exist in the ratings table? I dont really want to have to make
a dummy rating row just to trick it into working.
Am i making sense? I hope so ;o)
Jamie Burns.
Try going to www.freshmeat.net and searching for PoolMan. It's a Java
library for pooling connections to MySQL. I haven't messed around with
it but I saw it when trying to learn Java.
Hope this helps,
Jamie
-Original Message-
From: gaurav [mailto:[EMAIL PROTECTED]]
Sent
ble1.name
$results[0]['subject'][0] // table2.subject
$results[0]['subject'][1]// table2.subject
$results[0]['subject'][2] // table2.subject
i am guessing mysql doesnt have a notion of multidimensional results...
i will sort them myself ;o)
thanks anyway, jus
usable form?
thanks,
jamie.
3, has an average rating of 2.5
and could i possibly return the 10 highest rows?
any help with this would be really appreciated...
jamie burns.
y is great for my search engine because it ranks the results based
on how many keywords were found in each row (users love this).
i know have to think about making it portable (i found the if() statement
didnt work in PostgreSQL).
are there any portable equivilents to this M
I've been experiencing a simmilar problem only with MyISAM tables.
This is under 3.23.35 and 3.23.36 on Sparc/Solaris 2.7.
For me the problem occurs when doing an ALTER TABLE or a simmilar
operation (eg OPTIMIZE) on relatively large tables (>4 millon rows)
with one or two indeces.
The table in
ndful of
indeces -- including a primary key or unique index.
This is happening with 3.23.36 an 3.23.34 running
on Solaris 7 / sparc.
I'll post a follow-up if I can isolate a simple test
case which demonstrates the problem.
- Jamie
-
could evenly distribute those directories and make the links and
directories for MySQL.
Jamie
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 17, 2001 11:53 PM
To: Jamie Krasnoo
Cc: MySQL
Subject: Re: raid tables
On Sun, Jun 17, 2001 at 11:48:04PM
Is there a way to tell MySQL to automatically spread its tables over a
number of disks without going through the trouble of symbolic linking the
chunks to the different disks?
Thanks,
Jamie Krasnoo
[EMAIL PROTECTED]
-
Before
tadir=/dbdata1:/dbdata2:/dbdata3
Or would I need to create the database and then move the files and use
symlinks?
Thanks,
Jamie Krasnoo
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
Unfortunately I don't have an ordinary disk on that box. I'm thinking that
InnoDB is having a major problem with LVM not ReiserFS. I tried it on an
e2fs portion of the server and it still had problems.
Do you know of anyone successfully using InnoDB with just LVM?
Jamie
-Origin
d is 2.4.2. Until then I'm stuck
using BDB.
Thanks,
Jamie Krasnoo
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
-the Institute for the Study of American Music
-International Swimwear and Active Market)
Thanks for any help you can give me,
Jamie.
-
in the time
range but converting this into the free space start and end positions has
become a bit of headache.
Any ideas you can give will be much appreciated,
Jamie.
-
Before posting, please check:
http://www.mysql.com/manual.p
of A will be stored in it's place. I
later on want to change B independently to a different value than A so I
don't want a strict contraint that they must always be the same.
Thanks,
Jamie.
-
Before posting, please
Could anyone point me to any documents on creating a search engine using
MySQL or search engine theory in general?
Thanks,
Jamie Krasnoo
www.MyEBoard.com
[EMAIL PROTECTED]
PGP Key - http://www.planetphat.com/jkrasnoo/pgp.html
Problem: see below.
For some reason mysql doesn't like db to be outside of the directory. It
compiled fine when I moved the db directory in to the mysql source directory
and reconfiged so that it saw the berkeley db library. Has anyone else had
this problem?
Jamie
-Original Me
1]: Leaving directory `/usr/src/mysql-3.23.32'
make: *** [all-recursive-am] Error 2
config used:
./configure --prefix=/usr --with-raid --with-berkeley-db=/usr
On a RedHat 7.0 system, patched db already installed. Do I need to include
other CFLAGS or CXXFLAGS?
Much appreciated,
Jamie Krasn
I'm finding that msql 32-bit is somehow crashing when ever I play audio -
either from a CD in my CDrom or m3ps via Creative player II and winamp
respectivly. Does anyone else know of this or experienced this?
Jamie
I was wondering what the SQL command is to find the filed names of a
database once it has been created.
I'm trrying to write a script that will allow 'options' table to be created
where there is an ID fiield for the product then fields representing each of
the avalible options eg red blue green w
anuary 2001 6:02 PM
To: [EMAIL PROTECTED]
Subject: Re: Update and change a value
* Jamie <[EMAIL PROTECTED]> wrote on 23.01.01 11:51:
> UPDATE users SET visits=visits+1, WHERE user_id='$user' AND
> password='$password'
If that comma after +1 is not a typo in the
isits+1 which is simple enough and
taken virtually from the mySQL documentation. The line below works fine in
which I set a set value.
UPDATE users SET visits=4 WHERE user_id='$user' AND password='$password'
Any help would be appreciated
Jamie
75 matches
Mail list logo