Re: MySQL client - server side help menu

executing this script [EMAIL PROTECTED] scripts]# The mysql demon is running. 1148 ?S 0:00 /bin/sh ./bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/usr/local/mysql/data/bumble-bee.office.knowd.co.jp.pid 1181 ?S 0:00 [mysqld] Best regards Nils Valentin Tokyo

Re: very long query time

Hi Maurice, I would be interested to see how your SQL reuqest looks like. Perhaps it is possible to optimize at this point, just a guess so. Best regards Nils Valentin Tokyo/Japan 2003 6 27 18:34Maurice Coyle : hi all, i have a table in my mysql database with around 66 million rows

Re: Best Practices for mySQL Backups in Enterprise

Hi Gerald, Do you know some good information about it, seems like I need to brush up a bit on this. I dont understand how you want to do a roll forward for a MySQL table - especially if the backup is lets ay from 8 AM and the crash is at 2 PM. Best regards NIls Valentin Tokyo/Japan 2003 6

Re: error message during connection

PROTECTED] 127.0.0.1' USING PASSWORD(YES) The part saying '[EMAIL PROTECTED] 127.0.0.1' looks strange to me as it states localhost AND 127.0.0.1. Its the first time I saw this, but I haven't used tomcat. I would expect it to say 127.0.0.1 OR localhost but I might be wrong. Best regards Nils

Re: Best Pratices for mySQL Backups in Enterprise

alone could make a big difference, depending if you are using fulltext index or not. Best regards Nils Valentin Tokyo/Japan 2003 6 28 04:23Keith C. Ivey : On 27 Jun 2003 at 14:49, David Brodbeck wrote: FWIW, if size is a problem, mysqldump files compress quite well with gzip. (Lots

DELETE SYNTAX - [QUICK] option

Hi MySQL Fans ;-); Does anybody understand what the QUICK option is doing when used with the DELETE command ? It says in the manual ..no MERGEing of INDEX leaves during delete. Sorry, but I could not make any sense out of this. Could somebody please be so kind to enlighten me ? I guess it is

Re: Dumping data

Hi Rob, I think there was a similar question today. Is mysqldump -T perhaps doing what you are looking for ? Best regards Nils Valentin Tokyo/Japan 2003 6 26 17:[EMAIL PROTECTED] : Text1 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp

MySQL client - server side help menu

Hi MySQL Fans, I understood that within the mysql command line client there exist two help pages: a client help page - accessable with help a server help page accessable with help all I found that the file (seems like a table within the mysql privilege database) was not included in the 4.1

Re: Best Practices for mySQL Backups in Enterprise

Hi Subhakar, I would be interested to know what you mean with roll forward ? In case you have another backup let's say @10AM you could use this one, but if you dont have another backup where do you want to do a roll forward from ?? Do I miss something here ?? Best regards Nils Valentin Tokyo

Re: URGENT problem with mysql processes

Hi Keith, The wrong IP address could only avoid a client to connect to the database server. If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in config.inc.php or which ever tool you use than of course it will try to connect to this IP address. Best regards Nils

Re: Join vs. Where (help)

2003 6 25 15:[EMAIL PROTECTED] : This: SELECT * FROM machines INNER JOIN people ON machines.machinesID=people.peopleID; Inludes NULL records Is not producing the same results as this: SELECT lastname, model FROM people, machines WHERE machines.peopleID = people.peopleID; Dosent

Re: Join vs. Where (help)

still remain correct. The statement above does not return the NULL record while the other one does INNER JOIN) Best regards Nils Valentin Tokyo/Japan 2003 6 25 15:37Nils Valentin : 2003 6 25 15:[EMAIL PROTECTED] : This: SELECT * FROM machines INNER JOIN people ON machines.machinesID

Subselect functionality

Hi MySQL Fans ;-), I have a question regarding the MySQL feaures. From Version 4.1 Full subselect support was/is announced. However if I understood correctly then already from Version3.23-41 (or earlier) there are some subselect functions already included. For xample if I try this: CREATE

Re: Join vs. Where (help)

statement. Does it make it a bit clearer ? Sorry dont know how to better explain it really. Best regards Nils Valentin Tokyo/Japan 2003 6 25 17:[EMAIL PROTECTED] : What do you mean when you say, in this case, does not return the NULL record? I have no records that are completely NULL though

Re: datetime column dummy question

Also doesnt work in 4.1 alpha. Best regards Nils Valentin Tokyo/Japan (As requested I took Roman of , as he doesnt like direct e-mails ;-) 2003 6 25 19:12Roman Neuhauser : # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100: Sometime recently MaFai said: A table contains a column named

Re: Subselect functionality

