how to do a query using a file?

[mario . lat]

I have to buitd a "big" database.
I have to create table,
insert row in database and then do the same thing on another computer.
I'd like to do that using a file in whiich I write all ...
but how can I do?
Thank you in advance. Mario.

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

myodbc uses bash'ism and should not have #!/bin/sh

[Michael Widenius]

Hi!

> "ch" == ch  <[EMAIL PROTECTED]> writes:

>> Description:
ch> The following output occures when using ASH as /bin/sh.
ch> Your script seems to rely on non-POSIX features from bash
ch> and therefore should be called with #!/bin/bash. This works.
 
ch> -=(~/debian/mysql/ODBC/myodbc2.50.37-2.50.37)$ ./configure 
ch> creating cache ./config.cache
ch> checking for a BSD compatible install... /usr/bin/install -c
ch> checking whether build environment is sane... configure: error: ls -t appears 
to fail.  Make sure there is not a broken
ch> alias in your environment
ch> configure: error: newly created file is older than distributed files!
ch> Check your system clock

>> How-To-Repeat:
ch> use the smaller (but fully POSIX compliant) /bin/ash as /bin/sh
>> Fix:
ch> start the configure script with #!/bin/bash

The test that fails is: 

if (set X `ls -t $srcdir/configure conftestfile`; test "$2" = conftestfile)
then

We know that this works for a lot of 'sh' on a lot of different
systems and this is a standard configure thing I am more inclined to
think this is a bug in ASH than in configure.

Can you provide us with some more details about this or even better,
prove that configure is not following POSIX here?

Regards,
Monty



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MERGE Tables

[Sergei Golubchik]

Hi!

On Apr 30, Matthew Shaw wrote:
> Hi,
> 
> The merge table created is called asic_cache. It has exactly the same
> structure as above except there are no keys what so ever. My
> understanding is that there is no need for keys on the merge
> table as the table handler uses the keys on each individual table when
> doing the lookups.

You're only partially right.

Table handler for MERGE can use keys of underlying tables for
key lookups, but in fact it never will, as SQL optimizer will never ask 
to. Specifying keys for MERGE table is for SQL optimizer to able to 
chose the best way to execute your SELECTs. No real keys are created,
as MERGE handler ignores requests for key creation - but SQL optimizer
doesn't know about MERGE handler specific - and it shouldn't.

So, please, specify the same keys for MERGE table, you specified
for underlying tables.

Regards,
Sergei

--
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: New filter

[B. van Ouwerkerk]

>This is email. It's not a bomb on a plane. Choices exist for a digest,
>or a newsgroup. Freedom has a price. I am more than willing to pay it.

I don't feel our freedom has been limited by the filter used.

Glad the listadmins does take some steps to prevent spam.

just my 0,02

Bye,



B.

mysql, query, sql


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: how to do a query using a file?

[Sofiane Sakhri]

He, you can download the documentation file from
http://www.lri.fr/~aze/PHP/docs/  or others  and see
the example chapter,
In my case, I Store my Access data base in a text file
and upload to my serveur, then I execute this sql
query: load data local infile "file.txt" into table
my_table
it works fine, you will find this in the example
chapter.

Sofiane


--- [EMAIL PROTECTED] a écrit : > I have to buitd a
"big" database.
> I have to create table,
> insert row in database and then do the same thing on
> another computer.
> I'd like to do that using a file in whiich I write
> all ...
> but how can I do?
> Thank you in advance. Mario.
> 
>
-
> 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-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

dynamic SET and ENUM

[David Hugh-Jones]

Just drawing a bow at a venture, but is it possible to have a SET or ENUM 
dynamically linked to a table so that valid elements for the SET/ENUM are 
composed from the rows in another table? 

E.g.
ALTER TABLEpurchase MODIFY products_bought SET( SELECT * FROM products.name)

I guess not, but just wanted to check.

sql sql sql. dumb email filter.
-- 
David Hugh-Jones
iDomainCart

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql can't start: help!

[mario . lat]

I use RedHat (last release)
I try to use Mysql but It doesen' works:
I post you some lines can help you to understand the error.
how can create a table, use Mysql?
Thank you in advance, Mario.

-
[root@localhost mysqld]$ mysqladmin vesion
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mys
.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.
ists!


-
[root@localhost mysql]# ./mysql.server start 
[root@localhost mysql]# Starting mysqld daemon with databases from 
/var/lib/mysql
010430 10:37:02  mysqld ended
-
[root@localhost log]# tail mysqld.log 
010430 10:22:19  mysqld ended

010430 10:24:50  mysqld started
010430 10:24:50  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
010430 10:24:50  mysqld ended

010430 10:37:02  mysqld started
010430 10:37:02  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
010430 10:37:02  mysqld ended
-

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

TIMESTAMP Replication!!

[Gabriel Corneanu]

Hello,
The manual says that TIMESTAMP should work. What does this mean? When I
replicate a table with such a field, the values on the slave is
different. Is this OK or a bug?
I'm trying to use this field to avoid data overwrite. In a JSP page I
select a record, read TIMESTAMP field value, and when applying the
changes I use a statement like :
"update table set... where ID=? and TS=?"
where ID is key field and TS is TIMESTAMP field. In the case that
someone else modified the record, I can get a error (update count should
be 1).
When replicating, the TS values are diferent so the above statement
isn't working because of TS condition.
Can anyone help?
(mysql version 3.23.33)

Thanks,
Gabriel Corneanu


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem

[aditya shanker]

hi 
i have installd my sql on linux machine 

but its giving lot of problems related to 
configuration 
could you please tell me some link from where i can 
get a detailed trouble shooting material 
looking forward for your reply 
regards
aditya
 
Aditya ShankerTelecom and 
ConvergenceEscosoft Technologies LtdPh: 091-011-6959981/82/95/86 ext 
511

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: problem

[Harish Gundecha]

http://www.mysql.com
 
Kind Regards
Harish Gundecha
Systems Administrator
Email:   [EMAIL PROTECTED]
Versaware Technologies (India) Pvt. Ltd.
Phone No. : +91-20-6136028  Extn: 331

-Original Message-
From: aditya shanker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 3:36 PM
To: [EMAIL PROTECTED]
Subject: problem


hi 
i have installd my sql on linux machine 
but its giving lot of problems related to configuration 
could you please tell me some link from where i can get a detailed trouble
shooting material 
looking forward for your reply 
regards
aditya
 
Aditya Shanker
Telecom and Convergence
Escosoft Technologies Ltd
Ph: 091-011-6959981/82/95/86 ext 511

Re: Ordinary users can crash mysql server

[Gustavo Vieira Gonçalves Coelho Rios]

Hi folks!

Since we(not we, just my account) at Ifour had some problem with email,
i did'not get all resps to my bug report.

But, by reading some messages, i can see it'was not a good thing to have
posted the message on the list. Please, forgive for whatever i have
done. I have just done so, cause that's what is stated in the Manual,
and since i am a MySQL beginner... i do read the manuals.

Again, i am sorry for any problem i may have caused.
BTW, what was my mistaken?




