On Mon, Aug 20, 2001 at 11:38:57PM -0400, Network wrote:
> The problem= The 'addy1' column or field (in attdata) is tainted
> with incorrect data entries ... e.g. 'addy1' should only have
> addresses stored however, some bright person(s) have managed to
> input company names in the address/addy1
On Wed, Aug 22, 2001 at 12:40:05AM -0600, Camilo Rostoker wrote:
> Hi,
>
> I'm trying to create a search engine that sorts the results by
> relevance. Relevance means the number of times the tuple was
> selected during the search phase. How can I check table if a tuple
> exists (ie: has the sam
On Sat, Aug 18, 2001 at 11:55:52PM -0400, Philip Mak wrote:
>
> In Apache web server, the command used to start/stop the web server
> also has an option called "configtest". One can type "apache
> configtest" and it will tell you if the configuration file has a
> valid syntax. This is to save you
On Wed, Aug 22, 2001 at 09:40:13AM +0300, scott.alexander wrote:
> Hi,
>
> If I run mysqladmin status it shows uptime, no of questions etc.
>
> Can I reset these values to zero without stopping and starting the server.
FLUSH STATUS as described here:
http://www.mysql.com/doc/F/L/FLUSH.html
Hi,
If I run mysqladmin status it shows uptime, no of questions etc.
Can I reset these values to zero without stopping and starting the server.
thanks
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php
On Tuesday 21 August 2001 22:15, you wrote:
> hi,
>
> on my system runs SuSE 7.2 Linux and when i start MySQL by script
> (mysql.server start) or just by booting my PC I get a message like this:
>
> MySQL started
> 12345(a number, i would say it's the process ID) 10:20:30
Wahoo I m famous I have been immortalized on the MySQL forum...
To unsubscribe, e-mail <[EMAIL PROTECTED]>
That's me
Love you sense of humor Sasha...Keep up the excellent work!
Cheers
M;)
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2
I have updated the filter, this message should make it.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.c
hi,
on my system runs SuSE 7.2 Linux and when i start MySQL by script
(mysql.server start) or just by booting my PC I get a message like this:
MySQL started
12345(a number, i would say it's the process ID) 10:20:30 (the time)
ended
has anyone an advice?
THX
-
I have updated the filter, this message should make it.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.c
I have updated the filter, this message should make it.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.c
I have updated the filter, this message should make it.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.c
I have updated the filter, this message should make it.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.c
On Mon, Aug 20, 2001 at 11:31:24AM +0530, Rohit Pandey wrote:
> Any pointers as to how can mysql database can be used with
> Weblogic. If it can be...
Only the obvious:
http://www.google.com/search?q=mysql+weblogic
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Fin
At 06:12 PM 8/21/01 -0300, Pablo Javier Gonzalez Mateos wrote:
>Hello, im new in the list, im a VB 6.0 programmer, and im learning the
>MySQL basics with the Paul DuBois Book... i have a question to do... its
>possible to make a connection from an VB app. to a MySQL database ???, if
>its possib
You can use ODBC for mysql ... (download from www.mysql.com )
Install it , then just use it ...
To try it, make a Datasource for the ODBC ...
In vb make use a Datawizard form, select remote ODBC ...
then select the datasource you create it ...
and you have a simple maintainance form to a table on
You would think this would get built into MYSQL though.
Dave
On Tue, Aug 21, 2001 at 03:28:51PM -0700, Jeremy Zawodny wrote:
> On Mon, Aug 20, 2001 at 01:21:22PM -0700, David Turner wrote:
> >
> > It looks like this will only run on Linux and I must either use
> > Sparc Solaris or X86. I hate t
On Mon, Aug 20, 2001 at 05:16:04PM +0100, Elizabeth Alderton wrote:
> If I'm using libmysql to connect from Delphi to mysql - does it
> automatically provide a secure connection then?
It does not. To get a secure connection, you'll want to tunnel is
thru stunnel, ssh, or something similar. The
Yes, that's probably where we'll end up.
Thanks, Dave
On Tue, Aug 21, 2001 at 03:28:51PM -0700, Jeremy Zawodny wrote:
> On Mon, Aug 20, 2001 at 01:21:22PM -0700, David Turner wrote:
> >
> > It looks like this will only run on Linux and I must either use
> > Sparc Solaris or X86. I hate to impleme
On Mon, Aug 20, 2001 at 01:21:22PM -0700, David Turner wrote:
>
> It looks like this will only run on Linux and I must either use
> Sparc Solaris or X86. I hate to implement the failover within the
> application.
Perhaps you need some tiny piece of middleware that acts as a MySQL
proxy to do the
On Tue, Aug 21, 2001 at 10:04:58PM +0200, Jesus wrote:
> Threads: 12 Questions: 107446 Slow queries: 485 Opens: 88 Flush tables: 1
> Open tables: 82 Queries per second avg: 42.722
> --
>
> Why have I so many slow querys???
> I can't understand, but the performance get down.
>
>
On Wed, Aug 22, 2001 at 12:13:05AM +0300, Mike Jackson wrote:
> I have seen this question posted in the archives several times, but
> no answers. Is there currently a way for mysql to take it's users
> and passwords from an ldap server?
There is not.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
T
> Doesn't doing it that way preclude using $dbh->quote? That could mess up
> if the name had a single quote in it.
Placeholders remove the need for manual quoting. One of their
benefits.
--Pete
> On 16 Aug 2001, Harald Fuchs wrote:
>
> > I'd do it like that:
> >
> > my $sql = q{
> > REPLACE
Hello, im new in the list, im a VB 6.0 programmer, and im learning the
MySQL basics with the Paul DuBois Book... i have a question to do... its
possible to make a connection from an VB app. to a MySQL database ???, if
its possible, how can i do it ???.
Thanks you.
Best Regards...
---
Here's my dilemna
(NOTE: the mysql version im on is 3.22.25, blame communitech.net, not me)
I've created a forum system using php and is extensible to use any DBim
currently working on the mysql version
A pretty standard part of any forum system ive seen is rankings (look here
for exampl
On Tue, Aug 21, 2001 at 03:25:07PM -0500, Ben Davis wrote:
> I have a .sql file that I got from a PHPMyAdmin dump. Now I want to run the
> sql commands that are in that sql file, possibly even including the INSERT
> commands.. I have one that contains just the structure and one that has the
> st
Hi,
I have seen this question posted in the archives several times, but no
answers. Is there currently a way for mysql to take it's users and
passwords from an ldap server?
Regards,
Mike Jackson
-
Before posting, please check:
Sorry,
i meant to address this question to the list. at first, i had addressed it
to the author of the convertor but it seems that her email address does not
exist anymore. Can anyone help me with the problem below???
Thanks.
--
From: Nathan Walker <[EMAIL PROTECTED]>
Date: Tue, 21 Aug
El Martes 21 Agosto 2001 15:23, escribiste:
> Hello,
>
> I have downloaded your dbf2mysql-1.14.tar file from the
> MySQL.com site. I read through the README and still
> cannot seem to get this to work. Here is the error I'm
> getting:
>
> [info:admin/Desktop/dbf2mysql-1.14] root# make
> /usr/bin/
I downloaded the MySQL-client and MySQL-devel rpms but get the following
errors (I was able to install MySQL from a tarball):
[root@localhost svu]# rpm -U *.rpm
error: MySQL-client-3.23.40-1.i386.rpm cannot be installed
error: MySQL-devel-3.23.40-1.i386.rpm cannot be installed
[root@localhost s
On Tue, Aug 21, 2001 at 07:10:05PM +0200, Ornella Fasolo wrote:
> Hi,
>
> i have the mySQL server on a linux machine it is accessed by remote
> clients
>
> did someone use any crypting mechanism or a similar mechanism in
> order to protect the data traffic between the server and the client
> (C
Hello,
I have downloaded your dbf2mysql-1.14.tar file from the
MySQL.com site. I read through the README and still
cannot seem to get this to work. Here is the error I'm
getting:
[info:admin/Desktop/dbf2mysql-1.14] root# make
/usr/bin/cc -O2 -Wall -DVERSION=\"1.14\" -I/usr/local/
mysql -c -o db
I have a .sql file that I got from a PHPMyAdmin dump. Now I want to run the
sql commands that are in that sql file, possibly even including the INSERT
commands.. I have one that contains just the structure and one that has the
structure and data. What are the commands to run all the queries in
Hi We have a licensed MySQL software.
I have one question. During Database Maintenance, i don't want users to be
connected with the database.
I want to start my database in restricted mode, thereby other than DBA, no
one can access the database
during maintenance. how can i achive this in MySQL. O
Threads: 12 Questions: 107446 Slow queries: 485 Opens: 88 Flush tables: 1
Open tables: 82 Queries per second avg: 42.722
--
Why have I so many slow querys???
I can't understand, but the performance get down.
I have Mysql/apache/php
it's a web aplication
what can i do?
thanks
>Description:
I am evaluating mysql for use with our website and internal
workings and cannot get MYSQL configure on our Sun/Sparc Ultra 450. If
we use the mysql application we will buy support but until I can get it
to install I am unable to do any tests against our current website
confi
Is there a symbol file for the mysqld in MySQL-3.23.41-1.i386.rpm? If so
where is it? MySQL keeps crashing and I'm trying to look at the stack
trace.
Thanks!
Andy
-
Before posting, please check:
http://www.mysql.com/manu
I seen some info on using Mysql as an Imbedded Apllication and was wondering if there
was any links on how to do this with Delphi.
Also I am looking for and examples on building a MySQL Manager in Delphi as well.
I have a Volunteer program I am pondering for a Non-Profit group and want to us
How do I set up Autoincrement in Access & MySQL? Please excuse the
vagueness of this question, but I am getting the information 3rd-hand
and don't have exact details.
Apparently, using Mascon to add records to MySQL tables the
autoincrement works.
Using Access to add records to native Access ta
Hello
I want install mysql in Ibm-aix 4.3.2.0, but I´m not successfull.
In site www.mysql.com have the binary version 3.23.41 only for
ibm-aix 4.3.3.0, I try install it, but the instalation failed.
When I try run the comand shell> scripts/mysql_install_db, give the
error:
"Cannot
are you sure mysql is running?
At 10:06 AM 8/21/01 -0700, my sql wrote:
>On a new install of Suse 7.2 I get this message when
>attempting to acces MySQL through a php scrpipt in
>apache 1.30.20 (MySQL 3.23.39 and PHP 4.0.6):
>
>Warning: Can't connect to local MySQL server through
>socket '/var/li
Does /var/lib/mysql/mysql.sock exist???
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 21 Aug 2001 10:06:43 -0700 (PDT)
my sql <[EMAIL PROTECTED]> wrote:
> On a new install of Suse 7.2 I get this message when
> attempting to acces MySQL through a ph
On a new install of Suse 7.2 I get this message when
attempting to acces MySQL through a php scrpipt in
apache 1.30.20 (MySQL 3.23.39 and PHP 4.0.6):
Warning: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2) in
/usr/local/apache_1.3.20/htdocs/dbtest.php on line 1
Hi,
i have the mySQL server on a linux machine
it is accessed by remote clients
did someone use any crypting mechanism
or a similar mechanism in order to protect
the data traffic between the server and the client
(C + APImySQL), if yes where can I find the
informations ?.
I would like to use a
On Tue, 21 Aug 2001 18:55:15 +0400
Spirit <[EMAIL PROTECTED]> wrote:
> Hello!
>
> I need your suggestions on what keys to build for the table described
> below. Currently I have almost all possible keys on the table in order
> to see what keys mysql will use.
>
> I have a table here, which cons
On Mon, 20 Aug 2001, Matt Wagner wrote:
> It has been a great combination for me. Although I've never gone thru
> an HD crash/recovery with this setup yet... :)
Well, I just did, and it works like a charm. There is only one thing to
watch out for: if you restart the system with the failed disk di
Dear Members!
I have a problem at my work:
I must to convert a Corel-Paradox table (.db) to MySQL database ?
How can I to do this ???
Thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Can someone explain to me when and when not to use
single, double, or no quotes at all around values in a
query. I noticed when I updating an enum field I
needed a quote, but not when updating an int field.
Or could someone point me to a good online reference
on the subject.
Thank you,
Hans
[
Hi all,
I'm running MySQL Ver 3.23.32 for -freebsd4.2 on i386, With PHP4
compiled statically into Apache 1.3.17. All connections to the database
are non-persistent connections. It's a pretty busy server, hitting
about 60 queries per second during peak time. (Although I'm not sure
that would qu
Hello!
I need your suggestions on what keys to build for the table described
below. Currently I have almost all possible keys on the table in order
to see what keys mysql will use.
I have a table here, which consist of over 6 million records by now
and is defined as follows:
CREATE TABLE traffi
Hi,
I need some help with a query
I have two queries that I'd like to merge into one - one returns a list of
matches that a player has played in, and the other returns the players
batting performance. My problem is that a player doesn't always bat, and
therefore can have fewer rows in the s
Hi all,
There are a mysql fornt for windows named mysqlfront with the option of
import acces databases into mysql.
And it works.!!
- Original Message -
From: "Gabriel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 2:43 PM
Subject: Import from Access to MySql
it doesn't work... maybe problem lies in W2k where mySQL server is
installed?
Mariusz Muszalski
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 21 August 2001 11:39
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: mySQL and ASP
>
>
> I had a si
At 2:31 PM +0100 8/21/01, Brian Leyland wrote:
>Hello,
>
>I need to reset the auto increment value on a database.
>
>Can anyone help.
>
>
>Thanks
>
>Brian
If it's a MyISAM table and you mean that you want to reset the sequence
so that MySQL will next use the smallest currently unused value, do th
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!
http://business
On Monday 20 August 2001 23:59, Hans Zaunere wrote:
> Is there a way to have MySQL label columns returned
> from a select query with the complete column name, in
> table.column format?
AFAIK no.
> Sure I could alias each column, but if there is 30
> columns, that's a lot of aliasing. Is there
Hello,
I need to reset the auto increment value on a database.
Can anyone help.
Thanks
Brian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
Paul Foxton <[EMAIL PROTECTED]> writes:
> RH Linux 7.1, MySQL 3.23.41 source rpm
>
> Hi,
>
> I'm currently trying to do the following:
>
> shell>rpm --rebuild MySQL-3.23.41-1.src.rpm
>
> The rebuild always crashes out with the following error:
>
> "checking whether the C compiler (ecgs -O3 )
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Faine, Mark writes:
>> Ok, so I've downgraded my compiler (gcc) to 2.95.3 since mysql seems to be
>> incompatible with 3.0, yet I'm still getting an error during the make:
>>
>> /usr/local/sparc-sun-solaris2.8/bin/ld:
hello everybody,
we are facing strange problems since we dumped tables from 3.22.22 (isam)
mysql and imported them into 3.23.32 (myisam) last friday;
this problem also occured when we selected into outfile from 3.22.22 and
then loaded data infile to 3.23.32;
first, everything seemed to go ok; all
access has a module called exportaccesstomysql which will convert the access
DB to 2 text files. One contains a series of SQL statements to create the
various tables in MySQL and also add entries which are in the access DB. If
you have a win-32 version of nysql you can use this to create the DB on
Anyone can tell me how can i import an access db to mysql.
Go to http://www.mysql.com/downloads/contrib.html. Many contributed tools
plus a couple of macros that are run from within Access.
Jay Fesco
-
Before posting, pleas
At 09:43 AM 8/21/01 -0300, Gabriel wrote:
>Anyone can tell me how can i import an access db to mysql.
>
>Thanks in advance,
>
>Gabriel.
Convert the access data into text file, comma separated (CSV)
then use LOAD DATA INFILE c:\textfile INTO TABLE table_name
You can get additional hints using Go
Anyone can tell me how can i import an access db to mysql.
Thanks in advance,
Gabriel.
RH Linux 7.1, MySQL 3.23.41 source rpm
Hi,
I'm currently trying to do the following:
shell>rpm --rebuild MySQL-3.23.41-1.src.rpm
The rebuild always crashes out with the following error:
"checking whether the C compiler (ecgs -O3 ) works... no
configure: error: installation or configuration pr
Jaitly, Rajiv (Contractor) writes:
> Hi,
>
> I downloaded Ver 1.7.5 of mysqlGUI (win' 2000 environment ), but
> experiencing problems in using lots of features e.g. can not add / update
> tables interactively (F9), view data etc. Is there any patch i need to
> install to get this working.
>
> T
Jerry van Leeuwen writes:
>
> Are there any known stability issues with installing MySQL under Windows
> 9x? By this I mean actual issues with the MySQL server itself, because I
> realise Windows 9x itself is not the most stable option available.
>
> Is there any reason to believe that this co
At 12:54 PM 8/21/01 +0200, Marcin Pyla wrote:
>Hi,
>
>I have problem with delete user:
>
>I login to mysql as root'a and I do:
>
>mysql> delete from user where user='admin80' and Host='%';
>Query OK, 1 row affected (0.07 sec)
Try to escape the '%' character as '\%'
(just a guess, I haven't tri
Hi,
I have problem with delete user:
I login to mysql as root'a and I do:
mysql> select * from user where user='admin80';
+--+-+--+-+-+-+-+-+---+-+---+--+---
I had a similar problem before, asp would not return where any bigint types
where involved in the query. The fix was to check the 'convert bigint to
int' box
in the myodbc settings and everything came back just fine. might be worth
a try
Sean
-Original Message-
From: Mariusz Muszalski
Hello,
I use PHP 4.0.6 with mySQL 3.23.40 and I have the error
2008 (client run out of memory) performing this query :
select i2f.item_id, i2f.value, f.id from features as f, item2feature as i2f,
items as i where i.scat_id = '244d713abba5f2ffb8d0ba8c858111ef' and i.id =
i2f.item_id and f.id =
i'm using mysql 3.23.40 for windows, when i try to build one very
simple application, it shows me that error:
e:\pere\mysql 3.23.40 server\include\mysql_com.h(115) : error C2146:
syntax error : missing ';' before identifier 'fd'
e:\pere\mysql 3.23.40 server\include\mysql_com.h(115) : error
C25
I've just spotted something STRANGE in mySQL... using mySQL query from ASP
(connection via mySQL ODBC driver ver 2.50.37.00). MySQL query returns
normally records, but returns nothing with ASP...
Code (VBscript) is here:
<%@ LANGUAGE="VBSCRIPT" %>
<%option explicit%>
<%
Dim MyConn
Dim SQL_quer
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: marinoc
To: [EMAIL PROTECTED]
Subject: Failure when comparing floating point numbers
>Description:
A table is created
On 21 Aug 2001 10:48:03 +0200, Erlend Stromsvik wrote:
> Is it possible to have mysql load indexes into memory after a restart or
> reboot?
>
> The computer has 768mb memory, and after a reboot/restart I have like 700mb
> of free memory.
> Then when someone clicks a link on a page which runs a 'h
there should be a command in mysql and mysqladmin which shows the active
processlist
when you have a lot of sleeping processes the show processlist in badly to
handle
I think there should be an output like:
xxx processes sleeping
and then: the same output
ES> Hi
ES> Is it possible to have mysql load indexes into memory after a restart or
ES> reboot?
ES> The computer has 768mb memory, and after a reboot/restart I have like 700mb
ES> of free memory.
ES> Then when someone clicks a link on a page which runs a 'huge' query agains
ES> the server you ge
On 19 Aug 2001 19:29:17 +0100, Wesley Darlington wrote:
> Hi,
Howdy.
> On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote:
> > At the moment, what I am doing is:
> >
> > execute "LOCK TABLES foo READ"
> > select info from foo
> > //next lock implictly unlocks previous one
> >
Hi
Is it possible to have mysql load indexes into memory after a restart or
reboot?
The computer has 768mb memory, and after a reboot/restart I have like 700mb
of free memory.
Then when someone clicks a link on a page which runs a 'huge' query agains
the server you get a pretty long loading time
Hi,
two questions:
1)On the mysql manual, section 4.12.16 Mysql-Win32
compared to Unix MySQL it sas that:
"Mysql uses a blocking read for each connection. This
means that:
A connection will not be disconnected automatically
after 8 hours, as happens with the Unix Version of
Mysql".
This is of
Hi,
I installed the latest release of MYSQL on windows 2000 environment (non
networked). I would like to add the mysql server start up as a service at
system startup. Could anybody tell me how to do this.
Thanks
Raj
-
Before
try in simple programming skill at
1) if your script language uses the pattern
while (resultSet.next())
{
out.println(resultSet.getFirstColumn();
...
...
...
counter++;
}
out.println("Total number of records"+counter);
2) if you do not want that, you can also try this
sql
Hi,
I downloaded Ver 1.7.5 of mysqlGUI (win' 2000 environment ), but
experiencing problems in using lots of features e.g. can not add / update
tables interactively (F9), view data etc. Is there any patch i need to
install to get this working.
Thanks
Raj
---
83 matches
Mail list logo
