Re: error codes ??

[Werner Stuerenburg]

perror will tell you

Error code  69:  Srmount error

This looks  pretty much like a system error to me. Ask your ISP.


[EMAIL PROTECTED] schrieb am Donnerstag, 9. August 2001, 01:25:48:

> Hello,

> I seem to have corrupted mySQL deep down inside. I can not create any tables in any 
>new databases. I will get the exact same errcode each time ... that is :

> SQL-query:

> CREATE TABLE test (user_id INT (6)  not null AUTO_INCREMENT, notes VARCHAR (100)  
>not null  , PRIMARY KEY (user_id))
> MySQL said: Error writing file './relata/test.frm' (Errcode: 69) 


> I don't have root access to my server, and also can't find a list of what any of the 
>errcodes mean.

> Looking for help

> Peter



-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



-
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

About installing MySQL on Linux 7.1

[Alan]

Excuse Me,
I'm a starter to Linux.
I've downloaded the MySQL-3.23.40-1 for my Linux OS.
They are in .rpm form. How can I install the software properly on Linux! =

I try to follow the instructions mentioned in manual.txt but it didn't =
work.
Can you help me and tell my how to install it? Thanks!

Please send to me the solution.
E-mail : [EMAIL PROTECTED]

RE:Re: Localization..

[shiuwaitai]

Hi, 

try to use "varchar" or "varchar binary" instead.

they work fine in my application for searching '%multibyte%multibyte%' condition even.



>> Hi,
>> 
>> 
>> 
>> I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as
>> OS to run MySQL application. In my experience, I have not changed charset 
>> parameter in server startup, database or column. They can store latin1
>>  and big5 properly "in-a-mix".
>> 
>> Have u tested to insert and select your records with different charsets 
>> in MySQL before changing the value of charset?
>> 
>
>the table i want to create is of mixed charsets, ie:
>  Title VARCHAR(10), <--- Latin
>  desc_b5 VARCHAR(10), <--- Big5
>  desc_gb VARCHAR(10), <--- GB2312 
>  desc_en VARCHAR(10), <--- ASCII 
>  desc_(some other charsets...)
>
>I am now using a simple BINARY option to make 
>this (seems) possible. INSERT work fine with this.
>
>However, _SELECT col_name from tbl_name
>LIKE '%(somthing)%';_ doesn't work as expected
>with multi-byted charsets... MySQL try to match
>across two characters.
>
>I don't want to use Unicode in this, as Unicode 
>is not a complete superset of all charset i have to use,
>there will be some losses when i convect to other charsets..
>
>That's why i am asking here.
>
>> Beside setting charset value what problems do u face actually?
>> 
>> 
>> > Date |Tue, 7 Aug 2001 17:25:48 +0800
>> 
>> > From |"SDiZ Cheng" <[EMAIL PROTECTED]>
>> 
>> > 
>> 
>> > Hello!
>> 
>> > 
>> 
>> > 
>> 
>> > SC> I have read these docs. I can't find any charset option in CREATE
>> 
>> TABLE
>> 
>> > SC> syntax.
>> 
>> > Oh no.
>> 
>> > You need to set up charset in mysql configuration.
>> 
>> > like this:
>> 
>> > http://www.mysql.com/doc/C/h/Character_sets.html
>> 
>> 
>> 
>> Yes, i have read that too.
>> 
>> that tell me how to compile mysql with multi charset,
>> 
>> but not create such kind of table.
>> 
>> 
>> 
>> i expect there is somthing like
>> 
>>   CREATE TABLE tbl_name ( 
>> 
>> col_name type CHARSET=char_set, 
>> 
>> col_name2 type CHARSET=char_set2 ) ...
>> 
>> 
>> 
>>   CREATE DATABASE db_name DEFAULT_CHARSET=char_set 
>> 
>> where can i find these?
>
>> 
>
>
==
·s®ö§K¶O¹q¤l«H½c  http://sinamail.sina.com.hk




-
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: DBASE help

[Grigory Bakunov]

Date |Wed, 08 Aug 2001 07:02:09 +
>From |"saraswathy saras" <[EMAIL PROTECTED]>

Hello!

SS> hai
SS> do anyone know how to join  table in DBASE?

SS> The situation :-

SS> table 1
SS> -
SS> EM_id
SS> EM_gender

SS> table 2
SS> -
SS> EN_id
SS> EN_name

SS> The question is how to select all field from table1 and EN_name from table2  
SS> at one query? .The EM_id and  EN_id is same.Is that any idea.
SS> please help me.


SS> thanks in advance.
You can use two tables in one SELECT queries.

SELECT * from table1,table2 where table1.EM_id = table2.EM_id
for example

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.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

Embedded max() function in an insert?

[Jason Ziegler]

All,

Is there any way to do the following in MySQL:
INSERT INTO TableName (rowID) VALUES ('max(rowID)+1')
(so that the next unique identifier for the table can be determined 
WITHIN the insert statement?)

I know MySQL provides auto-incrementing and last_insert_id. However, 
architecture constraints have been placed on my project that may prevent 
me from using these...

Thanks in advance,

Jason

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

[Grigory Bakunov]

Date |Wed, 8 Aug 2001 13:11:1 +0800
>From |winnie <[EMAIL PROTECTED]>

Hello!

W> Hi Sir,

W> Now I'm trying the fulltext search of mysql 3.23.40. 
W> The question is : May I use chinese font as the substring in mysql script?  I 
tried, but failed. 


Sorry but in current version mysql doesnt support multibyte fulltext
search. But if you read TODO http://www.mysql.com/doc/F/u/Fulltext_TODO.html
you can see what multibyte search planed in next versions.
___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.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: Upgrading mysql on Win2K

[Grigory Bakunov]

Date |Tue,  7 Aug 2001 13:07:46 -0700
>From |"A. Clausen" <[EMAIL PROTECTED]>

Hello!

AC> What is the process of upgrading v3.23.36 to 3.23.40 on Windows NT.  Can I just 
install over top or is there some other steps that should be taken?
No.You can just install new version.
AC> I am running two mysql servers, one a  master and one a slave.  Does this make a 
difference?
No.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.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: Zerofill Auto_Increment

[Grigory Bakunov]

Date |Tue, 07 Aug 2001 13:59:05 -0500
>From |[EMAIL PROTECTED]

Hello!

M> Hi All,

M> Not sure if this is a bug or just a standard behavior of a auto_increment
M> zerofill column.

M> I have a column in a MySQL database table assigned as such:

M> memid int(8) auto_increment zerofill primary key,

M> now when the a new row is inserted in fills the column with the appropriate 0's,
M> but when I do a 'SELECT LAST_INSERT_ID()', after the insert, I get the last
M> insert number, without the zeros, IE... Last inserted id value = '0012' but
M> the return value is '12' and if I do a SELECT * FROM table_name WHERE memid =
M> '12'; or SELECT * FROM table_name WHERE memid = '0012';

M> I get the same results, whether I use '12' or '0012' 

M> Is this suppose to do that?? Just curious :)
I think it's absolutely normal.
Lets think slightly.
when we compare to integer - why we need to look on leading zeroes ?

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.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: Undefined Reference when Linking with C API

[Gregory A Greenman]

Benjamin Pflugmann wrote:

> Hi.
>
> On Wed, Aug 08, 2001 at 08:01:43PM -0500, [EMAIL PROTECTED] wrote:
> [...]
> > $ gcc -o cl2 cl2.o -L/usr/local/mysql/lib -lmysqlclient
> >
> > Can anyone tell me what I need to do to take care of this
> > problem?
>
> Just add -lz (a compression library) to your gcc call:

Many thanks, that solved the problem.


Greg


-
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: Migrating from MS SQLserver to MySQL

[Bart Goormans]

I'll look into this,


Thanks,
bart goormans


(will be following up on this thread shortly ...)



Van: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 9 augustus 2001 3:53


Bart:

There are many ways to skin this cat, but this is one we have used
recently
with good success.

Create a script in MSSQL7 (you can do it through the Enterprise
Manager) so
can re-create the database schema in MySQL. There are some syntax
differences between MSSQL7 and MySQL, but it is pretty easy to
figure out.

Next, create an ODBC DSN to the MSSQL7 database(s). The MySQL Server
can be
installed eithe ron the same machine or another machine that can
connect to
MSSQL7.