- from the manual I misunderstood that nested queries and subselects are the same, which is obviously not the case as I heard now. I understood that Subselects originally exist of 2 or more SELECT... statements. Best regards Nils Valentin Tokyo/Japan 2003 6 25 19:53Egor Egorov : Nils

Re: Temporary tables - MySQL 4.1 alpha

, is that right ? Best regards Nils Valentin Tokyo/Japan 2003 6 25 19:17Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: I have some questions about temporary tables. I would appreciate any replies: I created a temporary table f.e. like this: mysql create temporary table temp

Re: user privileges question

not exactly what you are after, but I think the point about the privilege database becomes clearer. For other databases I believe you have to define one at a time, which allows you to set it up exactly to your needs. Hope that helps. Best regards Nils Valentin Tokyo/Japan 2003 6 26 07

Re: Multi-table count

regards Nils Valentin Tokyo/Japan 2003 6 26 05:05Mike Morton : I have searched the archives and the docs - and I cannot seem to find or adapt an answer to this particular problem, hopefully someone out there either knows how or can say simply that it cannot be done. I have two tables

Re: mysql ended error

serverside/MySQL (sorry page was temporary unavailable when I wrote this). Best regards Nils Valentin Tokyo/Japan 2003 6 25 23:20Pushpinder Singh Garcha : Thanks you Nils . I truly appreciate how helpful you have been !! I have now got the error sorted out now. I re-installed MySQL

Re: Subselect functionality

and nested queries. Best regards Nils Valentin Tokyo/Japan 2003 6 25 23:19Mike Hillyer : I am not sure that could be viewed as a subselect, as it in not a SELECT within an SELECT, but is instead a SELECT within a CREATE. I would imagine that the SELECT within the CREATE is easier

Re: Temporary tables - MySQL 4.1 alpha

Hi Vitcoria, Thank you for the response. No more questions about this, all systems clear now ;-). Thank you so much. Nils Valentin Tokyo/Japan 2003 6 25 21:18Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: WOW Victoria, thats a good explanation. That makes many things

Re: Join vs. Where (help)

regards Nils Valentin Tokyo/Japan 2003 6 25 22:09Bruce Feist : Nils Valentin wrote: SELECT * FROM machines INNER JOIN people ON machines.peopleID=people.peopleID; Inludes NULL records I meant the first statement returns also empty record fields or should I say incomplete data

Re: Warning: thr_alarm queue is full

This is what perror says about error 134 Error code 134: Unknown error 134 134 = Record was already deleted (or record file crashed) Hpe that makes any sense to you. Best regards Nils Valentin Tokyo/Japan 2003 6 26 09:04Ian Collins : My MySQL database just stopped. I had 47 users running

Re: user privileges question

Hi Paul, 2003 6 26 09:55Paul DuBois : At 9:19 +0900 6/26/03, Nils Valentin wrote: Hi Michael, you raised an interesting question. I created a new account (testroot) I gave him all privileges - except the GRANT privilege. GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx

Re: Join vs. Where (help)

this threat as it s kind of attached to it. Thank you for your reply. Best regards Nils Valentin Tokyo/Japan 2003 6 25 22:09Bruce Feist : Nils Valentin wrote: SELECT * FROM machines INNER JOIN people ON machines.peopleID=people.peopleID; Inludes NULL records I meant the first

Re: INSERT help (simple insert?

. Be careful with UPDATE .. when not using a WHERE clause. I suggest you try this on a test database as otherwise you may want to blame me for the advice given ;-). Best regards Nils Valentin Tokyo/Japan 2003 6 26 13:[EMAIL PROTECTED] : I want to insert a value into a (one) field of all

Re: Can you get the results of an UPDATE command?

one on big tables ;-). I know it is not what you were originally asking for, but in this way you could increase the availability of the server. Best regards Nils Valentin Tokyo/Japan 2003 6 24 16:02Jason : I've looked around and believe this to not be possible, but am checking just

Re: mysql 4.1 client authentication

in Version 4.1 the passwords are 45 bits in Version 4.1 passwords are 16 bits Upgrade your client will make it work again. You sould be able to connect from any 4.1 mysql client. Best regards 2003 6 25 03:[EMAIL PROTECTED] : Does anyone know what is different in mysql 4.1 client

Temporary tables - MySQL 4.1 alpha

Hi MySQL Fans ;-), I have some questions about temporary tables. I would appreciate any replies: I created a temporary table f.e. like this: mysql create temporary table temp SELECT * FROM relations; Query OK, 4 rows affected (2.35 sec) Records: 4 Duplicates: 0 Warnings: 0 When I do mysql

Re: mysql 4.1 client authentication