Markus Gieppner gravada:
> 
> Hi Chris,
> 
> You should not forget those users who depend greatly on the tech support
> (patches) of the manufacturer. Given your expertise and knowledge you might
> be able to protect yourself, but not everybody is (as a matter of fact even
> Gustavo said he isn't). In addition, to make things worse, today is Sunday,
> and given the usual working hours in most countries, there's a very small
> chance that someone from AB Konsulting has read this. On the other hand,
> quite a number of hobby vandals, who spend their free days looking for
> holes, might have found a nice new toy to play with, and Gustavo even
> provided the "how-to" .
> 
> I agree with you on the first point: If this is a known bug, it has to be
> part of the "known-bug-list" and given it's severity, be stated clearly on
> the MySQL web site. Crashed server applications often bear the risk of
> allowing a hacker to execute his own code, thus making such a bug really
> dangerous, especially for web applications.
> 
> Your third point is a bit optimistic... Are you really prepared to react
> immediately to all known or unknown security risks? If you have 10.000 users
> using your application on a daily basis, or if you have 100 sites running
> with it, every modification of a core component of your databases requires
> good planning and careful handling. On a production server you usually don't
> have the freedom to experiment a lot with your home-made patches.
> 
> Don't get me wrong, I am not at all opposed to disclosure. This is what
> makes programs like MySQL, Linux etc. so powerful and more secure than
> closed-source software. Remember the problems with Interbase, or Hotmail
> (even better!) or the countless problems on Microsoft programs. It's
> indispensable to search for bugs, but again, give the manufacturer at least
> a chance to look into a matter before giving hackers a doorway to crash your
> machine and worse steal or destroy your data.
> 
> Markus Gieppner
> MGF International Inc.
> 
> -Original Message-
> From: Chris DiBona [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 29, 2001 6:08 PM
> To: Markus Gieppner
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Ordinary users can crash mysql server
> 
> I disagree with you markus, and here is why..
> 
> 1gustavo probably isn't the only person who has noticed this, so it's
> fair to say it's already made the round amongst those who arent so nice.
> 
> 2this _is_ the mysql list.
> 
> 3this way, people can plan for such a problem and button things up
> until a fix is forthcoming.
> 
> 4whether he went to the manufacturer or not, I personally am happy
> that he posted it, it made me batte ndown a hatch or two.
> 
>  Chris
> 
> --
> Marketing Manager, OSDN Events|   http://www.osdn.com
> Grant Chair, Linux International. |   http://www.li.org
> Co-editor, Open Sources   |   http://www.dibona.com
> 
> On Sun, 29 Apr 2001, Markus Gieppner wrote:
> 
> > Bom dia, Gustavo,
> >
> > I am not in a position to comment nor to verify your warning. However, I
> am
> > pretty annoyed by the way you make it public to the world. Unless I missed
> > something here, but when someone discovers a security hole in any program,
> > it's common standard to contact the manufacturer immediately, directly and
> > offlist and give him a chance to comment and/or release a patch within a
> > reasonable timeframe. If then, after a couple of weeks, you didn't get any
> > response from the manfacturer, you should go public. I don't know if you
> did
> > that, if you did I apologize and ask to ignore this message.
> >
> > Just imagine what doors you might open to hackers and vandals who always
> > monitor these lists. (Where else could they get inspiration and necessary
> > info for their sick minds???)! A major security bug could threaten
> thousands
> > of sites all over the world. Responsible and fair handling is a must.
> >
> > Obrigado.
> >
> > Markus Gieppner
> >
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, April 29, 2001 11:13 AM
> > To: [EMAIL PROTECTED]
> > Subject: Ordinary users can crash mysql server
> >
> >
> > >Description:
> >   When a ordinary users tries to analyze bin log using a remote host (-h
> > ip_address) mysql server daemons crahes.
> > >How-To-Repeat:
> >   Just use mysqlbinlog to analyze a remote host binlog.
> >   mysql -h ip_

Re: Ordinary users can crash mysql server

[Gustavo Rios]

Yes, i use the same directory for data and log files (/var/db/mysql).
And, as far as i know, there is mysqld options that allows me to specify a directory 
to hold all logs.

How can this be accomplished?

Thanks for your support and time.

-- Original Message --
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Sun, 29 Apr 2001 14:51:50 -0700

>On Sun, Apr 29, 2001 at 03:12:51PM +, [EMAIL PROTECTED] wrote:
>> >Description:
>>  When a ordinary users tries to analyze bin log using a remote host (-h 
>ip_address) mysql server daemons crahes.
>> >How-To-Repeat:
>>  Just use mysqlbinlog to analyze a remote host binlog.
>>  mysql -h ip_address -u user -p pass file
>> 
>>  For instance (My environment):
>>  shell> mysql -h 192.168.1.11 -u awp -p root etosha-bin.001
>
>Do you store your binary logs in the datadir (the same directory which
>contains your database sub-directories)?
>
>If so, relocating the binary log files is probably the most
>straightforward solution until the MySQL team can verify and fix the
>problem.
>
>Jeremy
>-- 
>Jeremy D. Zawodny, <[EMAIL PROTECTED]>
>Technical Yahoo - Yahoo Finance
>Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
>
>MySQL 3.23.29: up 116 days, processed 720,915,358 queries (71/sec. avg)
>
>-
>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-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: how to do a query using a file?

[mario . lat]

> query: load data local infile "file.txt" into table
> my_table

Thank you.
But for creating an entire and complex database?
I mean If you have to create 40 table?!?
there is a way to do it by ascii file?
I write the SQL commands once and then I can recreate the db whth tables in 
different computers.
Thank you in advance, Mario.

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Unix_TimeStamp()

[Basil Hussain]

Hi,

>> Does the function Unix_TimeStamp() work in MySQL under Windows NT?
>> It doesn't seem to work here in simple queries, such as this query:
>> Select Unix_TimeStamp();
> 
> What about
> 
> SELECT UNIX_TIMESTAMP(NOW())

The above shouldn't be necessary - it is actually supposed to give you the
current timestamp if called without arguments. According to the manual,
anyway:

"If called with no argument, returns a Unix timestamp..."

So, if it's not working as documented under Windows, then I think this
counts as a bug, yes?

Regards,


Basil Hussain ([EMAIL PROTECTED])


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem

[Tonu Samuel]

On 30 Apr 2001 15:36:11 +0530, aditya shanker wrote:
> hi 
> i have installd my sql on linux machine 
> but its giving lot of problems related to configuration 
> could you please tell me some link from where i can get a detailed trouble shooting 
>material 
> looking forward for your reply 


This link is in the bottom of every message:


> -
> 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-mail <[EMAIL PROTECTED]>


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql can't start: help!

[Tonu Samuel]

On 30 Apr 2001 10:43:24 +0200, [EMAIL PROTECTED] wrote:
> 
> I use RedHat (last release)
> I try to use Mysql but It doesen' works:
> I post you some lines can help you to understand the error.
> how can create a table, use Mysql?
> Thank you in advance, Mario.
> 
> -
> [root@localhost mysqld]$ mysqladmin vesion
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/var/lib/mys
> .sock' (111)'
> Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.
> ists!
> 
> 
> -
> [root@localhost mysql]# ./mysql.server start 
> [root@localhost mysql]# Starting mysqld daemon with databases from 
> /var/lib/mysql
> 010430 10:37:02  mysqld ended
> -
> [root@localhost log]# tail mysqld.log 
> 010430 10:22:19  mysqld ended
> 
> 010430 10:24:50  mysqld started
> 010430 10:24:50  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> 010430 10:24:50  mysqld ended
> 
> 010430 10:37:02  mysqld started
> 010430 10:37:02  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> 010430 10:37:02  mysqld ended


Please check the manual both about common problems and how to post
problems in list. This error can depend on which MySQL version you
installed. Is it RPM, binary or source installation? Check the manual
again


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ANNOUNCE: moodss-14.2

[Jean-Luc Fontaine]

Hi everybody: here is a new version of moodss.


Check it out! (or at least the screenshots at
http://jfontain.free.fr/moodss3.gif or
http://jfontain.free.fr/moodss4.gif :).


### CHANGES ###

--- version 14.2 ---
made thresholds table a drop zone for data cells
MySQL myvars module updated to support 3.23.37 server
in thresholds table, implemented tabbing between cells
in save files, data tables column widths are now saved only if module
  specifies resizable columns
module programmers: added resizableColumns optional boolean in module
  configuration data
successfully built and tested on a Linux Redhat 7.1 i386 machine


### README ###

This is moodss (Modular Object Oriented Dynamic SpreadSheet) version
14.2.

Moodss won in the Best System Admin Technology category (Tcl Tips and
Tricks, Valuable Real World Programming Examples) at the O'Reilly
Tcl/Tk 1999 Conference.
Linux Magazine calls it a "lifesaver".
Tucows gives it 5 stars (cows or penguins :-).

Moodss is a modular application. It displays data described and
updated in one or more modules, which can be specified in the command
line or dynamically loaded or unloaded while the application is
running. Data is originally displayed in tables. Graphical views
(graph, bar, 3D pie charts, ...), summary tables (with current,
average, minimum and maximum values) and free text viewers can be
created from any number of table cells, originating from any of the
displayed viewers. Thresholds can be set on any number of cells.

Specific modules can easily be developed in the Tcl, Perl and Python
scripting languages or in C.

A thorough and intuitive drag'n'drop scheme is used for most viewer
editing tasks: creation, modification, type mutation, destruction,
... and thresholds creation. Table rows can be sorted in increasing or
decreasing order by clicking on column titles. The current
configuration (modules, tables and viewers geometry, ...) can be saved
in a file at any time, and later reused through a command line switch,
thus achieving a dashboard functionality.

The module code is the link between the moodss core and the data to be
displayed. All the specific code is kept in the module package. Since
module data access is entirely customizable (through C code, Tcl,
Perl, Python, HTTP, ...) and since several modules can be loaded at
once, applications for moodss become limitless.
For example, thoroughly monitor a dynamic web server on a single
dashboard with graphs, using the Apache, MySQL, cpustats, memstats,
...  modules. If you have replicated servers, dynamically add them to
your view, even load the snmp module on the fly and let your
imagination take over...

Along with a core trace module, random, ps, cpustats, memstats,
diskstats, mounts, route, arp, kernmods, netdev, pci, system, MySQL
(myquery, mystatus, myprocs, myvars) modules for Linux, ping, snmp and
snmptrap for UNIX, apache and apachex modules are included (running
"wish moodss ps cpustats memstats" mimics the "top" application with a
graphic edge and remote monitoring capability).

Thorough help is provided through menus, widget tips, a message area,
a module help window and a global help window with a complete HTML
documentation.

Moodss is multi-langual thanks to Tcl internationalization
capabilities. So far only English and partially French are
supported. Help with other languages will be very warmly welcomed.

Development of moodss is continuing and as more features are added in
future versions, backward module code compatibility will be maintained.

I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML
libraries enough for their great work.

In order to run moodss, you need to install the following packages
(unless you can use the rpm utility, see below):
Tcl/Tk 8.3.1 or above, at (or at a mirror near you)
  http://dev.scriptics.com/ or ftp://ftp.scriptics.com/
the latest tkTable widget library at:
  http://www.hobbs.wservice.com/tcl/main.html
the latest BLT library at:
  ftp://tcltk.sourceforge.net/pub/tcltk/blt/
eventually the latest tclperl library for writing modules in Perl, or
the latest tclpython library for writing modules in Python at:
  http://jfontain.free.fr/
(see the INSTALL file for complete instructions, for UNIX and also
Windows platforms).

You also have the option of using the moodss rpm file (also in my
homepage), if you are using a Redhat Linux system (6.0 or above).
You can find the required tcl, tk, tktable, blt, tcpperl and other
rpms at: http://jfontain.free.fr/

Whether you like it (or hate it), please let me know. I would like to
hear about bugs and improvements you would like to see. I will correct
the bugs quickly, especially if you send me a test script (module code
with a data trace would be best).

###

you may find it now at my homepage:

http://jfontain.free.fr/moodss-14.2.tar.bz2
http://jfontain.free.fr/moodss-14.2-1.i386.rpm
http://jfontain.free.fr/moodss-14.2-1.spec

and a bit later at:

ftp://contrib.redhat.com/ in libc6 sub-directory.

Re: MERGE Tables

[Basil Hussain]

Hi,

> Table handler for MERGE can use keys of underlying tables for
> key lookups, but in fact it never will, as SQL optimizer will never ask
> to. Specifying keys for MERGE table is for SQL optimizer to able to
> chose the best way to execute your SELECTs. No real keys are created,
> as MERGE handler ignores requests for key creation - but SQL optimizer
> doesn't know about MERGE handler specific - and it shouldn't.
> 
> So, please, specify the same keys for MERGE table, you specified
> for underlying tables.

I have been wondering about the use of indexes with MERGE tables. I came to
the same conclusion as what you have just explained, but by trial and error.
I would like to say that I think the section in the manual on MERGE tables
could do with some improvement!

Anyway, while we're on the subject, I seem to be having some trouble with my
indexes on MERGE tables. I posted a message a while ago, but no-one seems to
have noticed it...

Basically, if I create my MERGE table with indexes on the same columns as
the underlying tables, I then get strange results from some queries. Below I
quote part of my original message that illustrates the problem.

> mysql> select count(*) from eventlog_36;
> +--+
> | count(*) |
> +--+
> |   389959 |
> +--+
> 1 row in set (0.00 sec)
> 
> mysql> select count(*) from eventlog_all where bannerid = 36;
> +--+
> | count(*) |
> +--+
> |1 |
> +--+
> 1 row in set (0.01 sec)
> 
> (The table 'eventlog_36' is one of the tables mapped to 'eventlog_all' which
> holds only records with a 'bannerid' column value of 36.)
> 
> They don't match, so it's clearly not correct! It seems as though it's not
> looking at the indexes of the mapped tables correctly, although I have no idea
> why!

Also, I get the following error when I try to alter the mapping of the MERGE
table:

> mysql> ALTER TABLE eventlog_all UNION=(eventlog_11, <..lots of tables...>,
> eventlog_88);
> ERROR 1031: Table handler for '#sql-1f1_ea6d9' doesn't have this option

My MERGE table seems to be completely screwed! Could you explain what's
going on here? Is it because I'm running only version 3.23.32 of MySQL? Do I
need to upgrade? Any assistance would be appreciated, as no-one else seems
to be able to help.

Regards,


Basil Hussain ([EMAIL PROTECTED])


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: show table status command in MySQL

[Basil Hussain]

Hi,

> For show table status command in MySQL, which field is indicate the
> table size?  Or, Which command is to find out the database size.

The 'Data_length' field in the SHOW TABLE STATUS output will tell you how
big the data is (in bytes). Bear in mind this doesn't give the actual size
taken up on disk, because you have your index file and table definition file
too. I think the 'Index_length' field will tell you how big your indexes are
too, though.

Regards,


Basil Hussain ([EMAIL PROTECTED])


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: TIMESTAMP Replication!!

[Gabriel Corneanu]

Hi,
I have just checked the logs, and the point is that in the update log
there are statements for setting the timestamp, and in the binary log
not.
Is this OK?

Thanks again.
Gabriel

>  -Original Message-
> From: Gabriel Corneanu  
> Sent: Monday, April 30, 2001 11:23 AM
> To:   MySQL Mailing list (E-mail)
> Subject:  TIMESTAMP Replication!!
> 
> Hello,
> The manual says that TIMESTAMP should work. What does this mean? When
> I replicate a table with such a field, the values on the slave is
> different. Is this OK or a bug?
> I'm trying to use this field to avoid data overwrite. In a JSP page I
> select a record, read TIMESTAMP field value, and when applying the
> changes I use a statement like :
> "update table set... where ID=? and TS=?"
> where ID is key field and TS is TIMESTAMP field. In the case that
> someone else modified the record, I can get a error (update count
> should be 1).
> When replicating, the TS values are diferent so the above statement
> isn't working because of TS condition.
> Can anyone help?
> (mysql version 3.23.33)
> 
> Thanks,
> Gabriel Corneanu
> 

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql can't start: help!

[mario . lat]

> Please check the manual both about common problems and how to post
> problems in list. This error can depend on which MySQL version you
> installed. Is it RPM, binary or source installation? Check the manual
> again

I'm very sorry for take a noice to mailing list... but I try it!
i try also with safe_mysqld and some other command but it dont work!
For the version should be ritht :  It was istalled by RedHat (last version!)
I need mysql for thesis and I have to develop a free software...
so sorry if I make noice but I hope my work will be userfull for somebody of 
you in the future.
Mario.






> > I use RedHat (last release)
> > I try to use Mysql but It doesen' works:
> > I post you some lines can help you to understand the error.
> > how can create a table, use Mysql?
> > Thank you in advance, Mario.
> >
> > -
> > [root@localhost mysqld]$ mysqladmin vesion
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Can't connect to local MySQL server through socket '/var/lib/mys
> > .sock' (111)'
> > Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.
> > ists!
> >
> >
> > -
> > [root@localhost mysql]# ./mysql.server start
> > [root@localhost mysql]# Starting mysqld daemon with databases from
> > /var/lib/mysql
> > 010430 10:37:02  mysqld ended
> > -
> > [root@localhost log]# tail mysqld.log
> > 010430 10:22:19  mysqld ended
> >
> > 010430 10:24:50  mysqld started
> > 010430 10:24:50  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> > 010430 10:24:50  mysqld ended
> >
> > 010430 10:37:02  mysqld started
> > 010430 10:37:02  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> > 010430 10:37:02  mysqld ended
>
> Please check the manual both about common problems and how to post
> problems in list. This error can depend on which MySQL version you
> installed. Is it RPM, binary or source installation? Check the manual
> again
>
>
> -
> 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-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Unix_TimeStamp()

[Jeremy Zawodny]

On Mon, Apr 30, 2001 at 12:24:26PM +0100, Basil Hussain wrote:
> Hi,
> 
> >> Does the function Unix_TimeStamp() work in MySQL under Windows NT?
> >> It doesn't seem to work here in simple queries, such as this query:
> >> Select Unix_TimeStamp();
> > 
> > What about
> > 
> > SELECT UNIX_TIMESTAMP(NOW())
> 
> The above shouldn't be necessary - it is actually supposed to give you the
> current timestamp if called without arguments. According to the manual,
> anyway:
> 
> "If called with no argument, returns a Unix timestamp..."
> 
> So, if it's not working as documented under Windows, then I think
> this counts as a bug, yes?

Indeed. I hadn't used it without arguments before, and forgot about
that behavior.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 117 days, processed 723,589,119 queries (71/sec. avg)

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

doc error?

[till]

hi!

i found this in the mysql docs.. and it's irritating me: how can my_ulonglong 
have a value of -1?

 snip 

22.4.1 mysql_affected_rows()

my_ulonglong mysql_affected_rows(MYSQL *mysql) 

22.4.1.1 Description

Returns the number of rows affected (changed) by the last UPDATE, DELETE or 
INSERT query. May be called immediately after mysql_query() for
UPDATE, DELETE, or INSERT statements. For SELECT statements, 
mysql_affected_rows() works like mysql_num_rows(). 

mysql_affected_rows() is currently implemented as a macro. 

22.4.1.2 Return Values

An integer greater than zero indicates the number of rows affected or 
retrieved. Zero indicates that no records matched the WHERE clause in the 
query or
that no query has yet been executed. -1 indicates that the query returned an 
error or that, for a SELECT query, mysql_affected_rows() was called
prior to calling mysql_store_result(). 

22.4.1.3 Errors

None. 

22.4.1.4 Example

mysql_query(&mysql,"UPDATE products SET cost=cost*1.25 WHERE group=10");
printf("%d products updated",mysql_affected_rows(&mysql));


-- 
# till busch, reschgasse 5/24, 1120 wien, austria


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

index troubles

[Wix,Christian XCW]

Hi!
I have some troubles with my index.
I want to be able to use an index (test=(mintid, name)). I will use the
index when I write: select mintid, name from loeb;
I have created an index but it doesn't seem to work. Why?
// Chris - Copenhagen

mysql> show index from loeb;
+---++--+--+-+---+--
---+--+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part |
+---++--+--+-+---+--
---+--+
| loeb  |  0 | PRIMARY  |1 | id  | A |
90 | NULL |
| loeb  |  1 | rekord   |1 | mintid  | A |
NULL | NULL |
| loeb  |  1 | test |1 | mintid  | A |
NULL | NULL |
| loeb  |  1 | test |2 | name| A |
NULL | NULL |
+---++--+--+-+---+--
---+--+
4 rows in set (0.00 sec)

mysql> show columns from loeb;
+--+-+--+-+--++
| Field| Type| Null | Key | Default  | Extra  |
+--+-+--+-+--++
| name | varchar(20) |  | |  ||
| distance | double(3,1) |  | | 0.0  ||
| dato | date| YES  | | NULL ||
| id   | int(11) |  | PRI | 0| auto_increment |
| tottid   | time|  | | 00:00:00 ||
| mintid   | time|  | MUL | 00:00:00 ||
| art  | varchar(10) | YES  | | NULL ||
+--+-+--+-+--++
7 rows in set (0.00 sec)

mysql> explain select mintid, name from loeb;
+---+--+---+--+-+--+--+---+
| table | type | possible_keys | key  | key_len | ref  | rows | Extra |
+---+--+---+--+-+--+--+---+
| loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
+---+--+---+--+-+--+--+---+
1 row in set (0.00 sec)


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mod_auth_mysql & password trading

[Joel Gwynn]

Is there a simple way to prevent password trading on an apache system
using mod_auth_mysql?  I've already got the module installed and
working.  It would be nice if a directory of flat files could be
protected, without having any kind of SSI's, CGI's, etc.

anyone ... anyone?

--
[Joel-Gwynn]-[[EMAIL PROTECTED]]===
A train station is where a train stops.
A bus station is where a bus stops.
So now you know why they call this a workstation.

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Max connections on Freebsd

[Ken Menzel]

Hi Patric,
  I run serveral FreeBSD servers, although not on 4.2,  please upgrade
to 4.3,  there are documented problems with thread on 4.2 that were
corrected later.  I have a number of machines set at 300 as the
max_connections paramters althought I don't often see more than 130
connections at the moment.  It works just fine, we run about 23% cpu
load during peaks with DELL 2400 800mhz machines 1gig of RAM.
Ken
-
Ken Menzel  ICQ# 9325188
www.icarz.com  [EMAIL PROTECTED]
- Original Message -
From: "Patric de Waha Lists" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 6:07 PM
Subject: Max connections on Freebsd


> Hi,
> Is there someone who incremented the max_connection
> value to something above 100 (200) (300) on Freebsd 4.2?
>
> I had problems with mysql on freebsd 4.0, hooked up
> after some days without any good reason :).
> Some people told me thread libraries on freebsd 4.0
> suck a bit. So I wonder if 4.2's thread libraries
> are stable enough to handle 200 concurrent threads?!.
>
> Thanks in advance
>
> Regards,
> Patric de Waha
>
>
> 
-
> 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-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: index troubles

[Thalis A. Kalfigopoulos]

Hello,

The index you have created is just fine and should be utilized as long as you perform 
a query that needs to use an index.
Your query:
select a,b from t;
doesn't have any conditions imposed upon the table's rows. It just asks for all the 
them. Simple file scan.

regards,
thalis


On Mon, 30 Apr 2001, Wix,Christian XCW wrote:

> Hi!
> I have some troubles with my index.
> I want to be able to use an index (test=(mintid, name)). I will use the
> index when I write: select mintid, name from loeb;
> I have created an index but it doesn't seem to work. Why?
> // Chris - Copenhagen
> 
> mysql> show index from loeb;
> +---++--+--+-+---+--
> ---+--+
> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
> Cardinality | Sub_part |
> +---++--+--+-+---+--
> ---+--+
> | loeb  |  0 | PRIMARY  |1 | id  | A |
> 90 | NULL |
> | loeb  |  1 | rekord   |1 | mintid  | A |
> NULL | NULL |
> | loeb  |  1 | test |1 | mintid  | A |
> NULL | NULL |
> | loeb  |  1 | test |2 | name| A |
> NULL | NULL |
> +---++--+--+-+---+--
> ---+--+
> 4 rows in set (0.00 sec)
> 
> mysql> show columns from loeb;
> +--+-+--+-+--++
> | Field| Type| Null | Key | Default  | Extra  |
> +--+-+--+-+--++
> | name | varchar(20) |  | |  ||
> | distance | double(3,1) |  | | 0.0  ||
> | dato | date| YES  | | NULL ||
> | id   | int(11) |  | PRI | 0| auto_increment |
> | tottid   | time|  | | 00:00:00 ||
> | mintid   | time|  | MUL | 00:00:00 ||
> | art  | varchar(10) | YES  | | NULL ||
> +--+-+--+-+--++
> 7 rows in set (0.00 sec)
> 
> mysql> explain select mintid, name from loeb;
> +---+--+---+--+-+--+--+---+
> | table | type | possible_keys | key  | key_len | ref  | rows | Extra |
> +---+--+---+--+-+--+--+---+
> | loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
> +---+--+---+--+-+--+--+---+
> 1 row in set (0.00 sec)
> 
> 
> -
> 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-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

upgrade rpm and database

[Marc S. Bragg]

Am running mysql 3.23.22 with problem with linuxconf. Want to upgrade to

3.23.36 or 37, but get following error messages:

for 3.23.36 says:

mysql = 3.23.22 is needed by mysql-server-3.23.22-6
libmysqlclient.so.9 is needed by mysql-server-3.23.22-6
libmysqclient.so.9 is needed by php-mysql-4.0.1pl2-9

curiously, in /usr/lib/mysql there is:

libmysqlclient.so.9
libmysqlclient.so.9.0.0

so, I tried updating original install for libmysqlclient.so.9 but it
says it's already installed. What do I do ? I though libmysqlclient.so.9

is already installed, as I can see it, as a result of the original
mysql-3.23.22-6 installation.  On rpmfind.net all the
libmysqlclient.so.9 are included in the -6 rpm I alread have. Thanx,
very confused.

Runniing

rpm -Uvh mysql-3.23.22-6.i386 give me:

package mysql-3.23.22-6 is already installed.

also, cannot upgrade from glibc-2.1.92-14 to 2.2.2-10
get:

glibc < 2.2.2 conflicts with glibc-common-2.2.2-10
same issue perhaps?

thanx






--
Marc S. Bragg
[EMAIL PROTECTED]
Bialecki & Bragg, PC
p: 610-444-7508
f: 610-444-7548

http://www.chescolawyers.com/BB
"Chester County Legal Services" - "For All Your Legal Needs"


http://www.bloody100th.com "WWII 101st Airborne Division"
http://www.petercatalano.com "Soul of An Italian Artist"



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

What is wrong with load_file

[Dieter Becker]

>Description:
The following script should insert some files in a table, but load_file seems 
not to work
I think it is only a small error, but I don't find it.

Command File:

#
#!/bin/sh
set -exv
#Fügt die eingescannten Externbefunde in die Datenbank ein

edir=/net/ukh10288/tmpf/externbriefe
cd $edir


rm -f dofile1 dofile2 2>/dev/null
>dofile1
>dofile2


for x in letter*.tif
do
  if [ ! -f $x ]
  then
break
  fi
  dname=$edir/$x
  echo $dname
  ls -l $dname
  echo "insert into externbefunde values ('XXX11X', '1901-01-01', NULL, NULL, 
'tif', load_file(\"$dname\"), NULL);" >> dofile1
  echo "rm $dname 2>/dev/null" >> dofile2
done


# echo "delete from externbefunde where izahl = \"XXX11X\" and bild is null;" >> 
dofile1
/usr/local/bin/mysql -v -v -v -B -u db archiv < dofile1 2>&1
sh dofile2
rm dofile1 dofile2 2>/dev/null
###


The output looks like:

ukh3029 ~ [534]$ scan_db.sh 
#Fügt die eingescannten Externbefunde in die Datenbank ein

edir=/net/ukh10288/tmpf/externbriefe
edir=/net/ukh10288/tmpf/externbriefe
cd $edir
+ cd /net/ukh10288/tmpf/externbriefe 


rm -f dofile1 dofile2 2>/dev/null
+ rm -f dofile1 dofile2 
>dofile1
>dofile2


for x in letter*.tif
do
  if [ ! -f $x ]
  then
break
  fi
  dname=$edir/$x
  echo $dname
  ls -l $dname
  echo "insert into externbefunde values ('XXX11X', '1901-01-01', NULL, NULL, 
'tif', load_file(\"$dname\"), NULL);" >> dofile1
  echo "rm $dname 2>/dev/null" >> dofile2
done
+ [ ! -f letter0.tif ] 
dname=/net/ukh10288/tmpf/externbriefe/letter0.tif
+ echo /net/ukh10288/tmpf/externbriefe/letter0.tif 
/net/ukh10288/tmpf/externbriefe/letter0.tif
+ ls -l /net/ukh10288/tmpf/externbriefe/letter0.tif 
-rwxrw-rw-   1 nobody4  nogroup  2107944 Apr 30 15:46 
/net/ukh10288/tmpf/externbriefe/letter0.tif
+ echo insert into externbefunde values ('XXX11X', '1901-01-01', NULL, NULL, 
+'tif', load_file("/net/ukh10288/tmpf/externbriefe/letter0.tif"), NULL); 
+ echo rm /net/ukh10288/tmpf/externbriefe/letter0.tif 2>/dev/null 


# echo "delete from externbefunde where izahl = \"XXX11X\" and bild is null;" >> 
dofile1
/usr/local/bin/mysql -v -v -v -B -u db archiv < dofile1 2>&1
+ /usr/local/bin/mysql -v -v -v -B -u db archiv 
--
insert into externbefunde values ('XXX11X', '1901-01-01', NULL, NULL, 'tif', 
load_file("/net/ukh10288/tmpf/externbriefe/letter0.tif"), NULL)
--

Query OK, 1 row affected (0.01 sec)

Bye
sh dofile2
+ sh dofile2 
rm dofile1 dofile2 2>/dev/null
+ rm dofile1 dofile2 

ukh3029 ~ [535]$ 

#

The database does not store the file:
mysql> select * from externbefunde where izahl = "XXX11X" and rowid = 29856;
+++--+--+--+--+---+
| izahl  | datum  | bem1 | bem2 | typ  | bild | rowid |
+++--+--+--+--+---+
| XXX11X | 1901-01-01 | NULL | NULL | tif  | NULL | 29856 |
+++--+--+--+--+---+
1 row in set (0.00 sec)

mysql> 


What is wrong, and what should I change?


Thank You

Dieter


>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:Dieter Becker
>Organization:
  Dr. med. dipl.-math Dieter Becker   Tel.: (0 / +49) 6841 - 16 3046
  Medizinische Universitaets- und Poliklinik  Fax.: (0 / +49) 6841 - 16 3043
  Innere Medizin III 
  D - 66421 Homburg / SaarEmail: [EMAIL PROTECTED]
  
  
>
>MySQL support: email support #791
>Synopsis:  load_file in insert
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: 
>Release:   mysql-3.23.36 (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.18 Distrib 3.23.36, for sun-solaris2.6 on 
>sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.36-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 3 days 9 hours 16 min 40 sec

Threads: 42  Questions: 315967  Slow queries: 20  Opens: 28773  Flush tables: 7270  
Open tables: 1 Queries per second avg: 1.080
>Environment:

System: SunOS ukh3029 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-2
Architecture: sun4

Some paths:  /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc 
/d0/workshop/SUNWspro/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
-rw-r--r--   1 bin  bin  1607728 Oct 19  1999 

Re: Ordinary users can crash mysql server

[Rene Tegel]

you just did the right thing: you posted an anomaly to the list. that's not bad, 
that's good. Thanx for notifying us!

don't worry about possible abuse, as far as i can see you need a normal mysql account 
anyhow in the first place, and if any system administrator would notice such a user 
killing the deamon on purpose, he/she'd probably first kick him out off the system for 
ever, and then tell him/her he/she could be sewed (or in fact: sew him/her if there is 
any damage).

So, if a system administrator has such users, it's his/hers own mistake. Security is 
not made by a system or by mysql, security is made or broken by humans.


regards,

rene

On Mon, 30 Apr 2001 07:28:44 -0300
Gustavo Vieira Gonçalves Coelho Rios  <[EMAIL PROTECTED]> wrote:

> Hi folks!
> 
> Since we(not we, just my account) at Ifour had some problem with email,
> i did'not get all resps to my bug report.
> 
> But, by reading some messages, i can see it'was not a good thing to have
> posted the message on the list. Please, forgive for whatever i have
> done. I have just done so, cause that's what is stated in the Manual,
> and since i am a MySQL beginner... i do read the manuals.
> 
> Again, i am sorry for any problem i may have caused.
> BTW, what was my mistaken?
> 
> 
> 
> 
> Markus Gieppner gravada:
> > 
> > Hi Chris,
> > 
> > You should not forget those users who depend greatly on the tech support
> > (patches) of the manufacturer. Given your expertise and knowledge you might
> > be able to protect yourself, but not everybody is (as a matter of fact even
> > Gustavo said he isn't). In addition, to make things worse, today is Sunday,
> > and given the usual working hours in most countries, there's a very small
> > chance that someone from AB Konsulting has read this. On the other hand,
> > quite a number of hobby vandals, who spend their free days looking for
> > holes, might have found a nice new toy to play with, and Gustavo even
> > provided the "how-to" .
> > 
> > I agree with you on the first point: If this is a known bug, it has to be
> > part of the "known-bug-list" and given it's severity, be stated clearly on
> > the MySQL web site. Crashed server applications often bear the risk of
> > allowing a hacker to execute his own code, thus making such a bug really
> > dangerous, especially for web applications.
> > 
> > Your third point is a bit optimistic... Are you really prepared to react
> > immediately to all known or unknown security risks? If you have 10.000 users
> > using your application on a daily basis, or if you have 100 sites running
> > with it, every modification of a core component of your databases requires
> > good planning and careful handling. On a production server you usually don't
> > have the freedom to experiment a lot with your home-made patches.
> > 
> > Don't get me wrong, I am not at all opposed to disclosure. This is what
> > makes programs like MySQL, Linux etc. so powerful and more secure than
> > closed-source software. Remember the problems with Interbase, or Hotmail
> > (even better!) or the countless problems on Microsoft programs. It's
> > indispensable to search for bugs, but again, give the manufacturer at least
> > a chance to look into a matter before giving hackers a doorway to crash your
> > machine and worse steal or destroy your data.
> > 
> > Markus Gieppner
> > MGF International Inc.
> > 
> > -Original Message-
> > From: Chris DiBona [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, April 29, 2001 6:08 PM
> > To: Markus Gieppner
> > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: Ordinary users can crash mysql server
> > 
> > I disagree with you markus, and here is why..
> > 
> > 1gustavo probably isn't the only person who has noticed this, so it's
> > fair to say it's already made the round amongst those who arent so nice.
> > 
> > 2this _is_ the mysql list.
> > 
> > 3this way, people can plan for such a problem and button things up
> > until a fix is forthcoming.
> > 
> > 4whether he went to the manufacturer or not, I personally am happy
> > that he posted it, it made me batte ndown a hatch or two.
> > 
> >  Chris
> > 
> > --
> > Marketing Manager, OSDN Events|   http://www.osdn.com
> > Grant Chair, Linux International. |   http://www.li.org
> > Co-editor, Open Sources   |   http://www.dibona.com
> > 
> > On Sun, 29 Apr 2001, Markus Gieppner wrote:
> > 
> > > Bom dia, Gustavo,
> > >
> > > I am not in a position to comment nor to verify your warning. However, I
> > am
> > > pretty annoyed by the way you make it public to the world. Unless I missed
> > > something here, but when someone discovers a security hole in any program,
> > > it's common standard to contact the manufacturer immediately, directly and
> > > offlist and give him a chance to comment and/or release a patch within a
> > > reasonable timeframe. If then, after a couple of weeks, you didn't get any
> > > response from the manfacturer, y

RE: MySQL (3.23) connection bombardment question ..

[Terry Katz]

Thanks for the advice!

I put 2.4.3ac9 (will try 2.4.4 a bit later today) on the database (and
web) servers .. However, at the peak hours and the onslaught of users
hit the site everything goes to hell .. 

I'm tending to lean towards there being some issues in the MySQL area ..
During normal hours of 'low' (low being relative .. The site gets
moderate usage throughout the day) everything runs fine .. If I monitor
connections to the server (via processlist) I see lots of connections
come in .. A lot of SELECT's, a few UPDATE's, and then everything
disconnects .. And this behaviour happens throughout the day ...
However, during peak hours (9am and 5pm) the connections come in .. And
seem to overload the mysql server ... Up to 600+ connections will be in
the system .. Then mysql timeouts kick in and start killing connections
( a lot of the connections seem to be in the 'Sending data' state, or
'Locked' state because of the Updates .. ) .. Then it seems that when
the connections are killed, the clients aren't made aware of this and
just hang .. So, for example, I may see no connections in the database
(after it kills them), but yet hundreds of the scripts are still
running, not doing anything .. That may be a separate issue .. 

It just seems as though MySQL (under Linux/Intel anyway) can't seem to
handle thousands of incoming connections at once .. The same behaviour
seems to happen with a bunch of scripts that just do nothing but
SELECT's (written by totally different authors) .. 

Still stuck .. :-/

Thanks,
  Terry

> -Original Message-
> From: Rene Tegel [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, April 28, 2001 6:36 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL (3.23) connection bombardment question ..
> 
> 
> just realised it:
> another thing might be the linux threading problems. when 
> spawning multiple threads at once, the 2.2 kernel will delay 
> the new threads more and more. Upgrading to kernel 2.4 solves 
> this. read the lists' archives on this, there were several 
> discussions on this subject.
> 
> 
> regards,
> 
> rene
> 
> 
> On Sat, 28 Apr 2001 10:17:26 +
> Rene Tegel <[EMAIL PROTECTED]> wrote:
> 
> > i'm just wondering: what hangs first: your scripts or the mysql 
> > database?
> > 
> > if (one of your) scripts is in a endless loop, for one 
> reason or the 
> > other, the symptons will be the same...
> > 
> > I would try to figure out if there's one particulair query 
> that hangs, 
> > or if it happens randomly.
> > 
> > For cgi i wouldn't know what standard behaviour is when a 
> client drops 
> > the connection, but i guess you'll have to close the mysql 
> connection 
> > yourself. Do your scripts maybe exit on client 
> disconnection without 
> > disconnecting to the mysql server?
> > 
> > Does your log say anything about connection errors?
> > 
> > I'd prefer php scripts anyhow, for speed & persistant 
> connections (!), 
> > but it is quite tough to rewrite all scripts i'm afraid.
> > 
> > gl
> > 
> > rene
> > 
> > 
> > On Fri, 27 Apr 2001 20:45:10 -0400
> > "Terry Katz" <[EMAIL PROTECTED]> wrote:
> > 
> > > Hello ..
> > > 
> > > I've been experiencing a few problems with MySQL 3.23.3[67] 
> > > configured for TCP on Linux ..
> > > 
> > > We have two websites which are very active, and are 
> noticing similar 
> > > behaviour with the database.. One site has about a 
> hundred thousand 
> > > users, and gets very active a few times a day.. The site 
> does many 
> > > reads and updates to the database, at the same time .. Usually 
> > > during the peak times, when it seems as though everyone 
> is logging 
> > > in and using it, the database starts filling up with 
> queries waiting 
> > > for updates to complete .. It keeps going until the 
> database server 
> > > (4 processors @ 550mhz ea) gets unbearably slow, and our 
> cluster of 
> > > webservers do the same with apache's + cgi's waiting for replies 
> > > from the database ... From what I've read, this is considered 
> > > normal, because of the table locking nature of MySQL ... 
> Right?  Ok 
> > > ..
> > > 
> > > The second site does no writes to the database just 
> strictly reads 
> > > .. The database itself is also on a large server (4 
> cpu/550mhz), and 
> > > during peak times where many users bombard the site all 
> at once, the 
> > > database seems to act similar to above .. Connections flood the 
> > > system and apache's get caught waiting for a reply ..
> > > 
> > > In both cases the built-in timeouts in MySQL kill the 
> connections, 
> > > but the scripts (Apache's + cgi's) don't seem to get notified and 
> > > just hang around indefinately ... This may be a coding bug .. (?)
> > > 
> > > I guess my question is .. Are there any known problems with MySQL 
> > > receiving many instantaneous connections ? (hundreds within a few 
> > > seconds .. )
> > > 
> > > For further info, I'm running linux 2.2.19 configured for 
> up to 2000 
> > > processes (the max I've se

SV: index troubles

[Wix,Christian XCW]

But why doesn't this work then:
select name, tottid, distance, min(mintid) from loeb group by distance;
(tottid seems to be random)

mysql> explain select name, tottid, distance, min(mintid) from loeb group by
distance;
+---+--+---+--+-+--+--+---+
| table | type | possible_keys | key  | key_len | ref  | rows | Extra |
+---+--+---+--+-+--+--+---+
| loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
+---+--+---+--+-+--+--+---+
1 row in set (0.00 sec)

// Chris

> -Oprindelig meddelelse-
> Fra:  Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]]
> Sendt:30. april 2001 15:42
> Til:  Wix,Christian XCW
> Cc:   '[EMAIL PROTECTED]'
> Emne: Re: index troubles
> 
> Hello,
> 
> The index you have created is just fine and should be utilized as long as
> you perform a query that needs to use an index.
> Your query:
> select a,b from t;
> doesn't have any conditions imposed upon the table's rows. It just asks
> for all the them. Simple file scan.
> 
> regards,
> thalis
> 
> 
> On Mon, 30 Apr 2001, Wix,Christian XCW wrote:
> 
> > Hi!
> > I have some troubles with my index.
> > I want to be able to use an index (test=(mintid, name)). I will use the
> > index when I write: select mintid, name from loeb;
> > I have created an index but it doesn't seem to work. Why?
> > // Chris - Copenhagen
> > 
> > mysql> show index from loeb;
> >
> +---++--+--+-+---+
> --
> > ---+--+
> > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
> |
> > Cardinality | Sub_part |
> >
> +---++--+--+-+---+
> --
> > ---+--+
> > | loeb  |  0 | PRIMARY  |1 | id  | A
> |
> > 90 | NULL |
> > | loeb  |  1 | rekord   |1 | mintid  | A
> |
> > NULL | NULL |
> > | loeb  |  1 | test |1 | mintid  | A
> |
> > NULL | NULL |
> > | loeb  |  1 | test |2 | name| A
> |
> > NULL | NULL |
> >
> +---++--+--+-+---+
> --
> > ---+--+
> > 4 rows in set (0.00 sec)
> > 
> > mysql> show columns from loeb;
> > +--+-+--+-+--++
> > | Field| Type| Null | Key | Default  | Extra  |
> > +--+-+--+-+--++
> > | name | varchar(20) |  | |  ||
> > | distance | double(3,1) |  | | 0.0  ||
> > | dato | date| YES  | | NULL ||
> > | id   | int(11) |  | PRI | 0| auto_increment |
> > | tottid   | time|  | | 00:00:00 ||
> > | mintid   | time|  | MUL | 00:00:00 ||
> > | art  | varchar(10) | YES  | | NULL ||
> > +--+-+--+-+--++
> > 7 rows in set (0.00 sec)
> > 
> > mysql> explain select mintid, name from loeb;
> > +---+--+---+--+-+--+--+---+
> > | table | type | possible_keys | key  | key_len | ref  | rows | Extra |
> > +---+--+---+--+-+--+--+---+
> > | loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
> > +---+--+---+--+-+--+--+---+
> > 1 row in set (0.00 sec)
> > 
> > 
> > -
> > 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-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > 
> > 

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql can't start: help!

[Gerald Clark]

The RPM on the RedHat 7.0 CD does not work properly.
Get a new one from the Red Hat or MySQL site.

On Mon, 30 Apr 2001, [EMAIL PROTECTED] wrote:
> > Please check the manual both about common problems and how to post
> > problems in list. This error can depend on which MySQL version you
> > installed. Is it RPM, binary or source installation? Check the manual
> > again
> 
> I'm very sorry for take a noice to mailing list... but I try it!
> i try also with safe_mysqld and some other command but it dont work!
> For the version should be ritht :  It was istalled by RedHat (last version!)
> I need mysql for thesis and I have to develop a free software...
> so sorry if I make noice but I hope my work will be userfull for somebody of 
> you in the future.
> Mario.
> 
> 
> 
> 
> 
> 
> > > I use RedHat (last release)
> > > I try to use Mysql but It doesen' works:
> > > I post you some lines can help you to understand the error.
> > > how can create a table, use Mysql?
> > > Thank you in advance, Mario.
> > >
> > > -
> > > [root@localhost mysqld]$ mysqladmin vesion
> > > mysqladmin: connect to server at 'localhost' failed
> > > error: 'Can't connect to local MySQL server through socket '/var/lib/mys
> > > .sock' (111)'
> > > Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.
> > > ists!
> > >
> > >
> > > -
> > > [root@localhost mysql]# ./mysql.server start
> > > [root@localhost mysql]# Starting mysqld daemon with databases from
> > > /var/lib/mysql
> > > 010430 10:37:02  mysqld ended
> > > -
> > > [root@localhost log]# tail mysqld.log
> > > 010430 10:22:19  mysqld ended
> > >
> > > 010430 10:24:50  mysqld started
> > > 010430 10:24:50  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> > > 010430 10:24:50  mysqld ended
> > >
> > > 010430 10:37:02  mysqld started
> > > 010430 10:37:02  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> > > 010430 10:37:02  mysqld ended
> >
> > Please check the manual both about common problems and how to post
> > problems in list. This error can depend on which MySQL version you
> > installed. Is it RPM, binary or source installation? Check the manual
> > again
> >
> >
> > -
> > 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-mail
> > <[EMAIL PROTECTED]> Trouble
> > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> -
> 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-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

restarting mysql

[del]

Greetings,

I re-booted my server that a database resides oni started mysql 
(bin/safe_mysql  --user=del &)

However i think that the desired database is not loaded..not being a 
database guru, what is the proper way of starting mysql so that i can 
specify the proper database..?

thanks
donnie 


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Ever heard of anything like this?

[webmaster]

I can't connect to my database via mysql

This is the load of crap I'm getting...

I would appreciate any input or feedback you have.

We are on a virtual server..we set up with this
company AITcom.net to be resellers.

First of all we are getting this error message when we try to connect to the database.

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Here is their version of an answer to my problem


I wanted to get back to you as soon as possible with an answer.  Here is what I 
found.  The Pearl modules will not run in a change root file system.  The user name 
that is being called does not exist on your server.  Also, there may be a problem with 
the version of Pearl being used.
The only solution is to have a dedicated server where you have root access to the 
box.  Our shared hosting solution is designed for a virtual server using a proprietary 
Linux operating system.  With a dedicated server, you can have any version of Linux 
you would like and any version of Pearl.  This would allow you full control over the 
server and as you have stated this works on every other server you have installed.  I 
know this has been a frustrating time for you and I would like to offer a solution.  I 
will transfer all monies paid to AIT over to the cost of a dedicated server 4.  If 
this solution is acceptable, please let me know and I will have the necessary paper 
work sent to you.  I look forward to your response.

Our people are saying that the solution is this...

> > > > Tony,
> > > >
> > > > If your still getting the .sock error, ask your ISP to
> > > > recompile DBD::mysql on the server...
> > > >
> > > > There is NO configuration within our programs that
> > > > interacts with DBD::mysql in any way that can cause or
> > > > effect that error.  When DBD::mysql is compiled (installed),
> > > > it makes a note of where MySQL is and always referrs
> > > > back to that note for connecting.  If its not connecting, its
> > > > likely that DBD::mysql was either installed from RPM or
> > > > binaries or copied from another server rather then actually
> > > > compiled on that one, OR, the MySQL server has been
> > > > moved, changed, upgraded, or otherwise.

Help! Please!

Anthony Giuliani
Director of Operations
21st Century Marketing & Training Solutions, Inc.
[EMAIL PROTECTED]
voice...407-831-8722

"mysql ended"

[Mike Loiterman]

Using RedHat 7 with mysql 3.23.33.

Every time I do a ./mysql.server start i get the following error

mysql ended.

In the error log it says that it cannot find mysql.host.  What can I do to 
fix this problem?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Ever heard of anything like this?

[Cal Evans]

>>We are on a virtual server..we set up with this
>>company AITcom.net to be resellers.

This is your problem, right here.

I had an account with them for 1 month.  I was going to move one of my small
sites over and if it worked out, move all my sites over. in 1 month, they
shut my server down 6 times. They disabled my telnet, canceled my SSH AND
reloaded MySQL, erasing a production database.

Cal



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Password security

[oltra jean-michel]

On Sun, 29 Apr 2001, Philippe Louis Houze wrote:

> Date: Sun, 29 Apr 2001 10:56:52 -0400
> From: Philippe Louis Houze <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Password security
> 
> Hi,
> 
> How do you keep MySQL password out of view of "visitors" when needed in PHP to 
>access the db. The password is in plain english in all the php files, and can be 
>easily downloaded by anyone.
> 
> Philippe
> 
> ex:
> 
>   mysql_select_db("database");
> ?>


and in variables.php3 file


and protect include-directory with .htaccess
-- 
jean-michel


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Password security

[Johnny Withers]

Put it in an include file, like..

dbconnect.inc

Then add this to your httpd.conf file:


Order allow,deny
Deny from all


keeps people from downloading your .inc files.

And also, make the .inc file readable only by the web server
and no one else.

Cheers.

-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985


-Original Message-
From: oltra jean-michel [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 10:03 AM
To: Philippe Louis Houze
Cc: [EMAIL PROTECTED]
Subject: Re: Password security


On Sun, 29 Apr 2001, Philippe Louis Houze wrote:

> Date: Sun, 29 Apr 2001 10:56:52 -0400
> From: Philippe Louis Houze <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Password security
>
> Hi,
>
> How do you keep MySQL password out of view of "visitors" when needed in PHP to 
>access the db. The password is in plain english in
all the php files, and can be easily downloaded by anyone.
>
> Philippe
>
> ex:
>
>   mysql_select_db("database");
> ?>


and in variables.php3 file


and protect include-directory with .htaccess
--
jean-michel


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: myodbc uses bash'ism and should not have #!/bin/sh

[Dan Nelson]

In the last episode (Apr 30), Michael Widenius said:
> >> Description:
> ch>  The following output occures when using ASH as /bin/sh.
> ch>  Your script seems to rely on non-POSIX features from bash
> ch>  and therefore should be called with #!/bin/bash. This works.
>   
> ch>  -=(~/debian/mysql/ODBC/myodbc2.50.37-2.50.37)$ ./configure 
> ch>  creating cache ./config.cache
> ch>  checking for a BSD compatible install... /usr/bin/install -c
> ch>  checking whether build environment is sane... configure: error: ls -t appears 
>to fail.  Make sure there is not a broken
> ch>  alias in your environment
> ch>  configure: error: newly created file is older than distributed files!
> ch>  Check your system clock
> 
> The test that fails is: 
> 
> if (set X `ls -t $srcdir/configure conftestfile`; test "$2" = conftestfile)
> then
> 
> We know that this works for a lot of 'sh' on a lot of different
> systems and this is a standard configure thing I am more inclined to
> think this is a bug in ASH than in configure.

This is a standard autoconf test from sanity.m4; it's not
mysql-specific.  If it was buggy, I think a lot more than one person
would be complaining :)  FreeBSD uses ash as /bin/sh and I've never
seen this error.

Take a look at configure.log and see if there are any error messages
in there that might point you to the exact problem.

-- 
Dan Nelson
[EMAIL PROTECTED]

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SV: index troubles

[Thalis A. Kalfigopoulos]

On Mon, 30 Apr 2001, Wix,Christian XCW wrote:

> But why doesn't this work then:
> select name, tottid, distance, min(mintid) from loeb group by distance;
> (tottid seems to be random)
> 
> mysql> explain select name, tottid, distance, min(mintid) from loeb group by
> distance;
> +---+--+---+--+-+--+--+---+
> | table | type | possible_keys | key  | key_len | ref  | rows | Extra |
> +---+--+---+--+-+--+--+---+
> | loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
> +---+--+---+--+-+--+--+---+
> 1 row in set (0.00 sec)
> 

Because your index is on (mintid,name) and you are grouping by distance. The group by 
will force the table to be sorted (i think) and from each group you then select the 
min(mintid),etc. Having an index on things that are in your select clause is of no 
help. I bet (not much, but still I'd bet something) that if you added a where clause 
involving (mintid) you'd see you index utilised.
If you want to help this particular query, add an index on (distance)

regards,
thalis

:w

> // Chris
> 
> > -Oprindelig meddelelse-
> > Fra:Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]]
> > Sendt:  30. april 2001 15:42
> > Til:Wix,Christian XCW
> > Cc: '[EMAIL PROTECTED]'
> > Emne:   Re: index troubles
> > 
> > Hello,
> > 
> > The index you have created is just fine and should be utilized as long as
> > you perform a query that needs to use an index.
> > Your query:
> > select a,b from t;
> > doesn't have any conditions imposed upon the table's rows. It just asks
> > for all the them. Simple file scan.
> > 
> > regards,
> > thalis
> > 
> > 
> > On Mon, 30 Apr 2001, Wix,Christian XCW wrote:
> > 
> > > Hi!
> > > I have some troubles with my index.
> > > I want to be able to use an index (test=(mintid, name)). I will use the
> > > index when I write: select mintid, name from loeb;
> > > I have created an index but it doesn't seem to work. Why?
> > > // Chris - Copenhagen
> > > 
> > > mysql> show index from loeb;
> > >
> > +---++--+--+-+---+
> > --
> > > ---+--+
> > > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
> > |
> > > Cardinality | Sub_part |
> > >
> > +---++--+--+-+---+
> > --
> > > ---+--+
> > > | loeb  |  0 | PRIMARY  |1 | id  | A
> > |
> > > 90 | NULL |
> > > | loeb  |  1 | rekord   |1 | mintid  | A
> > |
> > > NULL | NULL |
> > > | loeb  |  1 | test |1 | mintid  | A
> > |
> > > NULL | NULL |
> > > | loeb  |  1 | test |2 | name| A
> > |
> > > NULL | NULL |
> > >
> > +---++--+--+-+---+
> > --
> > > ---+--+
> > > 4 rows in set (0.00 sec)
> > > 
> > > mysql> show columns from loeb;
> > > +--+-+--+-+--++
> > > | Field| Type| Null | Key | Default  | Extra  |
> > > +--+-+--+-+--++
> > > | name | varchar(20) |  | |  ||
> > > | distance | double(3,1) |  | | 0.0  ||
> > > | dato | date| YES  | | NULL ||
> > > | id   | int(11) |  | PRI | 0| auto_increment |
> > > | tottid   | time|  | | 00:00:00 ||
> > > | mintid   | time|  | MUL | 00:00:00 ||
> > > | art  | varchar(10) | YES  | | NULL ||
> > > +--+-+--+-+--++
> > > 7 rows in set (0.00 sec)
> > > 
> > > mysql> explain select mintid, name from loeb;
> > > +---+--+---+--+-+--+--+---+
> > > | table | type | possible_keys | key  | key_len | ref  | rows | Extra |
> > > +---+--+---+--+-+--+--+---+
> > > | loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
> > > +---+--+---+--+-+--+--+---+
> > > 1 row in set (0.00 sec)
> > > 
> > > 
> > > -
> > > 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-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > > 
> > > 
> 


-
Before posting, please check:
   http://www.mysql.com/ma

Re: mysql ended-addendum

[Mike Loiterman]

>From: [EMAIL PROTECTED]
>To: "Mike Loiterman" <[EMAIL PROTECTED]>
>Subject: Re:  mysql ended-addendum
>Date: 30 Apr 2001 15:16:07 -
>
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>database,sql,query
>
>If you just reply to this message, and include the entire text of it in the
>reply, your reply will go through. However, you should
>first review the text of the message to make sure it has something to do
>with MySQL. You have written the following:
>
>
>I ran the install script and I also ran the test script.  All tests passed
>with the test script.  The program was built from the source.
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>

_
Get your FREE download of MSN Explorer at http://explorer.msn.com


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: index troubles

[Jeff Brewer]

In your query your still asking for all rows in the table.  To utilize an
index, a restrictive query often works for example:

Assuming you have an index on distance ---
SELECT * FROM loeb WHERE distance = 2;

The random tottid results from your grouping by distance.  In effect you
have made groups that all have the same distance.  If you take one of those
groups and look at another attribute (say tottid...) that attribute is
likely to have many values (say 1, 5, 5, & 9).  The query you gave below is
asking for one of those many possible values from the group.  You could ask
for the MIN, MAX, AVG of those values and get a consistent answer (MAX = 9,
MIN = 1, AVG = 5).  Indexes have nothing to do with your query returning
different tottid's every time.  I can't tell from your query what you really
wanted or I would've tried to point out how to do it.

Good luck,
Jeff

-Original Message-
From: Wix,Christian XCW [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 10:05 AM
To: 'Thalis A. Kalfigopoulos'
Cc: '[EMAIL PROTECTED]'
Subject: SV: index troubles


But why doesn't this work then:
select name, tottid, distance, min(mintid) from loeb group by distance;
(tottid seems to be random)

mysql> explain select name, tottid, distance, min(mintid) from loeb group by
distance;
+---+--+---+--+-+--+--+---+
| table | type | possible_keys | key  | key_len | ref  | rows | Extra |
+---+--+---+--+-+--+--+---+
| loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
+---+--+---+--+-+--+--+---+
1 row in set (0.00 sec)

// Chris

> -Oprindelig meddelelse-
> Fra:  Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]]
> Sendt:30. april 2001 15:42
> Til:  Wix,Christian XCW
> Cc:   '[EMAIL PROTECTED]'
> Emne: Re: index troubles
>
> Hello,
>
> The index you have created is just fine and should be utilized as long as
> you perform a query that needs to use an index.
> Your query:
> select a,b from t;
> doesn't have any conditions imposed upon the table's rows. It just asks
> for all the them. Simple file scan.
>
> regards,
> thalis
>
>
> On Mon, 30 Apr 2001, Wix,Christian XCW wrote:
>
> > Hi!
> > I have some troubles with my index.
> > I want to be able to use an index (test=(mintid, name)). I will use the
> > index when I write: select mintid, name from loeb;
> > I have created an index but it doesn't seem to work. Why?
> > // Chris - Copenhagen
> >
> > mysql> show index from loeb;
> >
> +---++--+--+-+---+
> --
> > ---+--+
> > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
> |
> > Cardinality | Sub_part |
> >
> +---++--+--+-+---+
> --
> > ---+--+
> > | loeb  |  0 | PRIMARY  |1 | id  | A
> |
> > 90 | NULL |
> > | loeb  |  1 | rekord   |1 | mintid  | A
> |
> > NULL | NULL |
> > | loeb  |  1 | test |1 | mintid  | A
> |
> > NULL | NULL |
> > | loeb  |  1 | test |2 | name| A
> |
> > NULL | NULL |
> >
> +---++--+--+-+---+
> --
> > ---+--+
> > 4 rows in set (0.00 sec)
> >
> > mysql> show columns from loeb;
> > +--+-+--+-+--++
> > | Field| Type| Null | Key | Default  | Extra  |
> > +--+-+--+-+--++
> > | name | varchar(20) |  | |  ||
> > | distance | double(3,1) |  | | 0.0  ||
> > | dato | date| YES  | | NULL ||
> > | id   | int(11) |  | PRI | 0| auto_increment |
> > | tottid   | time|  | | 00:00:00 ||
> > | mintid   | time|  | MUL | 00:00:00 ||
> > | art  | varchar(10) | YES  | | NULL ||
> > +--+-+--+-+--++
> > 7 rows in set (0.00 sec)
> >
> > mysql> explain select mintid, name from loeb;
> > +---+--+---+--+-+--+--+---+
> > | table | type | possible_keys | key  | key_len | ref  | rows | Extra |
> > +---+--+---+--+-+--+--+---+
> > | loeb  | ALL  | NULL  | NULL |NULL | NULL |   90 |   |
> > +---+--+---+--+-+--+--+---+
> > 1 row in set (0.00 sec)
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To reques

USE INDEX()/IGNORE INDEX() not getting through

[Thalis A. Kalfigopoulos]

I'm having the following problem with the IGNORE INDEX()/USE INDEX() directives on a 
mysql 3.23.32

mysql> explain SELECT age_0,reliable,COUNT(*) FROM age,reliable WHERE age.id=rel
iable.id GROUP BY age_0,reliable;
+--++---++-++-+-
-+
| table| type   | possible_keys | key| key_len | ref| rows| Extr
a|
+--++---++-++-+-
-+
| age  | index  | dd_idx,id | dd_idx |   4 | NULL   | 100 | Usin
g index; Using temporary |
| reliable | eq_ref | dd_idx,id | id |   3 | age.id |   1 |
 |
+--++---++-++-+-
-+ 

Normally my query uses index(dd_idx) on table age_0 and index(id) on table reliable. 
Now I want to force the use of index(id) on table age_0 as well:

mysql> explain SELECT age_0,reliable,COUNT(*) FROM age USE INDEX(id),reliable WH
ERE age.id=reliable.id GROUP BY age_0,reliable;
+--++---++-++-+-
-+
| table| type   | possible_keys | key| key_len | ref| rows| Extr
a|
+--++---++-++-+-
-+
| age  | index  | dd_idx,id | dd_idx |   4 | NULL   | 100 | Usin
g index; Using temporary |
| reliable | eq_ref | dd_idx,id | id |   3 | age.id |   1 |
 |
+--++---++-++-+-
-+

Why does it insist on using index dd_idx for table age_0?
I even tried telling to explicitly ignore this index:

mysql> explain SELECT age_0,reliable,COUNT(*) FROM age IGNORE INDEX(dd_idx),reli
able WHERE age.id=reliable.id GROUP BY age_0,reliable;
+--++---++-++-+-
-+
| table| type   | possible_keys | key| key_len | ref| rows| Extr
a|
+--++---++-++-+-
-+
| age  | index  | dd_idx,id | dd_idx |   4 | NULL   | 100 | Usin
g index; Using temporary |
| reliable | eq_ref | dd_idx,id | id |   3 | age.id |   1 |
 |
+--++---++-++-+-
-+

It still uses index(dd_idx) for table age_0 :-(
Any ideas?

regards,
thalis




-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: New filter

[Sasha Pachev]

On Saturday 28 April 2001 19:28, Jeremy Zawodny wrote:
> On Sat, Apr 07, 2001 at 10:42:09AM -0600, Sasha Pachev wrote:
> 
> > I have now installed the new spam filter on this list. It is very
> > simple - instead of having bad words, we now have good words. You
> > must mention one of the following: sql, database, query in the body
> > of your message to get past the filter. Substrings are ok, and check
> > is case-insensitive so if you say MySQL, it will work.
> 
> Having had a few of my posts bounced, I have two questions:
> 
>   (1) Does it count properly separated signatures "-- \n" as part of
>   the body?
> 
>   (2) Can it be taught to grok a header? Maybe "X-MySQL-On-Topic: yes"
>   or something?
> 
> I've already solved my problem if the answer to #1 is yes, but #2
> seems like a nice clean and unobtrusive approach.

#1 should work, with one exception - if a line contains the list address, it 
is excluded from consideration completely - dirty fix for the problem of 
something like: To unsubscribe your address, click on 
http://www.spamsite.com/unsubscribe.exe?[EMAIL PROTECTED] . #2 is 
a good idea, I will let you know when I have it fixed.

-- 
MySQL Development Team
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Newbie win 2000 install question (reprise)

[Rhasaun Campbell]

Ok I tried both of your suggestions but no dice. I actuall failed to mention
that once I got into the bin i tired to start the service by typing
mysld--standalone, but it returned an error stating:

mysqld--standalone is not recognized as an internal or external command,
operable program or batch file...

so I physically went to the bin and looked at files where there, I saw
mysql.exe to I tired to start mysql server that way but i got another error
stating "Can't connect to MySQL server on'localhost' <10061>

Basically I know my problem lies in starting the service, because i tried
pinging localhost 3306 and it timed out, So do you have any other
suggestions?

ohh btw I just picked up a book PHP fast and easy web development by Julie C
Melonie, and with it came a CD-Rom with mysql-shareware-3_22_34-win.exe, I
checked the site and saw that they had newer versions of MySQL out, so maybe
that is my problem thanks for your help already anymore will be greatly
appreciated

-Original Message-
From: Michael Tefft [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 29, 2001 10:25 PM
To: Rhasaun Campbell
Subject: RE: Newbie win 2000 install question


Well, just typing cd c:\mysql\bin does not do anything. You are just going
to the mysql bin directory. To start mysql try doing mysqld &. Better yet,
run winmysqladmin and start it from there.

-Original Message-
From: Rhasaun Campbell [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 29, 2001 9:48 PM
To: mysql list
Subject: Newbie win 2000 install question


Ok so here's the deal, I'm trying to check if mysql is working on my machine
so I open up the dos command prompt, type cd c:\mysql\bin and everything's
fine

then it try to create a test database by  typing mysqladmin create testDB,
it try's to connect but it gives me an error message

 "Can't connect to mySQL server on 'localhost' <10061>'
then it says check that mysqld is running on localhost and that the port is
3306

I tried to telnet to 3306 and of course iut's not running, so here's my
question How do I get the mySQL server to start running on my machine.
ohh btw I'm on a w2k workstation. I know it's something that's probably
simple, which I'm overlooking, but I could use some help figuring it out.
The install went fine, I just need some help with starting mysql...please

tia

Rhasaun Campbell
Web Consultant
Urban Graphics
110 Camden St.
Roselle Pk, NJ 07204
c. 908.531.9418
t.908.245.1161
[EMAIL PROTECTED]
www.urbangraphics.tv




-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: upgrade rpm and database

[Shankar Unni]

The RPMs on the MySQL site don't seem to match RedHat's RPM layout at all -
the RedHat RPM can't be "upgraded" to the MySQL RPM (even the package names
are different - "mysql" in RedHat vs "MySQL" in the MySQL package).

The only thing you can do is:

* rpm -e `rpm -q -a | grep mysql`
* rpm --install -v 

(i.e. a clean install), followed by whatever other system-specific changes
you've already made (e.g. what runlevels it starts at, etc.)

The DB should be OK through the above process - rpm -e won't delete your
DBs.

If the MySQL RPM ends up creating the DB root somewhere else, you may need
to put in a symbolic link from that directory to wherever your current DB
location is..

-Original Message-
From: Marc S. Bragg [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 6:50 AM
To: [EMAIL PROTECTED]
Subject: upgrade rpm and database


Am running mysql 3.23.22 with problem with linuxconf. Want to upgrade to

3.23.36 or 37, but get following error messages:

for 3.23.36 says:

mysql = 3.23.22 is needed by mysql-server-3.23.22-6
libmysqlclient.so.9 is needed by mysql-server-3.23.22-6
libmysqclient.so.9 is needed by php-mysql-4.0.1pl2-9

curiously, in /usr/lib/mysql there is:

libmysqlclient.so.9
libmysqlclient.so.9.0.0

so, I tried updating original install for libmysqlclient.so.9 but it
says it's already installed. What do I do ? I though libmysqlclient.so.9

is already installed, as I can see it, as a result of the original
mysql-3.23.22-6 installation.  On rpmfind.net all the
libmysqlclient.so.9 are included in the -6 rpm I alread have. Thanx,
very confused.

Runniing

rpm -Uvh mysql-3.23.22-6.i386 give me:

package mysql-3.23.22-6 is already installed.

also, cannot upgrade from glibc-2.1.92-14 to 2.2.2-10
get:

glibc < 2.2.2 conflicts with glibc-common-2.2.2-10
same issue perhaps?

thanx






--
Marc S. Bragg
[EMAIL PROTECTED]
Bialecki & Bragg, PC
p: 610-444-7508
f: 610-444-7548

http://www.chescolawyers.com/BB
"Chester County Legal Services" - "For All Your Legal Needs"


http://www.bloody100th.com "WWII 101st Airborne Division"
http://www.petercatalano.com "Soul of An Italian Artist"

asian charatersets in mysql?

[Luis Hoeks]

I would be very pleased, if someone could tell me if MYSQL supports asian 
character sets like big5 or thai charctersets.
If yes, what do I need to install to get it running. Where can I find any 
help?
Any advice is very much appreciated!
Kind regards from
Luis
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: asian charatersets in mysql?

[Steve Ruby]

http://www.mysql.com/doc/c/o/configure_options.html

http://www.mysql.com/doc/A/d/Adding_character_set.html

Luis Hoeks wrote:
> 
> I would be very pleased, if someone could tell me if MYSQL supports asian
> character sets like big5 or thai charctersets.
> If yes, what do I need to install to get it running. Where can I find any
> help?
> Any advice is very much appreciated!
> Kind regards from
> Luis
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> -
> 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-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Ordinary users can crash mysql server

[Gustavo Vieira Gonçalves Coelho Rios]

I have been experiencing some environment modifications around about
this bug. I am sure that's not related to mysqlbinlog only. It happens
because of compilation with support for libwrap. Any other program da do
tcp/ip mysql will crash it!


Rene Tegel gravada:
> 
> you just did the right thing: you posted an anomaly to the list. that's not bad, 
>that's good. Thanx for notifying us!
> 
> don't worry about possible abuse, as far as i can see you need a normal mysql 
>account anyhow in the first place, and if any system administrator would notice such 
>a user killing the deamon on purpose, he/she'd probably first kick him out off the 
>system for ever, and then tell him/her he/she could be sewed (or in fact: sew him/her 
>if there is any damage).
> 
> So, if a system administrator has such users, it's his/hers own mistake. Security is 
>not made by a system or by mysql, security is made or broken by humans.
> 
> regards,
> 
> rene
> 
> On Mon, 30 Apr 2001 07:28:44 -0300
> Gustavo Vieira Gonçalves Coelho Rios  <[EMAIL PROTECTED]> wrote:
> 
> > Hi folks!
> >
> > Since we(not we, just my account) at Ifour had some problem with email,
> > i did'not get all resps to my bug report.
> >
> > But, by reading some messages, i can see it'was not a good thing to have
> > posted the message on the list. Please, forgive for whatever i have
> > done. I have just done so, cause that's what is stated in the Manual,
> > and since i am a MySQL beginner... i do read the manuals.
> >
> > Again, i am sorry for any problem i may have caused.
> > BTW, what was my mistaken?
> >
> >
> >
> >
> > Markus Gieppner gravada:
> > >
> > > Hi Chris,
> > >
> > > You should not forget those users who depend greatly on the tech support
> > > (patches) of the manufacturer. Given your expertise and knowledge you might
> > > be able to protect yourself, but not everybody is (as a matter of fact even
> > > Gustavo said he isn't). In addition, to make things worse, today is Sunday,
> > > and given the usual working hours in most countries, there's a very small
> > > chance that someone from AB Konsulting has read this. On the other hand,
> > > quite a number of hobby vandals, who spend their free days looking for
> > > holes, might have found a nice new toy to play with, and Gustavo even
> > > provided the "how-to" .
> > >
> > > I agree with you on the first point: If this is a known bug, it has to be
> > > part of the "known-bug-list" and given it's severity, be stated clearly on
> > > the MySQL web site. Crashed server applications often bear the risk of
> > > allowing a hacker to execute his own code, thus making such a bug really
> > > dangerous, especially for web applications.
> > >
> > > Your third point is a bit optimistic... Are you really prepared to react
> > > immediately to all known or unknown security risks? If you have 10.000 users
> > > using your application on a daily basis, or if you have 100 sites running
> > > with it, every modification of a core component of your databases requires
> > > good planning and careful handling. On a production server you usually don't
> > > have the freedom to experiment a lot with your home-made patches.
> > >
> > > Don't get me wrong, I am not at all opposed to disclosure. This is what
> > > makes programs like MySQL, Linux etc. so powerful and more secure than
> > > closed-source software. Remember the problems with Interbase, or Hotmail
> > > (even better!) or the countless problems on Microsoft programs. It's
> > > indispensable to search for bugs, but again, give the manufacturer at least
> > > a chance to look into a matter before giving hackers a doorway to crash your
> > > machine and worse steal or destroy your data.
> > >
> > > Markus Gieppner
> > > MGF International Inc.
> > >
> > > -Original Message-
> > > From: Chris DiBona [mailto:[EMAIL PROTECTED]]
> > > Sent: Sunday, April 29, 2001 6:08 PM
> > > To: Markus Gieppner
> > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > > Subject: RE: Ordinary users can crash mysql server
> > >
> > > I disagree with you markus, and here is why..
> > >
> > > 1gustavo probably isn't the only person who has noticed this, so it's
> > > fair to say it's already made the round amongst those who arent so nice.
> > >
> > > 2this _is_ the mysql list.
> > >
> > > 3this way, people can plan for such a problem and button things up
> > > until a fix is forthcoming.
> > >
> > > 4whether he went to the manufacturer or not, I personally am happy
> > > that he posted it, it made me batte ndown a hatch or two.
> > >
> > >  Chris
> > >
> > > --
> > > Marketing Manager, OSDN Events|   http://www.osdn.com
> > > Grant Chair, Linux International. |   http://www.li.org
> > > Co-editor, Open Sources   |   http://www.dibona.com
> > >
> > > On Sun, 29 Apr 2001, Markus Gieppner wrote:
> > >
> > > > Bom dia, Gustavo,
> > > >
> > > > I am not in a position to comment nor to verify your warning. However, I
> 

To install MySQL, where can free download Lunix?

[johnd]

Hi, 

I would like to install MySQL. I want to setup Lunix on IBM compatible computer. Do 
you know where I can get free download Lunix recent version?

Thank you very much.

John Ding

Re: how to do a query using a file?

[Shawn Cummings]

>From the command line you can load syntax from a file

mysql -u [username] -p [database] < filename.txt


On Mon, 30 Apr 2001 [EMAIL PROTECTED] wrote:

> > query: load data local infile "file.txt" into table
> > my_table
> 
> Thank you.
> But for creating an entire and complex database?
> I mean If you have to create 40 table?!?
> there is a way to do it by ascii file?
> I write the SQL commands once and then I can recreate the db whth tables in 
> different computers.
> Thank you in advance, Mario.
> 
> -
> 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-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

-- 


Shawn Cummings
bostonwebspace.com
$9 webhosting/mySQL/Perl/PHP


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: red hat 7.1 rpm --rebuild error

[Florin Andrei]

I try to "rpm --rebuild" the src.rpm for 3.23.37 on a Linux Red Hat 7.1
system, but i get this error:

checking for gcc... egcs
checking whether the C compiler (egcs  -O3  ) works... no
configure: error: installation or configuration problem: C compiler
cannot create executables.
error: Bad exit status from /var/tmp/rpm-tmp.21106 (%build)


RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.21106 (%build)
[root@two /root]#

However, the compiler is installed, and it works (i have some other
programs build on that system).


database,sql,query :-P


-- 
Florin Andrei

"Bloat is not about being big. Bloat is about being slow and stupid and
not
realizing that it's because of design mistakes." - Linus Torvalds





-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

LAST_INSERT_ID returning 3 rows?

[Graeme B. Davis]

mysql> INSERT INTO outages (status) VALUES ('Open');
mysql> SELECT LAST_INSERT_ID() AS lid FROM outages;
+-+
| lid |
+-+
| 101 |
| 101 |
| 101 |
+-+
3 rows in set (0.00 sec)

Why would MYSQL do this?  Any ideas?

Thanks,

Graeme

p.s. DESCRIBE outages;

+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| id| int(10) unsigned |  | PRI | NULL| auto_increment |
| router| varchar(25)  | YES  | | NULL||
| techticket| varchar(15)  | YES  | | NULL||
| rfoticket | varchar(15)  | YES  | | NULL||
| nocticket | varchar(15)  | YES  | | NULL||
| sitesaffected | int(6)   | YES  | | NULL||
| telconame | varchar(100) | YES  | | NULL||
| telcoticket   | varchar(100) | YES  | | NULL||
| start | datetime | YES  | | NULL||
| stop  | datetime | YES  | | NULL||
| updated   | timestamp(14)| YES  | | NULL||
| slasent   | datetime | YES  | | NULL||
| sla   | varchar(10)  | YES  | | NULL||
| vmstart   | datetime | YES  | | NULL||
| vmstop| datetime | YES  | | NULL||
| rfo   | varchar(200) | YES  | | NULL||
| status| varchar(15)  |  | | Open||
| interface | varchar(255) | YES  | | NULL||
| comments  | text | YES  | | NULL||
+---+--+--+-+-++


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Syntax error

[Ryan]

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);

}

when i run  that bean from JSP for mysql dataaccess, it gives Syntax error.

please help me out. thanks in advance.

PS. there not connection problem. i got hooked up with mysql server. i just leave 
blank in my sample code.



-
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices

RE: LAST_INSERT_ID returning 3 rows?

[Braxton Robbason]

last_insert_id is a function. It will return a value for each row in the
table.  You want to run:
select last_insert_id() as lid;

instead of selecting from a table.

-Original Message-
From: Graeme B. Davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 3:17 PM
To: [EMAIL PROTECTED]
Subject: LAST_INSERT_ID returning 3 rows?


mysql> INSERT INTO outages (status) VALUES ('Open');
mysql> SELECT LAST_INSERT_ID() AS lid FROM outages;
+-+
| lid |
+-+
| 101 |
| 101 |
| 101 |
+-+
3 rows in set (0.00 sec)

Why would MYSQL do this?  Any ideas?

Thanks,

Graeme

p.s. DESCRIBE outages;

+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| id| int(10) unsigned |  | PRI | NULL| auto_increment |
| router| varchar(25)  | YES  | | NULL||
| techticket| varchar(15)  | YES  | | NULL||
| rfoticket | varchar(15)  | YES  | | NULL||
| nocticket | varchar(15)  | YES  | | NULL||
| sitesaffected | int(6)   | YES  | | NULL||
| telconame | varchar(100) | YES  | | NULL||
| telcoticket   | varchar(100) | YES  | | NULL||
| start | datetime | YES  | | NULL||
| stop  | datetime | YES  | | NULL||
| updated   | timestamp(14)| YES  | | NULL||
| slasent   | datetime | YES  | | NULL||
| sla   | varchar(10)  | YES  | | NULL||
| vmstart   | datetime | YES  | | NULL||
| vmstop| datetime | YES  | | NULL||
| rfo   | varchar(200) | YES  | | NULL||
| status| varchar(15)  |  | | Open||
| interface | varchar(255) | YES  | | NULL||
| comments  | text | YES  | | NULL||
+---+--+--+-+-++


-
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-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: LAST_INSERT_ID returning 3 rows?

[Gerald Clark]

Because you included a from clause, you got one line for each row
of 'outages'

Leave out the "from outages"

Graeme B. Davis wrote:

> mysql> INSERT INTO outages (status) VALUES ('Open');
> mysql> SELECT LAST_INSERT_ID() AS lid FROM outages;
> +-+
> | lid |
> +-+
> | 101 |
> | 101 |
> | 101 |
> +-+
> 3 rows in set (0.00 sec)
> 
> Why would MYSQL do this?  Any ideas?
> 
> Thanks,
> 
> Graeme
> 
> p.s. DESCRIBE outages;
> 
> +---+--+--+-+-++
> | Field | Type | Null | Key | Default | Extra  |
> +---+--+--+-+-++
> | id| int(10) unsigned |  | PRI | NULL| auto_increment |
> | router| varchar(25)  | YES  | | NULL||
> | techticket| varchar(15)  | YES  | | NULL||
> | rfoticket | varchar(15)  | YES  | | NULL||
> | nocticket | varchar(15)  | YES  | | NULL||
> | sitesaffected | int(6)   | YES  | | NULL||
> | telconame | varchar(100) | YES  | | NULL||
> | telcoticket   | varchar(100) | YES  | | NULL||
> | start | datetime | YES  | | NULL||
> | stop  | datetime | YES  | | NULL||
> | updated   | timestamp(14)| YES  | | NULL||
> | slasent   | datetime | YES  | | NULL||
> | sla   | varchar(10)  | YES  | | NULL||
> | vmstart   | datetime | YES  | | NULL||
> | vmstop| datetime | YES  | | NULL||
> | rfo   | varchar(200) | YES  | | NULL||
> | status| varchar(15)  |  | | Open||
> | interface | varchar(255) | YES  | | NULL||
> | comments  | text | YES  | | NULL||
> +---+--+--+-+-++
> 
> 
> -
> 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-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Syntax error

[Eric Fitzgerald]

I don't see any ticks surrounding userid...unless of coarse userid is a
number??

Also, myResultSet, is that public?  If not, are you returning it?  (I'm not
familiar with Java, so not sure if you need to or not)
- Original Message -
From: "Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 12:17 PM
Subject: Syntax error


>
> 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);
>
> }
>
> when i run  that bean from JSP for mysql dataaccess, it gives Syntax
error.
>
> please help me out. thanks in advance.
>
> PS. there not connection problem. i got hooked up with mysql server. i
just leave blank in my sample code.
>
>
>
> -
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Database size

[Dhiin Data - Erik Dhiin]

Hi,

I have a problem, my database has reached Linux Redhat 7.1 max file
size. (2147483647 Bytes).
Does eny one know what i can do to make a lager database.  (lager
filesystem)

Thanks
Erik Dhiin



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[jcz@mylinepcx.com: Bug#95872: replication failure]

[Christian Hammers]

Hello

This came through the Debian BugTrackingSystem but I have no clue about
it.

bye,

 -christian-



Package: mysql-server
Version: 3.23.33-3
Severity: normal

from /var/log/mysql.err:

010430 16:06:52  Slave: Failed reading log event, reconnecting to retry, log 'FIRST' 
position 4
010430 16:06:52  Slave: reconnected to master 'repl@espsv0002:3306',replication 
resumed in log 'FIRST' at position 4
010430 16:06:52  Error reading packet from server: Binlog has bad magic number, fire 
your magician (read_errno 0,server_errno=65535)


-- System Information
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux Linux1 2.2.15 #1 Thu Jun 1 10:47:16 EST 2000 i586

Versions of packages mysql-server depends on:
ii  adduser   3.33   Add and remove users and groups to
ii  debconf   0.9.28 Debian configuration management sy
ii  libc6 2.2.2-4GNU C Library: Shared libraries an
ii  libdbi-perl   1.14-4 The Perl5 Database Interface by Ti
ii  libmysqlclient10  3.23.33-3  mysql database client library 
ii  libstdc++2.10-glibc2.21:2.95.3-6 The GNU stdc++ library
ii  libwrap0  7.6-7  Wietse Venema's TCP wrappers libra
ii  mysql-client  3.23.33-3  mysql database client binaries
ii  perl  5.6.0-20   Larry Wall's Practical Extracting 
ii  zlib1g1:1.1.3-12 compression library - runtime 





-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problems with mysqlshow under linux

[Siomara Pantarotto]

Hi all,

When I try to execute mysqlshow under linux I get this message:

$ mysqlshow
mysqlshow: Can't connect to local MySQL server through socket 
'/tmp/mysqld.sock'
(111)
$

However when I do the same under NT it works fine

E:\Program Files\mysql\bin>mysqlshow
+---+
| Databases |
+---+
| BUGUNISON |
| mysql |
| test  |
+---+

Can someone help me with this issue???

Thanks so much

Siomara
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Tons of "opening tables"

[Jonathan Roy]

  Now and then when our site is very busy, mysql seems to get into a
state where tons and tons threads 'stick' in the Opening Tables status...

www# mysqladmin proc | grep -c "Opening tables"
188

  Any ideas why that is? Anything I can do to try and figure it out? I'm
stumped how to procede here. :) As for what else is doing on, beside
sleeping threads we have:

www# mysqladmin proc | grep -v Opening | grep -v Sleep | grep localhost
| 136 | root | localhost | forum | Query   | 15   | Writing to net |
SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY
parentid,displayorder|
| 269 | root | localhost | forum | Query   | 19   | Writing to net |
SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY
parentid,displayorder|
| 314 | root | localhost | forum | Query   | 19   | Writing to net |
SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY
parentid,displayorder|
| 395 | root | localhost | forum | Query   | 38   | Writing to net |
SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY
parentid,displayorder|
| 610 | root | localhost | forum | Query   | 4| closing tables |
SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE
sessionhash='707795b6e5e7a7b534c |
| 679 | root | localhost |   | Query   | 0|| show
processlist
  |

  Just a few selects writing to net... the queries are for many different
tables. Forum itself is a MyISAM table. Other tables are using InnoDB. I
thought maybe it was related to the innodb_file_io_threads=4 but that
shouldn't affect non-InnoDB tables, right?

  This is on FreeBSD 3.4 with mysql 3.23.37. It is compiled with the
optimization flags recommended in the manual for gcc 2.95 on an Intel
machine.

-Jonathan

---
Jonathan Roy - [EMAIL PROTECTED]



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MATCH AGAINST 2-3 tables

[Paul Van Slyke]

Hi Everyone!

I've got two seperate tables that I would like to query using a MATCH ..
AGAINST() syntax.   If I run the query individually on one table, the
speed of the returned results is great!  Very fast, indeed.  However,
when I try and use the following statement for querying both tables at
the same time, it is painfully slow.  Too slow to use in a production
environment.

Any help speeding this up would be greatly appreciated.
Thanks in advance!

Paul


The super slow query is

SELECT DISTINCT * from tA, tB WHERE MATCH tA.aName AGAINST ('name') ||
MATCH tB.bName AGAINST ('name');

The fast queries are

SELECT DISTINCT * from tAWHERE MATCH tA.aName AGAINST ('name');

SELECT DISTINCT * from tBWHERE MATCH tB.bName AGAINST ('name');


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie win 2000 install question (reprise)

[Miguel Angel Solórzano]

At 12:49 30/4/2001 -0400, Rhasaun Campbell wrote:
Hi!
To install and start up MySQL is easy and fast on Win2000,
below you see the commands I had, before the setup:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.

C:\>cd\mysql\bin

C:\mysql\bin>mysqld-nt --install

C:\mysql\bin>net start mysql

O serviço de MySql foi iniciado com êxito.


C:\mysql\bin>mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.36

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql>

You see the message of the service start in Portuguese, because
my Win2k Server version is Portuguese.

After this, every machine boot the service is started automatic.
Notice also that you need to login with administrator rights
to set a service on NT/Win2k machines.

Take a look in the Manual at \mysql\docs

The setup and start I did ~ 2 min.

Regards,
Miguel

>Ok I tried both of your suggestions but no dice. I actuall failed to mention
>that once I got into the bin i tired to start the service by typing
>mysld--standalone, but it returned an error stating:
>
>mysqld--standalone is not recognized as an internal or external command,
>operable program or batch file...
>
>so I physically went to the bin and looked at files where there, I saw
>mysql.exe to I tired to start mysql server that way but i got another error
>stating "Can't connect to MySQL server on'localhost' <10061>
>
>Basically I know my problem lies in starting the service, because i tried
>pinging localhost 3306 and it timed out, So do you have any other
>suggestions?
>
>ohh btw I just picked up a book PHP fast and easy web development by Julie C
>Melonie, and with it came a CD-Rom with mysql-shareware-3_22_34-win.exe, I
>checked the site and saw that they had newer versions of MySQL out, so maybe
>that is my problem thanks for your help already anymore will be greatly
>appreciated
>
>-Original Message-
>From: Michael Tefft [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, April 29, 2001 10:25 PM
>To: Rhasaun Campbell
>Subject: RE: Newbie win 2000 install question
>
>
>Well, just typing cd c:\mysql\bin does not do anything. You are just going
>to the mysql bin directory. To start mysql try doing mysqld &. Better yet,
>run winmysqladmin and start it from there.
>
>-Original Message-
>From: Rhasaun Campbell [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, April 29, 2001 9:48 PM
>To: mysql list
>Subject: Newbie win 2000 install question
>
>
>Ok so here's the deal, I'm trying to check if mysql is working on my machine
>so I open up the dos command prompt, type cd c:\mysql\bin and everything's
>fine
>
>then it try to create a test database by  typing mysqladmin create testDB,
>it try's to connect but it gives me an error message
>
>  "Can't connect to mySQL server on 'localhost' <10061>'
>then it says check that mysqld is running on localhost and that the port is
>3306
>
>I tried to telnet to 3306 and of course iut's not running, so here's my
>question How do I get the mySQL server to start running on my machine.
>ohh btw I'm on a w2k workstation. I know it's something that's probably
>simple, which I'm overlooking, but I could use some help figuring it out.
>The install went fine, I just need some help with starting mysql...please
>
>tia
>
>Rhasaun Campbell
>Web Consultant
>Urban Graphics
>110 Camden St.
>Roselle Pk, NJ 07204
>c. 908.531.9418
>t.908.245.1161
>[EMAIL PROTECTED]
>www.urbangraphics.tv
>
>
>
>
>-
>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-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solórzano <[EMAIL PROTECTED]>
/_/  /_/\_, /___/\___\_\___/  São Paulo, Brazil
<___/  Development Team


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem with LAST_INSERT_ID();

[Joshua J. Kugler]

I have run into this problem in Access using MyODBC. Access will try to 
evaluate the function last_insert_id() before it passes the query to the 
database.  It will do this EVEN if I say it is a 'dbSQLPassThrough' query.  
Very aggravating.

j- k-

On Sunday 29 April 2001 06:23, [EMAIL PROTECTED] wrote:
> The context is Active Server Pages application over IIS in NT server.
> This code is in a file named DatiPrev.asp :
>
> Open the connection using ODBC (I use MyODBC):
> > set objConn = Server.CreateObject("adodb.connection")
> > objConn.Open Application("Connection1_ConnectionString")
>
> and this is the instruction :
> > mSql = "Insert into ordinit (ID_Ordine, Cod_Cliente, Data_Ordine,
>
> Ora_Ordine, Evaso, Tipo, PercSconto, ImpSconto, TotImp, TotIVA,
> ImpTotale, Status) values(NULL, " & mCodCliente & "," & sDate & ",
> '" & sTime & "', 'N', '" & mTipo & "', 0, 0, " & mTotImp & ", " &
> mTotIVA & ", " & mTotImp + mTotIVA & ", 'de');"
>
> > set objRS = objConn.Execute (mSql)
> >
> > mSql = "select last_insert_id();"
> > set objRS = objConn.Execute (mSql)
> > response.write(objRS.Fields(0))
>
> This is the error:
> >Microsoft OLE DB Provider for ODBC Drivers error '80020009'
> >[Microsoft][ODBC Driver Manager] Il driver non supporta questo parametro.
>
>   The driver not support this parameter.
> I think that the problem is MyODBC.
> But I have tried also with MySQLGUI client and the return value is zero.:-(
>
> Regards.
> Nino.
>
> > Weird. I've used them often (on ISAM tables) and it works just fine.
> >
> > Do you use the same connection for the 'LAST_INSERT_ID' query as for
> > the INSERT query? The LAST_INSERT_ID is kept per connection and until
> > another INSERT is done.
>
> -
> 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-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Joshua Kugler
Associated Students of the University of Alaska Fairbanks
Information Services Director
[EMAIL PROTECTED]
907-474-7601

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

perl DBD make test errors??? Please Help

[Chris Becker]

RedHat 6.2 on Intel, ...36 MySQL, and perl5, DBI installed correctly.

I ran perl Makefile.PL, seemed to run ok, no errors seen.
Ran make, same thing.
Then the following from make tets:

/perlmods/DBD10>make test
make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql'
make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql'
make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql'
PERL_DL_NONLAZY=1
/usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00
503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests
$verbos
e); $verbose=0; runtests @ARGV;' t/*.t
t/00baseinstall_driver(mysql) failed: Can't load
'../blib/arch/auto/DB
D/mysql/mysql.so' for module DBD::mysql:
../blib/arch/auto/DBD/mysql/mysql.so: und
efined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm
line
169.

 at (eval 1) line 3

 at t/00base.t line 38
dubious
Test returned status 255 (wstat 65280, 0xff00)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/Te
st/Harness.pm line 288.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql'
make: *** [test] Error 2


Please Help - am I installing DBD in the wrong directory?  MySQL is
installed in /usr/local/mysql - should I be running this make file there???

Thank in advance,

Chris Becker
MCSE MCDBA
===
Idysys
http://www.idysys.com
[EMAIL PROTECTED]
===


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ORDER BY DESC optimization

[ryc]

I have a fairly large table (greater than 4mil rows) that I would to preform
a query like:

SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;

I have an index on the table INDEX1( a,b,c );

When running the query as is, it takes around 4seconds. If I omit the "DESC"
part the query runs in a fraction of a second.

I would like the query to run faster when I use DESC. I looked at
myisamchk -R to sort by the 'b' index but I want to be sure it will speed up
my query since it may take a while to sort all 4million rows.

Does anyone have guidance on how to accomplish this? is myisamchk -R what I
want?

Thanks.

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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Database size

[Jeff Brewer]

I run Linux 6.2 and don't have problems with file size.  Check the version
of MySQL you run.  The maximum table size was recently expanded in 3.23.x I
think.  Also, look at the MAX_ROWS parameter for the table.  Finally, if
nothing else works perhaps you can define the table as a UNION, check the
manual (a recent copy.)

-Jeff

-Original Message-
From: Dhiin Data - Erik Dhiin [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 4:13 PM
To: [EMAIL PROTECTED]
Subject: Database size


Hi,

I have a problem, my database has reached Linux Redhat 7.1 max file
size. (2147483647 Bytes).
Does eny one know what i can do to make a lager database.  (lager
filesystem)

Thanks
Erik Dhiin



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MATCH AGAINST 2-3 tables

[Paul Van Slyke]

Thanks for the response!

The two tables contain different types of information which are related
by a foreign key (orginally designed that way).However, there is no
reason that there can't be a single table that contains both (actually 3
seperate tables) sets of data.  Unfortunately, building the
FULLTEXT index on the third table is incredibly slow on tables sizes
500Megs or more.

So, it sounds like we don't have much of a choice.  Your suggestion to
have one table for the FULLTEXT searches seems the best way to go.

What we decided to do is to compile mysql-4.0, build a combined table of
the three (which will be over a GIG) and index it under 4.0.  Then move
the tables over to 3.23 for production use.

Thanks!  Off to compile 4.0!

Paul


>I've got two seperate tables that I would like to query using a MATCH
..
>AGAINST() syntax.

Why are they two separate tables?

>If I run the query individually on one table, the
>speed of the returned results is great!  Very fast, indeed.  However,
>when I try and use the following statement for querying both tables at
>the same time, it is painfully slow.  Too slow to use in a production
>environment.

>SELECT DISTINCT * from tA, tB WHERE MATCH tA.aName AGAINST ('name') ||
>MATCH tB.bName AGAINST ('name');

You are doing a join between two tables.  This means that if table A
has 100 matches and table B has 400 matches, you get 40,000 results
(before applying DISTINCT).  *SLOW* !!!

I don't know the structure of your tables, but if they are identical,
why aren't these in one table (with an extra column for which table
they belong in) ?

>The fast queries are
>SELECT DISTINCT * from tAWHERE MATCH tA.aName AGAINST ('name');
>SELECT DISTINCT * from tBWHERE MATCH tB.bName AGAINST ('name');

Gordon L. Burditt


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Database size

[Terry Katz]

Erik,
  If your running Linux on an Intel machine (which I assume it is), then
you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want to go
with sizes higher then 2gig you need to upgrade to a 2.4 kernel (and the
latest GNU Libc) .. I've had (not mysql databases) 40gig files on Intel
boxes work out fine ...

-Terry

> 
> Hi,
> 
> I have a problem, my database has reached Linux Redhat 7.1 
> max file size. (2147483647 Bytes). Does eny one know what i 
> can do to make a lager database.  (lager
> filesystem)
> 
> Thanks
> Erik Dhiin
> 
> 
> 
> -
> 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-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MERGE Tables

[Sergei Golubchik]

Hi!

On Apr 30, Basil Hussain wrote:
> Hi,
> 
> Anyway, while we're on the subject, I seem to be having some trouble with my
> indexes on MERGE tables. I posted a message a while ago, but no-one seems to
> have noticed it...
> 
> Basically, if I create my MERGE table with indexes on the same columns as
> the underlying tables, I then get strange results from some queries. Below I
> quote part of my original message that illustrates the problem.
> 
> > mysql> select count(*) from eventlog_36;
> > +--+
> > | count(*) |
> > +--+
> > |   389959 |
> > +--+
> > 1 row in set (0.00 sec)
> > 
> > mysql> select count(*) from eventlog_all where bannerid = 36;
> > +--+
> > | count(*) |
> > +--+
> > |1 |
> > +--+
> > 1 row in set (0.01 sec)
> > 
> > (The table 'eventlog_36' is one of the tables mapped to 'eventlog_all' which
> > holds only records with a 'bannerid' column value of 36.)
> > 
> > They don't match, so it's clearly not correct! It seems as though it's not
> > looking at the indexes of the mapped tables correctly, although I have no idea
> > why!
> 
> Also, I get the following error when I try to alter the mapping of the MERGE
> table:
> 
> > mysql> ALTER TABLE eventlog_all UNION=(eventlog_11, <..lots of tables...>,
> > eventlog_88);
> > ERROR 1031: Table handler for '#sql-1f1_ea6d9' doesn't have this option
> 
> My MERGE table seems to be completely screwed! Could you explain what's
> going on here? Is it because I'm running only version 3.23.32 of MySQL? Do I
> need to upgrade? Any assistance would be appreciated, as no-one else seems
> to be able to help.
> 
> Regards,
> 
> 
> Basil Hussain ([EMAIL PROTECTED])
> 

Ok, the first bug (incorrect COUNT, etc. for MERGE and individual tables)
was fixed some time ago. Though, it is possible that you found another bug,
the probability is low.

As for the second - ALTER TABLE ... UNION = () is absolutely legal syntax
and MySQL does support it (if you have source distribution, look at
mysql-test/t/merge.test). So, let's upgrade now, and then we'll see.

Regards,
Sergei

--
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

trouble installing mysql rpm on Linux

[Nathaniel Hekman]

I'm having trouble installing the MySQL RPM on Linux.  I've got
mysql-3.23.32-1.7.i386.rpm and I'm on RH Linux 7.0.  I run 'rpm -i
mysql-3.23.32-1.7.i386.rpm' and it shows no errors, but then I try running
'mysql' (the client) and get this error:

ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)

It's not too difficult to figure out why:  the mysql daemon isn't running.
'ps a | grep -i mysql' comes up empty; there's nothing in /etc/rc.d to start
mysql.  I found a file /usr/share/mysql/mysql.server which is a script that
says it's supposed to be run from /etc/rc.d, but it's 644 (not executable),
and definitely not linked to rc.d.  There are a lot of mysql* files in
/usr/bin...

What am I missing?  Did the rpm get installed correctly and there's just
some other step I'm supposed to do?  Or did it not install correctly?  How
can I tell?

Any help would be appreciated.  Thanks in advance.


Nate

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Ever heard of anything like this?

[Gary Garrett]

We are also using AITCOM and often have problems. They seem to work on
their network at noon on Sat. and traceroutes die at their network.They
seem to go offline randomly also. We asked for telnet access to
administer a Mysql database and can't get it to work. They say our DNS
is not configured for reverse lookups.. what the hell our DNS has to

do with their telnet I don't know. Their tech support is like M$oft,
technically correct but has no relevance to the problem. You would be
better served to learn Linux and see Rackspace.com for a dedicated
Server you have full access to. Best bet is to find a NOC close to you
in Internet space.




-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Is my table hosed?

[Carina C. Zona]

MySQL 3.23.33:

This morning, one of my tables suddenly reported index corruption.  I locked
the table, fixed with myisamchk -o, unlocked, and thought the problem was
solved.  But it keeps on re-corrupting (I'm not even writing anything to it
first).  Plus any query on that table which uses a "where" clause takes an
*extremely long time to execute.  Queries that normally take .01 seconds are
taking 10-15 *minutes*.  Or more.

DESC TABLE shows that the indexes are all still in place.  I even tried
dropping and re-creating an index, but that didn't seem to make a
difference.  EXPLAIN on the queries shows that MySQL still knows to use the
indexes that are there.  Yet obviously something is quite wrong.  One other
odd thing: after one of the (many) repair operations, I started getting
"disk quota filled" errors.  It turned out that a 142M file with the prefix
"#sql" had surfaced in /tmp.  I deleted it, and things went back to
semi-normal after that (everything working, but the table still extra slow).
Where did that big file come from?  My whole db is only 8M, the corrupted
table is only 4M, so does it sound right that a 142M temp file was somehow
generated..?

Odd.  Anyway, I'm hoping someone recognizes this problem and can point me
toward the right section of the manual to learn how to fix it.  

Thank you!


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Ever heard of anything like this?

[Steve Brazill]

Just a note.   If you're requesting "telnet" or "ftp" access to your
'colocated' systems,  the issue isn't only with your 'ISP'.   I just got
finished assisting another MySQL user in rebuilding his system (for the 2nd or
3rd time) who has been using "telnet" and "ftp" to remotely administer his
systems (it appeared that the machine had been 'hacked', and once rebuilt,
they just watched for the new login password, and hacked it again).

Though the MySQL manual (and other README notes) makes it clear that you
should set a "root" password to protect your MySQL data from intruders,  they
don't mention that you shouldn't 'broadcast' this info (or any other MySQL
user login info) over the Internet 'in the clear'.   Why you would want any
hacker watching your network traffic to 'grab' your login name and password is
beyond me...

The issue of 'reverse DNS lookups' IS relevent if they (or you) are using any
kind of 'allow/deny' lists which will need to authenticate you before making a
decision on whether to grant or deny access.   A lot of Internet Email systems
are now 'bouncing' mail that they recieve which they can't do a 'reverse
lookup' on the incoming IP to make sure it's really from who it says it is...


Gary Garrett wrote:

> We are also using AITCOM and often have problems. They seem to work on
> their network at noon on Sat. and traceroutes die at their network.They
> seem to go offline randomly also. We asked for telnet access to
> administer a Mysql database and can't get it to work. They say our DNS
> is not configured for reverse lookups.. what the hell our DNS has to
>
> do with their telnet I don't know. Their tech support is like M$oft,
> technically correct but has no relevance to the problem. You would be
> better served to learn Linux and see Rackspace.com for a dedicated
> Server you have full access to. Best bet is to find a NOC close to you
> in Internet space.
>

Re: Ever heard of anything like this?

[Gary Garrett]

Yes, reverse lookups are a good idea from a static address but AITCOM is
marketing reseller stuff to people who use dial-up connections and
dynamic IP addresses. DNS does not have inaddr-arpa entries for dynamic
addresses. It sounds to me if the passwords are sent in clear text, no
Mysql Database is safe across the internet. Is there a way to encrypt
these passwords? Even on the local network a sniffer could get a Mysql
connection password if sent from any host other than the server console.
What should a guy do about this?


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Query Question

[Daren Cotter]

I have a members table which stores, among other things, a Member ID and a
Points field. We get reports sent to us in a CSV format, with a list of all
Members signing up for a certain offer. Basically, what I need to do, is
create a query like this:

UPDATE members SET points = points + (offer_value) WHERE member_id =
(member_id)

for each member ID. With a small VB program I could create a file that has
these queries (upwards of 10,000), but I've heard something about a query
like this:

UPDATE members SET points = points + (offer_value) WHERE member_id IN
(7,8,9,10,23,etc)

Just wondering which format would be better for the server, assuming there
are upwards of 10,000 member_ids, whether it be one of these solutions or
another one.

TIA,

Daren Cotter


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Ever heard of anything like this?

[Steve Brazill]

I personally use SSH (running as a server on the Unix/Linux system running
MySQL,  and which is now included in the RedHat 7 release series) which is
configured to accept only 'ranges' of IP address (subnets that my dialup
ISP might assign me,  like  207.25.33.*  207.25.34.*).That should
pretty much protect you from 'snooping' while you're logging into the
system, and administering MySQL (and other stuff).

If you're performing any 'client/server' type of tasks,  you'd can do some
more research and try to 'tunnel' the MySQL traffic thru the encrypted
connection.   I have both my SSL webserver and MySQL db server next to each
other,  with a dedicated 'private' network between them (it's just a
'crossover' network cable),  so no one can watch what they're discussing...

Gary Garrett wrote:

> Yes, reverse lookups are a good idea from a static address but AITCOM is
> marketing reseller stuff to people who use dial-up connections and
> dynamic IP addresses. DNS does not have inaddr-arpa entries for dynamic
> addresses. It sounds to me if the passwords are sent in clear text, no
> Mysql Database is safe across the internet. Is there a way to encrypt
> these passwords? Even on the local network a sniffer could get a Mysql
> connection password if sent from any host other than the server console.
> What should a guy do about this?


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

What can I do to help the mysql developers to get mysql to work on OS X?

[haikusw]

So, I'd really like to have mysql working on OS X and while there were a 
few people trying it out and having difficulty, I have yet to see any 
posts of total success.

I'm an experienced MacOS programmer, but I have little experience on 
Unix --  so I'm way behind the curve on looking at the source and 
figuring it out.  My only thought is to try to dive in and run mysqld 
via gdb and then try to figure out the source tree sufficiently to see 
where the shutdown (HUP?) message is getting handled and then set a 
breakpoint to see if that code is ever getting called and watch where it 
gets stuck by tracing from there.

Unfortunately, I don't know how to use gdb (yet), and there is a LOT of 
source to slog through to find where the shutdown code is.Perhaps a 
more experienced unix hack could recommend some starting places; perhaps 
someone more experienced with the mysql source could point me to the 
locations of signal handling code (I hope it's not too obvious, since I 
haven't even looked yet... :-(  Got to get gdb working first... ).


So, if there is something I can do here to help get the issues resolved, 
I'd like to do so.  Please feel free to email me directly with 
suggestions, staring points etc.,  if that helps.

Thanks,
Tyler
[EMAIL PROTECTED]


P.S.  The problems I have seen posted and experienced myself are:

1) the small edit to get it to compile (not a big deal, but should get 
fixed)

2) The mysqld cannot be stopped short of kill -9

3) trying to use mysqladmin shutdown to stop mysqld (and safe_mysql) 
fails (hangs, requires kill -9 to halt)

4) the tests do not work.
  4a) make test fails
  4b) mysql-test-run   fails


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Question regarding getting column value from previous record and putting in next record