MySQLFront (http://www.mysqlfront.de/) can help you import the
MSSQL7 row
information into your MySQL database. Alternatively, you could link
tables
with MSAccess, but MySQLFront is easier and cleaner.

Gerald Jensen


From: "Bart Goormans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 8:11 PM


Hi all,

There's a fairly large MS SQLserver Database that my client wants me
to
convert to MySQL.

...

The main issue will be its size, so an intermediate tab-delimited
textfile
might not be useable.

Bart




-
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: Migrating from MS SQLserver to MySQL

[Bart Goormans]

'DTS' the information ?
Sorry Edgart, what exactly do you mean by that ?


bart


From: Edgart Gonzalez [mailto:[EMAIL PROTECTED]]
augustus 9, 2001 3:39


You can DTS you information from MsSql to MySQL via ODBC.

-Original Message-
From: Bart Goormans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 6:11 PM
To: [EMAIL PROTECTED]
Subject: Migrating from MS SQLserver to MySQL


Hi all,

There's a fairly large MS SQLserver Database that my client wants me
to
convert to MySQL. Can someone advice me on how to tackle this, or
direct me
to some help.
There aren't any BLOBs-fields or other exotic field types, mainly
straightforward text/integers, so I don't expect too much problems
on that.
The main issue will be its size, so an intermediate tab-delimited
textfile
might not be useable.

(?)

Thanks,

Bart




-
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

Support perfect transaction?

[심충보]

Hi all.
I'm wondering about transaction support of Mysql.
www.mysql.com announces that recent mysql support transaction.(type=BDB)
Does it really support perfect transaction?

If not, what's difference ?

Please reply to me.

Thanks in advance.

-
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: Date calculations with php and mysql

[Paul DuBois]

At 9:01 PM -0500 8/8/01, Joel wrote:
>How do I find the elapsed time on a timestamp field?

A timestamp is a single value.  You can't find elapsed time without
a point of reference to measure it against (two values).  What's
your point of reference?

If you have two timestamps, convert each of them to seconds since the epoch
using UNIX_TIMESTAMP() and take the difference.

>I know there must be a way but I can't find it in the Mysql Docs.
>I am using php 4 and the latest mysql i386 binary.
>Thank you very much
>Joel


-- 
Paul DuBois, [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

MySQLdump failure

[Wendell Dingus]

This is on a RedHat 7.1 (very recently freshly installed) server with all
patched from updates.redhat.com installed and kernel 2.4.3-12.  RedHat 7.1
installed MySQL 3.23.36 and that's what it was running until this problem
came up and I upgraded it to 3.23.40 from the Roswell beta directory from
RedHat's FTP site as something to try.

If I do a mysqldump of a database taking up about 250MB with a bunch of
small tables and one 600,000+ record table it hangs. I get 42,908 bytes of
data in the dump file and no more. If I do a 'top' I still see mysql and
mysqldump using a lot of CPU but the file never grows larger. I've waited a
considerable length of time to see if it is caching something and will
eventually catch up. It doesn't.

Here's a tail of the dump file:

  INC_METHOD char(3) NOT NULL default '',
  INC_PER_UNIT int(6) NOT NULL default '0',
  INC_UNITS int(5) NOT NULL default '0',
  INC_UNIT_TYPE char(2) NOT NULL default '',
  INC_SCHED_C


Right after that last C is my # command prompt with no line-ending character
in the file. It gets part way through the describe of the table layout and
stops. Using phpMyAdmin I can view everything just fine and even renamed
that one field and then named it back thinking there could be a hidden
control character in the name or something. The one thing to note is that
there are a LOT of fields in this one table, 500+ I'd guess. Other databases
on this server (none this large but some fairly large) dump just fine. This
is the only one with a problem.

I've even ran mysqldump on other servers with a -h pointing over to this
server to try to get a dump of the data and see the same results. All
selects against this database seem to run fine (and fast) and I've rebooted
and shut down/restarted mysql multiple times.

I'm at a loss and have to suspect it might be a mysql bug at this point...

Thanks in advance!

PS. Threw in a -t to mysqldump to not produce the table create data and it
got about 20K (versus ~40K previously) into the dump and stopped at the end
of an insert. Plenty of RAM and plenty of disk space on the server too...


-
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

About MYSQLGUI

[tonilaw]

 Dear sir,

I have a problem, I run the MYSQL GUI on my Server, but it always say that " Can't 
connect to local Mysql through socket " (111)


What is that socket?

I have already input the port and the server name. What do i need to do or need to set 
config or..??? please show me the way!!

please help me!! 
Thanks for yout attention

Toni
--
 Åwªï¨Ï¥ÎHongKong.com¶l¥ó¨t²Î
 Thank you for using hongkong.com Email system


-
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 DSN and PHP

[Steve Doig]

Hi Folks - new user here,

My question is on the setup of my local server.
I'm using Windows 2000 and IIS 5

I've just started to use php on my local IIS as a cgi .exe file.
Under c:\Inetpub I have:
\mySQL
\php
\wwwroot etc
(php seems to working fine)

In a php test page I'm trying to connect to the 'test' database (in
c:\inetpub\mysql\data\ ) and hardware 'table'.

$link = mysql_connect("mySQL_test", "mysql_login", "mysql_password")
or die ("Could not connect");
print ("Connected successfully");
mysql_select_db ("test")
or die ("Could not select database");

I get the error message:
Warning: Unknown MySQL Server Host 'mySQL_test' (2) in
C:\Inetpub\wwwroot/mySQL.php on line 9

In my ODBC sources I have a user DSN of
name: mySQLtest
driver: mySQL
mySQL host: 127.0.0.1
mySQL database name: test

I have a system DSN:
name: mySQL_test
driver: mySQL
mySQL host: 127.0.0.1
mySQL database name: test

I get the same message using mySQLtest in the php file. (names are case
sensitive?)
I run WinMySQLadmin 1.1 on startup, and it runs okay. Details are:
Server Info: 3.23.38-nt
Host Info: localhost via TCP/IP
Client Info: 3.23.36
MyODBC driver version 02.50

Everything looks fine to my untrained eye.

Help 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

Date calculations with php and mysql

[Joel]

How do I find the elapsed time on a timestamp field?
I know there must be a way but I can't find it in the Mysql Docs.
I am using php 4 and the latest mysql i386 binary.
Thank you very much
Joel

Re: Localization..

[SDiZ Cheng]

> Date |Wed, 8 Aug 2001 03:05:20 +0800
> From |"SDiZ Cheng" <[EMAIL PROTECTED]>
> 
> Hello!
> 
> 
> SC> Yes, i have read that too.
> SC> that tell me how to compile mysql with multi charset,
> SC> but not create such kind of table.
> 
> SC> i expect there is somthing like
> SC> CREATE TABLE tbl_name ( 
> SC> col_name type CHARSET=char_set, 
> SC> col_name2 type CHARSET=char_set2 ) ...
> 
> SC> CREATE DATABASE db_name DEFAULT_CHARSET=char_set 
> SC> where can i find these?
> Aha. so, i think nowhere.
> You can't do that.
> 

Can anyone tell me what exactly --with-extra-charset do?
I can compile those charset in, but not use them?
Or that's just for a localized error message?

I think mysql have somthing like postgresql's CREATE DATABASE 
db_name ENCODEING=encode;.


-
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: Migrating from MS SQLserver to MySQL

[Gerald R. Jensen]

Bart:

There are many ways to skin this cat, but this is one we have used recently
with good success.

Create a script in MSSQL7 (you can do it through the Enterprise Manager) so
can re-create the database schema in MySQL. There are some syntax
differences between MSSQL7 and MySQL, but it is pretty easy to figure out.

Next, create an ODBC DSN to the MSSQL7 database(s). The MySQL Server can be
installed eithe ron the same machine or another machine that can connect to
MSSQL7.

MySQLFront (http://www.mysqlfront.de/) can help you import the MSSQL7 row
information into your MySQL database. Alternatively, you could link tables
with MSAccess, but MySQLFront is easier and cleaner.

Gerald Jensen


- Original Message -
From: "Bart Goormans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 8:11 PM
Subject: Migrating from MS SQLserver to MySQL


Hi all,

There's a fairly large MS SQLserver Database that my client wants me to
convert to MySQL. Can someone advice me on how to tackle this, or direct me
to some help.
There aren't any BLOBs-fields or other exotic field types, mainly
straightforward text/integers, so I don't expect too much problems on that.
The main issue will be its size, so an intermediate tab-delimited textfile
might not be useable.

(?)

Thanks,

Bart



-
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: Undefined Reference when Linking with C API

[Benjamin Pflugmann]

Hi.

On Wed, Aug 08, 2001 at 08:01:43PM -0500, [EMAIL PROTECTED] wrote:
[...]
> $ gcc -o cl2 cl2.o -L/usr/local/mysql/lib -lmysqlclient
> 
> /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In
> function
> `my_uncompress':
> my_compress.o(.text+0x9a): undefined reference to `uncompress'
> 
> I've got MySQL version 3.23.40. I'm running Mandrake Linux
> 7.0.
> 
> Can anyone tell me what I need to do to take care of this
> problem?

Just add -lz (a compression library) to your gcc call:

gcc -o cl2 cl2.o -L/usr/local/mysql/lib -lmysqlclient -lz

The lib in question comes with the packet zlib-devel. So you might
need to install it, if it isn't already.

Bye,

Philemon.


-
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

Migrating from MS SQLserver to MySQL

[Bart Goormans]

Hi all,

There's a fairly large MS SQLserver Database that my client wants me to
convert to MySQL. Can someone advice me on how to tackle this, or direct me
to some help.
There aren't any BLOBs-fields or other exotic field types, mainly
straightforward text/integers, so I don't expect too much problems on that.
The main issue will be its size, so an intermediate tab-delimited textfile
might not be useable.

(?)

Thanks,

Bart



-
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

Undefined Reference when Linking with C API

[Gregory A Greenman]

I'm trying to create a simple C program that accesses MySQL.
I've included  in the source code. The program
compiles fine, but when I try to link it as follows, I get the
following error messages:

$ gcc -o cl2 cl2.o -L/usr/local/mysql/lib -lmysqlclient

/usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In
function
`my_uncompress':
my_compress.o(.text+0x9a): undefined reference to `uncompress'

/usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In
function
`my_compress_alloc':
my_compress.o(.text+0x12a): undefined reference to `compress'
collect2: ld returned 1 exit status



I've got MySQL version 3.23.40. I'm running Mandrake Linux
7.0.

Can anyone tell me what I need to do to take care of this
problem?

Thanks,


Greg





-
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

Not so good transaction support

[심충보]

Hi.
I downloaded mysql 3.23.40 from www.mysql.com.
This site announces that this mysql version supports transaction which was
not supported in older mysql.
I was so happy to find that. So I tested that support. The case was
following.

I launched two mysql - one in A terminal window and other in B terminal
window.
And I created the table using 'create table foodb (name char(20), email
char(30)) type=BDB;'

In A I entered the followings.

mysql>set autocommit=0;
mysql>begin;
mysql>insert into foodb values('charley', '[EMAIL PROTECTED]');

  it's just before enter COMMIT. 


After that, I entered the followings in B.

mysql>select * from foodb;

In this case, B's mysql suspended.
But B contiued to execute above SELECT query after I entered COMMIT in A.

I think this is not true transaction. B's query should be able to be
executed before A's COMMIT query.
Oracle8(sqlplus) executes this situation correctly.

Question.

1. Please explain the above in detail.

2. If the above situation is the transaction which mysql supports, what's
difference between LOCK TABLE and TRANSACTION?
I think the only difference is functions(COMMIT, ROLLBACK) support.

3. I think the above transaction causes the performance to be lowered which
mysql is better than other RDBMS in.
I want your explanation.

Please answer to me as soon as possible because I must port my server
application using oracle 8 into that using mysql.

Thank you for reading and thanks in advance.

my email address is mailto:[EMAIL PROTECTED].
Don't send to [EMAIL PROTECTED] please.




-
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 server for Sun Solaris i386?

[Jeff Tanner]

I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL
server for Sun Solaris i386?
Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386? 

Thanks

Jeff Tanner
Viathan
Seattle, WA

-
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 codes ??

[pcole]

Hello,

I seem to have corrupted mySQL deep down inside. I can not create any tables in any 
new databases. I will get the exact same errcode each time ... that is :

SQL-query:

CREATE TABLE test (user_id INT (6)  not null AUTO_INCREMENT, notes VARCHAR (100)  not 
null  , PRIMARY KEY (user_id))
MySQL said: Error writing file './relata/test.frm' (Errcode: 69) 


I don't have root access to my server, and also can't find a list of what any of the 
errcodes mean.

Looking for help

Peter

Re: local MySQL server authenticating users by machine username

[Gerald Jensen]

Bennett:

Regardless of the login username / password, you have to GRANT user rights
to create, alter, etc. in MySQL. By default, the root user has those rights,
but not other users.

Gerald Jensen

- Original Message -
From: "Bennett Haselton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:50 PM
Subject: local MySQL server authenticating users by machine username


> The first page of the MySQL tutorial at:
> http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
>
> says that when you connect to the MySQL server, it authenticates you based
> on a username and password that you enter, unless the server is also
> configured to allow "anonymous" access, in which case you can log in with
> no username.
>
> Isn't it also true that if you connect to the MySQL server on your local
> machine, the server authenticates you based on the username that you're
> already logged in under?
>
> I'm just trying out the MySQL server on my machine, and when I'm logged to
> the machine as "bhaselto" and I invoke mysql (with no username or password
> on the command line), I get the mysql prompt, however I am not able to
> create new databases.  However, if I quit mysql, then "su" to become root,
> and then invoke mysql again with no username/password arguments, when I
get
> the mysql prompt I am able to create new databases.
>
> (If this is right, then should I send an update suggestion to the author
of
> the http://www.mysql.com/doc/C/o/Connecting-disconnecting.html page?  Is
he
> or she on the list?)
>
> -Bennett
>
> [EMAIL PROTECTED] http://www.peacefire.org
> (425) 649 9024
>
>
> -
> 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: local MySQL server authenticating users by machine username

[Paul DuBois]

At 2:50 PM -0700 8/8/01, Bennett Haselton wrote:
>The first page of the MySQL tutorial at:
>http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
>
>says that when you connect to the MySQL server, it authenticates you 
>based on a username and password that you enter, unless the server 
>is also configured to allow "anonymous" access, in which case you 
>can log in with no username.
>
>Isn't it also true that if you connect to the MySQL server on your 
>local machine, the server authenticates you based on the username 
>that you're already logged in under?

Not quite.  The server has no idea who you're logged in as.
The mysql client program uses your login name as the default MySQL user name
if you don't specify any user name explicitly.

>
>I'm just trying out the MySQL server on my machine, and when I'm 
>logged to the machine as "bhaselto" and I invoke mysql (with no 
>username or password on the command line), I get the mysql prompt, 
>however I am not able to create new databases.  However, if I quit 
>mysql, then "su" to become root, and then invoke mysql again with no 
>username/password arguments, when I get the mysql prompt I am able 
>to create new databases.

You should be able to do the same by invoking mysql when logged in as
bhaselto like this:

mysql -u root

>
>(If this is right, then should I send an update suggestion to the 
>author of the 
>http://www.mysql.com/doc/C/o/Connecting-disconnecting.html page?  Is 
>he or she on the list?)
>
>   -Bennett
>
>[EMAIL PROTECTED] http://www.peacefire.org
>(425) 649 9024


-- 
Paul DuBois, [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-php mailing list

[Werner Stuerenburg]

Jason Radley schrieb am Mittwoch, 8. August 2001, 21:11:57:

> I have written a php script to get all the clients
> for a mysql table and send them emails.  The 
> problem is when the script is doing its job the 
> browser times out and it stops the script.  so I 
> am sending about 300 email out of 3000. And the
> browser said page not found.
> Any ideas?

Yes. It timed out. You adjust it with

set_time_limit(0);//indefinitely



-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



-
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-php mailing list

[Tonu Samuel]

On 08 Aug 2001 13:11:57 -0600, Jason Radley wrote:
> I have written a php script to get all the clients
> for a mysql table and send them emails.  The 
> problem is when the script is doing its job the 
> browser times out and it stops the script.  so I 
> am sending about 300 email out of 3000. And the
> browser said page not found.
> Any ideas?

PHP+browser are not meant to do such job. If you really like to do then:

1. PHP timeout is configurable (check the {PHP manual)
2. Run PHP processor from command line.

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   <___/   www.mysql.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: ASP & ADO

[Steven Petrie]

In my (limited) experience it's nearly as easy as using ASP/ADO wirth Access.  MySQL 
is a bit touchier about what it considers proper SQL.  We're developing a hybrid 
(mutant?) system using MS's 
IIS web server and MySQL running on a Linux box and it's coming along quite nicely.  
You really don't need to know much more about ASP/ADO than you need to know to make it 
work with 
Access.

07 Aug 01 10:09:06 PM, "Steve Doig" <[EMAIL PROTECTED]> wrote:

>Hi Folks,
>
>New user here...How easy or not is it to use mySQL as a substitute when
>using .asp and ADO?
>What do I need to know in order to use mySQL with ASP and ADO?  Are there
>3rd party solns available?
>
>Thankyou,
>Steve.
>
>
>-
>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

local MySQL server authenticating users by machine username

[Bennett Haselton]

The first page of the MySQL tutorial at:
http://www.mysql.com/doc/C/o/Connecting-disconnecting.html

says that when you connect to the MySQL server, it authenticates you based 
on a username and password that you enter, unless the server is also 
configured to allow "anonymous" access, in which case you can log in with 
no username.

Isn't it also true that if you connect to the MySQL server on your local 
machine, the server authenticates you based on the username that you're 
already logged in under?

I'm just trying out the MySQL server on my machine, and when I'm logged to 
the machine as "bhaselto" and I invoke mysql (with no username or password 
on the command line), I get the mysql prompt, however I am not able to 
create new databases.  However, if I quit mysql, then "su" to become root, 
and then invoke mysql again with no username/password arguments, when I get 
the mysql prompt I am able to create new databases.

(If this is right, then should I send an update suggestion to the author of 
the http://www.mysql.com/doc/C/o/Connecting-disconnecting.html page?  Is he 
or she on the list?)

-Bennett

[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024


-
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-php mailing list

[Jason Burfield]

Add this to the top of the script:

set_time_limit(0);

That will set the time out to 0, so it will never time out.

  --  Jason


On 8/8/01 3:11 PM, Jason Radley was heard saying:

> I have written a php script to get all the clients
> for a mysql table and send them emails.  The
> problem is when the script is doing its job the
> browser times out and it stops the script.  so I
> am sending about 300 email out of 3000. And the
> browser said page not found.
> Any ideas?
> Thanks
> Jason
> 
> 
> -
> 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-php mailing list

[Stefan Hinz]

Dear Jason,

maybe the problem is your provider cut CPU time to something like 6
seconds per call? Here in Germany, we have ISPs that do exactly this.
So, it's actually not a timeout but rather a "CPU out". Ask your ISP for
such restrictions.

Hope it helps.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Jason Radley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 9:11 PM
Subject: mysql-php mailing list


> I have written a php script to get all the clients
> for a mysql table and send them emails.  The
> problem is when the script is doing its job the
> browser times out and it stops the script.  so I
> am sending about 300 email out of 3000. And the
> browser said page not found.
> Any ideas?
> Thanks
> Jason
>
>






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

Reportwriters for mySQL

[Garrick S. Louie]

I was wondering what GUI reportwriters worked with mySQL.  I wanted to use a 
windows-based software for reporting and I know that Reportsmith and Crystal Reports 
are popular but do not have connections that directly support mySQL.  If I have to use 
ODBC, will I need to setup a middleware ODBC server?  How does that work and how will 
it impact performance?  Right now I use Reportsmith with Oracle and with it's direct 
connection the queries are very fast.


Thank you,
Garrick Louie

Build problems (+solution) on HPUX 10.20/gcc 2.95

[Michael Widenius]

Hi!

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

verkouter> Description:
verkouter>  I tried to compile the mysql client stuff. 
verkouter>  The first configure command was:
verkouter>  ./configure --prefix=/jaw0_3/jops/verkout --without-server 
--without-docs --without-bench --without-debug --with-pthread

verkouter>  This (obviously) did not fully work. Almost everyting was built, 
except the mysql binary (mysql{admin,show,..} were ok (and did work).
verkouter>  When compiling mysql.cc it gave *a lot* of errors, on include 
 and some other files. Mostly errors on lines wher _fpos_t and/or int64 were 
used.

verkouter>  Checked www.mysql.com. Found HPUX 10.20 build instructions.
verkouter>  Did another configure (env. vars. changes as per the webpage first).
verkouter>  ./configure --prefix=/jaw0_3/jops/verkout --without-server 
--without-docs --without-bench --without-debug --with-pthread 
--with-named-thread-libs='-ldce' --disable-shared

verkouter>  Still didn't work; the errors were still the same... I suspected they 
had to do with large-file support. Gave it another try with this configure command:
verkouter>  ./configure --prefix=/jaw0_3/jops/verkout --without-server 
--without-docs --without-bench --without-debug --with-pthread 
--with-named-thread-libs='-ldce' --disable-shared --disable-large-files

verkouter>  You guessed it: no difference.



Between the different configure attemtns, did you do 'rm config.cache'?

If not, then there is a big change that the old content of 
config.cache from the first build could have affected the later
builds.

Any change you could quickly check on your machine if the
recommended configure line from the MySQL manual would work one a
clean MySQL distribution ?

On our HPUX 10.20 machine, we use the following configure line to
build our binaries:

CFLAGS="-DHPUX -I/opt/dce/include  -O3 -fpic" CXX=gcc CXXFLAGS="-DHPUX 
-I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 " ./configure 
--prefix=/usr/local/mysql "--with-comment=Official MySQL binary" 
--with-extra-charsets=complex "--with-server-suffix="  --with-pthread 
--with-named-thread-libs=-ldce --disable-shared

And this compiles without any problems.

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: DBASE help

[Carsten H. Pedersen]

> Hi Gang, is there a feild number limit in MySql? Like in Access 
> you can only
> have 255 feilds, is this also true in MySql? or is there any limit to the
> number of feilds?

http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_5_0

(the answer is: Yes, there's a limit. But that limit is
somewhere above 2000)

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq


-
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

FROM_UNIXTIME problem

[Michael T. Babcock]

While trying to fix my previous database problem, I discovered that
FROM_UNIXTIME
does not function as I expected (or MySQL can't do math).  This is 3.23.38
(upgrading
to 3.23.40 in the next few days):

SELECT UNIX_TIMESTAMP(End_Time) - (Hours * 60 * 60) from ProjectTime;
+--+
| UNIX_TIMESTAMP(End_Time) - (Hours * 60.0 * 60.0) |
+--+
| 995986800.00 |
| 995988600.00 |
| 995999400.00 |
...

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(End_Time) - (Hours * 60 * 60)) from
ProjectTime;
+-+
| FROM_UNIXTIME(UNIX_TIMESTAMP(End_Time) - (Hours * 60.0 * 60.0)) |
+-+
| 2001-07-24 11:30:00 |
| 2001-07-24 11:30:00 |
| 2001-07-24 14:30:00 |
...

SELECT FROM_UNIXTIME(995986800);
2001-07-24 11:00:00 (not 2001-07-24 11:30:00) ... what's wrong here??
--
Michael T. Babcock



-
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-php mailing list

[Jason Radley]

I have written a php script to get all the clients
for a mysql table and send them emails.  The 
problem is when the script is doing its job the 
browser times out and it stops the script.  so I 
am sending about 300 email out of 3000. And the
browser said page not found.
Any ideas?
Thanks
Jason



-
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: SQL Error?

[Sebastiaan J.A. Kamp]

---> Reply is under the quoted text <---

=>From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
=>Subject: SQL Error?
=>
=>I have a table that contains hourly work done on projects.  It has
=>a basic structure of (extraneous fields left out):
=>
=>++--+--+
=>| Field  | Type | Null |
=>++--+--+
=>| ID | int(10) unsigned |  |
=>| ProjectID  | bigint(20)   |  |
=>| ContactID  | int(10) unsigned | YES  |
=>| NotesID| int(10) unsigned | YES  |
=>| Start_Time | datetime |  |
=>| End_Time   | datetime | YES  |
=>++--+--+
=>
=>I had made 4 entries for a day that had the wrong date;
=>eg "2001-07-01 9:00" instead of "2001-08-01 9:00".
=>
=>I did a seconds count between the incorrect times and the
=>correct times (2592000) and then ran:
=>
=>UPDATE ProjectTime set Start_Time=UNIX_TIMESTAMP(Start_Time)+2592000;
=>
=>This gave me warnings and thats when I realised that I hadn't
=>put a WHERE clause in, so I ran the same query in reverse (-2592000).
=>
=>Now all of my entries (in the entire table) have '0' for their
=>Start_Time.
=>
=>1) Is there any way (besides a restore from a 24hr old
=>backup tape) to get the old values back?
=>2) Why did these queries fail to do what I'd expected?


Michael,

As far as I know, there'll be no other solution than recovering from backup.

However, there's another "Caveat" here!

It seems to me to problems arise in your first query:
UNIX_TIMESTAMP(Start_Time)=2592000 will result in a large number, i.e.:
+---+
| UNIX_TIMESTAMP(NOW())+2592000 |
+---+
| 999888107 |
+---+
If you insert this value into a datetime column, as you've done, you're
inserting an incompatible value:
+++
| id | changed|
+++
| 10 | 2912112238 |
+++
1 row in set (0.00 sec)

mysql> update link set changed='999888107' where value=36000;
Query OK, 1 rows affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> select * from link;
+++
| id | changed|
+++
| 10 | 00 |
+++

Seems to me you'd have to convert your unixtime back to a timestamp before
inserting it:

UPDATE ProjectTime set
Start_Time=FROM_UNIXTIME(UNIX_TIMESTAMP(Start_Time)+2592000);

This should help you avoiding all zero values as a result next time.


Regards,

Sebastiaan J.A. Kamp

General Manager
VOF Post Zero
Hoogstraat 98a
3011 PT  Rotterdam
tel. +31 1 04199140
fax. +31 1 04111335
@to: [EMAIL PROTECTED]

Information & Automation Erasmus University Rotterdam
Network & system manager, Lector "New Media"
Room L5-040, Woudestein
Burgemeester Oudlaan 50
3062 PA  Rotterdam
tel. 010-4088638
@to: [EMAIL PROTECTED]

Executive Officer
Safenet BV
van Galenstraat 35
2518 EN  Den Haag
tel. 070-3642968
fax. 070-3454537
@to: [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

Solaris 8 intel Seg Fault when starting

[mbest]

>Description:

After installing mysql and running the ./bin/safe_mysqld it seg faults with a core dump

>How-To-Repeat:
/usr/local/mysql/bin/safe_mysqld

>Fix:

>Submitter-Id:  mbest
>Originator:Super-User
>Organization: 
 
>MySQL support: [none]
>Synopsis:   Seg Fault starting mysqld after install on Solaris 8 intel
>Severity:   serious
>Priority:   medium
>Category:   mysql
>Class:  support
>Release:mysql-3.23.39 (Official MySQL binary)

>Environment:

System: SunOS disco 5.8 Generic_108529-05 i86pc i386 i86pc
Architecture: i86pc

Some paths:  /usr/local/bin/perl /usr/ccs/bin/make /opt/sfw/bin/gmake 
/usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  
LDFLAGS=''
LIBC: 
-rw-r--r--   1 root bin  1579204 Nov 23  2000 /lib/libc.a
lrwxrwxrwx   1 root root  11 Aug  6 02:11 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 root bin   932532 Nov 23  2000 /lib/libc.so.1
-rw-r--r--   1 root bin  1579204 Nov 23  2000 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Aug  6 02:11 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 root bin   932532 Nov 23  2000 /usr/lib/libc.so.1
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=Official 
MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared


-
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: Logging connections

[Arjen G. Lentz]

- Original Message -
From: "Tadej Guzej" <[EMAIL PROTECTED]>


 > How would I log connections to MySQL server?
> I need the time user connects and the time user disconnects.

It's a workaround, but the general MySQL log actually has this information.
Here's a sample:

/usr/sbin/mysqld, Version: 3.23.40-log, started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time Id CommandArgument
010314 21:56:41   3 Connect [EMAIL PROTECTED] on
[...]
010314 22:00:00   3 Quit
010314 22:31:23   4 Connect Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
010314 22:32:02   5 Connect [EMAIL PROTECTED]
[...]
010314 22:33:30   5 Quit

As you see you have the time and date, then the connection ID, then the
command.
You just pick the Connect and Quit commands (probably you need client aborts
as well) for each connection ID with the date/time, and pick the address
from the connect line.

If you do log rotation, you can use a simple script to analyse the old log
and stuff the results into a database table (just don't forget that the
connection ID will be reset if you restart the server so you can't use it as
a unique key in the table).
Chances are someone has already done something like this so you may just be
able to find the script on the net!

Will this do what you require?


Regards,

Arjen.



-
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 rotating logs problem in MySQL(Linux)

[Mike Yuen]

I'm pretty new to the Linux world and i'm getting the following error:
errors occured while rotating /var/log/mysqld.log

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost'
erorr running prerotate script -- leaving old in place

Does anyone know how I can fix this on my Linux Red Hat 7 Server?

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: how to install mysql?

[Stefan Hinz]

Dear Dmitry,

> to make a web server out of my pc, just a localhost. How do I set up
mysql
> to work with php and apache?

You are mixing up web server, php and MySQL. You can use MySQL
standalone, but for PHP you will need a web server (at least on
localhost) to actually run those scripts.

Tip: Get PhpTriadSetup which will set up everything with a single
setup.exe. No need for tricky configurations etc. You can get it here:
http://sourceforge.net/projects/phptriad/

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Dmitry Kashlev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:35 PM
Subject: how to install mysql?


> How can I install mysql on apache (apache is operated by Windows Me)?
I
> downloaded php, set it up with apache on my windows Me PC, but I don't
want
> to make a web server out of my pc, just a localhost. How do I set up
mysql
> to work with php and apache?
> Your response would be greatly appreciated,
>
> Dmitry
>
>
> -
> 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: SQL Error?

[Stefan Hinz]

Dear Michael,

> put a WHERE clause in, so I ran the same query in reverse (-2592000).
> 1) Is there any way (besides a restore from a 24hr old
> backup tape) to get the old values back?

I don't think so. Maybe someone has a trick for this. I'd be interested.

> 2) Why did these queries fail to do what I'd expected?

Look what the manual (http://www.mysql.com/doc/D/A/DATETIME.html) says
about this:
"Always specify year, month, and day, even if your column types are
TIMESTAMP(4) or TIMESTAMP(2). Otherwise, the value will not be a legal
date and 0 will be stored. "

And how do you specify year / month / day? Well, like this: MMDD or
YYMMDD (if it is specified as an integer). So, 2592 is interpreted
as day 00 of month 20 of year 2592, which is an illegal date because the
month part makes no sense in this context. What does the manual say
about illegal dates?

"Illegal DATETIME, DATE, or TIMESTAMP values are converted to the
``zero'' value of the appropriate type ('-00-00 00:00:00',
'-00-00', or 00). "

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:53 PM
Subject: SQL Error?


> I have a table that contains hourly work done on projects.  It has
> a basic structure of (extraneous fields left out):
>
> ++--+--+
> | Field  | Type | Null |
> ++--+--+
> | ID | int(10) unsigned |  |
> | ProjectID  | bigint(20)   |  |
> | ContactID  | int(10) unsigned | YES  |
> | NotesID| int(10) unsigned | YES  |
> | Start_Time | datetime |  |
> | End_Time   | datetime | YES  |
> ++--+--+
>
> I had made 4 entries for a day that had the wrong date;
> eg "2001-07-01 9:00" instead of "2001-08-01 9:00".
>
> I did a seconds count between the incorrect times and the
> correct times (2592000) and then ran:
>
> UPDATE ProjectTime set Start_Time=UNIX_TIMESTAMP(Start_Time)+2592000;
>
> This gave me warnings and thats when I realised that I hadn't
> put a WHERE clause in, so I ran the same query in reverse (-2592000).
>
> Now all of my entries (in the entire table) have '0' for their
> Start_Time.
>
> 1) Is there any way (besides a restore from a 24hr old
> backup tape) to get the old values back?
> 2) Why did these queries fail to do what I'd expected?
> --
> Mike Babcock
>
>
>
> -
> 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: connection a un serveur Mysql

[Stefan Hinz]

Dear Amar,

make sure to install the databases mysql and test. This is usually done
by a script called mysql_install_db. You can find help about this topic
in http://www.mysql.com/doc/m/y/mysql_install_db.html

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Amar Msaid" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:37 PM
Subject: connection a un serveur Mysql


J'ai installe un serveur apache, un serveur Mysql et PHP4
sur un serveur Linux Redhat 7.0 ayant pour adresse IP
192.168.1.2 , que j'utilise aussi comme client. j'ai ecrit un
script PHP4 dans lequel je me connecte au serveur
Mysql

$db=mysql_connect('localhost', 'Moncpt', 'Monpasswd');

je recois le message suivant:

Mysql Connection failed: Can't connect to Mysql Server through socket
'/tmp/mysql.sock'

j'ai change l'instruction par

$db=mysql_connect('192.168.1.2', 'Moncpt', 'Monpasswd');

je recois le message

host '192.168.1.2'  is not allowed to connect to this Mysql server.

par contre a partir du shell

si je lance mysql -hlocalhost  -uMoncpte -pMonpasswd je me connect au
serveur Mysql

si je lance mysql -h192.168.1.2  -uMoncpte -pMonpasswd je recois le
message host '192.168.1.2' is not allowed to connect to this Mysql
server.

Quel est le probleme ?  Merci.



-
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 URL / JDBC connection trouble

[Venu]

Hi !

)-Original Message-
)From: [EMAIL PROTECTED]
)[mailto:[EMAIL PROTECTED]]On Behalf Of Charles Megnin
)Sent: Wednesday, August 08, 2001 8:55 AM
)To: [EMAIL PROTECTED]
)Subject: Re: database URL / JDBC connection trouble
)
)
)Mark -
)thanks for your input.
)I am using RH 6.2
)however
)
)charly@theblueplanet[24]  cat /etc/hosts
)127.0.0.1 localhost.localdomain localhost
)
)Besides, I've added 127.0.0.1 explicitely in the db table
)& tried to connect via that IP address
)rather than localhost, to no avail.
)Incidentally, I am using the mm.mysql-2.0.6.1.jar driver
)Charles
)

