Re: InnoDB vs. MySQL performance Issue

Sam Przyswa wrote: Sameh Attia ([EMAIL PROTECTED]) écrivait: She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine Did you know a democratic country named ISRAEL created in 1948 ? How do u define democratic? country? Israel? created?

Re: InnoDB vs. MySQL performance Issue

Sameh Attia wrote: Hi, I have a system running MySQL 3.23.41. I read many times about InnoDB performance and that it is superior to the MyISAM one. I have a table 'sessions' in a MyISAM format with about 20 milion records. Its size is 2.5 GB; the index file is 1.1 GB. In mysql client I

RedHat 8.0

Hi All, Here is the screen dump for installation MySQL 3.23.54 at RedHat 8.0. Hope this can help to solve the problem for crash compilation. (Similar screen appears at compiling 3.23.53, but not in 3.23.52) [root@www mysql-3.23.54a]# sh mcompile.sh creating libtool nm: libc-tls.o: no symbols

Re: InnoDB vs. MySQL performance Issue

select crap from blahblah where nobody_is_interested = 'Y' sql,query - Original Message - From: Sameh Attia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 7:32 PM Subject: Re: InnoDB vs. MySQL performance Issue Sam Przyswa wrote: Sameh Attia ([EMAIL

4.0.7 - UPDATE / ERROR 1105

Description: We've got a specific UPDATE that will cause: How-To-Repeat: CREATE TABLE `t` ( `a` varchar(16) NOT NULL default '', `b` smallint(6) NOT NULL default '0', `c` datetime NOT NULL default '-00-00 00:00:00', `d` smallint(6) NOT NULL default '0', ) TYPE=MyISAM; INSERT INTO

ÓòÃû×¢²á,ÐéÄâÖ÷»ú

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾­Ñé,ÕâΪÎÒÃǺͿռä

question

I em working In application MySql Client When I click on menu Commands on submenu Tables command Edit Table or Create Table nothing happened. Tell me what to do. Thank you - Before posting, please check:

Re: mysqlbug

Hi Ing. Conti You need to install the Dynamic loading compatibility library http://www.opendarwin.org/projects/dlcompat I would recommend that you install fink (http://fink.sf.net). Then all you need to do is fink install mysql which automatically installs the dlcompat and compiles mysql. If

Re: Upgrading from MySQL 3.23.52 to 3.23.54

Am Montag, 6. Januar 2003 04:45 schrieb Peter Teo: Good day, I have read on http://www.mysql.com about the press releases asking all 3.23 users to upgrade to the latest stable version. How can I do this without uninstalling my current version? I tried to look for some documentation

mysqldump script

Using 3.23.54 mysqldump produces DB references when scripting foreign keys. I.E FOREIGN KEY (`KEYNAME`) REFERENCES `DBNAME.TABLENAME` (`KEYFIELD`) Is there a way to avoid DBNAME.? Using a template DB which is copied to new DB's with different names, hand editing is a pain. Could possibly be stream

re: Russian in MySQL ?

On Saturday 04 January 2003 21:07, Paul Reilly wrote: I have a website which gets data from MySQL. The website is in several languages. I'm now working on Russian, and we have the translations, but I can't seem to get it into MySQL. I have a few questions which I hope someone can help with:

re: RE: MySQL Help Needed Please

On Sunday 05 January 2003 09:08, Anton Zavrin wrote: Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql [1] 71491 # Starting mysqld daemon with databases from

Autonum broken

Hello everyone I am developing an application with MySQL v3.23.33 (MyISAM tables) using Microsoft Visual Basic and ODBC v3.520.6019.0. My OS is MS Windows 2000 I have just had an interesting issue crop up concerning gaps in autonumbering. In the interests of better normalisation I decided to

InnoDB on update cascade

Hi all, Does anyone know why 'on update cascade' option does not work in InnoDB foreign keys? Is it supported anyway? Thanks, Daniel mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Timestamp records

I have a table of records using timestamp(14) as a field and need to remove any records that are 60 days past the timestamp. I've looked at the manual and can't find anything relating on doing this. What query would I need to run on the database? TIA Ed mysql

Re: InnoDB vs. MySQL performance Issue

Sameh Attia ([EMAIL PROTECTED]) écrivait: Sam Przyswa wrote: Sameh Attia ([EMAIL PROTECTED]) écrivait: She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine Did you know a democratic country named ISRAEL created in 1948 ? How

Re: Autonum broken

At 12:37 + 1/6/03, John Morrison wrote: Hello everyone I am developing an application with MySQL v3.23.33 (MyISAM tables) using Microsoft Visual Basic and ODBC v3.520.6019.0. My OS is MS Windows 2000 I have just had an interesting issue crop up concerning gaps in autonumbering. In the

MySQL fulltext. Question about the stopword list

Hi I'm currently using MySQL (4.0.4 recompiled) as our database for storing information about books. There are about 1.5mill book titles + other information in the database now. The fulltext search capabilities of MySQL have turned out to become very good with the 4+ version and with a little

Re: Timestamp records

* [EMAIL PROTECTED] I have a table of records using timestamp(14) as a field and need to remove any records that are 60 days past the timestamp. I've looked at the manual and can't find anything relating on doing this. What query would I need to run on the database? To remove records, use

Re: Timestamp records

Thanks, Ed On Mon, 6 Jan 2003, Roger Baklund wrote: * [EMAIL PROTECTED] I have a table of records using timestamp(14) as a field and need to remove any records that are 60 days past the timestamp. I've looked at the manual and can't find anything relating on doing this. What query

Re: Autonum broken

Hello Paul Many thanks. I won't try that again, then. John In article p05111b50ba3f391357f4@[192.168.0.33], Paul DuBois wrote: At 12:37 + 1/6/03, John Morrison wrote: Hello everyone I am developing an application with MySQL v3.23.33 (MyISAM tables) using Microsoft Visual Basic and

Re: InnoDB vs. MySQL performance Issue

Sam Przyswa wrote: Sameh Attia ([EMAIL PROTECTED]) écrivait: Sam Przyswa wrote: Sameh Attia ([EMAIL PROTECTED]) écrivait: She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine Did you know a democratic country named ISRAEL created in

query only returns one row

Hi, I finally established a connection to my db after I realized that it was located in a different directory than that which I kept placing my php files. As some would say, D'OH! The code below is intended to select and display all 1300 names from the NAMES_TBL but is only returning the

Re: Optimize Table usage

On Sat, 4 Jan 2003 21:25:03 -0500, Dan Cumpian wrote: 1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE TableName command? From Delphi help: Use ExecSQL to execute queries that do not return a cursor to data (such as INSERT, UPDATE, DELETE, and CREATE TABLE). 2) The

MySQL for Netware

Hi, I've readed the following post : PROVO, Utah and SEATTLE - Oct. 21, 2002 - Novell and MySQL AB, developer of the world's most popular open source database, today announced that Novell will ship a NetWare-optimized commercial version of the MySQL™ database with Novell® NetWare® 6 and

Re: mod_perl and mySql

From: Chris Faust [EMAIL PROTECTED] Thanks Paul, that tells me to stop going crazy over it at least :).. Yeah, don't go crazy. I didn't see this in the thread, so I'll include it; a snippet from the Apache::DBI docs: PerlModule Apache::DBI # this comes before all other modules using DBI