[ganbold]

Hi,

I'm writing in PHP and in perl ISP billing software and I have some problems.
I have following questions:

I need get some column value from previous record and put it to next record column 
value. It is something like:

Contract_idUseridPrevious_balanceDailyTotal
Due_balance
Record 1:1   Ganbold1001010
110
Record 2:1   Ganbold11088  
  118

Due-balance=Total+Previous_balance
Previous record's Due_balance is next record's Pre_balance

How to solve this kind of problem in one query? IS there any way to do that in one 
query or command?
How to solve it in simple way? I need solution which gives me fastest speed.

thanks in advance,

Ganbold

BUG

[Brad Casiano]

To Whom it May Concern,
I have downloaded mysql from the cd provided to me in the book "PHP: fast and easy web 
development" . To test the MySQL installation, at the MS-DOS command  prompt I typed 
cd c:\mysql\bin. Followed by:
c:\mysql\bin>mysqld --standalone 
I receive a BAD COMMAND OR FILENAME ERROR.
Can you explain why?

Brad

Fundamental (newbie) question

[Michael J. Kobb]

Please forgive the relatively basic nature of this question.  I'm new at
this.  I have the DuBois MySQL book and the O'Reilly one as well, so please
feel free to point me at a page number.  I couldn't find the answer myself.