Try:
GRANT ALL ON *.* TO me_as_jdbc_user@% IDENTIFIED BY "my_password"

This will grant access to me_as_jdbc_user from everywhere (which is a
security problem). If your Windoze machine has the IP "62.122.22.33", better
take "me_as_jdbc_user@"62.122.22.33" instead of "%" (= all).

Also, please check the following online MySQL manual for more on security.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#General_security

Hope it helps you.
Regards,
venu
--
For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Redwood city, California  USA
   <___/   www.mysql.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: error connecting to mysql using JDBC

[Venu]

Hi !

)-Original Message-
)From: Danny Khow [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, August 08, 2001 8:15 AM
)To: [EMAIL PROTECTED]
)Subject: error connecting to mysql using JDBC
)
)
)MySQL reported this error when i tried to connect using JDBC :
)
)Error during query: Unexpected Exception: java.sql.SQLException message
)given: Communication link failure: java.io.IOException
)
)the funny thing about the error is that it only happens once in a while.
)Meaning that an SQL statement might be working fine today but when
)i test it
)the next day without even modifying anything at all i will get this error
)

It looks some thing related to threading and/or timing. You said, you are
not able to re-produce it every time. Is it possible for you to make it
every time and send the sample or atleast the code which is causing the
problem ? Becuase this type of things (Communication failure) needs to be
fixed from the driver/server point of view, else this will defiantly causes
problem in heavy loads.

