Re: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

-new-mysql-user.php I hope that you find this info useful. Best regards Nils Valentin Tokyo / Japan http;//www.be-known-online.com On Tuesday 14 June 2005 06:58, Yannick wrote: > Kevin, > > In addition to that, the ZORUM database works because when I stop mysql, > the followin

Re: Need help

Hi Shreedjhar, Are you aware of this paper ? http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf It may perfectly answer most of your questions. Best regards Nils valentin Tokyo / Japan http'//www.be-known-online.com On Saturday 18 June 2005 22:01, mad

Recreating primary index on MyIsam table

shouldnt be too difficult, but perhaps I am just too long in front of the screen. ;-) Best regards Nils Valentin Tokyo / Japan www.be-known-online.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Recreating primary index on MyIsam table

Hi Peter, thanks a bunch, I new that it must have been something simple like this. I am just no programmer. ;-) Thanks a bunch !! Best regards Nils Valentin Tokyo / Japan On Sunday 10 April 2005 23:41, Peter Brawley wrote: > Nils, > > >So the task is to recreate the current

Re: Version 4.1.1

, > Dan -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: RedHat-9

Also bear in mind that the file ~/.my.cnf or var/lib/mysql/.my.cnf will take precedence over /etc/my.cnf which should set only the global settings. Please let me know once more the mysql server version you are using mysql> SELECT VERSION(); Best regards Nils Valentin Tokyo/Japan 2003年 5月

Re: changing mysqld deamon ownership.

Hi Alan, you would have to do mysql -u root -p and then enter the password to connect. best regards Nils Valentin Tokyo/Japan 003年 5月 31日 土曜日 04:02、2Hosts.com さんは書きました: > Hi Nils, > > So if I su to root and try to start mysql, I get the following... does that > mean I'm se

Re: Creating new users

is 1, I get back 1 record. If it is 0 or default I get > the error > > Any thoughts on how to get more records. > > Thanks, > > Barry > > -Original Message- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 29, 2003 8:45 PM > To: Dancis, Bar

Re: MYSQL DB PROBLEM

Hi Adam, there was a similar thread within the last 24 hours. try SHOW VARIABLES LKE '%time%'; Best regards Nils Valentin Tokyo/Japan 2003年 6月 1日 日曜日 14:47、Adam Murphy さんは書きました: > I am trying to insert a table ibf_posts > > into a localhost database using the MYSQL control

Re: MySQL Errno: 2013

Hi Kevin, I dont think its the switch. I would like to try the following variables: net_read_timeout 60 net_write_timeout 60 long_query_time 30 Please let me know if this was of any help. Best regards NIls Valentin Tokyo/Japan 2003年 5月 30日 金曜日 23:33、Kevin A. Miller さんは書きました: > N

Re: Practical samples for table types

Hi Everybody, our server was down for 8 hours. I applogize in case anybody did try to access the table chart. Its up and running and of course I would appreciate any feedback. http://www.knowd.co.jp/staff/nils/mysql-ttf.html Best regards Nils Valentin Tokyo/Japan 2003年 5月 30日 金曜日 17:34

Re: Query problem

Hi everybody, I hope ASAFP stands for something like AS Soon AS Feasable Possible ;-) We are not going to swear are we ? Best regards Nils Valentin 2003年 6月 2日 月曜日 07:30、Sparky Kopetzky さんは書きました: > I have a view I need to create from several tables where I'm looking up one > v

Re: SELECTing last occurences from a table

In this case you would need to add a timestamp and check for the latest timestamp. This price should be taken for your query. Something like SELECT * FROM food WHERE timestamp(MAX); Thats my guess - anybody please correct me if I talk rubbish here Best regards Nils Valentin Tokyo/Japan

Re: SELECTing last occurences from a table

;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 2日 月曜日 08:55、Mateusz さんは書きました: > > SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC > > LIMIT > > > 1; > > COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date > > that >

Re: Inserting data?

g any data record , you will have to update this only once, while in the previous sample you will have to update it several times (time consuming). While this is a complex topic I would suggest to read some articles from www.devshed.com about database normalization Best regards Nils Valentin T

MYSQL Documentation

Hello Mysql List members, I am about to create some documents which I feel are not "so" complete documented until now. It's not a lot right now. I ceate a table comparison chart and a MySQL error code listing (in text format) which you could use to lookup Client and Server errors. Table or OS