I have two databases.  Database A has a few tables, and the table of
interest has about 35 columns.

Database B also has a few tables, and one of them has about 52 columns.  35
of those 52 are exactly the same as the ones in the table in Database A.
One could think of the data in Database B almost as a C++ subclass of the
data in Database A -- it has all the same fields, plus some extra ones.

Is there a relatively easy way to take a record in Database A and copy all
the matching fields over to a record in Database B?

I wish I could post the exact tables and such, but I can't.  Here's a
simplified version:

Database A, table 1 has:
Name
Address
Phone
Birthday

Database B, table 1 has:
Name
Address
Phone
Birthday
Purchases
Account balance

I would like to be able to easily make a new record in database B, copying
over the data from the matching fields in A.

Before you suggest that B should simply point at A, I can't do that
unfortunately.  The data in A "ages out" over time, but the data in B needs
to persist.  So, I think the best choice is to copy.

Thanks!
--Mike


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: BUG

[Gerald R. Jensen]

What files are in the C:\MYSQL\BIN directory? If there is no file named
MYSQLD.EXE, you have found the problem. Very likely there is one called
MYSQLD-SHAREWARE.EXE or something like that.

Suggestion? Uninstall the software provided with the book ... and download
the current version (3.23.37) from www.mysql.com or one of the mirrors. Make
sure you download the binary as opposed to the source.