Thanks in advance
Venu
--
For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Woodside, California  USA
   <___/   www.mysql.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

MERGE tables and UNION joins

[David Newman]

I'm having trouble getting MySQL's union join to work when merging tables
from different databases. MySQL complains with "ERROR 1017: Can't find file:
'total.MRG' (errno: 2)" even though this file exists.

Here are the commands I use to produce the error. Please let me know how I
can get union joins working. Thanks!

create database v1;
use v1;
create table v1 (type varchar(10), price double);
insert into v1 (type, price) values ('cheap','10');
create database v2;
use v2;
create table v2 (type varchar(10), price double);
insert into v2 (type, price) values ('pricy','50');
create database total;
use total;
create table total (type varchar(10), price double)
type=merge union=(v1.v1, v2.v2);

Up to this point MySQL is happy. Then, when I say:

select * from total;

MySQL responds with:

ERROR 1017: Can't find file: 'total.MRG' (errno: 2)

The file exists. I have permissions to use it. Again, how can I do union
joins across multiple databases?

Thanks

David Newman




-
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

Bug with MySQL replication of "error 'unexpected success or fatal error' on query 'create database db2183-2'"

[Kevin Green]

>Description:

I don't have an absolutely 100% complete description of the problem, but I
guess it's easy to figure out what happened...

Basically I came to the situation when the slave was down thusly:

mysql> show slave status;
+-+-+-+---+-
-+--+---+-+-
++--
-+--+
| Master_Host | Master_User | Master_Port | Connect_retry |
Log_File | Pos  | Slave_Running | Replicate_do_db |
Replicate_ignore_db | Last_errno | Last_error
| Skip_counter |
+-+-+-+---+-
-+--+---+-+-
++--
-+--+
| coulds07.netbenefit.com | admin   | 3306| 60|
coulds07-bin.008 | 25262417 | No| |
| 4294967295 | error 'unexpected success or fatal error' on query 'create
database db2183-2' | 0|
+-+-+-+---+-
-+--+---+-+-
++--
-+--+

This database didn't exist at the filesystem level (ie. in /var/lib/mysql/
there was no "db2183-2" directory), didn't exist in MySQL (a "use db2183-2"
didn't go for it).

So I'm surmising that someone attempted to create an illegally named
database on the master, and this failed command was incorrectly passed
through to the slave, when it should have been trapped, and caused
replication to stop.

>How-To-Repeat:
It's a production system. I really can't afford to try and replicate it, but
I'm quite sure that doing a "create database [illegal db name]" on a master
server would cause this to happen.

I've looked through all the changelogs to see if this bug has been fixed
yet, and it doesn't appear to have been. So I thought it was worth reporting
it anyway.

>Fix:   
On slave:

SET SQL_SLAVE_SKIP_COUNTER=1;
SLAVE START;

Repeat as necessary depending on how many times moronic user on the master
has tried to create the database which has a duff name.

>Submitter-Id:  
>Originator:root
>Organization:  Netbenefit Plc
>MySQL support: none
Synopsis:   Replication failure brought on by attempts to create an
illegally named database on
>Severity:  serious
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.22.38 (Official MySQL RPM)

>Environment:
System: Linux version 2.2.13 ([EMAIL PROTECTED]) (gcc version
egcs-2.91.60 19981201 (egcs-1.1.1 release)) #3 SMP Fri Jan 7 17:49:10 GMT
2000
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='egcs'  CFLAGS='-O6 -fomit-frame-pointer -mpentium'
CXX='egcs'  CXXFLAGS='-O6 -fomit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
Configure command: ./configure  --disable-shared
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL
RPM'
Perl: This is perl, version 5.004_04 built for i386-linux

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

[jurban]

Have a look at urSQL -- http://www.urbanresearch.com/ursql/urquery.php

urSQL is a query editor (much like a text editor with database/query
support and SQL syntax highlighting).  It has the capability to connect
directly to your server and submit the query.  The History feature keeps
track of each query that is submitted to the database.  You also have the
option of saving, opening, and editing existing queries.  

On Wed, 8 Aug 2001, Naintara Jain wrote:

> actually all i need to know is say i type in a long sql query and make a
> typing error, is there any convenient way to retain the query and make the
> correction without having to re-type the entire query?
> eg. when i work with sybase on linux, i simply use 'vi' within sybase and
> can correct the last query in memory. Even Oracle has an editor for
> saving/editing queries and running them.
> 
> I don't really need a query-creator. If i use notepad, copy and paste
> doesn't seem to work -- MSDOS hangs. Do i need to make them into script
> files and then run?


-
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: LOAD DATA INFILE performance testing

[Michael Widenius]

Hi!

> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:

Sinisa> Jeff Tanner writes:
>> 
>> I running a test on mysql to test its performance of doing a bulk insert
>> into a table using LOAD DATA INFILE.
>> 
>> The table is simple:
>> 
>> CREAT TABLE test (
>> valueCHAR(32) NOT NULL PRIMARY KEY
>> )
>> 
>> The test is simple:
>> a) clear table
>> b) time performance of inserting X unique values into table from a
>> single file (each value on a new line)
>> 
>> # of unique values   time in seconds
>> 100.05
>> 100   0.05
>> 1K0.10
>> 10K   0.75
>> 100K10
>> 500K  125
>> 1M 500
>> 5M  55000
>> 
>> My concern is the last entry of 5 million entries. Is there a mysql system
>> variable I should reset to improve performance?
>> 
>> Thanks
>> 
>> Jeff Tanner
>> Viathan
>> Seattle, WA 