Re: Query problem

OOh thats fine then isnt it ? ;-) Best regards Nils Valentin 2003年 6月 2日 月曜日 22:47、Sparky Kopetzky さんは書きました: > No, not swearing - just As Soon As Financially Possible!!! > > Robin > > *** Still need an answer if someone can help * > > > - Original Mes

Re: Slackware 9.0 and MySQL 3.23.56

d chgrp to change it to mysql's Linux user account (ps -u). Then it will start without any problems. Best regards Nils Valentin 2003年 6月 3日 火曜日 01:[EMAIL PROTECTED] さんは書きました: > I recently installed Slackware 9.0 from ISO onto a box and cannot get > mysql to run on it. It gives the error

Re: ft_boolean_default='AND'

No swearing please, we are not on holiday ;-) Best regards Nils Valentin 2003年 6月 3日 火曜日 07:14、electroteque さんは書きました: > myisam/ft_static.c'. > > so i have to edit this and recompile ? what a pain in the ass , i'll have > to try and format it then > -Original Me

Re: control center question

and then click on " use the following database" and enter your database name. Press apply, disconnect and connect again and voila ! Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日 04:55、Fabio Bernardo さんは書きました: > Hi there, I´m using control center 0.9.1-beta and when I st

Re: cant grant privileges?!

How do you login to mysql ? mysql -u user -p -h localhost should do it. You dont even need "-h localhost" in this case. Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日 11:31、Kalin Mintchev さんは書きました: > hi everybody... > > i just installed mysql 4.0.13 on a redhat

Re: Replication problems (server_errno=1236)

Hi Calvin, I am not sure which table format you use, but somehow I assume you use innodb. If I remember correctly than Innodb will need all log files. If only one is missing than thats it, you get the error described. - anybody please correct me if I talk rubbish here Best regards Nils

Re: cant grant privileges?!

PHP is a different topic you have to use a procedure called "mysql_pconnect". However that is well documented in several PHP documents. Best regards Nils Valentin 2003年 6月 3日 火曜日 11:44、Kalin Mintchev さんは書きました: > On Tue, 3 Jun 2003, Nils Valentin wrote: > > How do

Re: MYSQL Privileges

/Server_Side/MySQL/Grant_Tables/page1.html http://www.devshed.com/Server_Side/MySQL/Administration/page1.html They also offer printer friendly formats. I hope you dont think ... hmm just another document ;-). They are really worth the time. Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日

Re: cant grant privileges?!

Hi Allann, Ajos, Mysql List members As far as I know the flush privileges is not necessary when using GRANT. flush privileges is only used after you updated the privilege database "mysql" manually using INSERT or UPDATE. Somebody please correct me if I am wrong. Best regards Nil

Re: Regarding inoperable symbolic links in Win2K Pro

Hi Charles, Having spoken to "somebody" from MySQL AB in person last month here in Tokyo I know that the problem seems to be adressed currently. What I dont know is when, how and which new mechanism will be applied to the mailing list. Best regards Nils Valentin Tokyo/Japan 2003年

Can't open privilege tables: Table 'mysql.host' doesn't exist

Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extra

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

, perhaps my.cnf and/or mysql itself. Best regards Nils Valentin 2003年 6月 4日 水曜日 12:36、Nils Valentin さんは書きました: > Hi Mysql list members, > > I added a Innodb database to the existing MyISAM databases and now MySQL > doesnt start up. From the InnoDB logfile I saw this error message &g

Re: FW: MySQL for our production reporting data warehouse

wever you can follow up on the change logs in the documentation on www.mysql.com http://www.mysql.com/doc/en/News.html Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 04:02、Sonia Ghadially さんは書きました: > > -Original Message- > > From: Sonia Ghadially > > S

Re: MySQL List Stats for May, 2003

I am not sure if I will use it often, but definitely well done ;-) Very clear organization of the data. Thats definitely something which will be highly appreciated by most list members (and MySQL AB) I am sure !! Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 06:55、Bill

Re: [Correction] MySQL List Stats for May, 2003