Re: InnoDB vs. MySQL performance Issue

Peace to all, This is not the right place for this kind of discussions. Please STOP. Also i have a suggestion for the administrator of this list: -to forbidden all e-mail which have in subject or body, logo /slogan/catchword which can be considered RINGLEADER. Regards, Gelu

Re: query only returns one row

Hi Chris, You need to use a while loop to fetch all of the records returned in the SELECT statement in PHP, as follows: ?php $db = mysql_connect(host, user, pwd); mysql_select_db(dbname,$db); $result = mysql_query(SELECT * FROM NAMES_TBL,$db); while

Re: MySQL for Netware

In the last episode (Jan 06), P van Mierlo said: I've readed the following post : PROVO, Utah and SEATTLE - Oct. 21, 2002 - Novell and MySQL AB, developer of the world's most popular open source database, today announced that Novell will ship a NetWare-optimized commercial version of the

Re: InnoDB vs. MySQL performance Issue

Gelu Gogancea wrote: Peace to all, This is not the right place for this kind of discussions. Please STOP. Also i have a suggestion for the administrator of this list: -to forbidden all e-mail which have in subject or body, logo /slogan/catchword which can be considered RINGLEADER. Regards,

Question about replication

Hello I am using Mysql and Innodb tables since one year with great success. Everything works fine. Now I try to set up a master/slave replication architecture. master slave pc Linux rh 6.2 pc Linux rh 6.2 version 3.23.47 version 3.23.54 I have