Sinisa> No, but you could crate a table without index and add primary key
Sinisa> after loading of data.

Actually MySQL is already doing this when you do LOAD DATA INFILE to
a table without any rows.

Jeff, what you can do is to start mysqld with a much bigger value for
'myisam_sort_buffer_size' and see if this helps.

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: database URL / JDBC connection trouble

[Venu]

Hi !

)-Original Message-
)From: Mark Matthews [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, August 08, 2001 5:48 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: RE: database URL / JDBC connection trouble
)
)
)There is no problem with your URL. The message you are receiving comes from
)the database. Your network permissions are not setup to allow TCP/IP
)connections from localhost (or my bet, you're on Redhat which brokenly maps
)127.0.0.1 to "localhost.localdomain"). You will need to add grants to allow
)connections from whatever 127.0.0.1 on your system maps to. See
)chapter 6 of
)your MySQL server manual for a very in-depth description of how to setup
)security.
)

Also, please read the previous mails in the JAVA/JDBC section of
lists.mysql.com, where in you can find the solution.

Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Redwood city, California  USA
   <___/   www.mysql.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: DBASE help

[Glyndower]

Hi Gang, is there a feild number limit in MySql? Like in Access you can only
have 255 feilds, is this also true in MySql? or is there any limit to the
number of feilds?


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

[Ganz, Will]

What I do is use the 'source' command. Now, I am assuming that you are
running under Win32 since you said "MSDOS hangs." Write the SQL command in
your favorite text edior and save. At the mySQL prompt enter the keyword
'source' and then drag&drop the filename unto the MSDOS window. Change the
'\' to '/' in the command line. Put the semicolon at the end, press ENTER,
and Voila' you have the command executed. 

Example:

source C:/usr/bin/mysql/sql/updateALL.sql;


HTH

Will

-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 9:13 AM
To: Naintara Jain; Stefan Hinz; mysql
Subject: Re: editor


Dear Naintara,

>I don't really need a query-creator. If i use notepad, copy and paste
>doesn't seem to work -- MSDOS hangs. Do i need to make them into script
>files and then run?

I assume you run MySQL under Windows 9x. Here, the MySQL Monitor does
not supply a history list by default.

Simply start c:\mysql\bin\mysqlc.exe instead - and the history list is
there! :)
(Note: You will have to copy cygwinb19.dll to your windows/system
directory before using mysqlc.)

You can even type your statement with any editor (notepad etc.) and then
start MySQL in batch mode. This is how you do it:

1. Type the statements, each ended by a semicolon, something like this:
USE test;
CREATE TABLE test_table (testcol INT NOT NULL);
INSERT INTO test_table VALUES (1), (2), (3);
etc.
2. Save the file. For the next step, I assume you save it to
c:\mysql\bin
3. Start mysql.exe (not mysqlc.exe!) from the DOS command line, in batch
mode, like this:
mysql < the_file_i_typed_in_notepad.txt

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "Stefan Hinz" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 3:34 PM
Subject: RE: editor


Dear Stefan,

thanks for your input.
actually all i need to know is say i type in a long sql query and make a
typing error, is there any convenient way to retain the query and make
the
correction without having to re-type the entire query?
eg. when i work with sybase on linux, i simply use 'vi' within sybase
and
can correct the last query in memory. Even Oracle has an editor for
saving/editing queries and running them.

I don't really need a query-creator. If i use notepad, copy and paste
doesn't seem to work -- MSDOS hangs. Do i need to make them into script
files and then run?

regards,

-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:38 AM
To: Naintara Jain; mysql
Subject: Re: editor


Dear Naintara,

what about Notepad (the windows standard editor)?

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 7:02 PM
Subject: editor


> is there any editor available (eg vi on UNIX) that runs on MS-DOS to
make
> writing queries easier in MYSQL. I am a newbie.
>
>
> -
> 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

Re: editor

[Tadej Guzej]

You can try FreeMascon.
It's a windows grafical UI client for MySQL. There you can find a query
editor that even highlights syntax. And it's free.
download at www.scibit.com

HTH, Tadej


- Original Message -
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "Stefan Hinz" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 2:34 PM
Subject: RE: editor


> Dear Stefan,
>
> thanks for your input.
> actually all i need to know is say i type in a long sql query and make a
> typing error, is there any convenient way to retain the query and make the
> correction without having to re-type the entire query?
> eg. when i work with sybase on linux, i simply use 'vi' within sybase and
> can correct the last query in memory. Even Oracle has an editor for
> saving/editing queries and running them.
>
> I don't really need a query-creator. If i use notepad, copy and paste
> doesn't seem to work -- MSDOS hangs. Do i need to make them into script
> files and then run?
>
> regards,
>
> -Original Message-
> From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 12:38 AM
> To: Naintara Jain; mysql
> Subject: Re: editor
>
>
> Dear Naintara,
>
> what about Notepad (the windows standard editor)?
>
> Regards,
>
> --
>   Stefan Hinz
>   Geschäftsführer / CEO iConnect e-commerce solutions GmbH
>   #  www.js-webShop.com www.iConnect.de
>   #  Gustav-Meyer-Allee 25, 13355 Berlin
>   #  Tel: +49-30-46307-382  Fax: +49-30-46307-388
>
> - Original Message -
> From: "Naintara Jain" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL PROTECTED]>
> Sent: Monday, August 06, 2001 7:02 PM
> Subject: editor
>
>
> > is there any editor available (eg vi on UNIX) that runs on MS-DOS to
> make
> > writing queries easier in MYSQL. I am a newbie.
> >
> >
> > -
> > 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

Re: Migrating to MS SQL Server

[Grigory Bakunov]

Date |Tue, 07 Aug 2001 13:24:02 +0200
>From |Frank Fisher <[EMAIL PROTECTED]>

Hello!

FF> My company just stole my web server running MySQL.  I will now have to 
FF> host my site on a consolidated server that has MS SQL Server.

FF> How do I migrate?  I think my SQL code will be good except for 
FF> auto_increment, but are there any migration tools?

FF> Frank Fisher
You can try to use output of 'mysqldump' tool
and change it by 'sed' or some other automatic editor.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.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: Localization..

[Grigory Bakunov]

Date |Wed, 8 Aug 2001 03:05:20 +0800
>From |"SDiZ Cheng" <[EMAIL PROTECTED]>

Hello!


SC> Yes, i have read that too.
SC> that tell me how to compile mysql with multi charset,
SC> but not create such kind of table.

SC> i expect there is somthing like
SC> CREATE TABLE tbl_name ( 
SC> col_name type CHARSET=char_set, 
SC> col_name2 type CHARSET=char_set2 ) ...

SC> CREATE DATABASE db_name DEFAULT_CHARSET=char_set 
SC> where can i find these?
Aha. so, i think nowhere.
You can't do that.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.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: database URL / JDBC connection trouble

[Charles Mégnin]

Mark -
thanks for your input.
I am using RH 6.2
however

charly@theblueplanet[24]  cat /etc/hosts
127.0.0.1 localhost.localdomain localhost

Besides, I've added 127.0.0.1 explicitely in the db table
& tried to connect via that IP address
rather than localhost, to no avail.
Incidentally, I am using the mm.mysql-2.0.6.1.jar driver
Charles

for Mark Matthews wrote:

> There is no problem with your URL. The message you are receiving comes from
> the database. Your network permissions are not setup to allow TCP/IP
> connections from localhost (or my bet, you're on Redhat which brokenly maps
> 127.0.0.1 to "localhost.localdomain"). You will need to add grants to allow
> connections from whatever 127.0.0.1 on your system maps to. See chapter 6 of
> your MySQL server manual for a very in-depth description of how to setup
> security.
>
> -Mark




-
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 connecting to mysql using JDBC

[Danny Khow]

MySQL reported this error when i tried to connect using JDBC :

Error during query: Unexpected Exception: java.sql.SQLException message
given: Communication link failure: java.io.IOException

the funny thing about the error is that it only happens once in a while.
Meaning that an SQL statement might be working fine today but when i test it
the next day without even modifying anything at all i will get this error


-
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: Why is there no mysql hpux11 binary for hppa1.1 (32 Bit) database

[Sinisa Milivojevic]

Andre Konopka writes:
> Hi,
> 
> since .38 there is no longer a HPUX11 binary for the hppa1.1 architecure
> (32 Bit)??
> 
> 
> I think that the 10.20 binary is runnable but I suppose that you
> compiled it
> with MIT-threads. On HP-UX11 I would prefer to compile it with native
> threads, do you agree?
> The 10.20 binary version isn't compiled with INNOBASE???
> 
> Thanks  Andre
> 

Do not use 10.20 binary.

As your OS / CPU combo is rare, you could build MySQL yourself. With
InnoDB.

Just follow closely instructions from our manual , especially
regarding patches for 11.0 , compiler etc ...

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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

SQL Error?

[Michael T. Babcock]

I have a table that contains hourly work done on projects.  It has 
a basic structure of (extraneous fields left out):

++--+--+
| Field  | Type | Null |
++--+--+
| ID | int(10) unsigned |  |
| ProjectID  | bigint(20)   |  |
| ContactID  | int(10) unsigned | YES  |
| NotesID| int(10) unsigned | YES  |
| Start_Time | datetime |  |
| End_Time   | datetime | YES  |
++--+--+

I had made 4 entries for a day that had the wrong date;
eg "2001-07-01 9:00" instead of "2001-08-01 9:00".

I did a seconds count between the incorrect times and the
correct times (2592000) and then ran:

UPDATE ProjectTime set Start_Time=UNIX_TIMESTAMP(Start_Time)+2592000;

This gave me warnings and thats when I realised that I hadn't
put a WHERE clause in, so I ran the same query in reverse (-2592000).

Now all of my entries (in the entire table) have '0' for their
Start_Time.

1) Is there any way (besides a restore from a 24hr old
backup tape) to get the old values back?
2) Why did these queries fail to do what I'd expected?
-- 
Mike Babcock



-
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: load multiple files into the same table at once?

[Bing Du]

Hrmm...from my testing, omitting REPLACE has the same effect as IGNORE is used.

Bing

Bing Du <[EMAIL PROTECTED], 979-845-9577>
Texas A&M University, CIS, Operating Systems, Unix

>>> [EMAIL PROTECTED] 08/08/01 02:50AM >>>
Dear Bing,

what about omitting REPLACE? This should simply load the data into your
table, adding (inserting) the new records.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de 
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 10:26 PM
Subject: load multiple files into the same table at once?


> Hi,
>
> If this kind of question has been asked and answered, I'd appreciate
if
> somebody can point me to the right direction looking for the answers.
>
> The question is how I should load different external text files into
> different columns of the same table.  For instance, file1.txt contains
> 'ssn name' and file2.txt contains 'ssn grade'.  These two files are
> generated by different organizations and we want to put both name and
> grade info into the same table.
>
> The table named students contains three columns: ssn name grade.
> One sample record is like:
>
> ssn   namegrade
> -   
> 123456789 John Smith 95%
>
> I tried:
>
> mysql> load data local infile '/home/file1.txt' replace into table
> students (ssn,name);
>
> mysql> load data local infile '/home/file2.txt' replace into table
> students (ssn,grade);
>
> But the second 'load data' replaces all the stuff that the first one
> just loaded.
>
> If I use 'ignore', the grades can not get loaded at all.
>
> Any help would be greatly appreciated.
>
> Bing
>
> Bing Du <[EMAIL PROTECTED], 979-845-9577>
> Texas A&M University, CIS, Operating Systems, Unix
>
> -
> 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

how to install mysql?

[Dmitry Kashlev]

How can I install mysql on apache (apache is operated by Windows Me)? I
downloaded php, set it up with apache on my windows Me PC, but I don't want
to make a web server out of my pc, just a localhost. How do I set up mysql
to work with php and apache?
Your response would be greatly appreciated,

Dmitry


-
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: Bad path to ibpthread.so.14.20?

[Gerald Clark]

1. Add the path to /etc/ld.so.conf
2. Run ldconfig

Adam Douglas wrote:

> I'm installed MySQL 3.23.37 and I can't get it started. I know there has be
> number of posts regarding such a problem but I haven't seen a resolution to
> fix mine specificly. I get this error when I try and load mysqld
> 
> /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or
> directory
> Starting mysqld daemon with databases from /var/mysql
> 010807 15:42:38  mysqld ended
> 
> Now I know the file is located at /usr/local/lib/pth/libpthread.so.14.20 but
> where is the location for me to fix this bad path? Funny thing is I had
> MySQL Daemon running just fine but when I did a reboot I haven't been able
> to start it since. I can go ldconfig -m /usr/local/lib/pth/ and that seems
> to fix the problem for that session. Once a reboot of the system is done the
> path is no longer known.
> 
> Frustration is settling in very quickly .
> 
> -
> 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