Hi Bill, Such a pitty. For a moment I thought I am the new No.1 ;-) (see previous posted data) Best regards Nils Valentin Toko/Japan 2003年 6月 5日 木曜日 07:29、Bill Doerrfeld さんは書きました: > --- > Please ignore my prior post on this. The numbers were wrong as it > tur

Re: detailed FULLTEXT index and search help needed

table which you dont use in the WHERE clause of your SQL statement ? Anybody please correct me if I talk rubbish here ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 02:25、H M Kunzmann さんは書きました: > Hello All. > > I have a table that is about 1.5GB with about 400 records. >

Re: authentification intranet

Dont forget "FLUSH PRIVILEGES" ;-) otherwise you might be wondering why the new settings dont apply. Best regards Nils Valentin 2003年 6月 5日 木曜日 02:55、jinal jhaveri さんは書きました: > I guess the problem is with your authentication. Mysql 4.1 uses a new auth > schema. You might want

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

your advice and I am in process of repairing this, however I would really appreciate if I could also technically understand why this is. This case I can learn and step up ;-) Do you mind explaining why this is ? Best regards Nils Valentin 2003年 6月 4日 水曜日 21:09、Heikki Tuuri さんは書きました: &

Re: nested ORDER BY statements

Hi David, can't give you detailed advice but I believe you look for SELECT...GROUP BY ... ORDER BY Please see the docs like "info mysql". Best regards Nils Valentin Tokyo/Japan \ 2003年 6月 4日 水曜日 22:37、Dave Terrio さんは書きました: > Hello - I'm a relative newcomer to dev

Re: MySQL Errno: 2013

Hi Kevin, thats alright, let me know when it worked, thats what I want to hear ;-) Best regards Nils Valentin 2003年 6月 5日 木曜日 00:12、Kevin A. Miller さんは書きました: > Nils: > > sorry for the delay getting back to you. > > this morning we modified the variables mentioned below. Followin

Re: mysqldump

all data and delete the rest which is not needed. Thats very easy done on the command line (in case you use MyISAM) or you can edit the backup file directly. Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日 17:55、Massimo Petrini さんは書きました: > It is possibile to make an export d

forming foreign keys

Hello Mysql list, I try to create foreign keys in a innodb database. I read through some threats and the manual, and several online resources, but somehow I am missing something. What I try to do is recreate the keys and their functions of the mysql database (privilege database) as a innodb d

Re: detailed FULLTEXT index and search help needed

work around the problem and also be able to reduce the maintenance for the future. Please let me know if I went down the wrong way ;-) or if I missed the spot again ;-). Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 02:25、H M Kunzmann さんは書きました: > Hello All. > > I have a tabl

Re: How to empty the cache?

join_buffer_size myisam_sort_buffer net_buffer_length tmp_table_size I guess if you lookup any of the variables above you will quickly sort out the ones which applies to your question and the ones that don't. Sorry, but with the information given I am unable to be more precise. Best regards Nils Val

Do all mysql versions from 4.1 support sub selects?

Hi Mysql List, Will all mysql versions (std, max and debug) from 4.1 support sub selects or will this only be included f.e in the max version ? Best regards -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For li

Certification study quide from Dubois, Hinz and Pedersen

Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, hello Mysql List, I was wondering if you guys would let me know about the release schedule of the "MySQL Certification Study Guide " which is about to be released - as announced on the UC 2 months ago. Any information much appreciated - no info

Re: Certification study quide from Dubois, Hinz and Pedersen

position most. That would be marvelous, but we dont want to reach for the stars.. ;-) Best regards Nils Valentin Tokyo/Japan nils(at)knowd.co.jp 2003年 6月 10日 火曜日 00:31、あなたは書きました: > Nils, > > > Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, > > Ah! How did you find ou

Re: array/pointer question

Arrays are coming from version 5.0 as far as I know the plans. Best regards Nils Valentin 2003年 6月 9日 月曜日 23:49、Ioana さんは書きました: > Hello, I have just recently started learning mysql, and was wondering if > it supports arrays/pointers(for linked lists) of any types, and if so, > wh

Re: Certification study quide from Dubois, Hinz and Pedersen

Hi Paul, 2003年 6月 10日 火曜日 01:26、Paul DuBois さんは書きました: > At 1:08 +0900 6/10/03, Nils Valentin wrote: > > > > > >Hello Stefan, > > > >well I have my sources ... ;-) .. I guess its no secret ,especially as it > > was announced on the UC. > > > >I

