On Fri, Feb 16, 2001 at 06:46:58PM -0800, Tim Chambers wrote:
>
> Is there any way I can generate a list of the databases in mysql,
> perhaps with the mysqlshow command and some fancy grep?
SHOW DATABASES
> I'm looking for a list separated by spaces, something that I could
> use in a bash script
Ok, I looked through the archive, unsuccessfully.
Here's the "problem":
I rebuilt a machine running a MySQL db, and stupidly
only backed up the user-oriented databases, and not
the mysql administrative ones. Nonetheless, I went
back in and used the guiclient to do the appropriate
grants. After
Dear Sir,
I have a Red-hat Linux6.2 . And i have installed MySql -3.23.32 server. It installed
successfully. now when go to install MySql-3.23.32.rpm it doesn`t install, same for
MySql-devel-2.32.32 it also doesn`t install.
And also tell em how to Uninstalled .rpm.
Pls reply me asap.
Regards,
Hello,
is there a browseable archive for this list?
I would as soon look it over, if it exists, before
posting what may be an FAQ.
TIA
Michael Fischer
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mys
"G. Adam Stanislav" schrieb:
>
> At 16:25 17-02-2001 +0200, Siim Einfeldt aka Itpunk wrote:
> >Hi everybody,
> >
> >I want to implement ordering something on a website without refreshing the
> >page.
>
> That is generally done using JavaScript. But be advised that not everyone
> has JavaScript t
Hi,
The problem is when I execute show processlist; the mysql
replied syntax error. So i cant use the processlist.
here's wat the mysql respond:
SHOW PROCESSLIST;parse error near 'PROCESSLIST' at line 1
thanks
teddy- Original Message -
From: "Fred van Engen" <[EMAIL PROTECTED]>
To: <[EMAIL
Dear all,
I have a field defined as float (16,0). When I insert 99 (10 9s) into the
table, it changed it's value to 100(1 and 10 0s). It also change some other
inserted values.
Does anybody have any idea what the reason causing it? And how can I fix that?
Thanks in advance
On Sun, Feb 18, 2001 at 02:19:17AM +0100, Fred van Engen wrote:
> On Fri, Feb 16, 2001 at 06:50:53PM -0600, Richard Reina wrote:
> > Here is the table:
> > +--+
> > | STOP_0FFS |
> > +--+
> > |FLIGHT_NO |CITY | SEQUENC
On Sat, Feb 17, 2001 at 04:10:08PM +0100, Wernher Korff wrote:
>
> does anybody know the QUERY to drop a column for MSSQL 6.5?
No, but I'm sure it is in the MSSQL documentation.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
On Fri, Feb 16, 2001 at 06:50:53PM -0600, Richard Reina wrote:
> Here is the table:
> +--+
> | STOP_0FFS |
> +--+
> |FLIGHT_NO |CITY | SEQUENCE|
> |127 |Chicago |1|
> |127 |Boston |2|
> |
Here is the table:
+--+
| STOP_0FFS |
+--+
|FLIGHT_NO |CITY | SEQUENCE|
|127 |Chicago |1|
|127 |Boston |2|
|391 |Miami|1|
+--+
SELECT flight
If connect to mysql server using C API function and mysql server is under very
high load, client never timeout, it's just sit there waiting - how to stop
this?
I use the mysql_options() first to set timeout
const char *timeout = "1";
mysql_init(&mysql);
mysql_options(&mysql, MYSQL_OPT_CONNECT_
At 16:25 17-02-2001 +0200, Siim Einfeldt aka Itpunk wrote:
>Hi everybody,
>
>I want to implement ordering something on a website without refreshing the
>page.
That is generally done using JavaScript. But be advised that not everyone
has JavaScript turned on by default: I often have it turned off
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello monty,
Peter> I'm trying to use merge table for logging - to have a possibility to
Peter> Rotate log files and to quickly delete old data - for this I'm goint
Peter> to setup a number of merge tables where each co
To be truthful about it, MySQL stores everything in files in the data
directory. However, in every instance I have seen, the BLOBs are in fact
stored in rows in the MySQL database tables, and are not separate binaries.
>From both management and portability standpoints, I would much rather have
Hi.
On Sun, Feb 18, 2001 at 01:18:04AM +0800, [EMAIL PROTECTED] wrote:
> Hi All,
> Below is the status that I got from my server's mysql server, can anyone
> explain to me more on this?? and as u see here... currently mysql server
> is running extremely slow:
>
> mysql>show variables;
> +---
So I got MySQL installed on a build of MacOS X.
I futzed it up, I need to unistall it, and I thought I did, but it says that
MySQL is still running on an open port, and I can't allow the newer version
of MySQL I've installed to run. Any ideas? I can't kill the process, as it
appears to just be an
Hello.
On Fri, Feb 16, 2001 at 03:58:20PM -0800, [EMAIL PROTECTED] wrote:
>
> This is the latest approach we're using now. It turns out that the
> query to get Total Plays for an Album per City can be taken out of
> the City for loop & done only once as a GROUP BY. The worst case
> time for MyS
On Sat, 17 Feb 2001, Ingrid Kast Fuller wrote:
> I'm having an ODBC call failed error when I open one of my customers
> databases. I've tried re-linking it and still get the error. My other
> Mysql databases are working. But we just upgraded from FreeBSD 2.2.8 to
> FreeBSD 4.2 and we have had a fe
Actually, blobs are stored in files in data directory. You can store your
binary files in data directory, if you wish.
- Original Message -
From: Gerald R. Jensen <[EMAIL PROTECTED]>
To: clay bond <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, February 17
On Fri, Feb 16, 2001 at 05:58:27PM +0300, Peter Zaitsev wrote:
> Hello monty,
>
> I'm trying to use merge table for logging - to have a possibility to
> Rotate log files and to quickly delete old data - for this I'm goint
> to setup a number of merge tables where each contains data for one
I'm having an ODBC call failed error when I open one of my customers
databases. I've tried re-linking it and still get the error. My other
Mysql databases are working. But we just upgraded from FreeBSD 2.2.8 to
FreeBSD 4.2 and we have had a few files come over with wrong
permissions. It's saying "
Hello, I've been trying to make and ODBC connection with a remote database
and I can't. What should I do?
Something else, Can I have a connection between Visaul Basic and MySqlwith a
remote database?
Thank you.
-
Before postin
On Sun, Feb 18, 2001 at 01:18:04AM +0800, Teddy A Jasin wrote:
> Hi All,
> Below is the status that I got from my server's mysql server, can anyone
> explain to me more on this?? and as u see here... currently mysql server
> is running extremely slow:
>
Try posting a 'show processlist' so you ca
Some guys here lurk around only to get their problems solved and chuck off the
minute any kindred list memeber solves it . For them it just feels so smart thinking
that the list is the best place to get their work done without paying a dime .
So all u guys intending to only take and not gi
Hi All,
Below is the status that I got from my server's mysql server, can anyone
explain to me more on this?? and as u see here... currently mysql server
is running extremely slow:
mysql>show variables;
++--+
| Variable_name
just do it using grant statement so that you can connect from another host.
use grant to username@'%' instead of localhost
- Original Message -
From: "Emre Yildirim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 18, 2001 12:40 AM
Subject: cannot connect to database
>
You can use PHP with Flash and then use PHP to access MySQL.
BR,
Fábio Ottolini
- Original Message -
From: "Wernher Korff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 12:53 PM
Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
> can yopu link
On Sat, 17 Feb 2001, Artem Koutchine wrote:
> Aha, java is even better :)
Absolutely. I can't think of anything I'd rather do
than sit and wait for the browser to load the JVM.
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
try mod_auth_mda
or some generic auth module which allows authrization via
any script. However, i am happily using mod_auth_mysql
with 1.3.14, however i build from the port on mysql with
some magic envolved. However, i didn't try to build
it with 1.3.17
- Original Message -
From: "Erik Tj
I said Java. Java i said. Java said I.
- Original Message -
From: "Wernher Korff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 6:53 PM
Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
> can yopu link a database to flash?
> van
>
> -Origina
yes you can. And its cool too :-)
On Sat, 17 Feb 2001, Wernher Korff wrote:
> can yopu link a database to flash?
> van
>
> -Original Message-
> From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 17, 2001 4:07 PM
> To: Brian V Bonini
> Cc: [EMAIL PROTEC
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Hello folks,
This is probably some very stupid mistake, but I don't know what else to do.
I just installed the latest mysql source. Everything compiled nice and
without errors and installed correctly. My problem is, I can't connect to
the
It is even possible to do just with JavaScript, by being creative. However,
refreshing the page seems the logical option. Is there any special reason
for not doing it? I am almost always in favor of keeping things on the
server side.
Jose Carlos
>Relax, XML has N.O.T.H.I.N.G. to do with what you
No, solve it in your own program.
- Original Message -
From: "Robert Heron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 6:35 PM
Subject: special characters in MySQL query
> I have written a program which reads data from WWW forms and passes
it to
> MyS
Am I the only one with problems with mod_auth_mysql?
When trying to install Apache 1.3.17 with mod_auth_mysql 2.20
the compilation of apache fails. This seems to be because
mod_auth_mysql wants to use alloc (from apache), but
its name has changed to ap_alloc.
I just changed alloc.h to ap_alloc.h
can yopu link a database to flash?
van
-Original Message-
From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 17, 2001 4:07 PM
To: Brian V Bonini
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTEC
I have written a program which reads data from WWW forms and passes it to
MySQL queries. All works fine except for the cases when the form is filled
with characters like '%', '"', ''', etc. Then, these characters are treated
like special, formatting characters in SQL query, which, of course demage
> Maybe Flash is an option?
Well, I know I could probably do it some way in flash (if I had
experiences with it), but this is just a bit out 'of the box'. But still,
thanks for offering.
Siim
-
Before posting, please check:
does anybody know the QUERY to drop a column for MSSQL 6.5?
thanx regards wernher
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
Aha, java is even better :)
- Original Message -
From: "Brian V Bonini" <[EMAIL PROTECTED]>
To: "Peter Skipworth" <[EMAIL PROTECTED]>; "Siim Einfeldt aka
Itpunk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
On Fri, Feb 16, 2001 at 10:46:40AM -0800, Fox Mulder wrote:
>
> --- Brian Reichert <[EMAIL PROTECTED]> wrote:
> > On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
> > > There are no DB defined space limits on MySQL Databases ?It's
> > dangerours .How to control
> > > the database space on m
Relax, XML has N.O.T.H.I.N.G. to do with what you want to do.
You want dynamically update (rebuild) HTML page, well,
the only way to do it currently in more or less compatible way
is to use javascript+DHTML. And the result will SUCK, i know,
i've done it. So, go the way the elders did. Refresh th
Actually ... there are often some good reasons one might want to store
pictures in BLOBs.
For example, our integrated application gives the administrators at our
various customer sites the ability to associate a series of icons on a
toolbar with a wide range of programmable functions. In addition
XML is all about data definition - not being able to dynamically
change the display of the data on a webpage. Browsers don't even
understand XML natively - you need to write it out as HTML before you can
display it in IE or Netscape.
P
On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote:
>
>
Maybe Flash is an option?
> -Original Message-
> From: Peter Skipworth [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 17, 2001 9:29 AM
> To: Siim Einfeldt aka Itpunk
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROT
But I`m pretty sure it is possible with XML, in theory at least, I get
the data from the database, I write it into array, put into xml and then
deal with it - that`s how I imagine it.
DHTML doesn`t seem the best way to do it...but then maybe it`s just me.
cheers
Siim Einfeldt
> I'm afra
I'm afraid XML isn't going to help you - you need to investigate DHTML
options, although you'll be lucky to find a solution which is
compatible across both Netscape and IE.
regards,
P
On Sat, 17 Feb 2001, Siim Einfeldt
aka Itpunk wrote:
> Hi everybody,
>
> I want to implement ordering somethi
Hi everybody,
I want to implement ordering something on a website without refreshing the
page. Lets say i have four columns in the html table - name,age,skill and
phone. All these are links - under these are the information, eg:
Name Age Skill Phone
Siim 23 php 051...
Tony 18 html 132...
N
On Sat, 17 Feb 2001, Nikhilesh Haval wrote:
> I want to store different file formats in a database like images (*.jpg)
> or audio files (*.mp3). Is it possible to do so in mysql?
>
Yeah, that's what BLOB is for--but why would you want
to do that? Why not just store the path in the table,
and
Hi all,
All of a sudden, some of my data (originating from a web form) is showing
content such as the following...
Sailing & Windsurfing Instructor – training
given-(Mediterranean Coast)This is a fantastic opportunity to work
for the UK’s leading children’s adventure holiday
co
Solaris tar has bugs - download and install GNU tar from
www.gnu.org
Cheers,
Pete
On Sat, 17 Feb 2001, HASAN farooq wrote:
> I have GNU tarbut still when i decompress the the
> mysql i get
> mysql-3.22.32-sun-solaris2.7-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_
> i686-cmp-adabas,mysql
I have GNU tarbut still when i decompress the the
mysql i get
mysql-3.22.32-sun-solaris2.7-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_
i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks
tar: directory checksum error
i have used both versions
mysql-3.22.32-sun-solaris2.7-sparc.tar
mysql-3.23.3
On Sat, Feb 17, 2001 at 12:07:53PM +0100, Cedric Lefebvre wrote:
> I have written the following SQL request, but I get
> an error, why ?
>
> create table MovementOrder (
> teamCode INT(4) NOT NULL,
> quarter INT(4) NOT NULL,
> position INT(4) NOT NULL,
> priority INT(4) NOT NULL,
> orde
Shawn Boedecker writes:
> Hi,
>
> I just started looking at the MySQLGUI tool in depth yesterday. I have one
> question for now. I'm able to save queries via the "Save Query" button but
> I don't see any facility to load the query back in from a file. Is this
> functionality missing or h
damn it, DOES ANYBODY READ MANUALS these days?
in short: yes
for details: RTFM
it might not be good. you probabluy want to keep filenames in
the db, but files itself in the filesystems. Your choice.
Artem
- Original Message -
From: "Nikhilesh Haval" <[EMAIL PROTECTED]>
To: "mysql list"
Lyrics: I found it weird that people don't even realize that one must
learn to learn and for that one must learn to ask questions. I also
often find that people who cannot ask questions are either idiots
beyond
hope or very much egoists. That, of course, does not apply to every
single
case. There
Hi All!
I am not able to connect to remote Mysql running on a Linux meachine .I
am running a win2k where apache and php are configured .
Please let me know what could be wrong or how to connect to remore Mysql
database
Thanks in advance
Manikandan
_
HI!
In response to several mail messages on mailing list that were
centered around some misbehaviour of SHOW DATABASES / TABLES, I have
tested thoroughly (with several --user=... options) 3.23.33 and found
out that it works perfectly.
Causes of misbehavious can be :
- errors in building proces
I want to store different file formats in a database like images (*.jpg)
or audio files (*.mp3). Is it possible to do so in mysql?
-Nikhilesh
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
I have written the following SQL request, but I get
an error, why ?
create table MovementOrder (
teamCode INT(4) NOT NULL,
quarter INT(4) NOT NULL,
position INT(4) NOT NULL,
priority INT(4) NOT NULL,
order VARCHAR(10),
parameter VARCHAR(5),
PRIMARY KEY(teamCode,quarter,position,prio
61 matches
Mail list logo
