MySQL-Front

2002-09-22 Thread Kevin Smith

Hi All,

Does anyone know what happened to the MySQL-Front project, which was at
http://www.anse.de/mysqlfront/ ?

Thanks,

Kevin


-
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-Front

2002-09-22 Thread Iikka Meriläinen

Hello,

As they say on the site, it is discontinued. My guess is that there were
no active developers. Quite a shame, though, as MySQLFront was simply the
best frontend for MySQL.

I _really_ hope that someone will pick up the development from where it
was left off and continue the development of this excellent frontend.

Best regards,
Iikka

On Sun, 22 Sep 2002, Kevin Smith wrote:

 Hi All,

 Does anyone know what happened to the MySQL-Front project, which was at
 http://www.anse.de/mysqlfront/ ?

 Thanks,

 Kevin


 -
 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


**
* Iikka Meriläinen   *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**


-
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-Front

2002-09-22 Thread Stuart Low

Hrm,

I wouldn't mind taking this over, or at the very least, taking over the
website and releasing the current version. I have quite a bit of Windows
programming experience as it is so I should be able to make patches etc.
where needed.

Anyone know where I can find more info? I can host it at Perlboy.org without
any dramas.

Cheers,

Stuart

---
Perlboy.org - Professional Perl Programming Services
Carpet-Head.com - Sally's Blog


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Iikka Meriläinen
Sent: Sunday, 22 September 2002 7:10 PM
To: Kevin Smith
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL-Front


Hello,

As they say on the site, it is discontinued. My guess is that there were
no active developers. Quite a shame, though, as MySQLFront was simply the
best frontend for MySQL.

I _really_ hope that someone will pick up the development from where it
was left off and continue the development of this excellent frontend.

Best regards,
Iikka

On Sun, 22 Sep 2002, Kevin Smith wrote:

 Hi All,

 Does anyone know what happened to the MySQL-Front project, which was at
 http://www.anse.de/mysqlfront/ ?

 Thanks,

 Kevin


 -
 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


**
* Iikka Meriläinen   *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**


-
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-Front

2002-09-22 Thread Stuart Low

Interesting,

http://mysqlfront.sstienemann.de/

Still works.

Stuart

---
Perlboy.org - Professional Perl Programming Services
Carpet-Head.com - Sally's Blog


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Iikka Meriläinen
Sent: Sunday, 22 September 2002 7:10 PM
To: Kevin Smith
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL-Front


Hello,

As they say on the site, it is discontinued. My guess is that there were
no active developers. Quite a shame, though, as MySQLFront was simply the
best frontend for MySQL.

I _really_ hope that someone will pick up the development from where it
was left off and continue the development of this excellent frontend.

Best regards,
Iikka

On Sun, 22 Sep 2002, Kevin Smith wrote:

 Hi All,

 Does anyone know what happened to the MySQL-Front project, which was at
 http://www.anse.de/mysqlfront/ ?

 Thanks,

 Kevin


 -
 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


**
* Iikka Meriläinen   *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**


-
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: Fractions

2002-09-22 Thread Jan Steinman

From: MySQL [EMAIL PROTECTED]

   From: Madscientist [EMAIL PROTECTED]

   You might also consider using two integer type fields - one for the
   numerator and another for the denominator. This way storage and recovery are
   easy and the mathematics are wide open.
   _M

I suspect that a float add is faster than 3 integer multiplies and
sum.

Ah, but it is not as accurate!

If the original poster knows he needs fractions, he won't be happy with float.

Just as one should NEVER use floating point to represent money, one should NEVER use 
it for representing fractions that need to be precise. For example, (1/3 as a float) * 
3 will come out to 0..

-- 
: Jan Steinman -- nature photography: http://www.Bytesmiths.com
: Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services
: Join the forums at http://www.Bytesmiths.com/wiki


-
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




Multiple concurrent MySQL question?

2002-09-22 Thread Paul Maine

I desire to configure MySQL in such a way that it will permit me to have two
different PHP/MySQL e-commerce applications running concurrently on my
development system. The table names and table structure are the same on both
applications(and databases). I have received a SQL backup from the new
client and would just like to be able to restore it to a directory and start
up another copy of MySQL and point it to the new location. I know that I
could create two different databases to accomplish what I desire however, I
would have to change all of the security tables for the new database.

What are your suggestions to solve this issue?

Thank You
Paul


-
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




ERROR 1146

2002-09-22 Thread hans schneidhofer