column name

Hi all, I guess it's a dumb question for you guys, but MySql manual doesn't seem to offer newbies a great deal of help on this one: how do I change a column name? Gian - Before posting, please check:

RE: column name

ALTER TABLE Simon -Original Message- From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 16:30 To: [EMAIL PROTECTED] Subject: column name Hi all, I guess it's a dumb question for you guys, but MySql manual doesn't seem to offer newbies a great deal of help on this

RE: question

Which client are you using? The MySQL client that comes with the server is not GUI based so there are no menus. Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -Original Message- From: Aleksandar Mitrakovic [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 5:53 AM To:

RE: column name

Check out the alter table syntax ... something to note you can't just change the name - you have to retype the whole column signature: ALTER TABLE [table] CHANGE [old column name] [new column name] [old column definition]; ie. ALTER TABLE users CHANGE st state char(2) NOT NULL DEFAULT 'MI';

Re: InnoDB vs. MySQL performance Issue

Gelu Gogancea ([EMAIL PROTECTED]) écrivait: Peace to all, This is not the right place for this kind of discussions. Please STOP. Also i have a suggestion for the administrator of this list: -to forbidden all e-mail which have in subject or body, logo /slogan/catchword which can be considered

Re: Autonum broken

John Morrison wrote: In the interests of better normalisation I decided to divide one table's data between two tables. So I created another table and copied selected rows into it. I'd love to know how you believe that copying rows to another table is better for normalization. If you

Re: [OT] Palestine

Sam Przyswa wrote: Yes I know, his name is PLO, and in this case Palestine is not a country but a terrorist organisation. Palestine is a name given to the region in which Israel currently has governing authority. It was recognized by the romans, and other occupying governments before that.

Re: InnoDB vs. MySQL performance Issue

Hi, I'm sure that all the people from this list RESPECT in what you believe or in values which are considered by you to be inviolable/holy. I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something like ... I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD, BEN GURION. ... i'm

My new Forum

I created a new forum for you guys that don't like to dig through tons of mail just to find on good answer. You can talk about MySQL and about anything else computer related. You can check it out here http://www.linuxforum.hopto.org/ thanks

Re: InnoDB vs. MySQL performance Issue

Gelu Gogancea wrote: Hi, I'm sure that all the people from this list RESPECT in what you believe or in values which are considered by you to be inviolable/holy. I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something like ... I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD,

Re: Hiding the password

If you will put the password in the .pm module, that module must be viewed by everyone because it must be viewed by the user that runs the Apache server. In this case, someone could take a look what is in that module. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] -

Re: Hiding the password

No, we are not talking about the staff of the hosting company. The hosting company runs a single Apache server on a single account on that server for all sites that are sitting on that computer. If the user that runs the web server has access to your files, this means that everyone has access.

Re: Hiding the password

I have another suggestion, ... a little bit more complicated. It could be made an executable (binary) file that are returning the password and the username. That executable will return a different username and password if it is run in another path or on another server. So it should be run from

Re: Hiding the password

Oh yes this is the problem. If they are logged on the server. More hosting companies offer SSH access or telnet access for their customers and they can see the original Perl or PHP files, not the result processed by the web server. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL

Re: MySQL fulltext. Question about the stopword list