Re: arrangement of fields in a table

Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 02:40、Mojtaba Faridzad さんは書きました: > Hi, > > I need to define for example 100 fields in a table. 8 of them are more > important and many queries just need these fields. Should I define them > before the other fields in the table or it doe

Re: diff between 7.2 and 8.0 rights?

e that nobody of your customers ever finds this mailing list ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 03:36、Obantec Support さんは書きました: > Hi > > I have 2 servers both with 3.23.56-1 installed via rpm's > > proteus2 which is running RedHat 7.2 on 1 cpu

Re: Trouble with SELECT AS syntax

xx" but no reserved words please ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 10:53、Becoming Digital さんは書きました: > Despite my review of the manual, I cannot get my SELECT AS statements to > work. Every attempt returns Error 1064. My statements, which appear to be > in

Re: Trouble with SELECT AS syntax

Jim was faster ;-), ..but I am getting there. Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました: > On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > > SELECT item_name AS name, item_desc AS desc FROM food; > > 'desc

Re: Trouble with SELECT AS syntax

I posted a page containing the reserved words at http://www.knowd.co.jp/staff/nils/ In case it is of any help for somebody. Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました: > On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > &g

InnoDB question(s)

O.K MySQL List This one is on me, a bit funny, a bit strange but with a serious background. You are allowed to laugh ;-). Assuming that somebody has the "clever idea" to rename the folder for a InnoDB database f.e. on the command line base (mv command for Linux). Now the mysqld server startsu

Re: InnoDB question(s)

the orginal dbname). Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 14:55、Becoming Digital さんは書きました: > http://www.innodb.com/ibman.html#Backing_up > > See the section on Forcing Recovery. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > &g

Re: forming foreign keys

Hi Victoria, 2003年 6月 10日 火曜日 19:16、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > I try to create foreign keys in a innodb database. I read through some > > threats and the manual, and several online resources, but som

Re: Practice test

Hi Rich, Jeremy,, Mysql List 2003年 6月 10日 火曜日 23:51、Jeremy Zawodny さんは書きました: > On Tue, Jun 10, 2003 at 12:03:51PM +0200, rich johnson wrote: > > Has anyone else tried this? I got 8/10. Going to the exam next week; > > I suppose that's a good sign :-) > > > > http://www.mysql.com/certification/self

Re: alter table blocks other tables!

Hi Dan, I wanted to comment on the comparison between the scsi cards - plase see below. 2003年 6月 10日 火曜日 16:55、Jeremy Zawodny さんは書きました: > On Mon, Jun 09, 2003 at 05:27:00PM -0700, Dan Edwards wrote: > > > Can you grab the output of 'vmstat' or iostat or something that'll > > > measure disk I/O n

Re: droping foreign key

HiJoe, thats not supported yet. You will have to recreate the table to remove the foreign key. Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 10:13、Joe Gaffney さんは書きました: > Can someone help with trying to remove a foreign key constraint from a > table. Each time I run the alter

Re: droping foreign key

t; > Thanks, > Joe > > > > > -Original Message- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2003 9:40 PM > To: Joe Gaffney; MySql > Subject: Re: droping foreign key > > > HiJoe, > > thats not supported yet. You will have t

Re: forming foreign keys

| | +---++--+--+-+---+-+--++--++-+ Any comments appreciated. Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 22:52、Nils Valentin さんは書きました: > Hi Victoria, > > 2003年 6月 10日 火曜日 19:16、Victoria Reznichenko さんは書きました: > > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > &

Re: forming foreign keys

in another way f.e mysql> ALTER TABLE db ADD CONSTRAINT FOREIGN KEY (Host) REFERENCES user (Host); ERROR 1216: Cannot add or update a child row: a foreign key constraint fails But as you can see I get another error. Any comment much appreciated. Best regards Nils Valentin Tokyo/Japan

Re: Unicode(ucs2) setup question

Hi Yuji Error 2 means the file doesnt exist. (here: '/usr/local/share/mysql/charsets/ucs2.xml'). Please make sure the file is in the foldr specified and not misspelled. Best regards Nils Valentin Tokyo/Japan Japanese: 宜しくお願いします 2003年 6月 11日 水曜日 14:44、Yuji Sato さんは書きました: > I&