Suggestion #2: The manual (online and with the software you download) will
answer most of your questions with a little reading.


- Original Message -
From: "Brad Casiano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 9:06 PM
Subject: BUG


> To Whom it May Concern,
> I have downloaded mysql from the cd provided to me in the book "PHP: fast
and easy web development" . To test the MySQL installation, at the MS-DOS
command  prompt I typed
> cd c:\mysql\bin. Followed by:
> c:\mysql\bin>mysqld --standalone 
> I receive a BAD COMMAND OR FILENAME ERROR.
> Can you explain why?
>
> Brad
>


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AIX Binary Installation Problems

[Wendell Dingus]

I haven't read through any of the MySQL mailing lists in a while. Now that I
do I see that lots of the AIX related questions involve problems with
/usr/local/lib/libz.a as part of the "ZLib" compression library. The
pre-compiled ZLib on http://www.bull.de/pub/ fails for me with the [shr.o]
missing problems others have spoken of, etc... What I did was to download
the source for ZLib and compile/install it and MySQL works just fine now.
So, if it will help anyone the libz.a file which is working fine for me is
downloadable at:

http://216.98.81.199/libz.a

I'd install zlib-1.1.3.2.exe from the Bull AIX Binary site and then replace
libz.a with this one. Have done so on a half dozen machines and it's running
fine everywhere.