Uuups I meant 16 bytes and 45 bytes of course ;-) - otherwise anybody with a 286 could have found out ;-) Best regards Nils Valentin Tokyo/Japan 2003 6 25 07:35Nils Valentin : in Version 4.1 the passwords are 45 bits in Version 4.1 passwords are 16 bits Upgrade your client will make

Re: mysql ended error

;-) Let me know the outcome please. Best regards Nils Valentin 2003 6 24 02:43Pushpinder Singh Garcha : Is there an mysql directory in /usr/local/mysql/data? [psg:/usr/local/mysql] psgarcha% sudo ls data 127.0.0.1.errib_logfile1 psg.local..err ShwetaParekh

Re: mysql ended error

/mysql/data. Therefore you will not have the folder /usr/local/mysql/data/mysql which would contain the privilege database. Then your server could startup fine ;-) S, that should be really it. Lng story short end Linux account rights problem ;-) Best regards Nils Valentin Tokyo/Japan

Re: my.cnf and passwords

No, no yu are welcome ;-) Best regards Nils Valentin Tokyo/Japan 2003 6 24 02:29: Ahh thank you for the clarification. It is most appreciated! Cheers, Chris -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 5:42 PM To: Chris

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

Re: Remote access to MySQL

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'@'%' IDENTIFIED BY 'password'; Best regards Nils Valentin Tokyo/Japan 2003 6 16 08:28Renato

Re: Advanced how to's

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:52Jeremy Zawodny : On Tue, Jun 17, 2003 at 10:47:03AM +0900, Nils Valentin wrote: Hi Jonas, don't get me wrong, but I strongly believe

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:23Primaria Falticeni : Yes, in the last day the messages came twice and earlier. Iulian - Original Message

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:46Paul DuBois : A German translation of MySQL, Second Edition is now (or will soon be) available. The translation of Chapter 6 (The MySQL C API) is available

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 23

Re: development cycles at mysql-ab

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:31activeducation : Being new to mySQL could someone kindly shed some light

Re: my.cnf and passwords

Nils Valentin Tokyo/Japan 2003 6 21 05:36Chris 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/password combo to grab the info (which means

Re: mysql ended error

. The 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:25Pushpinder Singh Garcha : hello all, i hve been getting the 'mysql ended

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:40Jorge Cornejo : I believe this won't work: http://localhost/xoops/manuals/mysql/en/MERGE.html localhost??? put your Ip

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 6 16 21

Re: Advanced how to's

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:05Jonas Geiregat : Hey, I've been learning sql

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:23Becoming Digital : so i want userTypeID in tblUsers to be a foregn key referencing the userTypeID col in userTypes both

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 06:22Roman

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:21Roman Neuhauser : # [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900: Hi Roman, just saw this by chance. sockstat -4l | grep 3306

Re: table creation - arrays ?

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] To: Hans Nerdell [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: table creation - arrays ? Date: Sat, 14 Jun

Re: Set no root password

Hi John, You saved my day. Haven't laughed like this for long time ;-) How do I set no password for root? 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? Thanks a lot really. Best regards Nils

Re: open source shema relationship diagram tool

can it ? www.lysator.liu.se/~alla/dia/ I was unaware that windows is running under GPL and with GTK ;-) Taken from 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

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:24Mehmet KADAYIFI : Hi, I develop applications that about GIS. I am

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:24Mehmet KADAYIFI : Hi, I develop applications that about GIS. I am using Oracle Database for our projects. We store our geographical

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:23Bruce Dembecki : I thought I had most

Re: identifying foreign keys

SHOW CREATE TABLE tblname; Best regards Nils Valentin Tokyo/Japan 2003 6 14 05:22Michael 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 don't seem to see

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:25Hans Nerdell : table creation - arrays ? how are rows as ARRAYS specified and created on a table ? wbrgds hans

Re: Mysql -- Putting user databases under user directory

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:19Suba Arunkumar : I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right

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:40Paul 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 do that. If so can any one point me

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

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:02Becoming Digital : According to Sams Publishing (April 2002): The Berkeley DB table type is a usable

Re: forming foreign keys

questions now. I will try it now and feedback shortly. Best regards Nils Valentin Tokyo/Japan 2003 6 11 22:41Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: Thank you for the reply. I understand now that it must be the first part of the primary index in both related tables

Re: mySQL GUIs

;-) 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:21Adam Nelson : I like

Re: mySQL GUIs

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:23Knepley, Jim : Nils, and other well meaning members who mail me directly: I subscribe to the digest for a reason, please do not copy

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:17Daniel 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 at the moment please let me

Re: Unicode(ucs2) setup question