Hi! On Jan 06, Erlend Hopsø Strømsvik wrote: Hi I'm currently using MySQL (4.0.4 recompiled) as our database for storing information about books. There are about 1.5mill book titles + other information in the database now. The fulltext search capabilities of MySQL have turned out to

libwrap ignores entry in hosts.allow

Description: Hi, I'm using mysql-3.23.51 compiled with libwrap support. If hosts.{allow,deny} have similar to the following structure: hosts.allow: #start of hosts.allow mysqld: ALL #end of hosts.allow hosts.deny: #start of hosts.deny ALL: ALL #end of hosts.deny I end with a rejected access. A

Re: Question about replication

On Mon, Jan 06, 2003 at 04:56:38PM +0100, Chambon wrote: Hello I am using Mysql and Innodb tables since one year with great success. Everything works fine. Now I try to set up a master/slave replication architecture. master slave pc Linux rh 6.2 pc

Re: InnoDB vs. MySQL performance Issue

Sameh, The right table manager to use (MyISAM or InnoDB) really depends on the type of work you are requiring of MySQL. If you are mainly doing selects, and hardly any updates/deletes/inserts, then MyISAM is faster. Its indexes, as far as I know, are smaller and more efficient. However,

Re: InnoDB vs. MySQL performance Issue

Maximo Migliari wrote: Sameh, The right table manager to use (MyISAM or InnoDB) really depends on the type of work you are requiring of MySQL. If you are mainly doing selects, and hardly any updates/deletes/inserts, then MyISAM is faster. Its indexes, as far as I know, are smaller and more

Re: Hiding the password

On Mon, 6 Jan 2003, Octavian Rasnita wrote: Date: Mon, 6 Jan 2003 08:33:48 +0200 From: Octavian Rasnita [EMAIL PROTECTED] To: Larry Brown [EMAIL PROTECTED], MySQL List [EMAIL PROTECTED] Subject: Re: Hiding the password No, we are not talking about the staff of the hosting company.

Re: Hiding the password

Hello Teddy: Could you please be a bit more demonstrative? If I have a module in at Web address on a Apache server with permissions 700, (Warren said he has his scipt to 755, I think) how exactly do you believe a site visitor can access the text of the script? Or how do you think another system

RE: Hiding the password

This is your problem. Change hosting companies. There should be multiple accounts. At least one for each site and nobody from any other site should be able to log in and view your files. It's called chroot and is the most common method of separating customers of a hosting company. If your

Re: InnoDB vs. MySQL performance Issue

Sameh, your innodb_buffer_pool_size seems a bit small. In the manual it says: Set buffer pool size to 50 - 80 % of your computer's memory, but make sure on Linux x86 total memory usage is 2 GB. Your setting means that you have no more than 256MB RAM and that's not much for operations on really

LEFT JOIN function locking up when using large database

I have 2 tables, one with 1,000 entries, the other with 10,000 entries. I'll call these table1 and table2. The query uses both tables: SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID = table2.table1_ID) WHERE some condition; table2.table1_ID is just an int that matches an

Re: InnoDB vs. MySQL performance Issue

Well, its possible that it took 10 hours to complete the conversion, if the table was big enough, this could be justified. 20 million records is a lot of records! Also, don't forget to change the memory settings for InnoDB in my.cnf. InnoDB is a different table manager to MyISAM, and as such,

RE: LEFT JOIN function locking up when using large database

Are you using indexes on your tables? This does not sound like a mysql bug, but rather a problem with your table structure or query. I have seen much more complicated joins work on much larger tables without any problem, as I am sure many people on this list have as well. You should run an

RE: [PHP] Re: PHP and MySQL bug

This definitely sounds like a buggy installation or there may be some problem with the communication between the web server and the mysqld. Is the db on a different machine? Try using mysql_pconnect instead of connect just to see what result you get. I have read some unfavorable statements

Re: LEFT JOIN function locking up when using large database

Rob, as Jennifer stated, the problem is that your query doesn't use indexes. SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID = table2.table1_ID) WHERE some condition; some condition would be of interest here. If MySQL can't use indexes here, it will have to scan all of

Re: LEFT JOIN function locking up when using large database