Re: Unicode(ucs2) setup question

yourself ? Do you want to create your own character set ? My guess is that you perhaps wanted to use the new UTF-8 charcater set. Is that right ? Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 15:04、Yuji Sato さんは書きました: > Hi Nils, > > I have no ucs2.xml in the "/usr/loc

Re: Unicode(ucs2) setup question

Hi Juan, I understood Yuji is using OS FreeBSD 4.8 DB MySQL4.1.0-alpha Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 16:54、Juan Sebastian Alarcon さんは書きました: > In wich version of Windows do you have compiled mysql? > > I have Win XP and I need a mysql version that works with

Re: forming foreign keys

Hi Victoria, I thought so, but also if I try somthing similar like: ALTER TABLE db ADD FOREIGN KEY (Host) REFERENCES user (Host); I get the same error. BTW: Can I change the order of the keys ? Best regards Nils Valentin 2003年 6月 11日 水曜日 17:17、Victoria Reznichenko さんは書きました: > &q

Re: forming foreign keys

? Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 21:20、Nils Valentin さんは書きました: > Hi Victoria, > > I thought so, but also if I try somthing similar like: > > ALTER TABLE db ADD FOREIGN KEY (Host) REFERENCES user (Host); > > I get the same error. > > BTW: Ca

Re: Printing table descriptions

se you want to print them regularly) ? ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 22:29、Fernando Gerent さんは書きました: > Hi! > > I need to print the description of all tables in my database. The problem > is, there are about 200 of them, and the only way I know to do this

Re: Printing table descriptions

Martin, my compliment. Excellent answer. I completely forgot about the -d option for mysqldump. Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 22:32、Martin Waite さんは書きました: > On Wed, 2003-06-11 at 14:29, Fernando Gerent wrote: > > Hi! > > > > I need to print t

Re: configuration questions - newbie getting up-to-speed

Hi Chris, Not sure which OS you are using, but in case you use Linux you should try info mysql You will most probably find what you are after. Best regards Nils Valentin 2003年 6月 12日 木曜日 07:18、Chris McKeever さんは書きました: > I also found out that > > mysqld --help provides a whole lo

BDB or InnoDB

Hi MySQL Fans, I am sure this question was asked before, but I did not find sufficient info, so please allow me to ask this question again. When comparing BDB and InnoDB which one would be (generally speaking) a better choice for a certain purpose ? I understood that BDB and InnoDB have basica

Re: BDB or InnoDB

Thanks Edward, Thank you that confirms what I found. I also found that BDB is not available on Mac and Linux (alpha) architecture. Best regards Nils Valentin Tokyo/Japan 2003年 6月 12日 木曜日 16:02、Becoming Digital さんは書きました: > According to Sams Publishing (April 2002): > The Berkeley DB

Re: forming foreign keys

questions now. I will try it now and feedback shortly. Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 22:41、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > Thank you for the reply. I understand now that it must be the first part &g

Re: mySQL GUIs

gh good reasons ;-) I have no clue why MySQL is partnering with EMS ;-), but I strongly believe that DbVisualizer is the best around. If anybody believes that another tool is better than I would be VERY interested to hear about it. Best regards Nils Valentin Tokyo/Japan 2003年 6月 12日 木曜日 23:21

Re: mySQL GUIs

e from the mailing list and follow up here if this is what you would like to do ;-) http://www.listsearch.com/mysql.lasso Best regards Nils Valentin Tokyo/Japan 2003年 6月 13日 金曜日 00:23、Knepley, Jim さんは書きました: > Nils, and other well meaning members who mail me directly: > > I subscribe to the

Re: open source shema relationship diagram tool

software included) (any OS) www.lysator.liu.se/~alla/dia/ Best regards Nils Valentin Tokyo/Japan 2003年 6月 13日 金曜日 11:17、Daniel Rossi さんは書きました: > hi there i was wondering if there was a table relationship diagram open > source tool around anywhere ? i am trying to document a project

Re: open source shema relationship diagram tool

om their homepage: .."Welcome to Dia's homepage. Dia is a gtk+ based diagram creation program released under the GPL license. " Best regards Nils Valentin Tokyo/Japan > > > > Best regards > > > > Nils Valentin > > Tokyo/Japan > > > > > &