it 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:04Yuji Sato : Hi Nils, I have no ucs2.xml in the /usr/local/share/mysql/charsets/ . but I

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:54Juan 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 UTF-I. I am waiting

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:17Victoria Reznichenko : Nils Valentin [EMAIL

Re: forming foreign keys

? Best regards Nils Valentin Tokyo/Japan 2003 6 11 21:20Nils 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: Can I change the order of the keys ? Best regards

Re: Printing table descriptions

to print them regularly) ? ;-) Best regards Nils Valentin Tokyo/Japan 2003 6 11 22:29Fernando 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 is send each of the screens to a file

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:32Martin Waite : On Wed, 2003-06-11 at 14:29, Fernando Gerent wrote: Hi! I need to print the description of all tables in my database

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:18Chris McKeever : I also found out that mysqld --help provides a whole lot more of the information

Re: InnoDB question(s)

the orginal dbname). Best regards Nils Valentin Tokyo/Japan 2003 6 10 14:55Becoming Digital : http://www.innodb.com/ibman.html#Backing_up See the section on Forcing Recovery. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Nils Valentin [EMAIL

Re: forming foreign keys

Hi Victoria, 2003 6 10 19:16Victoria 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 somehow I am missing something. What I try to do is recreate

Re: Practice test

Hi Rich, Jeremy,, Mysql List 2003 6 10 23:51Jeremy 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/selftest/core/index.php I

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:55Jeremy 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 next time this

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:13Joe Gaffney : Can someone help with trying to remove a foreign key constraint from a table. Each time I run the alter table statement

Re: droping foreign key

- 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 to recreate the table to remove the foreign key. Best regards Nils Valentin Tokyo/Japan 2003 6 11 10

Re: forming foreign keys

| | +---++--+--+-+---+-+--++--++-+ Any comments appreciated. Nils Valentin Tokyo/Japan 2003 6 10 22:52Nils Valentin : Hi Victoria, 2003 6 10 19:16Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: I try to create foreign keys in a innodb database. I read through some

Re: forming foreign keys

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 2003 6 11 11:06Nils Valentin

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:44Yuji Sato : I'd like to use ucs2 character set

Re: detailed FULLTEXT index and search help needed

to 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:25H M Kunzmann : Hello All. I have a table that is about 1.5GB

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 Valentin

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

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

described the 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 out? ;-) I was wondering if you guys

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:49Ioana : 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, what is the syntax... could

Re: Certification study quide from Dubois, Hinz and Pedersen

Hi Paul, 2003 6 10 01:26Paul DuBois : At 1:08 +0900 6/10/03, Nils Valentin wrote: offlist Hello Stefan, well I have my sources ... ;-) .. I guess its no secret ,especially as it was announced on the UC. I guess when you say Q3 you mean the english version, will there also

Re: arrangement of fields in a table

Nils Valentin Tokyo/Japan 2003 6 10 02:40Mojtaba 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 doesn't matter? Is accessing

Re: diff between 7.2 and 8.0 rights?

this mailing list ;-) Best regards Nils Valentin Tokyo/Japan 2003 6 10 03:36Obantec 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 and has been in use for over 1 year works as expected. [EMAIL PROTECTED] [/var/lib

Re: Trouble with SELECT AS syntax

regards Nils Valentin Tokyo/Japan 2003 6 10 10:53Becoming 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 accordance with the manual (http://www.mysql.com/doc/en/SELECT.html

Re: Trouble with SELECT AS syntax

Jim was faster ;-), ..but I am getting there. Best regards Nils Valentin Tokyo/Japan 2003 6 10 11:18Jim 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' is a reserved word. Try: SELECT

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:18Jim Winstead : On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: SELECT item_name AS name

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 startsup

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

Re: mysql for users

just another document ;-). They are really worth the time. Best regards Nils Valentin Tokyo/Japan 2003 6 7 00:20jude dashiell : I got mysql working for root and got a password for mysql set by root as well. I got into the tutorial and managed to populate the pet table with the load command

Re: How to select without using sub-select?

Hi Ola, How about SELECT id, title, max(version) FROM table GROUP BY version ORDER BY title; ? Thats a guess though... Best regards Nils Valentin Tokyo/Japan 2003 6 5 22:[EMAIL PROTECTED] : Hi, I am running MySQL 4.0.10 gamma. I have records with data: id title version 1

Re: ERROR 2003: Can't connect to MySQL server on ....

the output of SHOW GRANTS FOR username; I am am confident to be able to help you quickly knowing the ouptut. Best regards Nils Valentin Tokyo/Japan 2003 6 6 09:41Francisco Castellon : Hi: Thanx for the response. But yes the ZEUS.OLYMPUS.LOCAL host is in the mysql.user database for the user root

<    1   2   3   4   >