()
function dependant on what user is authenticated in to your web server. If
you need to restrict clients on a per-IP basis, you can do this at the php
level by checking the $REMOTE_ADDR variable and acting accordingly.
Hope this helps,
Ryan Fox
- Original Message -
From: Wee Chua [EMAIL
How do tamporary tables die? Is there a time limit, og do I have to drop
them manually?
They are dropped when the client connection that created them disconnects.
They can also be dropped manually.
Ryan
-
Before posting
| localhost || Query | 3||
show processlist
|
++---+---++-+--++---
---
+
Ryan Shrout
Owner - Amdmb.com
http
| localhost || Query | 3||
show processlist
|
++---+---++-+--++---
---
+
Ryan Shrout
Owner - Amdmb.com
http
I was wondering if there is a way to download the MySql database hosted on a
UNix machine running Solaris, to my Windows computer and be able to view and
modify it from there? The Solaris version has .ISD and .ISM files wheras
Windows has .MYD and .MYI files. Any help would be greatly
to store than the string 'Foo
Company'), ensure data integrity (make sure you don't have entries such as
'Foo Company' and 'foo company'), and to speed queries (matching integers
can be performed by the sql server MUCH qiucker than matching strings).
Hope this helps,
Ryan Fox
this, so I don't think the
problem is so much in the software, but something about my MySQL config or
setup.
I realize this may be a MySQL issue as much as it is a PhpAdsNew issue, but
I was really hoping someone here would be able to help me out with some
suggestions. Thanks!
Ryan Shrout
Owner
in advance,
-Ryan
NOTE TO MySql admins:
Dear Sir/Madam,
After trying to subscribe to the list I get a email asking me to confirm and when I
confirm by sending a blank email with the necessary string in the subject line I get
an email saying that there was an error and that you have given up
in advance,
-Ryan
NOTE TO MySql admins:
Dear Sir/Madam,
After trying to subscribe to the list I get a email asking me to confirm and when I
confirm by sending a blank email with the necessary string in the subject line I get
an email saying that there was an error and that you have given up
in advance,
-Ryan
NOTE TO MySql admins:
Dear Sir/Madam,
After trying to subscribe to the list I get a email asking me to confirm and when I
confirm by sending a blank email with the necessary string in the subject line I get
an email saying that there was an error and that you have given up
in advance,
-Ryan
NOTE TO MySql admins:
Dear Sir/Madam,
After trying to subscribe to the list I get a email asking me to confirm and when I
confirm by sending a blank email with the necessary string in the subject line I get
an email saying that there was an error and that you have given up
This problem is almost exactly like the load level on linux one seen
earlier, and like about 5 others I've seen on this list including my own.
Why is we can not get a straight answer from anyone on this???
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original
Hi,
I my name is ryan and I own a small site which has a mysql database and servlet
support.
I have a simple query to all you mysql gurus...
my table is very simple, i created a table with the following
create table datee(int today);
now,what statement do I use to put the sysdate
I can't help you with your problem, because I have almost the same thing
happening to my server every 2-3 days. It is exactly as you described
Please someone offer us suggestions??
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From
and I
think I have it correct!
[mysqld]
log-slow-queries=/root/slow-queries.log
and
/etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log
Either way, the server will not start. I take the line out and it works
again. What am I doing wrong?
Ryan Shrout
Owner - Amdmb.com
http
please reply to: [EMAIL PROTECTED]
too many parameters error on ./configure and then make
do i need to configure and make through dos? this is what i am doing.
or can i just double click on mysqlmanager?
whats difference?
Thank You,
Get 250 color business cards for FREE!
Thank you for the tip, but this is not our problem. We are running SCSI
disks with over 40 MB/sec throughput. Any other ideas?
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: Werner Stuerenburg [EMAIL PROTECTED]
To: Ryan Shrout [EMAIL
(including database table formats, queries,
etc) please let me know! I will be more than happy to give them to you!!
Thanks to anyone who helps me out!!!
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
out what is going on here. I
raised the max_connections from 100 to 300, and edited the following httpd.conf
settings:
MinSpareServers 15
MaxSpareServers 30
StartServers 15
MaxClients 150
MaxRequestsPerChild 1000
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
Jeremy, it was included in PART #2 of the problem message. Did you get
that?
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Ryan Shrout [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, August
, Pages.PageTitle, Pages.Text
FROM Pages, Articles
WHERE Ar |
++---+---+---+-+--++
--+
[root@dagger /root]#
Ryan Shrout
Owner - Amdmb.com
This just happened a second time today... that is the most frequent yet.
Please, you have got to help me on this!
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: Ryan Shrout [EMAIL PROTECTED]
To: Tonu Samuel [EMAIL PROTECTED]
Cc: [EMAIL
Sorry, but this system has quad 15K RPM SCSI hard drives running RAID 0+1.
I don't think hdparm applies to that.
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: Werner Stuerenburg [EMAIL PROTECTED]
To: Ryan Shrout [EMAIL PROTECTED]
Sent
there is HDA?
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: Werner Stuerenburg [EMAIL PROTECTED]
To: Ryan Shrout [EMAIL PROTECTED]
Sent: Tuesday, August 14, 2001 1:13 PM
Subject: Re: Mysql causing severe load problems on Dual-Athlon
hours and check the system/current
date,month and then query the database for people who want to send
their greetings on the same date,month and then connect to the smtp
server etc...any ideas?
ALL reply's are welcome,good or bad,abuses or hugs!
:-)
Cheers,
-Ryan
P.S I would really appreciate
: $customer_selectbr.mysql_errno(). :
.mysql_error();
echo $errMsg; echo P;
}
Ryan Shrout
-Original Message-
From: Felicia [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 9:29 AM
To: mysql post
Subject: mysql/php
I am trying to use php to print my results. This is my code (I have checked
keyword')
Where the japanese keyword is either a singlebyte or doublebyte character.
Now i can get this to work in english but not in japanese, is there support
for it? Or did i forget to enable something or am i doing this completely
wrong?
Thanks for you help
Ryan
works fine when using a Customer_No such as 15 or 153,
something numeric. The field itself is defined as a CHAR (50).
Any ideas what is causing this? It happens with every Customer_No in this
format and gives the same error.
Ryan Shrout
?
Ryan Shrout
-Original Message-
From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 3:20 PM
To: Shrout, Ryan
Subject: RE: Unknown column in 'where clause' error
WHERE Customer_No = 'CMET3558539239'
you need to use quotes when trying to reference data
sounds like you either dont have make installed on your machine, or it
is not in your PATH environment variable do 'find / -name make
-print' and see if it is on your machine, if not you will have to get
your redhat CD and install it
-Original Message-
From: Richard Kimberley
run time
libraries and stuff ... no luck, I get a bunch of linker errors ... anyone
ever done this successfully?
Thanks
Ryan Gilfether
Programmer
Praxis, Inc.
www.pxi.com
(703)837-8400 x5412
-
Before posting, please check
assume my_socket is not being defined...
Thanks
Ryan Gilfether
Programmer
Praxis, Inc.
www.pxi.com
(703)837-8400 x5412
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
at the top of mysql++ windows.h is included ...
So what am I missing? Thanks
--- Gilfether, Ryan [EMAIL PROTECTED] wrote:
sorry you all, but I am new to Visual C++, I am
trying to get some code
compiled using MySQL++ 1.7.1 for MS Visual C++ 6.0
but I keep getting an
error:
d:\docs\devel
have no idea what it would be ..
Anyone have any ideas?
Ryan Gilfether
Programmer
Praxis, Inc.
www.pxi.com
(703)837-8400 x5412
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
);
// this causes linker error only for MFC app
Query query = con.query();
whats the problem?
ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
hi everyone in this group, i am getting lately mysql syntax error when i run query
from JSP page. here is sample code:
public selectMyPass (String userid) {
String myQuery = select pass from datainfo where id=;
myQuery.concate(myQuery,userid);
myResultSet = stmt.executeQuery(myQuery);
hanks much,
Ryan
-
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 PROTECTED]
To unsubscribe, e-m
ermissions need to be?
I've tried setting various ownerships and privs and nothing works. I've
also tried "scripts/mysql_install_db --user=mysql" and that doesn't work
either.
Any help would be greatly appreciated. I'm about to tear all my hair
I fix
it?
Some people have said to make sure the privs and ownerships are right. What
should they be? Could anything else be causing this?
Thank you,
Ryan
-
Before posting, please check:
http://www.mysql.com/manual.php
that doesn't have a
MySQL backend, and just works off a flat file, please let me know!
Thanks!
Ryan Shrout
Production Manager
Athlonmb.com
http://www.athlonmb.com
[EMAIL PROTECTED]
) NOT NULL , [Title]
[cha' at line 1
What is the syntax problem that I am missing? And can I make MS SQL output the sql
file in the correct way?
Ryan Shrout
Athlonmb.com
Production Manager
http://www.athlonmb.com/
[EMAIL PROTECTED]
What process do you guys usually follow when upgrading your version of
MySQL? I have yet to perform an upgrade, but my first thought would be to
dump the databases, uninstall the old version (remove all the files),
install the new version, and import the dump file. Is this a good plan, or
is
From this feature list, it sounds like you are creating methods
(multi-deletes, updates from joins) that will take the place of
transactions. Is this the direction that MySQL is heading? Do you believe
that these methods will be preferred over traditional rollback/commit
transactions with BDB
Could someone explain to me the difference between the Primary/Index/Unique attributes
of MySQL? I am coming from using MS SQL where there is only the Primary key option.
Sorry if this is too beginner of a question for this list.
Ryan Shrout
Athlonmb.com
Production Manager
http
d it fail?
Thank you for your assistance.
Ryan Shrout
Production Manager
Athlonmb.com
http://www.athlonmb.com
[EMAIL PROTECTED]
connect to loacl MySQL
server through socket 'var/lib/mysql/mysql.sock' (111). When I go to the
/var/lib/mysql directory, there is nothing listed in a 'ls' command.
Thanks for any help. As you can guess, I am rather new the Linux as a server
operating system.
Ryan Shrout
Athlonmb.com
Production
the embedded mysql
3. How to compile and test out the code
I have a Linux box with the latest version of mysql on
it.
Thanks for your help
Ryan
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com
How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work? The
examples I have seen are like:
BEGIN;
statement 1;
statement 2;
statement n;
COMMIT;
Does this imply that if any of the statements fail then a ROLLBACK will be
called, otherwise it will COMMIT?
Yeah, it's in the manual.
On Fri, 2 Mar 2001, Progetto 2000 wrote:
Hi,
It's possible to create a database in a differents directories ? And how to
make it ?
Thanks
Carlo Carlini
-
Before posting, please check:
When ever i add a new number i get a processing form error in the SQL
statements?
tells me to report this error?
does anyone know what is going on
happens when i try to add a new item to the database.
-
Before posting, please
and manual with no success. Any
suggestions would be appreciated.
Thanks,
Ryan
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
I get the following error "Table 'ryan' is a
linked table with some properties that can't be modified." And when I try to export a
database to the remote MyODBC sorce I get this error "ODBC -- call failed.
[Microsoft][ODBC Driver Manager (#0)'
I think that the problem involves
http://www.phpwizard.net/
you gotta download it... it's seperate from php and mysql.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 11:08 AM
To: [EMAIL PROTECTED]
Subject: phpMyAdmin
I was reading through the list and found
I do?
Please give me detailed instructions as I am not too
familiar with MySql so if you are telling me to make
changes in the database please be specific.
Remember if you help me, when I become a LITTLE richer
than Bill Gates I won't forget you either!
C
st = 0.002 (much less than you suggest so that
is good... I think)
However this one worries me a bit...
Key_write/Key_write_requests = 0.087 (way lower than 1)
Does this mean that I am sending WAY to many un-needed UPDATE requests?
- Original Message -
From: "Jim Beigel" [EMAIL PROTE
Woah! 800,000 visits a day!? Wow... try 80,000.
-Original Message-
From: Ryan Hadley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:25 PM
To: [EMAIL PROTECTED]
Subject: Performance issues.
I'm not much of a db admin so I really don't know how to get better
performance
Thanks for the quick response.
The response time is slow... and the mysqld processes are what is hogging up
the system.
We do have indexes on the fields, but from what I understand, when you use a
"LIKE" statement, it rarely uses an index.
-Ryan
-Original Message-
From: K
I haven't had a chance to do so yet.
But, we offer 4 kinds of searches:
'$word%'
'%$word%'
'%$word'
and
'$word'
So some searches still won't use indexes.
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 7:26 PM
To: 'Ryan Hadley
SELECT
t1.id
FROM
table1 t1,
table2 t2a,
table2 t2b
WHERE
t1.StopTime = 0 AND
(t2a.Group != 'Dedicated' AND t2a.UserName != t2b.Username) AND
t2a.UserName = t1.UserName
Not sure if you need those () though.
On 2 Feb 2001, Drew
In the manual.
www.mysql.com
On 01 Feb 2001 17:29:02 -0200, Jader Wallauer wrote:
Where can i get an exemple of connection using c with mysql!
for gcc with freebsd OS.
tkz!
[]'s Jader
-
Before posting, please check:
Just because you send a message doesn't mean it's gonna get answered!!
Have you successfully installed a non alpha version of the db?
On 31 Jan 2001 11:09:33 -0500, Sanam Azeem wrote:
I sent this email two days ago and haven't heard from anyone
Date: Mon, 29 Jan 2001 14:51:30 -0500
A database server can contain multiple databases.
On 31 Jan 2001 19:01:02 +, SED wrote:
Hi,
Can I have two (or more) different SQL-databases running at the same time on
the same server (or same computer)? Does it varies between the systems?
And if I can, are they all available to
Yeah, you should really change the way the database is setup but you
could also do something like this. Have perl return an array and just do
a foreach on the array and that will give you all the values of each
column on the row, without you knowing how many rows there are.
Even if your not
If you do a
DESC tblNAME;
you can go through row by row and check if the Default is NULL
On Tue, 30 Jan 2001, Shawn Cummings wrote:
I want to query out the field names where the "Default" is NULL ... so I
can populate an HTML page for input...
SHOW FIELDS FROM tblNAME;
This
Try this one:
SELECT STRAIGHT_JOIN ArgumentCalendar.Docket
, ArgumentCalendar.Date
, DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Blurb
FROM ArgumentCalendar
, CaseID
, Parties
LEFT JOIN Preview ON
Send the results of the EXPLAIN
On 25 Jan 2001 15:15:35 -0500, Brian Hughes wrote:
Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN
there after the SELECT.
But it doesn't get me anything. EXPLAIN still says I am examining all
19,701 rows in CaseID: same problem
Go look at an example in the documentation on how to create an index and
create one on the ID column.
On 15 Jan 2001 20:57:55 +0100, Tobias Talltorp wrote:
I have a table with 2 fields which I, every fifteen minutes, load new data
into. The data is not formatted by me. It comes from an
301 - 367 of 367 matches
Mail list logo