hi list,
trying to do my first steps with mysql, i have done the following :
mysql USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql INSERT INTO mysql VALUES(localhost, sample_db,
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
ERROR 1146: Table 'mysql.mysql' doesn't exist

hmm - what I have done wrong here ? or do I have to do something before
?

these steps are a piece of description in a mysql-book mysql in 21
days and 

thanks for helping
bye hans




-
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: Re: Build errors with 3.23.51

2002-09-22 Thread B. van Velzen [VelzArt.nl]

Yes, I now the problem with MySQL,

Can anyone send me te solution?

Greetings

---
B. van Velzen
VelzArt

Mobile   : +31(0)653382221
Mail  : [EMAIL PROTECTED]
Info   : [EMAIL PROTECTED]

http://www.velzart.nl

===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
velzart.nl staat niet in voor de juiste en volledige overbrenging
van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

- Original Message -
From: [EMAIL PROTECTED]
To: B. van Velzen [VelzArt.nl] [EMAIL PROTECTED]
Sent: Sunday, September 22, 2002 3:06 PM
Subject: Re: Re: Build errors with 3.23.51


 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:

 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. Just typing the word MySQL once will be sufficient, for
example.

 You have written the following:

 Yes.

 I have excaclty the same problem :S

 can somebody mail me the solution?

 [EMAIL PROTECTED]

 Many thanks

 B. van Velzen





-
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




TO_DAYS() equivalent for months, hours etc.?

2002-09-22 Thread Tim Fountain


I'm writing a website statistics system and have been using GROUP BY
TO_DAYS(time) in the sql to aggregate results for different days,
however there doesn't seem to be an equivalent function for other time
periods such as hours and months. Will I be able to use:

GROUP BY (MONTH(time),YEAR(time))

to achieve this result, or is there a better way?


Cheers,
Tim.

-- 
Tim Fountain ([EMAIL PROTECTED])
http://www.tfountain.co.uk/


-
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




Duplicate key error

2002-09-22 Thread Graham Hodges

I am aware that this is an error of my own making, however . . .

I am unable to install my sql  because the scipt fails with
a duplicate key error

Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1062  Duplicate entry 'localhost-root' for key 1
ERROR: 1062  Duplicate entry 'localhost-root' for key 1
020922 12:55:57  ./bin/mysqld: Shutdown Complete

I have removed the database to the best of my ability, and am unable to find
any mysql files of anything containing the text localhost-root.  The
output however remains the same.

I have a mac G4 with os 10.1.5
Can anyone advise me how to proceed?

regards

Graham Hodges


-
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: Build errors with 3.23.51

2002-09-22 Thread Julian Ladisch

Shane Allen wrote:

 configure:12730: checking style of gethost* routines
 configure:12773: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions 
-fno-rtti
  -fpermissive -I/usr/local/mysql-glibc-2.2.2/include  conftest.cc 5
 gcc: installation problem, cannot exec `cc1plus': No such file or directory

Configure assumes that gcc can compile .cc file as well.  This is bad
because gcc can be installed without .cc support, which is in the optional
packages gpp and libgpp.

I had the same problem with SuSE 7.3 and the unmodified mysql-4.0.3-beta
sources using the recommended gcc configure options from the manual.

Install packages gpp and libgpp, and all will work fine.

Regards

  Julian


-
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: Multiple concurrent MySQL question?

2002-09-22 Thread Andrew Braithwaite

Paul,

You need to run another server on a different port with a different socket
path. 

See http://www.mysql.com/doc/en/Multiple_servers.html

And http://www.mysql.com/doc/en/mysqld_multi.html to manage multiple MySQL
servers.

Cheers,

Andrew

-Original Message-
From: Paul Maine [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, 22 September 2002 12:26
To: MySQL MySQL
Subject: Multiple concurrent MySQL question?


I desire to configure MySQL in such a way that it will permit me to have two
different PHP/MySQL e-commerce applications running concurrently on my
development system. The table names and table structure are the same on both
applications(and databases). I have received a SQL backup from the new
client and would just like to be able to restore it to a directory and start
up another copy of MySQL and point it to the new location. I know that I
could create two different databases to accomplish what I desire however, I
would have to change all of the security tables for the new database.

What are your suggestions to solve this issue?

Thank You
Paul


-
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: Problem starting mysqld on SCO

2002-09-22 Thread Steven Kreuzer

did you run the mysql_install_db script to create the mysql database and 
populate it with the bare values necessary for mysql run?

SK

On Thursday, September 5, 2002, at 05:57 PM, Darryl Hoar wrote:

 Greetings,
 I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL 
 website.
 I installed it per the INSTALL-BINARY readme file.

 When I try (from /usr/local/mysql) issue:
 bin/safe_mysqld --user=mysql 

 It starts and immediately stops mysqld. The .err file contains

 020904 21:41:45 mysqld started
 020904 21:41:45 bdb:
 /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql-max-3.23.42-pc-
 sco3.2v5.0.6-i386
 /data/log.01: Permission denied
 020904 21:41:45 bdb: PANIC: Permission denied
 020904 21:41:45 Can't init databases
 020904 21:41:45 mysqld ended

 I have changed the ownership/group as per the instructions and I even 
 went
 so far as to
 set the permission on the data directory to 777. Still no joy.

 Any ideas what step I missed?

 thanks in advance,
 Darryl



 -
 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 mysql-unsubscribe-
 [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




mysqlbug

2002-09-22 Thread Winnie Kwok


After i install the Redhat 7.3 and mysql
i cannot  connect to  the mysql server , it shutdown automatically


[root@localhost root]/usr/bin/safe_install 
[1]2023
[root@localhost root]Starting mysql daemon with databases from 
/var/lib/mysql
  020923 00:36:23 mysqld ended

  [1]+ Done  /usr/bin/safe_install
  [root@localhost root}# mysql -u root mysql
  ERROR 2002: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock'(111)





_
Send and receive Hotmail on your mobile device: http://mobile.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




first dbi access with perl and lost

2002-09-22 Thread Gerald Preston

Hi!,

I am lost!  I am running in win 98 and my perl code is:

#!perl

  use strict;
  use DBI();

  # Connect to the database.
  my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost,
   jwp, x,
 {'RaiseError' = 1});

  $drh = DBI-install_driver(\mysql);

I am not sure what is wrong.

I get the following error:

Global sysmbol $drh requires explicit package name at dbtest.pl line 12

Am I going about the the correct way?  I have created the table and added a number if 
items to the table.
I can look at the table with WinMySQL.adminVer 1.4 for Win95/Win98/NT/Win2000.

Thanks ,

Jerry




-
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: first dbi access with perl and lost

2002-09-22 Thread David Lloyd


Gerald,

 #!perl
 
   use strict;
   use DBI();
 
   # Connect to the database.
   my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost,
jwp, x,
  {'RaiseError' = 1});
 
   $drh = DBI-install_driver(\mysql);
 
 I am not sure what is wrong.
 
 I get the following error:
 
 Global sysmbol $drh requires explicit package name at dbtest.pl line 12

That's a Perl error.

You've told Perl not to allow you to use a variable unless you declare
it with:

my
local
our
(and possibly other keywords but these are the most common)

If you substitute:

my $drh=

...then you'll be fine.

You might want to find out more information on what the use strict
actually does too. A good place would be the perl documentation
(perldoc) or http://www.perl.org/

Hope this helps.

DSL

[mysql,query]
-- 
I reniad lin ne mor, nuithannen
  In gwidh ristennin, i fae narchannen
I lach Anor ed ardhon gwannen
  (Soundtrack LOTR)

-
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: first dbi access with perl and lost

2002-09-22 Thread Gerald Preston

David,

Thanks,

Now I am getting the following:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib 
C:/Perlsite/lib .) at (eval 1)
line 3;

I can't mysql.pm on my PC.  Was it not generated when I installed MySQL?  How do I fix 
this?

Thanks,

Jerry

David Lloyd wrote:

 Gerald,

  #!perl
 
use strict;
use DBI();
 
# Connect to the database.
my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost,
 jwp, x,
   {'RaiseError' = 1});
 
$drh = DBI-install_driver(\mysql);
 
  I am not sure what is wrong.
 
  I get the following error:
 
  Global sysmbol $drh requires explicit package name at dbtest.pl line 12

 That's a Perl error.

 You've told Perl not to allow you to use a variable unless you declare
 it with:

 my
 local
 our
 (and possibly other keywords but these are the most common)

 If you substitute:

 my $drh=

 ...then you'll be fine.

 You might want to find out more information on what the use strict
 actually does too. A good place would be the perl documentation
 (perldoc) or http://www.perl.org/

 Hope this helps.

 DSL

 [mysql,query]
 --
 I reniad lin ne mor, nuithannen
   In gwidh ristennin, i fae narchannen
 I lach Anor ed ardhon gwannen
   (Soundtrack LOTR)



-
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: first dbi access with perl and lost

2002-09-22 Thread David Lloyd


Gerald,

 Now I am getting the following:
 
 install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; 
C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
 line 3;
 
 I can't mysql.pm on my PC.  Was it not generated when I installed MySQL?  How do I 
fix this?

No, it's separate from the distribution of MySQL.

If you're using ActiveState then start the ppm (Perl Package Manager
Utility) and look for:

  DBD::mysql

You'll find it here:

  * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search

  (Search for DBD::mysql)

I don't really know the best way to install Perl modules on Windows (I
avoid Windows like the plague).

DSL
-- 
I reniad lin ne mor, nuithannen
  In gwidh ristennin, i fae narchannen
I lach Anor ed ardhon gwannen
  (Soundtrack LOTR)

-
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




Turn logging on or off for SQL statements

2002-09-22 Thread Owain McGuire

Is there an easy way to turn logging or SQL statement executions on or off without 
having to restart with a changed my.cnf file?  Just want to log queries to try and 
sort out some performance problems. 

Thanks,

O.

(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




What's this error mean?

2002-09-22 Thread Randy Johnson

What's this error mean?

Warning: Wrong parameter count for mysql_query() 


thanks

Randy



-
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: mysqlbug

2002-09-22 Thread Stuart Low

Hey there,

That means that the MySQL server is unable to find the mysql socket. Check
your error log for more info.

Stuart

---
Perlboy.org - Professional Perl Programming Services
Carpet-Head.com - Sally's Blog


-Original Message-
From: Winnie Kwok [mailto:[EMAIL PROTECTED]]
Sent: Monday, 23 September 2002 2:38 AM
To: [EMAIL PROTECTED]
Subject: mysqlbug



After i install the Redhat 7.3 and mysql
i cannot  connect to  the mysql server , it shutdown automatically


[root@localhost root]/usr/bin/safe_install 
[1]2023
[root@localhost root]Starting mysql daemon with databases from
/var/lib/mysql
  020923 00:36:23 mysqld ended

  [1]+ Done  /usr/bin/safe_install
  [root@localhost root}# mysql -u root mysql
  ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'(111)





_
Send and receive Hotmail on your mobile device: http://mobile.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



-
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 Query Question

2002-09-22 Thread Shaun Bramley

Hi all,

I need to be able to tell what the maximum length of a char column is.  Can
I query the database for this information?


Shaun
list filter: mysql

-
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 Query Question

2002-09-22 Thread Andrew Braithwaite

Shaun,

The length can be any value between 1 and 255. (As of MySQL Version 3.23,
the length of CHAR may be 0 to 255.)  See
http://www.mysql.com/doc/en/CHAR.html

If you're looking to find the maximum length of the values in a particular
column, use something like this:

In table 'tablename' for column 'columnname'.

mysql select max(length(columnname)) from tablename;

+-+
| max(length(columnname)) |
+-+
|  22 |
+-+

Cheers,

Andrew

-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, 22 September 2002 19:14
To: [EMAIL PROTECTED]
Subject: Database Query Question


Hi all,

I need to be able to tell what the maximum length of a char column is.  Can
I query the database for this information?


Shaun
list filter: mysql

-
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: What's this error mean?

2002-09-22 Thread Duncan Hill

On Sun, 22 Sep 2002, Randy Johnson wrote:

 What's this error mean?
 
 Warning: Wrong parameter count for mysql_query() 

Exactly what it says.  You called mysql_query (PHP?) with the wrong number 
of parameters/arguements.  Ie, it might expect 2, and you only gave it 1.

-- 

Sapere aude
My mind not only wanders, it sometimes leaves completely.
Never attribute to malice that which can be adequately explained by stupidity.


-
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: first dbi access with perl and lost

2002-09-22 Thread Gerald Preston

David,

I am not getting any where..   Do I have create mysql.pm on my system or can 
just copy the file onto my system.
I do not understand why MySQL did not create this file.

Thanks,

Jerry

David Lloyd wrote:

 Gerald,

  Now I am getting the following:
 
  install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; 
C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
  line 3;
 
  I can't mysql.pm on my PC.  Was it not generated when I installed MySQL?  How do I 
fix this?

 No, it's separate from the distribution of MySQL.

 If you're using ActiveState then start the ppm (Perl Package Manager
 Utility) and look for:

   DBD::mysql

 You'll find it here:

   * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search

   (Search for DBD::mysql)

 I don't really know the best way to install Perl modules on Windows (I
 avoid Windows like the plague).

 DSL
 --
 I reniad lin ne mor, nuithannen
   In gwidh ristennin, i fae narchannen
 I lach Anor ed ardhon gwannen
   (Soundtrack LOTR)



-
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: first dbi access with perl and lost

2002-09-22 Thread Paul DuBois

At 13:33 -0500 9/22/02, Gerald Preston wrote:
David,

I am not getting any where..   Do I have create mysql.pm on 
my system or can just copy the file onto my system.
I do not understand why MySQL did not create this file.

Because it's not part of MySQL.  It's part of DBD::mysql, the MySQL-specific
driver for the DBI module.

Since you say you're not getting anywhere, but do not specify what you've
tried, all we can say is follow the directions you've already been given.
That is, use ppm to install the DBD::mysql module.

Invoke the ppm program, then run this command:

install DBD::mysql


Thanks,

Jerry

David Lloyd wrote:

  Gerald,

   Now I am getting the following:
  
   install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC 
contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
   line 3;
  
   I can't mysql.pm on my PC.  Was it not generated when I 
installed MySQL?  How do I fix this?

  No, it's separate from the distribution of MySQL.

  If you're using ActiveState then start the ppm (Perl Package Manager
  Utility) and look for:

DBD::mysql

  You'll find it here:

* http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search

(Search for DBD::mysql)

  I don't really know the best way to install Perl modules on Windows (I
  avoid Windows like the plague).

  DSL
  --
  I reniad lin ne mor, nuithannen
In gwidh ristennin, i fae narchannen
  I lach Anor ed ardhon gwannen
(Soundtrack LOTR)



-
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: first dbi access with perl and lost

2002-09-22 Thread Gerald Preston

Paul,

Thank you!!  I had installed DBD, but I did not know that I had to install DBD::mysql.

THANKS SO MUCH!!!

Jerry

Paul DuBois wrote:

 At 13:33 -0500 9/22/02, Gerald Preston wrote:
 David,
 
 I am not getting any where..   Do I have create mysql.pm on
 my system or can just copy the file onto my system.
 I do not understand why MySQL did not create this file.

 Because it's not part of MySQL.  It's part of DBD::mysql, the MySQL-specific
 driver for the DBI module.

 Since you say you're not getting anywhere, but do not specify what you've
 tried, all we can say is follow the directions you've already been given.
 That is, use ppm to install the DBD::mysql module.

 Invoke the ppm program, then run this command:

 install DBD::mysql

 Thanks,
 
 Jerry
 
 David Lloyd wrote:
 
   Gerald,
 
Now I am getting the following:
   
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC
 contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
line 3;
   
I can't mysql.pm on my PC.  Was it not generated when I
 installed MySQL?  How do I fix this?
 
   No, it's separate from the distribution of MySQL.
 
   If you're using ActiveState then start the ppm (Perl Package Manager
   Utility) and look for:
 
 DBD::mysql
 
   You'll find it here:
 
 * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search
 
 (Search for DBD::mysql)
 
   I don't really know the best way to install Perl modules on Windows (I
   avoid Windows like the plague).
 
   DSL
   --
   I reniad lin ne mor, nuithannen
 In gwidh ristennin, i fae narchannen
   I lach Anor ed ardhon gwannen
 (Soundtrack LOTR)
 
 
 
 -
 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: first dbi access with perl and lost

2002-09-22 Thread Paul DuBois

At 14:24 -0500 9/22/02, Gerald Preston wrote:
Paul,

Thank you!!  I had installed DBD, but I did not know that I had to 
install DBD::mysql.

THANKS SO MUCH!!!

I take it from your tone that your script works now? :-)

DBI (I assume that's what you mean by installing DBD, because there is no
DBD module as such) provides the top-level database access mechanism.
But it doesn't contain any information about specific databases, so
you need to install a driver for each type of database you want to access:
DBD::mysql for MySQL, DBD::Pg for PostgreSQL, etc.  DBI uses the DBD-level
drivers to communicate with specific types of database servers.


Jerry

Paul DuBois wrote:

  At 13:33 -0500 9/22/02, Gerald Preston wrote:
  David,
  
  I am not getting any where..   Do I have create mysql.pm on
  my system or can just copy the file onto my system.
  I do not understand why MySQL did not create this file.

  Because it's not part of MySQL.  It's part of DBD::mysql, the MySQL-specific
  driver for the DBI module.

  Since you say you're not getting anywhere, but do not specify what you've
  tried, all we can say is follow the directions you've already been given.
  That is, use ppm to install the DBD::mysql module.

  Invoke the ppm program, then run this command:

  install DBD::mysql

  Thanks,
  
  Jerry
  
  David Lloyd wrote:
  
Gerald,
  
 Now I am getting the following:

 install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC
  contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
 line 3;

 I can't mysql.pm on my PC.  Was it not generated when I
  installed MySQL?  How do I fix this?
  
No, it's separate from the distribution of MySQL.
  
If you're using ActiveState then start the ppm (Perl Package Manager
Utility) and look for:
  
  DBD::mysql
  
You'll find it here:
  
  * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search
  
  (Search for DBD::mysql)
  
I don't really know the best way to install Perl modules on Windows (I
avoid Windows like the plague).
  
DSL
--
I reniad lin ne mor, nuithannen
  In gwidh ristennin, i fae narchannen
I lach Anor ed ardhon gwannen
  (Soundtrack LOTR)
  
  
  
  -
  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


-
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




Speaking of DBI -v- Net::MySQL (Was: RE: first dbi access with perl and lost)

2002-09-22 Thread Thoenen, Peter Mr. EPS

Following this conversation myself (also a perl db newbie :) ... before
always just used php) and curious if you know definitely what db vendor you
are going to be using (mysql in this case), any reason to use dbi; as
opposed to just using vendor specific or net::mysql; .  Is it just a
portability issue?

Cheers,

-Peter


 -Original Message-
 From: Paul DuBois [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, September 22, 2002 21:35
 To: Gerald Preston
 Cc: David Lloyd; mysql
 Subject: Re: first dbi access with perl and lost
 
 
 At 14:24 -0500 9/22/02, Gerald Preston wrote:
 Paul,
 
 Thank you!!  I had installed DBD, but I did not know that I had to 
 install DBD::mysql.
 
 THANKS SO MUCH!!!
 
 I take it from your tone that your script works now? :-)
 
 DBI (I assume that's what you mean by installing DBD, 
 because there is no
 DBD module as such) provides the top-level database access 
 mechanism.
 But it doesn't contain any information about specific databases, so
 you need to install a driver for each type of database you 
 want to access:
 DBD::mysql for MySQL, DBD::Pg for PostgreSQL, etc.  DBI uses 
 the DBD-level
 drivers to communicate with specific types of database servers.
 
 
 Jerry
 
 Paul DuBois wrote:
 
   At 13:33 -0500 9/22/02, Gerald Preston wrote:
   David,
   
   I am not getting any where..   Do I have create 
 mysql.pm on
   my system or can just copy the file onto my system.
   I do not understand why MySQL did not create this file.
 
   Because it's not part of MySQL.  It's part of DBD::mysql, 
 the MySQL-specific
   driver for the DBI module.
 
   Since you say you're not getting anywhere, but do not 
 specify what you've
   tried, all we can say is follow the directions you've 
 already been given.
   That is, use ppm to install the DBD::mysql module.
 
   Invoke the ppm program, then run this command:
 
   install DBD::mysql
 
   Thanks,
   
   Jerry
   
   David Lloyd wrote:
   
 Gerald,
   
  Now I am getting the following:
 
  install_driver(mysql) failed: Can't locate 
 DBD/mysql.pm in @INC
   contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
  line 3;
 
  I can't mysql.pm on my PC.  Was it not generated when I
   installed MySQL?  How do I fix this?
   
 No, it's separate from the distribution of MySQL.
   
 If you're using ActiveState then start the ppm 
 (Perl Package Manager
 Utility) and look for:
   
   DBD::mysql
   
 You'll find it here:
   
   * 
http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search
  
  (Search for DBD::mysql)
  
I don't really know the best way to install Perl modules on Windows
(I
avoid Windows like the plague).
  
DSL
--
I reniad lin ne mor, nuithannen
  In gwidh ristennin, i fae narchannen
I lach Anor ed ardhon gwannen
  (Soundtrack LOTR)
  
  
  
  -
  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


-
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




Perl and mySQL and character sets.

2002-09-22 Thread Shaun Bramley

Hello all,

I am currently using perl to import some information into a mysql db.  At
this point in time I have two issues:

1.  The text files that are being imported contain both english and french
text.  My text editor (textpad) gladly displays the text with all proper
hyphens and accentuated characters.  Now when I use perl to read the files,
the characters that are being displayed are not what I am expecting to see.
Apparently perl is reading the file as UTF8??  How do I get it to recognize
the file as using the ISO-8859-1 character set??  Now this leads to my
second question

2.  Does how perl is displaying the text really matter? will it store the
'proper' character or will it store the messed up character?

3. Does mysql by default use the ISO-8859-1 character set?

Any help is greatly appreciated.

Thanks Shaun

-
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




Performance while Building Indices -- how does it scale?

2002-09-22 Thread Chris Stoughton

I have a table with a few million rows, wth 633 columns.  I want to 
create 10 inidices on this table, six single-column and four two-column 
inidices.  The database will be loaded once and remain static, and 
queried many times.  Please note that this is a small prototype for 
the actual database, which will have 40 times more rows.

I used two strategies to create these tables:

1.  Create the indices in the create table statement
2.  Load the table, and then use the create index statement for each 
index.

With Strategy 1, the loading started nicely  using the load data 
infile command to load approx. 2000 records at a time.  It took 3 
seconds for each load data infile command.  After a few hundred load 
data infile commands, however, the time increased to two minutes per 
command.

With Strategy 2, the loading went from start to finish at 3 seconds for 
each load data infile command.  But now, creating each index is taking 
longer.  Here is a log:

Fri Sep 20 15:17:43 CDT 2002 create index objId on bestTsObj (objId)
Fri Sep 20 15:35:51 CDT 2002 create index fieldId on bestTsObj (fieldId)
Fri Sep 20 15:56:02 CDT 2002 create index targetObjId on bestTsObj 
(targetObjId)
Fri Sep 20 16:20:02 CDT 2002 create index ra on bestTsObj (ra)
Fri Sep 20 16:49:16 CDT 2002 create index decl on bestTsObj (decl)
Fri Sep 20 17:53:38 CDT 2002 create index u on bestTsObj (u)
Fri Sep 20 18:42:52 CDT 2002 create index g on bestTsObj (g)
Fri Sep 20 22:04:25 CDT 2002 create index r on bestTsObj (r)
Sat Sep 21 10:06:44 CDT 2002 create index i on bestTsObj (i)
Sat Sep 21 19:31:52 CDT 2002 create index z on bestTsObj (z)
Sun Sep 22 15:45:06 CDT 2002 create index ug on bestTsObj (u,g)


The first index was created in a reasonable amount of time (18 minutes), 
but it is taking longer to create more indices.


With both strategies, no process is swapping heavily, and mysqld is not 
consuming available CPU cycles efficiently.

Can you suggest how I can build multiple indices on large tables 
efficiently?  Will it help to create a narrow table with only the 
quantities I want to use in indices?

We have installed mysql via rpm:
bash-2.04$ mysqladmin
mysqladmin  Ver 8.18 Distrib 3.23.36, for redhat-linux-gnu on i386

bash-2.04$ uname -r
2.4.18-xfs-1.1
bash-2.04$ 

What diagnostics do you suggest I run?

Thanks









-
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 Gui Install and Setup for Win2K

2002-09-22 Thread Arthur Fuller

We were told by David Axmark of MySQL AB to stop using MySQLGui and switch
to MyCC. MySQLGUI is apparently dead.

- Original Message -
From: David Kramer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 16, 2002 12:52 PM
Subject: MySQL Gui Install and Setup for Win2K


 Can some one point me in the direction of some good install and setup Doc
 for MySQL GUI.  Im running the GUI on Win2K, but my DB server is RH7.2 w/
 stock Mysql(not sure version number).  Also is the FLTK absolutely
necessary
 to run the GUI on Win2K?  Any other hints or insights is greatly
 appreciated.

 Thanks,

 DK

 David Kramer
 Software Developer
 Reflect.com
 Direct: 415.369.4856
 Cell: 650.302.7889


 -
 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




mysql kylix

2002-09-22 Thread Terry Cheryl Haimann


I have a copy of Kylix 1.0, which I put on a recent RH 7.3 install. It
is running MySQL  3.23.49.  I therefore d/l  3.23 driver for kylix.

I then did the following:

*Copied the driver to the kylix\bin file
*Created the symbolic link(Does it matter what dir this is
executed from?)
*Updated the /usr/local/etc/dbxdrivers.conf with
libraryname=libsqlmy23.so.1
Now when I try to connect to the msql server I get a Unable to load
libsqlmy23.so.1.  Did I do something wrong?  Did I skip a step?

Terry



-
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 Gui Install and Setup for Win2K

2002-09-22 Thread Matt Hargraves

Oops... I meant Microsoft SQL Server and Oracle, not MySQL and Oracle.

Matt

- Original Message -
From: Matt Hargraves [EMAIL PROTECTED]
To: Arthur Fuller [EMAIL PROTECTED]; David Kramer
[EMAIL PROTECTED]
Cc: mysql mailing list [EMAIL PROTECTED]
Sent: Sunday, September 22, 2002 9:14 PM
Subject: Re: MySQL Gui Install and Setup for Win2K


 Don't let them mislead you, MyCC might as well be dead too... there hasn't
 been an update to it for more than 4 months.  Go get MySQL Navigator
because
 at least IT can export to a file that you can then edit.

 I usually use both though, MyCC is easier to design the basic (and I mean
 BASIC) database, then go into MySQL Navigator to export it so that I can
 manually add all the stuff that neither of the semi-worthless apps seem to
 support (half of SQL).  If MySQL AB wants to know why a lot of people use
 MySQL and Oracle, it's because the tools are there and they work.  The
only
 reason that people use MySQL is because it's cheaper (OK, a LOT cheaper).
 If they made tools that fully supported SQL then MySQL would get a lot
more
 industry support, IMO.

 Matt

 - Original Message -
 From: Arthur Fuller [EMAIL PROTECTED]
 To: David Kramer [EMAIL PROTECTED]
 Cc: mysql mailing list [EMAIL PROTECTED]
 Sent: Sunday, September 22, 2002 6:06 PM
 Subject: Re: MySQL Gui Install and Setup for Win2K


  We were told by David Axmark of MySQL AB to stop using MySQLGui and
switch
  to MyCC. MySQLGUI is apparently dead.
 
  - Original Message -
  From: David Kramer [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Monday, September 16, 2002 12:52 PM
  Subject: MySQL Gui Install and Setup for Win2K
 
 
   Can some one point me in the direction of some good install and setup
 Doc
   for MySQL GUI.  Im running the GUI on Win2K, but my DB server is RH7.2
 w/
   stock Mysql(not sure version number).  Also is the FLTK absolutely
  necessary
   to run the GUI on Win2K?  Any other hints or insights is greatly
   appreciated.
  
   Thanks,
  
   DK
  
   David Kramer
   Software Developer
   Reflect.com
   Direct: 415.369.4856
   Cell: 650.302.7889
  
  
   -
   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




-
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




merge tables - errorno: 143 - Is there a limit on columns with mergedtables ?

2002-09-22 Thread David Herring



Hello,

I get the following error when trying to access a table created of 
TYPE=MERGE

mysql describe yy;
ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143)

Reducing the number of colums in the tables to be merged removed the 
problem.

Any ideas gratefully received,

Dave
 ( MySQL version: 3.23.52 )





-
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 - errorno: 143 - Is there a limit on columns with merged tables ?

2002-09-22 Thread rich allen

from perror

143 = Conflicting table definition between MERGE and mapped table


On Sunday, Sep 22, 2002, at 18:36 America/Anchorage, David Herring 
wrote:



 Hello,

 I get the following error when trying to access a table created of 
 TYPE=MERGE

 mysql describe yy;
 ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143)

 Reducing the number of colums in the tables to be merged removed the 
 problem.


-
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




Slight problem storing data with Mysql...

2002-09-22 Thread Marvin Cummings

MySQL newbie seeking help and/or advice on storing data into a database.
I have a poetry section I'm trying to add to my site that will allow users to submit 
some of their work for public viewing. An example is located here: 
http://www.nubiint.com/nuwoez/nuwoez.htm.
By clicking on any one of the categories listed in the menu, the user is presented 
with a link that will allow them to complete a form and enter their text to be stored 
in the db I've created and made available for public viewing. The problem is that the 
data doesn't appear to store in the table in the database. After adding some test data 
I'm able to see the row added to the table, but I'm unable to see or view anything 
else, for instance the date(s) or data that's set as a mediumblob. 
How can I view this data to ensure that it is indeed in the table? 
Also how can I reset the ID field? After I delete the test data the ID doesn't reset, 
it continues to count from the last ID. 
Also how can I change the display of the date field? It currently shows as -00-00. 
Is there anyway to change it to 
00-00-???

TIA...Any response is appreciated.

-
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




transactions...

2002-09-22 Thread João Borsoi Soares

I think I've already asked this before, but I will try again. Do I loose
too much performance using InnoDB tables in autocommit mode instead of
using MyISAM tables?

Thanks.
Joao
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: transactions...

2002-09-22 Thread David Lloyd


Joao,

 I think I've already asked this before, but I will try again. Do I loose
 too much performance using InnoDB tables in autocommit mode instead of
 using MyISAM tables?

Possibly, but too much is really relative on what your needs are. What
are you trying to achieve and what is more important to you:

* speed
* reliability
* ability to roll back commits

mysql,query

??

DSL
-- 
I reniad lin ne mor, nuithannen
  In gwidh ristennin, i fae narchannen
I lach Anor ed ardhon gwannen
  (Soundtrack LOTR)

-
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: transactions...

2002-09-22 Thread Daniel Kiss

Hi!

At 00:56 2002.09.23._ -0300, you wrote:
Do I loose
too much performance using InnoDB tables in autocommit mode instead of
using MyISAM tables?

The real quiestion is: Why do you want to use InnoDB tables when you don't 
want to use its transaction safe features?
Anyway yes. I'm sure it is not worth using InnoDB tables in autocommit 
mode. If you want to do this use MyISAM instead.

Bye,
 Daniel (mysql)


-
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: transactions...

2002-09-22 Thread Iikka Meriläinen

On Mon, 23 Sep 2002, Daniel Kiss wrote:

 Hi!

 At 00:56 2002.09.23._ -0300, you wrote:
 Do I loose
 too much performance using InnoDB tables in autocommit mode instead of
 using MyISAM tables?

 The real quiestion is: Why do you want to use InnoDB tables when you don't
 want to use its transaction safe features?

The reason for prefering InnoDB over MyISAM? Performance. Most benchmarks
show InnoDB is slightly faster than MyISAM, and not to mention its some
other benefits.

But the performance could be a reason on its own to use InnoDB. I don't
mean that MyISAM is bad, not at all. It's simpler to use, after all. But
what I mean is that InnoDB can be used in all tasks MyISAM is suitable
for, and some tasks will be done faster using InnoDB.

Best regards,
Iikka

**
* Iikka Meriläinen   *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**

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




mysqlimport

2002-09-22 Thread vinita vigine Murugiah

Hi

I can create a database called test,
mysql create database test;
Query OK, 1 row affected (0.03 sec)

BUT I can't create any other databases???

mysql create database tem;
ERROR 1044: Access denied for user: 'ddb@localhost' to database 'tem'

mysql create database proj;
ERROR 1044: Access denied for user: 'ddb@localhost' to database 'proj'

Any idea
Thanks
Vinita



-
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