connection a un serveur Mysql

[Amar Msaid]

J'ai installe un serveur apache, un serveur Mysql et PHP4
sur un serveur Linux Redhat 7.0 ayant pour adresse IP
192.168.1.2 , que j'utilise aussi comme client. j'ai ecrit un
script PHP4 dans lequel je me connecte au serveur
Mysql

$db=mysql_connect('localhost', 'Moncpt', 'Monpasswd');

je recois le message suivant:

Mysql Connection failed: Can't connect to Mysql Server through socket '/tmp/mysql.sock'

j'ai change l'instruction par

$db=mysql_connect('192.168.1.2', 'Moncpt', 'Monpasswd');

je recois le message

host '192.168.1.2'  is not allowed to connect to this Mysql server.

par contre a partir du shell

si je lance mysql -hlocalhost  -uMoncpte -pMonpasswd je me connect au serveur Mysql

si je lance mysql -h192.168.1.2  -uMoncpte -pMonpasswd je recois le message host 
'192.168.1.2' is not allowed to connect to this Mysql server.
 
Quel est le probleme ?  Merci.

Re: editor

[Stefan Hinz]

Dear Naintara,

>I don't really need a query-creator. If i use notepad, copy and paste
>doesn't seem to work -- MSDOS hangs. Do i need to make them into script
>files and then run?

I assume you run MySQL under Windows 9x. Here, the MySQL Monitor does
not supply a history list by default.

Simply start c:\mysql\bin\mysqlc.exe instead - and the history list is
there! :)
(Note: You will have to copy cygwinb19.dll to your windows/system
directory before using mysqlc.)

You can even type your statement with any editor (notepad etc.) and then
start MySQL in batch mode. This is how you do it:

1. Type the statements, each ended by a semicolon, something like this:
USE test;
CREATE TABLE test_table (testcol INT NOT NULL);
INSERT INTO test_table VALUES (1), (2), (3);
etc.
2. Save the file. For the next step, I assume you save it to
c:\mysql\bin
3. Start mysql.exe (not mysqlc.exe!) from the DOS command line, in batch
mode, like this:
mysql < the_file_i_typed_in_notepad.txt

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "Stefan Hinz" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 3:34 PM
Subject: RE: editor


Dear Stefan,

thanks for your input.
actually all i need to know is say i type in a long sql query and make a
typing error, is there any convenient way to retain the query and make
the
correction without having to re-type the entire query?
eg. when i work with sybase on linux, i simply use 'vi' within sybase
and
can correct the last query in memory. Even Oracle has an editor for
saving/editing queries and running them.

I don't really need a query-creator. If i use notepad, copy and paste
doesn't seem to work -- MSDOS hangs. Do i need to make them into script
files and then run?

regards,

-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:38 AM
To: Naintara Jain; mysql
Subject: Re: editor


Dear Naintara,

what about Notepad (the windows standard editor)?

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 7:02 PM
Subject: editor


> is there any editor available (eg vi on UNIX) that runs on MS-DOS to
make
> writing queries easier in MYSQL. I am a newbie.
>
>
> -
> 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

salvaging database

[Jack Cushman]

Hi--

I am trying to recreate a table. I have the .frm and .isd files, but not the
.ism.

I assume it is impossible to recover the data (please tell me if I am
mistaken!), but is there any way I can get a description of the table from
the .frm? I inherited the database from someone else, and I don't know the
size and type of all the fields.

Thanks for your help,
Jack Cushman