Re: Spatial Support on MySQL

Hi Mehmet, I am not sure excactly what you are looking for as spatial data is quite new for MySQL I believe. How about this info ? http://localhost/xoops/manuals/mysql/en/GIS_spatial_extensions_in_MySQL.html 2003年 6月 13日 金曜日 17:24、Mehmet KADAYIFÇI さんは書きました: > Hi, > > I develop applications tha

Re: Spatial Support on MySQL

Hi Mehmet, Sorry I send you the worng link. Try this one please http://www.mysql.com/doc/en/GIS_spatial_extensions_in_MySQL.html Best regards 2003年 6月 13日 金曜日 17:24、Mehmet KADAYIFÇI さんは書きました: > Hi, > > I develop applications that about GIS. I am using Oracle Database for our > projects. We sto

Re: Replication troubles

in the index file, resetting the binlog index file to be empty. Previously named FLUSH MASTER . By doing this you eliminate all old master file and start over at FILENAME-bin-001 position 79. Best regards Nils Valentin Tokyo/Japan 2003年 6月 13日 金曜日 21:23、Bruce Dembecki さんは書きました: >

Re: identifying foreign keys

SHOW CREATE TABLE tblname; Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 05:22、Michael Conlen さんは書きました: > I'm working on a system that will allow me to perform operations on a > table using a web form, and I would like to know if a table has a > foreign key, however I

Re: table creation - arrays ?

I have read that Arrays are not coming before 5.0. have a look in the Documentation and the UC presentations. Best regards NIls Valentin Tokyo/Japan 2003年 6月 10日 火曜日 22:25、Hans Nerdell さんは書きました: > table creation - arrays ? > > how are rows as ARRAYS specified and created o

Re: Mysql -- Putting user databases under user directory

re ;-) I havent yet tried them all myself, but they should work at least for the MyISAM tables. Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 13:19、Suba Arunkumar さんは書きました: > I want to put some of my users database under their > home directory, is it possible to do that. If so can

Re: Mysql -- Putting user databases under user directory

Paul is right (I should have metnioned it as well ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 13:40、Paul DuBois さんは書きました: > At 21:19 -0700 6/13/03, Suba Arunkumar wrote: > >I want to put some of my users database under their > >home directory, is it possible to

Re: Set no root password

Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 14:53、John Chang さんは書きました: > It worked!!. Thanks. Now how do I protect it so that not anyone who > points to it cannot get to it without putting in a username/password? > > At 12:24 AM 6/14/2003 -0500, John Nichel wrote:

Re: table creation - arrays ?

ighlights.html Read a bit "between the lines" and you will find it ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 16日 月曜日 01:19、あなたは書きました: > thanks for the info ! > wbrgds > Hans > > > From: "Nils Valentin" <[EMAIL PROTECTED]> > > >

log file question

Hello Mysql Fans ;-); 030613 16:05:54 3 Connect [EMAIL PROTECTED] on 3 Query SHOW VARIABLES 3 Query SET autocommit=1 3 Query SET autocommit=1 030613 16:05:55 3 Query USE `sam_group_by_db`

Re: upgrading, tuning and performance

immediately after you installed it. Whenever the performane question comes up than the first thing I read here in the mailing list "Are you still running one of those old 3.23-xx versions ?? ;-)" Unfortunately thats almost all I can tell you. Best regards Nils Valentin Tokyo/Japan 2003年

Re: Advanced how to's

ntation of what I feel would be useful to me ;-) and others. http://www.knowd.co.jp/staff/nils Once you created some documents make sure to let everybody know about it (here in the mailing list). Best regards Nils Valentin Tokyo/Japan 2003年 6月 17日 火曜日 05:05、Jonas Geiregat さんは書きました: > Hey

Re: fastest DB engine

Foreign key support for MyISAM tables is planned for version 5.0 (refering to some presentations of the UC). Best regards Nils Valentin Tokyo/Japan 2003年 6月 17日 火曜日 03:23、Becoming Digital さんは書きました: > > so i want userTypeID in tblUsers to be a foregn key referencing the > > userT

Re: Can not run mysql_install_db

Hi Roman, just saw this by chance. >sockstat -4l | grep 3306. I never heard of such a tool , also I did not find any info on the internet. I assume you dont mean sock, of course. Could you let me know where I can find the tool ? Best regards Nils Valentin Tokyo/Japan 2003年 6月 17日 火曜日