... You're welcome


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: trouble installing mysql rpm on Linux

[Rolf Hopkins]

Did you download and install both client and server? Have you gone through
post installation?

- Original Message -
From: "Nathaniel Hekman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 6:45
Subject: trouble installing mysql rpm on Linux


> I'm having trouble installing the MySQL RPM on Linux.  I've got
> mysql-3.23.32-1.7.i386.rpm and I'm on RH Linux 7.0.  I run 'rpm -i
> mysql-3.23.32-1.7.i386.rpm' and it shows no errors, but then I try running
> 'mysql' (the client) and get this error:
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
>
> It's not too difficult to figure out why:  the mysql daemon isn't running.
> 'ps a | grep -i mysql' comes up empty; there's nothing in /etc/rc.d to
start
> mysql.  I found a file /usr/share/mysql/mysql.server which is a script
that
> says it's supposed to be run from /etc/rc.d, but it's 644 (not
executable),
> and definitely not linked to rc.d.  There are a lot of mysql* files in
> /usr/bin...
>
> What am I missing?  Did the rpm get installed correctly and there's just
> some other step I'm supposed to do?  Or did it not install correctly?  How
> can I tell?
>
> Any help would be appreciated.  Thanks in advance.
>
>
> Nate
>
> -
> 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-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Fundamental (newbie) question