(Please CC me; I'm not on the list)


-
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

Answer to ---> Re: DBASE query question.

[Scott Matthews]

In Dbase, do the following to get more information:

1. Type Dbase 
2.  Get to the "Dot" (.) prompt if you are not already there.  You may have 
to hit the escape key.
3. Type in "Help Join".


At 11:43 AM 8/8/2001 +0800, rsaras wrote:
>hai
>  In mysql it can be done but do anyone know how to join  table in DBASE?
>
>The situation :-
>
>  table 1
>  -
>EM_id
>EM_gender
>
>table 2
>-
>EN_id
>EN_name
>
>The question is how to select all field from table1 and EN_name from 
>table2  at
>one query? .The EM_id and  EN_id is same.Is that any idea.
>please help me.
>
>
>thanks in advance.
>
>
>


-
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: Upgrading to 3.23.37 from 3.22.32

[Gerald Clark]

Except, mysql needs write permission.

Adam Douglas wrote:

> MySQL reports read only table. As for file permissions, everything is fine.
> Everyone has read and execute privileges.
> 
> 
>> They are probably not owned by mysql anymore.
>> 
>> Adam Douglas wrote:
>> 
>> 
>>> I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was
>>> pkg_delete the old MySQL and install the new one. Before I 
>> 
>> delete the old
>> 
>>> MySQL I copied all the database files to a temporary 
>> 
>> location. Once the new
>> 
>>> installation was successful I copied over all the database 
>> 
>> files into the
>> 
>>> proper location. 
>>> 
>>> My problem is I seem to have 3 extra tables now, A-1, A-9 
>> 
>> and A-ce. The
>> 
>>> funny thing is they all seem to be linked to my tables. 
>> 
>> These tables to my
>> 
>>> knowledge were not present in the MySQL 3.22.32. Also I 
>> 
>> can't seem to remove
>> 
>>> the test user from mysql->db, MySQL says it's read only. I 
>> 
>> never made the
>> 
>>> table read only and doesn't seem to be.
>>> 
>>> Anyone have any ideas of what is going on? I feel kind of 
>> 
>> lost now, any help
>> 
>>> would be greatly appreciated.
>> 


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

[Naintara Jain]

Dear Stefan,

thanks for your input.
actually all i need to know is say i type in a long sql query and make a
typing error, is there any convenient way to retain the query and make the
correction without having to re-type the entire query?
eg. when i work with sybase on linux, i simply use 'vi' within sybase and
can correct the last query in memory. Even Oracle has an editor for
saving/editing queries and running them.

I don't really need a query-creator. If i use notepad, copy and paste
doesn't seem to work -- MSDOS hangs. Do i need to make them into script
files and then run?

regards,

-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:38 AM
To: Naintara Jain; mysql
Subject: Re: editor


Dear Naintara,

what about Notepad (the windows standard editor)?

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 7:02 PM
Subject: editor


> is there any editor available (eg vi on UNIX) that runs on MS-DOS to
make
> writing queries easier in MYSQL. I am a newbie.
>
>
> -
> 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: My databases got hosed when the server went down hard!

[Chip]

Stefan Hinz wrote:

> Dear Chip,
>
> myisamchk is not an SQL command, so it's not executed from the MySQL
> Monitor (the SQL command line tool) but rather from a shell. Type
> "myisamchk" at the shell prompt and you will see the options.
>

Thanks, I'm discovering there are a few of these commands to run from the
shell prompt, not from within MySQL.
Thanks,
--
Chip

>
> Or you can use the new version of PhpMyAdmin (www.phpmyadmin.com), this
> has a built-in table check & table repair part.
>
> Regards,
>
> --
>   Stefan Hinz
>   Geschäftsführer / CEO iConnect e-commerce solutions GmbH
>   #  www.js-webShop.com www.iConnect.de
>   #  Gustav-Meyer-Allee 25, 13355 Berlin
>   #  Tel: +49-30-46307-382  Fax: +49-30-46307-388
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 07, 2001 8:37 PM
> Subject: My databases got hosed when the server went down hard!
>
> > Geez, if it ain't one thing it's another. :-(
> > My fbsd server went down hard today, now my mysql database is
> supposedly
> > gone.
> > I see the .MYD, .MYI, and .FRM files in the /usr/var/db/mysql/
> directory,
> > but I get this -
> >
> > mysql> use bulletins
> > Can't read dir of './bulletins/' (Errcode: 13)
> > Database changed
> > mysql> show tables;
> > ERROR 12: Can't read dir of './bulletins/' (Errcode: 13)
> > mysql> myisamchk -s /usr/var/db/mysql/bulletins/*.MYI;
> > ERROR 1064: You have an error in your SQL syntax near 'myisamchk -s
> /usr/var/db/mysql
> > /bulletins/*.MYI' at line 1
> >
> > Obviously I don't know how to use myisamchk properly.
> > In Webmin I see the icons for the database, but when I select it the
> screen changes and shows
> > This database has no tables.
> >
> > Hopefully these files can be restored, I can view them with cat and
> they do contain the
> > data that was entered previously.
> >
> > Chip Wiegand
> > Computer Services
> > www.simradusa.com
> > [EMAIL PROTECTED]
> > Simrad, Inc
> > Lynnwood, WA
> > 425-712-1138
> >
> > "There is no reason anyone would want a computer in their home."
> >  --Ken Olson, president, chairman and founder of Digital Equipment
> Corp.,
> > 1977
> >   (-- Then why do I have nine? Somebody help me!)
> >
> >
> > -
> > 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

--
Regards,

--
Chip Wiegand
CRW Computer Services
www.wiegand.org
[EMAIL PROTECTED]
<-->
  Web page design
Consulting
 PC Repair
<-->




-
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: Timezone problem.

[Heikki Tuuri]

Ok :)

the problem solved. It was a wrong glibc after all.

Regards,

Heikki

At 01:07 PM 8/8/01 +0400, you wrote:
>Hello Heikki,
>
>  Sorry for confuse. The problem is The first complied binary I've
>  checked which was fine was complied with --with-other-glibc=XXX
>  therefore the correct option is  --with-other-libc=XXX.  So the
>  problem is with my self compiled GLIBC.
>
>  The small problem in mysql is it does not check if parameter is
>  correct in configure script - this produced the problem...
>  
>
>  
>
>-- 
>Best regards,
> Peter  mailto:[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+gemini compile errors

[Michael Furgal]

Hello:

The file db/tstset.cc holds all the different versions of
how to do an atomic test+set of a bit.  If you are on an 
Intel box, you should be using the section of code that 
uses the xchg instruction.  The configure script should be
setting a #define for the machine.  (check config.h).  This
#define along with a $MACHINE environment variable are used
to get the correct tstset() call out of db/tstset.cc.

Hope this helps

MikeF
-- 
--
Mike Furgal- The Database Guy
http://www.nusphere.com- Delivering Enhanced MySQL
--

> Hello,
> SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc
> gcc version 2.95.3 20010315 (release)
> 
> I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box.
> I get the following error which has me completly confussed:
> 
> ctstset: Compile tstset.cc --> tstset.[c|s] --> tstset.o
> Assembler:
> "tstset.s", line 43 : Illegal mnemonic
  [snip]
> 
> --
> Brian Millett
> Enterprise Consulting Group "Shifts in paradigms
> (314) 205-9030 often cause nose bleeds."
> [EMAIL PROTECTED]   Greg Glenn

-
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 URL / JDBC connection trouble

[Mark Matthews]

There is no problem with your URL. The message you are receiving comes from
the database. Your network permissions are not setup to allow TCP/IP
connections from localhost (or my bet, you're on Redhat which brokenly maps
127.0.0.1 to "localhost.localdomain"). You will need to add grants to allow
connections from whatever 127.0.0.1 on your system maps to. See chapter 6 of
your MySQL server manual for a very in-depth description of how to setup
security.

-Mark


-
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: Can't start MYSQL on Linux

[Ling Wang]

I got it. Thank you very very much for the help.
Ling

>From: Trond Eivind Glomsrød <[EMAIL PROTECTED]>
>To: Ling Wang <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Re: Can't start MYSQL on Linux
>Date: Tue, 7 Aug 2001 23:03:41 -0400 (EDT)
>
> >On Wed, 8 Aug 2001, Ling Wang wrote:
>
> > I have to login as root user to do mysql_install_db and safe_mysqld &.
> > Otherwise I will get permission denied message.
>
>You already made those files, and they're owned by root. You can't
>overwrite them that way.
>
>Just do a chown before you start the database.
>
> > How come when I type service mysqld start, Linux says command not found? 
>I
> > could not find the command chkconfig either.
>
>Both are not path of a user's path[1] - they're admin tools, and are for
>the use of root. Root can also control which services start with "tksysv"
>and "ntsysv".
>
>[1] They're in /sbin, for the curious.
>--
>Trond Eivind Glomsrød
>Red Hat, Inc.
>
>
>-
>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
>


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


-
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 and PHP

[Robinson, Mike]

I've had no problems at all with this setup.
Locate libmysqlclient.so.10 and make sure the
dir its in is in /etc/ld.so.conf, and run ldconfig.
>From a source install, its in /usr/local/mysql/lib/mysql.

 Mike Robinson
 IT / Developer - Toronto Star TV
 Phone: 416.945.8786
 Fax: 416.869.4566
 Email: [EMAIL PROTECTED]


-Original Message-
From: Nicholas Ritter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 3:55 PM
To: MySQL
Subject: Re: MySql and PHP


Speaking of Mysql and PHP, has anyone had a problem compiling PHP 4.0.6 (as
a DSO) with MySQL 3.23.40 in use with Apache 1.3.14 on a redhat 7.0 box?

The error I get occurs when I run apache, during startup it says that it can
load the php module because the libmysqlclient.so.10 file cannot be found,
even though the file is there. Any thoughts?

I figured I would ask here before asking the PHP list because they never
seem to be of much help.

Nicholas



-
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

Why is there no mysql hpux11 binary for hppa1.1 (32 Bit) database

[Andre Konopka]

Hi,

since .38 there is no longer a HPUX11 binary for the hppa1.1 architecure
(32 Bit)??


I think that the 10.20 binary is runnable but I suppose that you
compiled it
with MIT-threads. On HP-UX11 I would prefer to compile it with native
threads, do you agree?
The 10.20 binary version isn't compiled with INNOBASE???

Thanks  Andre

database,sql,query,table

-
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: Installing mysql-3.23.40 on Solaris 2.6

[Sinisa Milivojevic]

Emmanuel Tubacher writes:
> Hi,
> 
> I am new to this list -and somehow to Mysql- so apologies if this topic
> already
> been covered (list archives ?? where ??).
> 
> I try to install a mysql 3.23.40 version on a Solaris 2.6 with gcc
> 2.95.2 and
> it just won't complete compilation or even configuration. 
> Depending on the flags placed in the ./configure  command line I get a
> wide variety of troubles : 
> --all-static not allowed in 2.6 because of missing libraries, ld
> troubles in the end of the 
> compilation, c++ compilation errors and so on...
> 
> I'm not the maintainer of the system and we just can't upgrade our
> servers to Solaris 2.7.
> 
> Has anyone succeeded in compiling this version on this OS and how ?
> 
> Binary tarball for Solaris 2.7+ doesn't work of course, because of the
> absence of libcrypt_1.so 
> library in Solairs 2.6.
> 
> I badly need to upgrade my 3.22 version in order to use COUNT(DISTINCT )
>  
> SQL limitations,databases dumps and users admin in Mysql are really
> frustrating 
> when you come from SGBD like Sybase. I know Mysql growing up fast, but
> for now...
> 
> BTW : how to upgrade a server from 3.22 to 3.23 ? The web site says that
> there is no
> compatibility issue, great ! But the key question remains : what has to
> be replaced
> in the mysql directory ? Only the executables un mysql/bin or more ?
> 
> Many thanks for your help.
> -- 
> Emmanuel.

Hi!

If you follow instructions in the manual, section on 2.6, you will
have no problem building it.

Do not try static builds, as it is impossible on Solaris.

To convert mysql database from 3.22 to 3.23 use a script provided for
the purpose.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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: AW: Compiling error in complete.c: filename_completion_function

[Sinisa Milivojevic]

Sebastian Kayser writes:
> Sinisa Milivojevic writes:
> 
> 
> The dirent.h file is located @
> 
> /usr/include/
> /usr/src/linux/include/linux/
> 
> and in various directories below
> 
> /usr/src/mysql-3.23.40/
> 
> and each of these files seems to be ok.
> 

This is not ok. There should not be any dirent.h in mysql-3.23.40
except in mit-threads, and you should not use MIT threads on your
system.

Check out which dirent file got included and how is DIR defined in it.

You must use a pager with gcc -E to get anything usefull.

> Hope you can help again. I'm a bit of unexperienced concerning these
> things. 
> 
> Regards,
> 
> Sebastian Kayser

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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: MySQL++ API under Mac OS X

[Sinisa Milivojevic]

Halim Chtourou writes:
> 
> I'm using GCC 2.95.2 that comes with Apple's developer tools. I'm 
> getting tempted to try compiling GCC 3.
> 
> Doing a grep for the above symbols returns matches for both the static 
> and dynamic libsqlplus libraries, as well as libstdc++.a, which is 
> automatically linked in with C++ code. I even  tried manually adding 
> -lstdc++ but that didn't help. I've also tried defining various STL 
> options related to templates and several different compiler options, 
> without much success. Is this simply incompatible with GCC  version 
> 2.95.2?
> 
> 
> -Halim
> 

You are using the right compiler. 

What you should check are symlinks to dynamic and static versions of
libstdc++. 

They should point out to the stdc++ that came with gcc 2.95.2. 

If that does not help, add a full path to the correct libstdc++ in
your linker command.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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

Updating to v 3.23.40

[Lucy]

Hi
I've been running v.3.23.33 on Win2000 and have upgraded to v.3.23.40.  I
unzipped the file to the mysql dir, and let it write over files.  The Manual
doesn't state you have to remove older version.  The readme notes said it's
not necessary to run install programs.  But the MySQL monitor Welcome
message is still saying the old version, as does a status check.

I dont need to start the server, it automatically starts up.  In the
original installation, v.3.23.33, I changed the "my.cnf" file to read the d:
drive location for mysql dir and so don't need to refer to Environ
Variables.  As mysql location is still unchanged I haven't needed to alter
my.cnf.
But what do I need to run to get updated version?  Thanks.  Lucy


-
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: Logging connections

[Tadej Guzej]

Well, the problem is that I don't know how to determine when a user
connects.
Sometimes a user is connected for only 10 ms, sometimes 10 minutes.
Do I have to do SHOW PROCESSLIST every 10 ms or is there a better sollution?

Thanks for the reply.

Tadej

- Original Message -
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Tadej Guzej" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:35 PM
Subject: Re: Logging connections


> You have timestamp fields in your table. When the user connects,
> you insert a row. The first timestamp field is set to the entry
> time automatically, you just record the user.
>
> When he disconnects, you update the second timestamp with the
> disconnect time. You can later compute the difference.
>
> I wonder how you find out about the latter.
>
> Tadej Guzej schrieb am Dienstag, 7. August 2001, 15:37:59:
>
> > How would I log connections to MySQL server?
> > I need the time user connects and the time user disconnects.
>
> > Thanks,
>
> > Tadej
>
>
> > -
> > 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
>
>
>
> --
> Herzlich
> Werner Stuerenburg
>
> _
> ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
> Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
> http://pferdezeitung.de
>
>


-
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+gemini compile errors

[Sinisa Milivojevic]

Brian P. Millett writes:
> Hello,
> SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc
> gcc version 2.95.3 20010315 (release)
> 
> I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box.
> I get the following error which has me completly confussed:
> 


> 
> 
> --
> Brian Millett
> Enterprise Consulting Group "Shifts in paradigms
> (314) 205-9030 often cause nose bleeds."
> [EMAIL PROTECTED]   Greg Glenn

You can try two things.

First , checking that your compiler is well installed and that it
produces x86 binaries and second, try disabling usage of assembly with
MySQL configure.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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: Timezone problem.

[Sinisa Milivojevic]

Peter Zaitsev writes:
> Hello Michael,
> 
> Tuesday, August 07, 2001, 10:20:18 PM, you wrote:
> 
> The question is which place do you do aply timezone ?
> 
> I found the following interesting thing: Then mysql is started it uses
> correct timestamp, therefore INNODB is started with wrong timestamp...
> 
> 010807 12:59:44  mysqld started
> 010807  8:59:45  InnoDB: Started
> 

The above means that timezone has changed between the two calls ..

Between the two was tzset call. 

This is a typical case when a zone is changed from GMT to something
else !!!

And you are 4 hours before GMT, aren't you ??

If on Linux, check where does /etc/localtime point to. 

Simply, your startup scripts are not well setup. TZ should be set at
the machine boot.

> 
> -- 
> Best regards,
>  Petermailto:[EMAIL PROTECTED]

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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

[ 러브서프를 추천합니다. ]

[naramada]

´Ô.. ¾È³çÇϼ¼¿ä? 

[click to see ]


ªÀº ¸¸³², ±ä ¿©¿î 
Ä¿ÇÇ ÇÑ Àܸ¸ ÇÔ²² ÇÏ¿©µµ Áñ°Å¿ï ¼ö ÀÖ´Ù´Â °ÍÀº ÇູÇÑ ÀÏ ÀÔ´Ï´Ù. °¡½¿ ¼Ó¿¡ »óÅ­ÇÑ »ç¶û 
Çϳª °£Á÷ÇØµÑ ¼ö ÀÖ´Ù´Â °ÍÀº ¼ÒÁßÇÑ
ÀÏ ÀÔ´Ï´Ù. ´À³¥ ¼ö¸¸ À־ ¾Æ¸§´Ù¿î ÀÏ ÀÔ´Ï´Ù..
Lovesurf.co.kr
 * ÇѱÛÆÇÀº ÃÑ 9,800 ÆäÀÌÁö·Î ´ÜÀϱâ´É À¥ »çÀÌÆ®·Î´Â Çѱ¹Àº ¹°·Ð ¼¼°è ÃÖ´ë±Ô¸ðÀÇ 
»çÀÌÆ®·Î ¼ºÀÎ [³²°ú¿©],
[³²°ú³²], [¿©¿Í¿©]ÀÇ 3 °³ÀÇ Ä¿¹Â´ÏƼ¸¦ ¸ðµÎ ¼ö¿ëÇÑ »çÀÌÆ®·Î ½Ì±Û ¶óÀÌÇÁÀÇ »ç»ýÈ°±ÇÀÇ 
º¸È£¿Í ½ºÅäÄ¿ÀÇ ¹æÁö¸¦ ÃÖ¿ì¼±À¸·Î
Á¶Á÷µÈ À¥ »çÀÌÆ® ÀÔ´Ï´Ù. 


ÃßõÀÎ - 


ÀÌ ¸ÞÀÏÀ» ¾ÕÀ¸·Î ¹Þ°í ½ÍÁö ¾ÊÀ¸½Ã´Ù¸é ¸ÞÀϼö½Å°ÅÀý
  À» Å©¸¯ Çϼ¼¿ä. 

New version of MySQL++ for VC++

[Sinisa Milivojevic]

Hi!

A new sub-version of MySQL++ for VC++ has hit MySQL++ page.

This version solves all  problems that arise in building application
that involve both MySQL++ and MFC classes.

Those problems are now fixed and VC++ programmers may further enjoy
benefits of MySQL++ API.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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: DBASE help

[Tonu Samuel]

On 08 Aug 2001 08:20:27 +, saraswathy saras wrote:
> hai
>  do anyone know how to join  table in DBASE?

This is MySQL database list and questions about dBase are off-topic.
Please stop spamming.

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   <___/   www.mysql.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: help please

[Stefan Hinz]

Dear Santosh,

if you change the grant table entries (e. g. in mysql.user) manually,
you will have to execute

FLUSH PRIVILEGES

from the MySQL command line in order to tell the server to reload the
grant tables.

Granting privileges is better with the GRANT command, which will
automatically make the server reload the grant tables. Example:

GRANT ALL ON my_database.some_table TO "java_user"@"remote_address"
IDENTIFIED BY "my_password"

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "santosh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 10:07 AM
Subject: help please


Hai all,

I am using MySQL version 3.23.36 , i have a problem it would be great if
some body can help me out. The problem is:

I want to add the loginid and password to the server so that i can
connect to the mysql server and create tables programatically i.e. JAVA.
So what i have done is i have added the loginid ,password,hostname and
all permissions set to Y,  in the table "user"   of the "mysql"
database . But when i try to connect through a program it gives an error
as "Bad hand shake".

can anybody reply giving some assistence to this problem please.

Hoping for your early reply...


thanks in advance
santosh



-
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: help please

[shiuwaitai]

try to download and install updated JDBC driver matching with your MySQL
version and JDBC/JDK versions.


- Original Message -
From: "santosh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:07 PM
Subject: help please


> Hai all,
>
> I am using MySQL version 3.23.36 , i have a problem it would be great if
> some body can help me out. The problem is:
>
> I want to add the loginid and password to the server so that i can
> connect to the mysql server and create tables programatically i.e. JAVA.
> So what i have done is i have added the loginid ,password,hostname and
> all permissions set to Y,  in the table "user"   of the "mysql"
> database . But when i try to connect through a program it gives an error
> as "Bad hand shake".
>
> can anybody reply giving some assistence to this problem please.
>
> Hoping for your early reply...
>
>
> thanks in advance
> santosh


-
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: integer&char problem

[saraswathy saras]

table test
-
+---+--+--+-+-+---+
| Field| Type| Null   | Key  | Default   | Extra   |
+---+--+--+-+-+---+
| id_1 |  char(3)   |   | |   |
|
| id_2 |  int(10) unsigned  |   | | 0|
|
+---+--+--+-+-+---+
2 rows in set (0.00 sec)

* i want to select max number from table and auto increment it.
*  type is integer- first time the table  will be empty.when i query (
   select max(id_2) from table test)  it display the
   error bellow.
* type is char-  query (select max(id_1 from table test) it can but  it stop
at number 9.

runtime error:-
_
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)


[MERANT][ODBC MySql driver]Invalid character value. Error in column 1.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (1:1) to (1:42).


Date/Time: Wed Aug 8 15:13:03 2001
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.5
__






>From: "Chris Bolt" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: RE: integer&char problem
>Date: Wed, 8 Aug 2001 00:15:59 -0600
>
> >  i have a problem in query. My field type is integer.
> > The table is empty  and i want to select max number from the
> > field but it display error message.Then i try to change the type
> > to char ,it's can but,
> > the max is until 9 only.is there anyone can help me.
>
>What query? What table? What error message? We can't help you if you don't
>give us enough information.
>
>
>-
>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
>


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


-
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

Installing mysql-3.23.40 on Solaris 2.6

[Emmanuel Tubacher]

Hi,

I am new to this list -and somehow to Mysql- so apologies if this topic
already
been covered (list archives ?? where ??).

I try to install a mysql 3.23.40 version on a Solaris 2.6 with gcc
2.95.2 and
it just won't complete compilation or even configuration. 
Depending on the flags placed in the ./configure  command line I get a
wide variety of troubles : 
--all-static not allowed in 2.6 because of missing libraries, ld
troubles in the end of the 
compilation, c++ compilation errors and so on...

I'm not the maintainer of the system and we just can't upgrade our
servers to Solaris 2.7.

Has anyone succeeded in compiling this version on this OS and how ?

Binary tarball for Solaris 2.7+ doesn't work of course, because of the
absence of libcrypt_1.so 
library in Solairs 2.6.

I badly need to upgrade my 3.22 version in order to use COUNT(DISTINCT )
 
SQL limitations,databases dumps and users admin in Mysql are really
frustrating 
when you come from SGBD like Sybase. I know Mysql growing up fast, but
for now...

BTW : how to upgrade a server from 3.22 to 3.23 ? The web site says that
there is no
compatibility issue, great ! But the key question remains : what has to
be replaced
in the mysql directory ? Only the executables un mysql/bin or more ?

Many thanks for your help.
-- 
Emmanuel.

-
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: Sub select.

[Tonu Samuel]

On 07 Aug 2001 10:46:31 -0400, Trond Eivind Glomsrød wrote:

> MySQL doesn't have subselects. Some workarounds can be found at 
> 
> 
>http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Missing_Sub-selects
> 
> PostgreSQL supports them.

Actually MySQL 4.0 will do.

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   <___/   www.mysql.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: Can't start MYSQL on Linux

[Stefan Hinz]

Dear Ling,

> Thank you so much. Can I ask why?

you have to keep in mind that the mysqld (that's the MySQL server, or
the daemon) is the only one that must have read/write access to datadir
(the database directories). On your machine, /var/lib/mysql/ is datadir,
and mysqld will run as user "mysql" by default. If mysql is the owner of
the datadir directories and files, mysqld will have read/write access to
your databases and tables, otherwise it has not.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Ling Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 3:51 AM
Subject: Re: Can't start MYSQL on Linux


> Yes, that's it. It worked!!!
> Thank you so much. Can I ask why?
>
> Ling
>
>
> >From: Gerald Clark <[EMAIL PROTECTED]>
> >To: Ling Wang <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: Can't start MYSQL on Linux
> >Date: Tue, 07 Aug 2001 10:29:21 -0500
> >
> >chown -R mysql /var/lib/mysql
> >
> >Ling Wang wrote:
> >
> >>I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36
was
> >>installed together with the Redhat Linux. I can not start the mysql
> >>server by executing /usr/bin/safe_mysqld &. It always ends
immediately.
> >>When I look at the /var/log/mysql.log, the message says:
> >>
> >>mysql started
> >>/usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13)
> >>mysql ended
> >>
> >>
> >>I tried start safe_mysqld from many directories and without any
success.
> >>Can anyone please help me out?
> >>
> >>Thanks.
> >>
> >>Ling Wang
> >>
> >>_
> >>Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
> >>
> >>
>
>>-
> >>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]
> >
>
>
> _
> Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
>
>
> -
> 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: integer & char

[Stefan Hinz]

Dear Rsaras,

your problem description is not very precise.

>message.Then i try to change the type to char ,it's can but,
>the max is until 9 only.is there anyone can help me.

I guess what you did was to add a field with CHAR type to your table. If
you do not specify the length, like CHAR(20), the length will be set to
1 (so that's CHAR(1)). This will hold only one digit, and that's 0 to 9.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "rsaras" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 5:08 AM
Subject: integer & char


hai ,

 i have a problem in query. My field type is integer.
The table is empty  and i want to select max number from the field but
it display error message.Then i try to change the type to char ,it's can
but,
the max is until 9 only.is there anyone can help me.

thanks in advance








-
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: ASP & ADO

[Stefan Hinz]

Dear Steve,

> What do I need to know in order to use mySQL with ASP and ADO?

You might want to use ODBC for the database connection. It works fine
for any database system that provides an ODBC driver. You can find one
for MySQL called MyODBC at mysql.com.

ODBC is not the fastest way to access a database, and a "direct" access
like in PHP (like "mysql_connect()") will certainly be faster. Anyway,
with MyODBC, everything works fine, and if you don't have millions of
records to retrieve in your applications, ODBC will be you choice.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Steve Doig" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:09 AM
Subject: ASP & ADO


> Hi Folks,
>
> New user here...How easy or not is it to use mySQL as a substitute
when
> using .asp and ADO?
> What do I need to know in order to use mySQL with ASP and ADO?  Are
there
> 3rd party solns available?
>
> Thankyou,
> Steve.
>
>
> -
> 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: double column type why...

[Stefan Hinz]

Dear Attila,

I am not a mathematician but I guess you used INT and the data seem to
be out of range.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Attila Soki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 12:44 AM
Subject: double column type why...


> hi,
>
> please help me... i can't understand why are my doubles incorrect.
>
> create table test (dnum double(20,5));
> insert into test values(8998);
> insert into test values(8998.0001);
> insert into test values(898.0001);
> insert into test values(88.0001);
> insert into test values(1.0001);
> select * from test;
> ++
> | dnum   |
> ++
> | 8998.0 |
> | 8997.0 |<<< HERE
> |  898.0 |<<< HERE
> |   88.0 |<<< HERE
> |1.00010 |
> ++
>
> intel PII-450 / debian-2.2.19 / mysql 3.23.32
> intel PIII-833 / debian-2.2.19 / mysql 3.23.37
>
> thanx
>
> Attila Soki
>
> -
> 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: Upgrading to 3.23.37 from 3.22.32

[Stefan Hinz]

Dear Gerald,

does mysqld run as user "mysql"? And does user mysql have the correct
rights for datadir (e. g. /var/lib/mysql/) and all subdirectories?

(The MySQL Daemon is supposed to be the only one who has rights for
datadir. So, this could be 700 with user mysql as owner. No one else
needs rights to this directory, as no one else will access the
directories and files in datadir directly, only the daemon / server has
to.)

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Adam Douglas" <[EMAIL PROTECTED]>
To: "'Gerald Clark'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 11:02 PM
Subject: RE: Upgrading to 3.23.37 from 3.22.32


> MySQL reports read only table. As for file permissions, everything is
fine.
> Everyone has read and execute privileges.
>
> >
> > They are probably not owned by mysql anymore.
> >
> > Adam Douglas wrote:
> >
> > > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was
> > > pkg_delete the old MySQL and install the new one. Before I
> > delete the old
> > > MySQL I copied all the database files to a temporary
> > location. Once the new
> > > installation was successful I copied over all the database
> > files into the
> > > proper location.
> > >
> > > My problem is I seem to have 3 extra tables now, A-1, A-9
> > and A-ce. The
> > > funny thing is they all seem to be linked to my tables.
> > These tables to my
> > > knowledge were not present in the MySQL 3.22.32. Also I
> > can't seem to remove
> > > the test user from mysql->db, MySQL says it's read only. I
> > never made the
> > > table read only and doesn't seem to be.
> > >
> > > Anyone have any ideas of what is going on? I feel kind of
> > lost now, any help
> > > would be greatly 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
>


-
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: My databases got hosed when the server went down hard!

[Stefan Hinz]

Dear Chip,

myisamchk is not an SQL command, so it's not executed from the MySQL
Monitor (the SQL command line tool) but rather from a shell. Type
"myisamchk" at the shell prompt and you will see the options.

Or you can use the new version of PhpMyAdmin (www.phpmyadmin.com), this
has a built-in table check & table repair part.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 8:37 PM
Subject: My databases got hosed when the server went down hard!


> Geez, if it ain't one thing it's another. :-(
> My fbsd server went down hard today, now my mysql database is
supposedly
> gone.
> I see the .MYD, .MYI, and .FRM files in the /usr/var/db/mysql/
directory,
> but I get this -
>
> mysql> use bulletins
> Can't read dir of './bulletins/' (Errcode: 13)
> Database changed
> mysql> show tables;
> ERROR 12: Can't read dir of './bulletins/' (Errcode: 13)
> mysql> myisamchk -s /usr/var/db/mysql/bulletins/*.MYI;
> ERROR 1064: You have an error in your SQL syntax near 'myisamchk -s
/usr/var/db/mysql
> /bulletins/*.MYI' at line 1
>
> Obviously I don't know how to use myisamchk properly.
> In Webmin I see the icons for the database, but when I select it the
screen changes and shows
> This database has no tables.
>
> Hopefully these files can be restored, I can view them with cat and
they do contain the
> data that was entered previously.
>
> Chip Wiegand
> Computer Services
> www.simradusa.com
> [EMAIL PROTECTED]
> Simrad, Inc
> Lynnwood, WA
> 425-712-1138
>
> "There is no reason anyone would want a computer in their home."
>  --Ken Olson, president, chairman and founder of Digital Equipment
Corp.,
> 1977
>   (-- Then why do I have nine? Somebody help me!)
>
>
> -
> 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: WANTED: Utility to reverse engineer existing database II

[Stefan Hinz]

Dear Kevin,

mysqldump -w

or something like

SELECT * FROM my_table INTO OUTFILE my_dumpfile WHERE my_id BETWEEN 100
AND 500

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Jay Fesco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:24 PM
Subject: RE: WANTED: Utility to reverse engineer existing database II


> ...Some of my tables have thousands of records and I may only want the
first
> 200 or so.  I did not see
> an option on mysqldump that would limit the number of records.  Any
ideas
> without writing a program?
>
> Kevin
>
>
> >
>
> Try the WhereClause option in mysqldump.
>
> Syntax is:
>
> -w 'where_clause'
> -or-
> --where='where_clause'.
>
> Of course, 'where_clause' would be something like 'id<200' or
whatever's
> appropriate.
>
> It's on page 620 of 'MySQL' by Paul DuBois (New Riders).  Invaluable
book,
> btw.
>
> Jay Fesco
>
>
> -
> 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: importing data

[Stefan Hinz]

Dear Kevin,

check the online manual (www.mysql.com/documentation) for "mysqlimport"
and for "load data infile".

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:03 PM
Subject: Re: importing data


> Please see section 6.17 of http://www.mysql.com/doc/index.html.
>
> Bing
>
> Bing Du <[EMAIL PROTECTED], 979-845-9577>
> Texas A&M University, CIS, Operating Systems, Unix
>
> >>> Kevin Fonner <[EMAIL PROTECTED]> 08/07/01 10:08AM >>>
> Is there an easy way or perhaps a utility to import a tab delimeted
> text
> file of data into a mysql table
>
> Thanks,
>
> --
> Kevin Fonner
>
>
>
> -
> 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