Re: Can not run mysql_install_db

Hi Roman, I see, thank you. I guess that translates for me on a Linux system than to "netstat". Best regards Nils Valentin Tokyo/Japan 2003年 6月 17日 火曜日 14:21、Roman Neuhauser さんは書きました: > # [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900: > > Hi Roman, > > &g

Re: Remote access to MySQL

s for the combinaion of "username" AND "hostname". In case you want to be able to access mysql from anywhere then you will need an ' % ' entry for the host. That would make your statement something like: GRANT ALL ON database TO 'root'@'%' IDENTI

Re: Advanced how to's

pics beeing maintained by "volunteers" with open source community background - (perhaps some guys from OSDL ;-). Anyway thats my 2 cent. Best regards Nils Valentin Tokyo/Japan 2003年 6月 18日 水曜日 07:52、Jeremy Zawodny さんは書きました: > On Tue, Jun 17, 2003 at 10:47:03AM +0900, Nils Valentin wro

Difference between MERGE and MRG_MYISAM tables ?

Hi Mysql fans ;-), I just came across this in the manual http://www.mysql.com/doc/en/CREATE_TABLE.html where it show as table types MERGE and MRG_MYISAM tables. Than I continued onto this page http://localhost/xoops/manuals/mysql/en/MERGE.html Where it says "You can only use identical MyISAM

Re: Long turn-around time.... and double sending

Well I have posted 4 replies (5 including this one), but they didnt came up yet in the mailing list. So let s wait and see. Best regards Nils Valentin Tokyo/Japan 2003年 6月 18日 水曜日 18:23、Primaria Falticeni さんは書きました: > Yes, in the last day the messages came twice and earlier. >

Re: MySQL, Second Edition -- German Translation

Hi Paul, Thank you. When are you posting the rest ? - o.k just joking ;-) Best reards Nils Valentin Tokyo/Japan 2003年 6月 19日 木曜日 05:46、Paul DuBois さんは書きました: > A German translation of MySQL, Second Edition is now (or will soon be) > available. The translation of Chapter 6 (The MySQL C A

Re: insert hang problem on Solaris 8

Hi Randy, I am not sure if this is working, but did you try the slow query log ?? Why I am not sure is because I believe the result is logged AFTER the request is complete (which never happens in your case if I understood correctly)? Best regards Nils Valentin Tokyo/Japan 2003年 6月 18日 水曜日

Re: development cycles at mysql-ab

s), - Alpha (no bugs that the MySQL development team knows of), - Developer version (which you will have to compile yourself, certainly not for production, not even for advanced users). Best regards Nils Valentin Tokyo/Japan 2003年 6月 19日 木曜日 10:31、activeducation さんは書きました: > Being new to

Re: my.cnf and passwords

Nils Valentin Tokyo/Japan 2003年 6月 21日 土曜日 05:36、Chris Hutchison さんは書きました: > Hello all, > > I'm pretty new to MySQL, but have managed to create a database that is > accessed via PHP which then creates tables from the MySQL data. > > Currently, I am using the root user/pas

Re: mysql ended error

quick way is to reinstall MySQL. You could try to copy the whole folder were the privilege database "mysql" is stored from another machine (if you have one). Best regards Nils Valentin Tokyo/Japan 2003年 6月 21日 土曜日 04:25、Pushpinder Singh Garcha さんは書きました: > hello all, > >

Re: Difference between MERGE and MRG_MYISAM tables ?

Hi Jorge, Paul, MySQL List, I believe Paul gave me a sufficient answer. Thanks Paul. >>It's a synonym for MERGE. Best regards Nils Valentin Toky/Japan 2003年 6月 22日 日曜日 06:40、Jorge Cornejo さんは書きました: > I believe this won't work: > > http://localhost/xoops/manuals/mysq

Privilege question

Hi MySQL Fans ;-); I saw in the online manual http://www.mysql.com/doc/en/SET_OPTION.html http://www.mysql.com/doc/en/Privileges.html A SUPER PRIVILEGE mentioned. How does it differ from the GRANT privilege ? I would appreciate if anybody could point me to some more detailed infomation of ea

  1   2   3   4   >