[Tim]

Well, first of all, you may want to consider redesigning your two
databases.  Most properly designed databases don't have 52 columns in a
table.  The process of normalization should decompose these tables further
and make things way less complex.  I don't know what the context of your
databases are, but you might be able to treat 'Purchases' in Database B as
a separate entity, for example.

Unfortunately, I'm in the midst of learning MySQL myself, so I don't have
any insight on your real questionplus, it's time for bed.  But I think
if you take some time redesigning the databases, you'll find your problems
are not as complex...

Good luck!

- TIM FRASER

> Please forgive the relatively basic nature of this question.  I'm new at
> this.  I have the DuBois MySQL book and the O'Reilly one as well, so please
> feel free to point me at a page number.  I couldn't find the answer myself.
>
> I have two databases.  Database A has a few tables, and the table of
> interest has about 35 columns.
>
> Database B also has a few tables, and one of them has about 52 columns.  35
> of those 52 are exactly the same as the ones in the table in Database A.
> One could think of the data in Database B almost as a C++ subclass of the
> data in Database A -- it has all the same fields, plus some extra ones.
>
> Is there a relatively easy way to take a record in Database A and copy all
> the matching fields over to a record in Database B?
>
> I wish I could post the exact tables and such, but I can't.  Here's a
> simplified version:
>
> Database A, table 1 has:
> Name
> Address
> Phone
> Birthday
>
> Database B, table 1 has:
> Name
> Address
> Phone
> Birthday
> Purchases
> Account balance
>
> I would like to be able to easily make a new record in database B, copying
> over the data from the matching fields in A.
>
> Before you suggest that B should simply point at A, I can't do that
> unfortunately.  The data in A "ages out" over time, but the data in B needs
> to persist.  So, I think the best choice is to copy.
>
> Thanks!
> --Mike
>
>
> -
> 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-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>




-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Fundamental (newbie) question

[Michael J. Kobb]

Unfortunately, I have no option to redesign database A.  It's from a third
party.  I could potentially redesign database B somewhat, but I think there
would be one table with 30+ columns no matter what.

For instance, I could precisely duplicate the fields from the table in
database A in a table in database B.  But, the crux still remains -- is
there some simple way to copy data from one database to another if the
fields are the same?

Thanks!

> 
> Well, first of all, you may want to consider redesigning your two
> databases.  Most properly designed databases don't have 52 columns in a
> table.  The process of normalization should decompose these tables further
> and make things way less complex.  I don't know what the context of your
> databases are, but you might be able to treat 'Purchases' in Database B as
> a separate entity, for example.
> 
> Unfortunately, I'm in the midst of learning MySQL myself, so I don't have
> any insight on your real questionplus, it's time for bed.  But I think
> if you take some time redesigning the databases, you'll find your problems
> are not as complex...
> 
> Good luck!
> 
> - TIM FRASER
> 
>> Please forgive the relatively basic nature of this question.  I'm new at
>> this.  I have the DuBois MySQL book and the O'Reilly one as well, so please
>> feel free to point me at a page number.  I couldn't find the answer myself.
>> 
>> I have two databases.  Database A has a few tables, and the table of
>> interest has about 35 columns.
>> 
>> Database B also has a few tables, and one of them has about 52 columns.  35
>> of those 52 are exactly the same as the ones in the table in Database A.
>> One could think of the data in Database B almost as a C++ subclass of the
>> data in Database A -- it has all the same fields, plus some extra ones.
>> 
>> Is there a relatively easy way to take a record in Database A and copy all
>> the matching fields over to a record in Database B?
>> 
>> I wish I could post the exact tables and such, but I can't.  Here's a
>> simplified version:
>> 
>> Database A, table 1 has:
>> Name
>> Address
>> Phone
>> Birthday
>> 
>> Database B, table 1 has:
>> Name
>> Address
>> Phone
>> Birthday
>> Purchases
>> Account balance
>> 
>> I would like to be able to easily make a new record in database B, copying
>> over the data from the matching fields in A.
>> 
>> Before you suggest that B should simply point at A, I can't do that
>> unfortunately.  The data in A "ages out" over time, but the data in B needs
>> to persist.  So, I think the best choice is to copy.
>> 
>> Thanks!
>> --Mike
>> 
>> 
>> -
>> 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-mail
>> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>> 
> 
> 
> 
> 
> -
> 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-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Fundamental (newbie) question

[Michael J. Kobb]

Thanks for the suggestion!  I should have been more specific -- I don't need
to do this as a bulk import.  I need to do these on an ongoing basis.  It
doesn't have to be super-fast, though.  I would expect something on the
order of tens of events per hour at the most.

> Given my crude understanding of the tools I would suggest doing a SELECT
> INTO a text file of the fields you want in the 2nd DB and then using
> mysqlimport to import the text file into the 2nd DBthe fields need to be
> in the same order as the text file.  This could be automated with a script
> that passes mysql the SELECT INTO script and then execute the mysqlimport
> command.  Crude but ...
> 
> Trying to be helpful
> - Original Message -
> From: "Michael J. Kobb" <[EMAIL PROTECTED]>
> To: "MySQL" <[EMAIL PROTECTED]>
> Sent: Monday, April 30, 2001 10:24 PM
> Subject: Re: Fundamental (newbie) question
> 
> 
>> Unfortunately, I have no option to redesign database A.  It's from a third
>> party.  I could potentially redesign database B somewhat, but I think
> there
>> would be one table with 30+ columns no matter what.
>> 
>> For instance, I could precisely duplicate the fields from the table in
>> database A in a table in database B.  But, the crux still remains -- is
>> there some simple way to copy data from one database to another if the
>> fields are the same?
>> 
>> Thanks!
>> 
>>> 
>>> Well, first of all, you may want to consider redesigning your two
>>> databases.  Most properly designed databases don't have 52 columns in a
>>> table.  The process of normalization should decompose these tables
> further
>>> and make things way less complex.  I don't know what the context of your
>>> databases are, but you might be able to treat 'Purchases' in Database B
> as
>>> a separate entity, for example.
>>> 
>>> Unfortunately, I'm in the midst of learning MySQL myself, so I don't
> have
>>> any insight on your real questionplus, it's time for bed.  But I
> think
>>> if you take some time redesigning the databases, you'll find your
> problems
>>> are not as complex...
>>> 
>>> Good luck!
>>> 
>>> - TIM FRASER
>>> 
 Please forgive the relatively basic nature of this question.  I'm new
> at
 this.  I have the DuBois MySQL book and the O'Reilly one as well, so
> please
 feel free to point me at a page number.  I couldn't find the answer
> myself.
 
 I have two databases.  Database A has a few tables, and the table of
 interest has about 35 columns.
 
 Database B also has a few tables, and one of them has about 52 columns.
> 35
 of those 52 are exactly the same as the ones in the table in Database
> A.
 One could think of the data in Database B almost as a C++ subclass of
> the
 data in Database A -- it has all the same fields, plus some extra ones.
 
 Is there a relatively easy way to take a record in Database A and copy
> all
 the matching fields over to a record in Database B?
 
 I wish I could post the exact tables and such, but I can't.  Here's a
 simplified version:
 
 Database A, table 1 has:
 Name
 Address
 Phone
 Birthday
 
 Database B, table 1 has:
 Name
 Address
 Phone
 Birthday
 Purchases
 Account balance
 
 I would like to be able to easily make a new record in database B,
> copying
 over the data from the matching fields in A.
 
 Before you suggest that B should simply point at A, I can't do that
 unfortunately.  The data in A "ages out" over time, but the data in B
> needs
 to persist.  So, I think the best choice is to copy.
 
 Thanks!
 --Mike
 
 
 -
 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-mail
 <[EMAIL PROTECTED]>
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
>>> 
>>> 
>>> 
>>> 
>>> -
>>> 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-mail
> <[EMAIL PROTECTED]>
>>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>> 
>> 
>> 
>> -
>> 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-mail
> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>> 
>> 
> 


-

newbie question on variable length records.

[sagar tamhane]

Hi,

I am a newbie to Mysql. 

I would like to know how to create a table with
variable length records?

i have an object with following variables:
varchar v, int a, int b, int c.

and i want to store variable number of such objects
into the rows.
varchar v is the primary key.

the entries in the table would look like:
v11,a11,b11,c11,a12,b12,c12,a1,b13,c13
v21,a21,b21,c21,a22,b22,c22

Can you please help me with my problem?

Thanx in advance.

-Sagar




__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Computer Exploded!!!

[Selvin Sakal]

My computer didn't explode i just wrote that to get attention. My question
is this - I have a database with a table which looks like this -

CREATE TABLE sites
(
ID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
keywords VARCHAR(200) NOT NULL DEFAULT 0,
description VARCHAR(200) NOT NULL DEFAULT 0,
url VARCHAR(50) NOT NULL,
rank blob NOT NULL,
PRIMARY KEY (ID)
);

there is a index on keywords and description

what i would like to know is how to search description to see if it contains 
a word like 'web'.

i would also like to know how to search description and keyword for specific
words like this -

say description has 'the best search engine on the net'

i want to search for all the descriptions that contain 'best' and 'net'.

If i don't get help soon my computer might explode.

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem

[aditya shanker]

hi 
i am attaching a log file which was generated by the server in starting up mysql 
could any please tell me what exactlly the problen is 


log file 
=
010427 18:25:29  mysqld started
010427 18:25:29  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010427 18:25:29  mysqld ended

010427 18:26:05  mysqld started
010427 18:26:05  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010427 18:26:05  mysqld ended

010427 18:34:12  mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
010427 20:23:30  Aborted connection 10 to db: 'unconnected' user: 'root' host: 
`localhost' (Got an error reading communication packets)
010427 20:27:15  Aborted connection 17 to db: 'unconnected' user: 'root' host: 
`localhost' (Got an error writing communication packets)
010427 20:27:15  /usr/local/mysql/bin/mysqld: Normal shutdown

010427 20:27:15  /usr/local/mysql/bin/mysqld: Shutdown Complete

010427 20:27:15  mysqld ended

010430 12:10:00  mysqld started
010430 12:10:01  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010430 12:10:01  mysqld ended

010430 15:45:30  mysqld started
010430 15:45:30  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010430 15:45:30  mysqld ended

010430 15:46:20  mysqld started
010430 15:46:20  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010430 15:46:20  mysqld ended

010501 10:29:42  mysqld started
010501 10:29:42  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010501 10:29:42  mysqld ended

010501 10:30:34  mysqld started
010501 10:30:34  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010501 10:30:34  mysqld ended

010501 10:41:05  mysqld started
010501 10:41:05  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010501 10:41:05  mysqld ended

010501 11:06:18  mysqld started
010501 11:06:18  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010501 11:06:18  mysqld ended

010501 11:42:37  mysqld started
010501 11:42:37  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010501 11:42:37  mysqld ended

010501 11:52:29  mysqld started
010501 11:52:29  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)
010501 11:52:29  mysqld ended

010501 12:37:43  mysqld started
Fatal error: Can't change to run as user 'ser=mysql' ;  Please check that the user 
exists!
010501 12:37:43  Aborting

010501 12:37:43  mysqld ended

010501 12:47:05  mysqld started
/usr/local/mysql/bin/mysqld: ready for connections

Re: Mysql can't start: help! SOLUTION

[Rino Nucara]

I report a solution of my problem for other people ho have (or will have) the 
same problem.
I THANK VERY MUCH THE PEOPLE WHO HELPED ME
Mario.



IN A FEW WORDS:
Istalling rpm of MySql don't meas that MySql can run.
Some linux version (like My RedHad) have MySql istalled but not "inizialie"
So MySql don't run (In mandrake MySql is also inizialized).

SOLUTION:

[root@localhost bin]# ./mysql_install_db 
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root -p password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain -p password 
'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' 
directory:
cd sql-bench ; run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

[root@localhost bin]# 







[rino@localhost bin]$ su
Password: 
[root@localhost bin]#  safe_mysqld --user=root
Starting mysqld daemon with databases from /var/lib/mysql





-


4.16 Post-installation Setup and Testing

Once you've installed MySQL (from either a binary or source distribution), 
you need to initialize the grant tables, start the server, and
make sure that the server works okay. You may also wish to arrange for the 
server to be started and stopped automatically when your system
starts up and shuts down. 

Normally you install the grant tables and start the server like this for 
installation from a source distribution: 

shell> ./scripts/mysql_install_db
shell> cd mysql_installation_directory
shell> ./bin/safe_mysqld --user=mysql &

For a binary distribution, do this: 

shell> cd mysql_installation_directory
shell> ./bin/mysql_install_db
shell> ./bin/safe_mysqld --user=mysql &

This creates the mysql database which will hold all database privileges, the 
test database which you can use to test MySQL and also
privilege entries for the user that run mysql_install_db and a root user 
(without any passwords). This also starts the mysqld server. 

mysql_install_db will not overwrite any old privilege tables, so it should be 
safe to run in any circumstances. If you don't want to have
the test database you can remove it with mysqladmin -u root drop test. 







On Monday 30 April 2001 10:43, [EMAIL PROTECTED] wrote:
> I use RedHat (last release)
> I try to use Mysql but It doesen' works:
> I post you some lines can help you to understand the error.
> how can create a table, use Mysql?
> Thank you in advance, Mario.
>
> ---
>-- [root@localhost mysqld]$ mysqladmin vesion
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/var/lib/mys
> .sock' (111)'
> Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.
> ists!
>
>
> ---
>-- [root@localhost mysql]# ./mysql.server start
> [root@localhost mysql]# Starting mysqld daemon with databases from
> /var/lib/mysql
> 010430 10:37:02  mysqld ended
> ---
>-- [root@localhost log]# tail mysqld.log
> 010430 10:22:19  mysqld ended
>
> 010430 10:24:50  mysqld started
> 010430 10:24:50  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> 010430 10:24:50  mysqld ended
>
> 010430 10:37:02  mysqld started
> 010430 10:37:02  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
> 010430 10:37:02  mysqld ended
> ---
>--
>
> -
> 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-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php