Rob Taft wrote: I have 2 tables, one with 1,000 entries, the other with 10,000 entries. I'll call these table1 and table2. The query uses both tables: SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID = table2.table1_ID) WHERE some condition; Do you have indexes on

Re: InnoDB vs. MySQL performance Issue

Maximo Migliari ([EMAIL PROTECTED]) écrivait: Sameh, We r here to help one another solving their problems. Ive never posted any solutions, to this list or another based on religion or something else but the problem itself only. I invite all people here to read the Islamic history of true muslims

RE: Hiding the password

Check out the explination of chroot from the following url.. http://www.tcu-inc.com/Articles/23/chroot.html This is an article about doing more than an apache solution but it explains chroot. This is the best model I know of. I read that it is being used less often than in the past so there

Re: Hiding the password

- Original Message - From: William R. Mussatto [EMAIL PROTECTED] To: Octavian Rasnita [EMAIL PROTECTED] Cc: Larry Brown [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Monday, January 06, 2003 7:07 PM Subject: Re: Hiding the password Its possible to configure a single virtual host

Re: Hiding the password

One other thing about that is that on the section it describes apache it is chrooting the web server separate from other processes on the server. You can chroot the sites handled by apache as well, I just don't have a good example link to offer you. MySQL Larry S. Brown Dimension Networks, Inc.

RE: Hiding the password

It's not as easy as that unless there is something I'm unfamiliar with. There are scripts that will help chroot but it isn't just making an entry in httpd.conf. It does keep everyone totally separate though. As a shell user your / is actually some subfolder on the server. Your folders under /

Re: Hiding the password

On Mon, 6 Jan 2003, Mark wrote: Date: Mon, 6 Jan 2003 22:48:06 +0100 From: Mark [EMAIL PROTECTED] To: William R. Mussatto [EMAIL PROTECTED], Octavian Rasnita [EMAIL PROTECTED] Cc: Larry Brown [EMAIL PROTECTED], MySQL List [EMAIL PROTECTED] Subject: Re: Hiding the password -

RE: Hiding the password

Mangled from our httpd.conf VirtualHost 172.16.0.xx User clientsite Group clientsite AddHandler cgi-script cgi pl Directory /home/client/clientsite/clientsite/clientsite Options +ExecCGI /Directory ScriptAlias /cgi-bin/ /home/client/clientsite/clientsite/cgi-bin/ ServerAdmin [EMAIL PROTECTED]

RE: Optimize Table usage

Well, I knew that, but I wondered if using an OPEN would solve the problem. Does anyone know of a workaround for the out of sync error? Thanks, Dan Cumpian -Original Message- From: Steve Yates [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 10:22 AM To: [EMAIL PROTECTED]

I'm new in Mysql

Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql create

Re: I'm new in Mysql

At 16:38 -0800 1/6/03, Beogradjanin wrote: Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments

Re: auto increment

HI ALL I couldn't have an auto-increment in ver 3.23.53 for the table INNODB, mysql CREATE TABLE roomLockAuto ( - roomNum CHAR(20) NOT NULL, - id INT(2) unsigned zerofill NOT NULL auto_increment, - lockNum CHAR(20) NOT NULL, - PRIMARY KEY (roomNum, id) - ) TYPE=INNODB;

Re: Hiding the password

I think we must be at cross-purposes. I thought you were talking about individual VirtualHost/VirtualHost sections. That would have been a wonderful thing. Feasible too, perhaps. The Apache parent (root), could prefork its children, one for each VirtualHost/VirtualHost running as its own user (to

Re: auto increment

HI kayamboo wrote: sql, query, OfCourse that is the default criterian for an auto increment column. It need to be the primary key ID is part of the Primary key, It works fine for other table type. I do *NOT* want +---+-+---+ | roomNum | id | lockNum |

Re: auto increment

At 14:34 +1100 1/7/03, vinita Vigine Murugiah wrote: HI kayamboo wrote: sql, query, OfCourse that is the default criterian for an auto increment column. It need to be the primary key ID is part of the Primary key, It works fine for other table type. I do *NOT* want

tracing ips

hey everyone, Kind of an OT subject, but since a lot of you are sys admins and what not I thought maybe someone could help. I'm trying to trace people on my message board to get a better idea of who they are. Does anyone know how to trace an ip and what program or method to use? I have ips from

Re: auto increment

Well, he can do it, he just can't do it the way that he's trying to do it. He needs to do what the rest of the world does and separate out his different fields into different tables for labeling things. If he needs to make a different table for each 'room' or whatever, then so be it, he just

11001 or 10061 errors HELP!

Hey guys, I need some help. I have a windows 2000 machine that I need to connect to a debian linux box that has a mysql database. I am not really sure if I have it setup or not, but I am using MyODBC to connect to the linux box. I keep getting Unknown MySQL host 11001 or I get the 10061

Re: auto increment

At 23:02 -0500 1/6/03, Matt Hargraves wrote: Well, he can do it, he just can't do it the way that he's trying to do it. He needs to do what the rest of the world does and separate out his different fields into different tables for labeling things. If he needs to make a different table for each

Load local data infile problem

hello there, I have just installed mysql and am facing problems with the Load data local infile problem. I went through the manual and did all that was said like including the command --enable-local-infile and --local-infile[=1], but it does not seem to work. I have the version

Re: [PHP] Re: PHP and MySQL bug

I done a echo of Mysql_error and it returned: 'Nenhum banco de dados foi selecionado' (I have the mysql server in portuguese, but the translation is something like 'no db was selected') - Original Message - From: David Freeman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday,

Re: PHP and MySQL bug

The problem is if I close the connection and reopen it the query is done, but if I remain with the same connection has the previous query, mysql returns an error. - Original Message - From: Larry Brown [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, January 05, 2003 4:16

Re: PHP and MySQL bug

It would be helpful if you posted that error. You can get it by changing the die to $queryr = mysql_query($query) or die(mysql_error()); Without knowing the error, you problem will be harder for everyone to debug. -Original Message- From: Nuno Lopes [mailto:[EMAIL PROTECTED]] Sent:

Re: tracing ips

Hi! Go to http://cello.cs.uiuc.edu/cgi-bin/ip2ll for the always entertaining Host name to Latitude/Longitude. (Likely not of any interest is http://cello.cs.uiuc.edu/cgi-bin/slamm/ip2name which is just an IP Address to Hostname and Vice Versa) Have fun! Cheers! -warren filter: mysql,

Re: auto increment

Paul DuBois wrote: At 23:02 -0500 1/6/03, Matt Hargraves wrote: Well, he can do it, he just can't do it the way that he's trying to do it. He needs to do what the rest of the world does and separate out his different fields into different tables for labeling things. If he needs to make a

How to store maps in MySQL

Hi List, I read that MySQL (4.1) now supports geometric data types. I tried to look for documentation related to geometric data types in mysql. But could not find any. Can someone point me to documentation of geometric data types? Thanks, Shamit Verma

Re: tracing ips (whois site)

Hi! I forgot to mention whois: http://resellers.tucows.com/opensrs/whois/ This one seems to be pretty decent. Just type the domain name and see the registration info. Cheers! -warren filter: queries, mysql, bigint - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: MYSQL

RE: tracing ips

i've looked into this , HTTP_X_FORWARDED_FOR should get actual client ip's behind a proxy but some proxies dont send this which is a bugger or it would be a goer , i also need to know how = Original Message From Alex Behrens [EMAIL PROTECTED] = hey everyone, Kind of an OT subject, but

Re: How to store maps in MySQL

On Tue, Jan 07, 2003 at 11:22:50AM +0530, Shamit Verma wrote: Hi List, I read that MySQL (4.1) now supports geometric data types. I tried to look for documentation related to geometric data types in mysql. But could not find any. Yeah, the docs haven't been integrated (or even written?)

CLUSTER MYSQL

It is possibile to install MYSQL on a microsoft cluster ? I read for a special version of microsoft SQL version; anybody have installed MYSQL in this environment ? TKS - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO)