Please help me.

[Valentin Ionescu]

Hi!
My name is Valentin and I am writing to you for the following problem:
I created a database containing the table:
 
CREATE TABLE `documents_ex` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Journal_ex_ID` int(10) unsigned DEFAULT NULL,
  `Documents_ID` int(10) unsigned DEFAULT NULL,
  `Data` datetime DEFAULT NULL,
  `Nr` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Journal_ex_ID` (`Journal_ex_ID`,`Documents_ID`,`Data`,`Nr`),
  KEY `Documents_ID` (`Documents_ID`),
  CONSTRAINT `documents_ex_ibfk_1` FOREIGN KEY (`Journal_ex_ID`) REFERENCES 
`journal_ex` (`ID`) ON DELETE CASCADE,
  CONSTRAINT `documents_ex_ibfk_2` FOREIGN KEY (`Documents_ID`) REFERENCES 
`documents` (`ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1
 
After some time I decided to drop 'Journal_ex_ID' column and all its 
environment from this non empty table.
All I tried to do like:
 
alter table documents_ex drop column Journal_ex_ID
or
alter table documents_ex drop foreign key  Journal_ex_ID
or 
alter table documents_ex drop  key  Journal_ex_ID
 
 I receive the same error 150 and I don't know what to do.
 
Please help me.
 Best regards.


 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

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

[Nils Valentin]

Hi yannick,

Not sure if you have found the problem yet, any way there are many tutorials 
online which explain how to proberly setup user accounts.

[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
yannick

etc. are all separate users with different rights. So the combination of 
username, hostname and password is to be thought of as a set.

have alook at below links, which I hope help you kichstart and troubleshoot 
any issues you are having.

http://www.devshed.com/c/b/MySQL/
http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/
http://www.php-mysql-tutorial.com/mysql-tutorial/add-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 following site stops working :
 http://www.wxy.nl/zorum_3_5/  with the database ZORUM


 Here PHPadmin doesn't give me any privilege to create anything :
 http://www.wxy.nl/phpMyAdmin/


 I beleive I'm not to far from having it working ut I still have this
 priviledge issue.

 BEst regards

 Yannick


 -Message d'origine-
 De : Yannick [mailto:[EMAIL PROTECTED]
 Envoy : Monday, June 13, 2005 11:54 PM
  : [EMAIL PROTECTED]
 Cc : mysql@lists.mysql.com
 Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
 spam


 Kevin,

 Thanks for your answer. See below the results :
 * I' really wondering if there is not any missing files.
 * The mysql.soc file is complettly empty
 * I can only access myssql when I am not in root.
 * I can only see 1 database test when I know there is others like zorum
 which is working
 * The command Grant doesn't work.
 The result is that I can never access any database.

 I have been folowing the installatin process but it still does not work.
 Do you mind to have a look at the details below and advice on which files I
 should have a look.

 Thanks in advance.

 Yannick


 fujitsu:/etc # mysql -u root
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
 fujitsu:/etc # su mysql
 [EMAIL PROTECTED]:/etc mysql
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 9 to server version: 4.0.15-Max

 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 mysql quit
 Bye
 [EMAIL PROTECTED]:/etc mysql -u root
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
 [EMAIL PROTECTED]:/etc mysql -u mysql
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 11 to server version: 4.0.15-Max

 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 mysql quit
 Bye
 [EMAIL PROTECTED]:/etc su
 Password:
 fujitsu:/etc # mysql -u mysql
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
 fujitsu:/etc # mysql -u yannick
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
 YES)
 fujitsu:/etc # su mysql
 [EMAIL PROTECTED]:/etc mysql -u yannick
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 14 to server version: 4.0.15-Max

 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('Yannick');
 ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
 mysql SET PASSWORD FOR 'yannick' = PASSWORD('Yannick');
 ERROR 1133: Can't find any matching row in the user table
 mysql
 mysql show databases;
 +--+

 | Database |

 +--+

 | test |

 +--+
 1 row in set (0.00 sec)

 mysql
 mysql UPDATE mysql.user SET Password = PASSWORD('Yannick')
 - ;
 ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
 mysql
 fujitsu:/bin # mysqlshow
 mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
 fujitsu:/bin # mysql -e SELECT Host,Db,User FROM db mysql
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
 fujitsu:/bin #  bin/mysqld_safe --user=mysql --log 
 bash: bin/mysqld_safe: Aucun fichier ou rpertoire de ce type
 [1] 16599
 [1]   Exit 127bin/mysqld_safe --user=mysql --log
 fujitsu:/bin # mysqladmin version
 mysqladmin: connect to server at 'localhost' failed
 error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
 fujitsu:/bin #
 mysql SHOW DATABASES;
 +--+

 | Database |

 +--+

 | test |

 +--+
 1 row in set (0.00 sec)

 mysql GRANT ALL ON menagerie.* TO 'mysql'@'localhost';
 ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
 mysql GRANT ALL ON test TO 'mysql'@'localhost';
 ERROR 1046: No Database Selected
 mysql select test;
 ERROR 1054: Unknown column 'test' in 'field list'
 mysql use test
 Database changed
 mysql GRANT ALL ON test TO 'mysql'@'localhost';
 ERROR 1044: Access denied for user: '@localhost' to database 'test'
 mysql

 -Message d'origine-
 De : Kevin

Re: Need help

[Nils Valentin]

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, madderla sreedhar wrote:
 Isn't MySql supports large amounts of data to be
 stored in databases. What is the maximum number of
 records  that can be handled or stored in Mysql.
 Is there any limit. If i want to store large
 amounts of data then is it necessary to migrate to
 another database. Please reveal this .

 Any help is welcome.

 Thanking you ,
 Sreedjhar.


 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam protection around
 http://mail.yahoo.com

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

Recreating primary index on MyIsam table

[Nils Valentin]

Hi MySQL fans ;-),

I was just asked recently with the task to recreate a tables index 
gracefully on a MyIsam table.

This is the table layout:

CREATE TABLE `cl` (
  `c_serial` int(11) NOT NULL auto_increment,
  `cname` tinytext NOT NULL,
  `cl_vals` text NOT NULL,
  `utime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`c_serial`)
) TYPE=MyISAM


So the task is to recreate the current primary key (c_serial),so that the 
current index would start with 1,2,3,4,
Currently the numbers are all over the place. To make this simple (for now) 
there are no dependencies to other tables so the order of the index doesnt 
really matter, its more for the admins  peace of mind ;-)

I tried the obvious first, removing the column completely and adding the 
primary key, which left me with a lot of 0s - which is not what I had in 
mind ;-).

I know this 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

[Nils Valentin]

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 primary key (c_serial),so that the
  current index would start with 1,2,3,4,

 SET @i=0;
 UPDATE c1 SET c_serial=(@i:[EMAIL PROTECTED]);

 PB

 -

 Nils Valentin wrote:
 Hi MySQL fans ;-),
 
 I was just asked recently with the task to recreate a tables index
 gracefully on a MyIsam table.
 
 This is the table layout:
 
 CREATE TABLE `cl` (
   `c_serial` int(11) NOT NULL auto_increment,
   `cname` tinytext NOT NULL,
   `cl_vals` text NOT NULL,
   `utime` int(11) NOT NULL default '0',
   PRIMARY KEY  (`c_serial`)
 ) TYPE=MyISAM
 
 
 So the task is to recreate the current primary key (c_serial),so that the
 current index would start with 1,2,3,4,
 Currently the numbers are all over the place. To make this simple (for
  now) there are no dependencies to other tables so the order of the index
  doesnt really matter, its more for the admins  peace of mind ;-)
 
 I tried the obvious first, removing the column completely and adding the
 primary key, which left me with a lot of 0s - which is not what I had in
 mind ;-).
 
 I know this 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

 --
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.308 / Virus Database: 266.9.5 - Release Date: 4/7/2005

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

MySQL Users Conference 2005 - Call for Papers is Open

[Nils Valentin]

Hi MySQL community,

As some of you, I did a presentation at the UC2004 about Using MySQL in a 
Japanese environment  - and avoiding common pitfalls, which can also be 
found online.

http://www.be-known-online.com/mysql/

During the first 6 months I had so far 250 downloads, only for this single 
article on my homepage and probably many more on MySQLs homepage. 

http://www.mysql.com/news-and-events/users-conference/2004/

Thank you very much for anybody who showed interest.
As most of you know, the call for papers just started.

1) I am thinking about continuing the national character / Unicode issues and 
would like to hear which issues you have, what bothers you most.

I am already considering the following suggestion:

a) exploring national Character Sets / Java environment issues
 (supported fonts  functions by Sun, IBM etc..)

The follow up title would probably be something like

Using MySQL in a Japanese environment - x

Please send any ideas, suggestions or any rant you might want to leave ;-)

2) If my time allows it, I am considering to apply for holding a half day 
workshop.

I would naturally tend to expand the national character set issues, which will 
allow to explore the issues described with national characters more detailed.

Anybody interested in this kind of topic ? 
Note: No need to reply if not, otherwise my mail server might crash ;-)

-- 
Greetings from Tokyo

Nils Valentin

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: what os to use for mysql on amd64?

[Nils Valentin]

Hello MC,

any results yet by any chance ? What conclusion did you get out of your test ?

There is another threat going on with the subject line Re: best-performing 
CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

Best regards

Nils Valentin
Tokyo/Japan




On Tuesday 27 July 2004 12:39, bad corn wrote:
 Hi all,

 Recently our company has purchased a dual amd64 opteron machine for mysql
 server purpose.
 It seems that there are not many os choices for us.

 Here is the list of OS that we are going to test (in listed order):
 - debian   (amd64)
 - fedora2  (amd64)
 - suse (amd64 or 32bit mode)
 - solaris9 (32bit x86 mode)
 - debian   (32bit mode)

 FreeBSD is temporary not on our list because I have done some simple
 testing on FreeBSD/AMD64, and it was a nightmare... unfortunately we didn't
 have time to conduct the thing more thoroughly so we gave it up. We don't
 want to run freebsd in 32bit mode + linuxthreads.

 Debian is our first choice, but on the Debian/AMD64 howto, it is stated
 that the port is still in beta stage. Does anyone have experiences with
 debian/amd64 + mysql? I would love to know if mysql will run on it before
 giving it a try..

 Here are the questions that I have:
 1) What is the reason that mysql doc suggest people to use SuSE? I believe
 it is the kernel and libc that matters, but it seemed to me that most of
 the mysql/amd64 development and benchmarks are carried out on SuSE, RedHat
 or their derivatives.
 2) Whether the distro has thousands of applications is not relevant to us,
 because we will be running mysqld on the box only.
 3) Perhaps if anyone on this list would suggest me stick to 32bit os at the
 moment?

 Personally speaking, I don't like RedHat and SuSE (sorry but I am not here
 to start a distro war :)), so I would like to stay away from them as much
 as possible. Plus I have no experience with them at all.

 Besides, I heard from someone that Solaris10 will be quite good for MySQL
 purpose, could anyone comment on this? And if it is really good, does
 anyone know when is it going to be available to the public? Even beta
 releases are ok.

 I am new to the AMD64 world, and so I would love to hear from all of you.
 Thanks all :)

 Cheers,
 mc.

-- 
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: what os to use for mysql on amd64?

[Nils Valentin]

Sorry last e-mail didnt contain all text for whatever reason it should be like 
this:
--
 Hello MC,

 any results yet by any chance ? What conclusion did you get out of your
 test ?

 There is another threat going on with the subject line Re: best-performing
 CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

I am sure that anybody will appreciate any comments on the hot discussed 
topic.

 Best regards

 Nils Valentin
 Tokyo/Japan
www.be-known-online.com/mysql


---
 On Tuesday 27 July 2004 12:39, bad corn wrote:
  Hi all,
 
  Recently our company has purchased a dual amd64 opteron machine for mysql
  server purpose.
  It seems that there are not many os choices for us.
 
  Here is the list of OS that we are going to test (in listed order):
  - debian   (amd64)
  - fedora2  (amd64)
  - suse (amd64 or 32bit mode)
  - solaris9 (32bit x86 mode)
  - debian   (32bit mode)
 
  FreeBSD is temporary not on our list because I have done some simple
  testing on FreeBSD/AMD64, and it was a nightmare... unfortunately we
  didn't have time to conduct the thing more thoroughly so we gave it up.
  We don't want to run freebsd in 32bit mode + linuxthreads.
 
  Debian is our first choice, but on the Debian/AMD64 howto, it is stated
  that the port is still in beta stage. Does anyone have experiences with
  debian/amd64 + mysql? I would love to know if mysql will run on it before
  giving it a try..
 
  Here are the questions that I have:
  1) What is the reason that mysql doc suggest people to use SuSE? I
  believe it is the kernel and libc that matters, but it seemed to me that
  most of the mysql/amd64 development and benchmarks are carried out on
  SuSE, RedHat or their derivatives.
  2) Whether the distro has thousands of applications is not relevant to
  us, because we will be running mysqld on the box only.
  3) Perhaps if anyone on this list would suggest me stick to 32bit os at
  the moment?
 
  Personally speaking, I don't like RedHat and SuSE (sorry but I am not
  here to start a distro war :)), so I would like to stay away from them as
  much as possible. Plus I have no experience with them at all.
 
  Besides, I heard from someone that Solaris10 will be quite good for MySQL
  purpose, could anyone comment on this? And if it is really good, does
  anyone know when is it going to be available to the public? Even beta
  releases are ok.
 
  I am new to the AMD64 world, and so I would love to hear from all of you.
  Thanks all :)
 
  Cheers,
  mc.

-- 
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: Change Character Set for one user

[Nils Valentin]

Hi Mike,

if you refer to MySQL 4.1 then yes you an do that. (I assume you are speaking 
about the server side configuration).

I have made a presentation Using MySQL in a Japanese environment on the 
UC-2004 which can be found here:

www.be-known-online.com/mysql

I hope that this helps a bit.

Best regards

Nils Valentin
Tokyo / Japan

On Monday 10 May 2004 23:42, Mike Blezien wrote:
 Hello,

 is it possible to change the default character set for one mysql user
 without affecting the global character set setting, via the the user's
 .my.cnf option file ??

 thx's
 --
 MikemickaloBlezien
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 Thunder Rain Internet Publishing
 Providing Internet Solutions that work!
 http://www.thunder-rain.com
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

-- 
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: User Conference Presentations

[Nils Valentin]

Hi Reed,

Unfortuntaely I am unable to answer your question, but my presentation Using 
MySQL in a Japanese environment ... and avoiding common pitfalls is online 
at

http://www.be-known-online.com/mysql/

Hope that helps.

On Friday 07 May 2004 12:02, Ed Reed wrote:
 Where's the presentations? They were supposed to be on the website at
 the end of last week.

 Thanks

-- 
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: Documentation on character sets for version 4.0.17

[Nils Valentin]

Hi David,
(B
(BThank you for the detailed description. That certainly makes things easier to 
(Bargue now ;-).
(B
(BO.K Where to start ?
(B
(BFirst, as you know in version 4.0 you can basically set the character sets 
(Bonly for server and client side (not for DB, table, columns, connection and 
(Bresult sets).
(B
(BYou could set this from an application like Phpmyadmin I believe, BUT (note 
(Bits a big but) if you are on a rental server, than I doubt that this will 
(Bwork, as you will also change other users character set.
(B
(BSo I guess for now you will have to stay right were you are.
(B
(B
(B- Using MySQL 4.1
(B
(BNow lets assume 4.1 becomes stable today or tomorrow (just assuming, I have no 
(Binfo on this ;-)
(B
(BIn this case you would set the character set for the DB, table,columns etc. 
(Bf.e from Phpmyadmin. You would input the query into the editor and ask 
(BPhpmyadmin to execute it.
(B
(BI have not tried it, but that should work (if you have those privileges).
(B
(B- Separating the characters for several cgi scripts
(B
(BI am unable to help here really. I work mostly with a single cgi.
(BI can imagine that (assuming the cgi supports asian characters) it is just a 
(Bmatter of passing the right fields to the right cgi script.
(B
(BI would not suggest mixed fields in a table. Its probably wiser to separate 
(Bcolumns for asian texts and non-asian texts.
(B
(B
(B- About the search function with asian characters
(B
(BThis is a very hot issue. It wasnt discussed often yet here on the mailing 
(Blist. As described on page 21 in my presentation, Regexp() does NOT yet work 
(Bwith asian characters. Please use "LIKE" for the moment. I am not even sure 
(Bif "MATCH ... AGAINST" does work yet.
(B
(BI believe the manual mentioned somewhere which commands are supposed to work 
(Bwith asian characters.
(B
(B
(B- To sum it all up
(B
(BI hope that this answers the most important ones of your questions. With the 
(Bcgi I am a bit unable to help really. If the cgi is known to work with 
(BJapanese characters then it should really just be a matter of separating the 
(Bform fields for each cgi script.
(B
(BHowever using 4.0.xx your main issue will be that you need to change the 
(Bcharacter set on a rental server sharing the same MySQL server with different 
(Busers.
(B
(BBest regards
(B
(BNils Valentin
(BTokyo / Japan
(B
(B
(B
(B
(BOn Wednesday 05 May 2004 04:05, David Jourard wrote:
(B Nils,
(B
(B At 05:30 PM 5/4/04 +0100, you wrote:
(B Basically the best guess would be the documentation that comes with your
(B download. Note that online documents at www.mysql.com are always a mixture
(B  of several documentation versions really.
(B
(B Thats the problem.  Yesterday, I downloaded 4.0.1x yet the documentation
(B that comes with it in regards to asian character set etc. is 4.1
(B
(B But the application I'm working with is a perl/cgi/mysql thing on a virtual
(B hosted site and is using 4.0.15 (which means I can only set things from the
(B application level or via the connection string.)
(B
(B I need to know how to set this up for this version not 4.1
(B
(B  From your documentation I gather I need to tell the server what character
(B set to use and also about data coming from and going to the client.
(B
(B My problem is I'm not too sure how to start.
(B
(B Here is the data flow:
(B
(B Storing Data
(B 
(B
(B 1. web page (uses shift_sjis) --
(B 2. cgi app captures form data  with mixed fields eg. english and japanese
(B 3. cgi app --- saves data to mixed fields in a table.
(B
(B Is there something I do at the point data is being saved. Save one field in
(B one kind of encoding and the other in another kind of coding.
(B
(B OR is there something I indicate by a property of the field
(B
(B
(B Retrieving Data
(B ---
(B 1. cgi app searches on varchar fields both japanese and in english
(B 2. cgi app searchs on text fields using fulltext engine for keyword
(B searches.
(B
(B
(B Everything works fine for the english but the searches in japanese are not
(B working.
(B
(B I'm thinking maybe it has something to do with the encoding in the japanese
(B fields which I'm not sure how to do at the field level for version 4.0.15
(B
(B Thanks
(B
(B David J.
(B
(B-- 
(Bkind regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(Bhttp://www.be-known-online.com/mysql/
(B
(B-- 
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation on character sets for version 4.0.17

[Nils Valentin]

Hi David,
(B
(BYou may find my UC-2004 presentation useful as well as some UC-2003 
(Bpresentations from Mr. Gulutzan and Mr. Barkov:
(B
(Bwww.be-known-online.com/mysql
(Bmysql.planetmirror.com/Downloads/Presentations/MySQL-User-Conference-2003/National-Character-Sets-and-Unicode.pdf
(B
(BBasically the best guess would be the documentation that comes with your 
(Bdownload. Note that online documents at www.mysql.com are always a mixture of 
(Bseveral documentation versions really.
(B
(BI am not 100% if this answer all of your questions, but at least in my 
(Bpresentation you should find 90% of all the information you require.
(B
(BShould you have any other question, please do not hesitate to ask me.
(B
(BBest regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(BOn Wednesday 05 May 2004 01:16, David Jourard wrote:
(B Victoria ,
(B
(B Thank-you.
(B
(B At 01:35 PM 5/4/04 +0300, Victoria Reznichenko wrote:
(B David Jourard [EMAIL PROTECTED] wrote:
(B   I got the 4.0.17 documentation but when it discusses character sets it
(B   discusses this topic wrt 4.1
(B  
(B   Where can I find documentation specifically in regards to the
(B   production version on how to work with,  store, and search asian
(B   character sets specifically Japanese.
(B 
(B In version 4.0.17 you should specify character set with
(B --default-character-set option. For Japanese language take a look at sjis
(B and ujis character sets:
(B  http://dev.mysql.com/doc/mysql/en/Character_sets.html
(B
(B a. I'm working with a table where some fields are using the Latin 1 ch.
(B set. and other fields using Japanese.
(B
(B Can I work with both character sets?
(B
(B Can I run a query with both or do they have to be separate.
(B
(B b. Also the application is on a hosted web site so they do not have control
(B over the settings of the mysql server.  How does one set the character
(B set?  Is this done from the connection string or via the select query?
(B
(B Thank-you
(B David J.
(B
(B-- 
(Bkind regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(Bhttp://www.be-known-online.com/mysql/
(B
(B-- 
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question about Control Center

[Valentin Ionescu]

My name is Valentin IONESCU,
I download MySQL 4.1.1 and MySQL Control Center. 
I issue a subquery that works correctly on server, but
when I try to execute it from MySQL Control Center I
receive the message “[MySql_server] ERROR 1235: This
version of MySQL doesn't yet support 'LIMIT 
IN/ALL/ANY/SOME subquery'”. I think that the message
is not correct because the subquery works on MySQL
4.1.1 server. 
Until now I tested queries on Database Project from MS
Visual Studio 6.0.
What is happening and how can I test subqueries on
MySQL Control Center 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

problem with query (group, count)

[Agachi Valentin]

Hello to all,

I searched this list's archive, but I couldn't find a solution to a problem 
I am currently facing.
Any help would be appreciated.

I have the next table configuration: session (an session id), weight (a 
counter), and other fields.
When I add a new record and the session id I am tring to add doesn't exist 
in the table, the
weight field is set to 1, other wise the weight field is set to the maximum 
weight field + 1 found
for the same session id.

The problem: I want a query to get all the distinct session ids, but for 
each session id I want it
to return the last record in the order of the weight field.

I tried the following query:

select *, count(*) as cnt from table group by session having weight=cnt

But the problem is HAVING is applied after the grouping. I want my condition 
(weight=cnt) to
be processed before the grouping. I can't add it in the Where clause because 
of cnt.

How can I do this ?

Valentin Agachi

_
MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Version 4.1.1

[Nils Valentin]

Hi Dan,

for me its already the 2nd of December ;-) here in Tokyo.

On Sunday 30 November 2003 22:43, Daniel Kiss wrote:
 Hi all,

 Does anyone know when MySQL 4.1.1 will be released?
 I was told that around November 15th. Well, it's almost December now.

 Thanks,
   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: Innodb: Can't init databases

[Nils Valentin]

Hi Hsiu-Hui,

I havent followed the threat, excuse if this was mentioned before.

Did you try to start the server with the

--skip-innodb

option yet ?


--
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

On Thursday 13 November 2003 17:38, Hsiu-Hui Tseng wrote:
 Hi,

 I removed idbdata and iblogs and recreated idbdata and iblogs. But I keeps
 getting Can't init databases. I still have a lot of disk space. Could any
 one please tell me what's wrong?

 Here are message from error log

 InnoDB: Database physically writes the file full: wait...
 InnoDB: Progress in MB: 100
 InnoDB: Cannot initialize created log files because
 InnoDB: data files are corrupt, or new data files were
 InnoDB: created when the database was started previous
 InnoDB: time but the database was not shut down
 InnoDB: normally after that.
 031112 23:44:05  Can't init databases
 031112 23:44:05  Aborting

 Thank you for your help!

 Hsiu-Hui

---

-- 
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: CRASH AND ROLLBACK SIMULATION

[Nils Valentin]

Hi there,

I am not sure I understood your question correctly. What exactly is it that 
you want to test ?

a) the recovery possibility in case of power down
b) the recovery possibility in case of client disconnection (network 
interruption, timeout etc.)
c) Recovery possibilities in general accessing the data files directly and 
indirectly using command line and/or GUI tools.

In case a) mysql would recover the data files itself in most cases next time 
when the server is started as long as the logfiles, datafiles, config files 
are all there in the original positions (talking about InnoDB).

b) If the network connection times out or client is diconnected than all 
executed commands since the last commit,begin gets rolled back (will not be 
applied)

c) If the Innodb files are damaged so that the mysql server does not startup 
than no client tool (command line or GUI) that uses the indirect access 
method can access any data.

I know that there are tools in the mysql package which access and repair 
(My)ISAM tables directly (server doesnt need to run), but that isnt true for 
the InnoDB tables I believe. I am not sure if InnoDB Hotbackup can directly 
access the InnoDB tables.

What I know is that there will be a book coming up in February from Paul 
Dubois (Certification Study Guide) which is already described on Amazon.

When it comes out I believe that it  will be the best book on the market so 
far, answering many of those and similar questions. I had the honour to 
review one of those preprints, all I can say so far is Very impressive, you 
will see for yourself..   


On Friday 14 November 2003 00:58, nm wrote:
 Do you know how to test a crash and a rollback?

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

Fwd: Re: Error 1045: Access denied...

[Nils Valentin]

Hi Fernando;

you are logged in as anonymous user. log into mysql like this

mysql -u root -p

Hit enter if no password is set yet.

--
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

On Thursday 13 November 2003 00:47, Fernando wrote:
 Hello,
 i've just installed the 3.23.57 version in my account and i don't have root
 privileges. The problem is the if i try to create a database, like this

 mysql create database example;

 i get the following message:

 Error 1045: Access denied for user : '@localhost'.

 Is this because i'm not the root?
 If i try to use a database (one it doesn't exist) like this

 mysql use my_database;

 i get the following line

 Error 1044: Access denied for user : '@localhost' to database
 my_database.

 I know that it should give me an error because the database doesn't exist,
 but why this access denied message? Thanks in advance!


 
 http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español

---

-- 
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: Error 1045: Access denied...

[Nils Valentin]

Hi Patrick

How true ;-) hohohoho

Sorry for my really bad English, I just imagine that you might have had an 
experience already from somebody taking it literally ??

I will try to avoid it.

Thanks for the warning ;-)

Best regards

Nils Valentin

On Thursday 13 November 2003 01:13, Patrick Dowd wrote:
 Nils,

 I have made it a practice to never tell a user to HIT anything.  PRESS
 is much safer.

 Patrick

 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 12, 2003 8:06 AM
 To: [EMAIL PROTECTED]
 Subject: Fwd: Re: Error 1045: Access denied...




 Hi Fernando;

 you are logged in as anonymous user. log into mysql like this

 mysql -u root -p

 Hit enter if no password is set yet.

 --
 kind regards

 Nils Valentin
 Tokyo/Japan

 http://www.be-known-online.com/mysql/

 On Thursday 13 November 2003 00:47, Fernando wrote:
  Hello,
  i've just installed the 3.23.57 version in my account and i don't have

 root

  privileges. The problem is the if i try to create a database, like this
 
  mysql create database example;
 
  i get the following message:
 
  Error 1045: Access denied for user : '@localhost'.
 
  Is this because i'm not the root?
  If i try to use a database (one it doesn't exist) like this
 
  mysql use my_database;
 
  i get the following line
 
  Error 1044: Access denied for user : '@localhost' to database
  my_database.
 
  I know that it should give me an error because the database doesn't
  exist, but why this access denied message? Thanks in advance!
 
 
  
  http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español

 ---

 --
 kind regards

 Nils Valentin
 Tokyo/Japan

 http://www.be-known-online.com/mysql/

-- 
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: Error 1045: Access denied...

[Nils Valentin]

I get your point Patrick.

I was customer support engineer myself. You cant always think about all 
eventualities can you ;-), its really hard and needs a special way of 
thinking.

Anyway that little lesson saved my day. ;-)

Thanks a lot.

Nils Valentin


On Thursday 13 November 2003 01:22, you wrote:
 Oh yes.  Some in the past have taken it literally.  Always better to be
 very simple and very explicit in your instructions to users.

 I support users in 45 retail stores across the US.  Sometimes we have to
 have them shut down an application and reboot.  Some of them have said,
 Oh, I just press the power button to shut it off?  
 Aaaa!

 Patrick

 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 12, 2003 8:18 AM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: Error 1045: Access denied...


 Hi Patrick

 How true ;-) hohohoho

 Sorry for my really bad English, I just imagine that you might have had an
 experience already from somebody taking it literally ??

 I will try to avoid it.

 Thanks for the warning ;-)

 Best regards

 Nils Valentin

 On Thursday 13 November 2003 01:13, Patrick Dowd wrote:
  Nils,
 
  I have made it a practice to never tell a user to HIT anything. 
  PRESS is much safer.
 
  Patrick
 
  -Original Message-
  From: Nils Valentin [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, November 12, 2003 8:06 AM
  To: [EMAIL PROTECTED]
  Subject: Fwd: Re: Error 1045: Access denied...
 
 
 
 
  Hi Fernando;
 
  you are logged in as anonymous user. log into mysql like this
 
  mysql -u root -p
 
  Hit enter if no password is set yet.
 
  --
  kind regards
 
  Nils Valentin
  Tokyo/Japan
 
  http://www.be-known-online.com/mysql/
 
  On Thursday 13 November 2003 00:47, Fernando wrote:
   Hello,
   i've just installed the 3.23.57 version in my account and i don't have
 
  root
 
   privileges. The problem is the if i try to create a database, like this
  
   mysql create database example;
  
   i get the following message:
  
   Error 1045: Access denied for user : '@localhost'.
  
   Is this because i'm not the root?
   If i try to use a database (one it doesn't exist) like this
  
   mysql use my_database;
  
   i get the following line
  
   Error 1044: Access denied for user : '@localhost' to database
   my_database.
  
   I know that it should give me an error because the database doesn't
   exist, but why this access denied message? Thanks in advance!
  
  
   
   http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español
 
  ---
 
  --
  kind regards
 
  Nils Valentin
  Tokyo/Japan
 
  http://www.be-known-online.com/mysql/

-- 
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: MaxDB Release?

[Nils Valentin]

Hello Iago,

I dont know anything, but I remember that a while back (3 months ago) some
people mentioned that the 15th November should be a remarkable day for a
MySQL announcement.

Wether this is true or not I dont know.

Best regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

On Tuesday 11 November 2003 19:23, Iago Sineiro wrote:
 Hi.

 Some curiosity. Does anyone know when the release of MySQL MaxDB 7.5
 version will come out?

 In the MySQL web page at http://www.mysql.com/sapdb/timeline.html says that
 the release was planned for 15 of October but now we are at 11 of November
 and nothing has been released. Is it delayed until MySQL 4.1.1 is released?

 Iago.

---

-- 
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: Setting wait_timeout in my.cnf?

[Nils Valentin]

Hi Maarten,

I havent tried it recently but substitute any underbar (_) with a hiven (-)
when doing a setting in the my.cnf.


--
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

On Tuesday 11 November 2003 20:22, Hoeven, Maarten van der wrote:
 correction: section shoud be read as [mysqld]

 -Original Message-
 From: Hoeven, Maarten van der
 Sent: Tuesday, November 11, 2003 12:02 PM
 To: [EMAIL PROTECTED]
 Subject: Setting wait_timeout in my.cnf?

--
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

 Hi all,

 gosh, I must be overlooking something obvious. Running mysql 4.0.16. I
 want to set the wait_timeout in my.cnf (section [mysql]) like:

 wait_timeout = 300

 also tried the depricated

 set-variable = wait_timeout=300

 Both are not working; still default to 28800. Sure, I stopped and
 started the server.


 However, when I set the variable in the mysql-client with:

 set wait_timeout=30;

 the variable wait_timeout is changed!


 What am I overlooking? I really want to set this in my config-file,
 rather that setting it manually in the client... Any hints?


 PS. Linux Redhat 9 out of the Box, kernel 2.4.20-8


 Maarten
 --
 Zie ook/see also: http://www.knmi.nl/maildisclaimer.html

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]
 --
 Zie ook/see also: http://www.knmi.nl/maildisclaimer.html

---

-- 
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: Setting wait_timeout in my.cnf?

[Nils Valentin]

Hmm.

You could try 

show variables like %timeout%;

perhaps interactive_timeout

 can help you out ?

-- 
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/


On Tuesday 11 November 2003 21:37, Hoeven, Maarten van der wrote:
 nope, that didnt help. Thanks though!

 Any other suggestions?

 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, November 11, 2003 1:00 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Setting wait_timeout in my.cnf?



 Hi Maarten,

 I havent tried it recently but substitute any underbar (_) with a hiven
 (-)
 when doing a setting in the my.cnf.


 --
 kind regards

 Nils Valentin
 Tokyo/Japan

 http://www.be-known-online.com/mysql/

 On Tuesday 11 November 2003 20:22, Hoeven, Maarten van der wrote:
  correction: section shoud be read as [mysqld]
 
  -Original Message-
  From: Hoeven, Maarten van der
  Sent: Tuesday, November 11, 2003 12:02 PM
  To: [EMAIL PROTECTED]
  Subject: Setting wait_timeout in my.cnf?

 --
 kind regards

 Nils Valentin
 Tokyo/Japan

 http://www.be-known-online.com/mysql/

  Hi all,
 
  gosh, I must be overlooking something obvious. Running mysql 4.0.16. I
  want to set the wait_timeout in my.cnf (section [mysql]) like:
 
  wait_timeout = 300
 
  also tried the depricated
 
  set-variable = wait_timeout=300
 
  Both are not working; still default to 28800. Sure, I stopped and
  started the server.
 
 
  However, when I set the variable in the mysql-client with:
 
  set wait_timeout=30;
 
  the variable wait_timeout is changed!
 
 
  What am I overlooking? I really want to set this in my config-file,
  rather that setting it manually in the client... Any hints?
 
 
  PS. Linux Redhat 9 out of the Box, kernel 2.4.20-8
 
 
  Maarten
  --
  Zie ook/see also: http://www.knmi.nl/maildisclaimer.html
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
  http://lists.mysql.com/[EMAIL PROTECTED]
  --
  Zie ook/see also: http://www.knmi.nl/maildisclaimer.html

 ---

 --
 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]
 --
 Zie ook/see also: http://www.knmi.nl/maildisclaimer.html

-- 
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: ANN: Database Workbench 2.4 released

[Nils Valentin]

Hi Martjin,

How do I install this tool on a Unix, Linux or BSD based machine ? 

Why does it say on the page 

1) Receiving upgrades is not time limited.

and 2)
The license itself isn't time limited - but there is a 20% yearly renewal fee 
for maintenance and support (updates etc) on the driver after the first year.

???
 
I found this 

a) confusing and 
b) I would prefer a one time fee.

The module system  is probably a nice idea, but shouldnt that allow to offer 
the drivers for a reasonable price ?

I found 435$ for the full module software to expensive. I can get similar and 
better software easily for under 100$ - ( sometimes even free) which offer 
more features and reliability than your product.

If you have the luck to find customers which are willing to pay this, than you 
are probably the most terrific sales person  around for a while. 
All power to you.

Best regards

-- 
Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

 


 


On Monday 10 November 2003 19:01, Martijn Tonies wrote:
 Ladies, gentlemen,

 There's a new tool in town - Upscene Productions is
 proud to announce:

 Database Workbench for MySQL

 Download a trial: http://www.upscene.com
 Documentation: http://www.upscene.com/documentation/dbw

 For years, the workbench series has been helping InterBase
 and Firebird database developers all over the world - and now,
 it has become an even more versatile tool. Version 2.4 adds
 MySQL support, becoming a cross-database engine development
 tool for your needs.

 Features include:

 * Multi Engine
   - MySQL 4
   - MS SQL Server 7, 2000, MSDE 1  MSDE 2
   - Borland InterBase 4.x, 5.x, 6.x, 7.x
   - Firebird 1.x, 1.5
 * Schema Migrator tool
   - convert from legacy ADO/ODBC datasources
   - quickly copy existing objects to other databases
 * Datapump
   - transfer data from MS SQL, ADO or ODBC datasources
   - schedule the command line version to do this regularly
 * Object Editors
   - easily create, alter and drop database objects
   - editors help to avoid errors
   - no need to write error prone SQL/DDL statements
   - BLOB editor to add/change/view your binary data
 * Test Data Generator
   - generate thousands of rows of meaningfull test data
   - includes a large repository of real-life names, addresses etc
 * Metadata Printing
   - print lists of tables, indices and other database objects
   - many options to customize the output
 * Import/Export
   - Import data from CSV
   - Export to many different formats, including CSV and XML
 * Many other usefull features and tools available...

 Download your trial at http://www.upscene.com

 If you experience any problems with this new version, don't
 hestitate and either go to the website and send a support email
 or email directly to [EMAIL PROTECTED]



 Thank you your support,

 Martijn Tonies
 Database Workbench - the database developer tool for professionals
 Upscene Productions
 http://www.upscene.com

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

Fwd: Re: ANN: Database Workbench 2.4 released

[Nils Valentin]

Hi List members,

 I just forward this for completeness of the thread .

Best regards

Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql

-

Hi Nils,

   How do I install this tool on a Unix, Linux or BSD based machine ?
 
  The tool itself is Windows based - however, people are running
  it under Wine and similar emulators. See
  http://www.upscene.com/documentation/dbw_freebsd_wine.htm
  for an example.

 That was 1 customer, yes thats right, but you dont want to argue that the
 performance will be the same ;-).

From what I've heard, the performance is good.

Wine is a good product, but it is more or
 less for an emergency and not for the everyday basis.  There are already

some

 products running on, but within limits.

I'm also not saying that it should run on Unix, Linux or FreeBSD. I'm not
argueing about it either. It's a Windows based tool, plain and simple. You
can connect, of course, to other systems running MySQL.

  perhaps messed up? The page is tested with IE and Opera and looks fine
  in both.

 Thank you for asking. I am using Mozilla, Opera and Konqueror. It looks

fine

 in all3 browsers, but it was not clear for me that the second note was

only

 for the InterXpress for Firebird product.

Thank you for confirming that at least the pages look the same :-)

 I believ it would help to list them up on separate pages or perhaps change

the

 background colour slightly to make it more obvious.

Perhaps a more detailed difference would enhance the page. Thank you for
the suggestion.

   The module system  is probably a nice idea, but shouldnt that allow to
 
  offer
 
   the drivers for a reasonable price ?
 
  You are mixing two things, the driver product has nothing to do with
  Database Workbench.
 
   I found 435$ for the full module software to expensive. I can get

similar

  and
 
   better software easily for under 100$ - ( sometimes even free) which
   offer more features and reliability than your product.
 
  I'm surprised you can say something like that just a few hours after
  release
 
  :-)
 
  Take another look: if you want to use Database Workbench for MySQL only,
  you can purchase a license for Euro 109,- not Euro 435,- ... If you want
  more
  database engines supported, the license price will increase.

 The most critical point to me is that the combination of closed source/
 features/price seesm to be a bit unlucky.

Did you take a look at the features available?

 First it doesnt seem to be an open source product (and please correct me

if I

 am wrong).

 Secodnly, I dont like the idea, that I have to buy for what is supposed to

be

 an addon. That should be included. And the modul type should easily allow
 cheaper prices for the whole package.

I'm unsure what you mean by addon in this particular context?

 Have a look at other products and let me know what you think;

 www.business.com/search/rslt_default.asp?r4=tquery=database
 +development+tool

  (over 100 tools introduced

 www.10xsoftware.com/products/

I'm unsure if any of their products are comparable.

 www.fabforce.net

Case tool, without after-case development tools.

 www.minq.se

Nice tool, but different feature set, $99.

 www.dbtools.com.br/EN/dbmanagerpro.php

The enterprise version isn't available for purchase yet.

 www.ems-hitech.com

$135 - which a lot less features, but does have a case tool
(visual design)

 www.quest.com/solutions/database_management_products.asp

If you have more than $2000,- then there are some nice tools
available, but none of them MySQL related. For example, their
test-data-generator tool is more expensive then Database
Workbench including all modules.

  (10 tools introduced)

 www.linuxadvisor.net/doc/12029

?

 www.macosguru.de/

MacOS tool. Looks pretty nice.

 www.easysoft.com/solutions/osx.phtml

ODBC driver for MacOS.

 www.hallogram.com/dezign/

DeZign is a case tool

 There are 100^s more. Not all of them are open source. It depends strongly

on

 which platform you are running the software.

There are more - you're right about that. Most of the ones you listed
are not open source though. And there are few good open source products
out there - I'm not saying there aren't. Not at all. If you prefer open
source,
the one thing I can say: stick with it. There's no law telling you to buy
tools.

But have you tried Database Workbench before you wrote this email? If you're
missing features, feel free to write me and they might be included in the
next version.

  The InterBase and Firebird modules of Database Workbench have been
  successfull for quite some years and include many useful tools not

offered

  in order applications. The per database engine modules allow you to
  make a difference between a one size fits all product, but still have

the

  ability to use tools like the Test Data Generator

 The Test data generator is nowadays integrated in quite a few tools.

  or Schema Migration tool
  without the need to buy licenses for hundreds

Fwd: Re: ANN: Database Workbench 2.4 released

[Nils Valentin]

Hi List members,

 I just forward this for completeness of the thread .

Best regards

Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql


--  Forwarded Message  --

Subject: Re: ANN: Database Workbench 2.4 released
Date: Tuesday 11 November 2003 23:47
From: Nils Valentin [EMAIL PROTECTED]
To: Martijn Tonies [EMAIL PROTECTED]

Hi Martjin,

On Monday 10 November 2003 19:50, Martijn Tonies wrote:
 Hi Nils,

  How do I install this tool on a Unix, Linux or BSD based machine ?

 The tool itself is Windows based - however, people are running
 it under Wine and similar emulators. See
 http://www.upscene.com/documentation/dbw_freebsd_wine.htm
 for an example.

That was 1 customer, yes thats right, but you dont want to argue that the
performance will be the same ;-). Wine is a good product, but it is more or
less for an emergency and not for the everyday basis.  There are already some
products running on, but within limits.

  Why does it say on the page
 
  1) Receiving upgrades is not time limited.
 
  and 2)
  The license itself isn't time limited - but there is a 20% yearly renewal

 fee

  for maintenance and support (updates etc) on the driver after the first

 year.

 The (2) part comes from a different product: InterXpress for Firebird and
 is not related to Database Workbench. There's a different header on the
 webpage above that part.

  I found this
 
  a) confusing and
  b) I would prefer a one time fee.

 If you read it like that, it actually is confusing :-) ... Is your web-page
 view
 perhaps messed up? The page is tested with IE and Opera and looks fine
 in both.

Thank you for asking. I am using Mozilla, Opera and Konqueror. It looks fine
in all3 browsers, but it was not clear for me that the second note was only
for the InterXpress for Firebird product.

I believ it would help to list them up on separate pages or perhaps change
 the background colour slightly to make it more obvious.

  The module system  is probably a nice idea, but shouldnt that allow to

 offer

  the drivers for a reasonable price ?

 You are mixing two things, the driver product has nothing to do with
 Database Workbench.

  I found 435$ for the full module software to expensive. I can get similar

 and

  better software easily for under 100$ - ( sometimes even free) which
  offer more features and reliability than your product.

 I'm surprised you can say something like that just a few hours after
 release

 :-)

 Take another look: if you want to use Database Workbench for MySQL only,
 you can purchase a license for Euro 109,- not Euro 435,- ... If you want
 more
 database engines supported, the license price will increase.

The most critical point to me is that the combination of closed source/
features/price seesm to be a bit unlucky.

First it doesnt seem to be an open source product (and please correct me if I
am wrong).

Secodnly, I dont like the idea, that I have to buy for what is supposed to be
an addon. That should be included. And the modul type should easily allow
cheaper prices for the whole package.

Have a look at other products and let me know what you think;

www.business.com/search/rslt_default.asp?r4=tquery=database
+development+tool

 (over 100 tools introduced

www.10xsoftware.com/products/
www.fabforce.net
www.minq.se
www.dbtools.com.br/EN/dbmanagerpro.php
www.ems-hitech.com
www.quest.com/solutions/database_management_products.asp  

 (10 tools introduced)

www.linuxadvisor.net/doc/12029
www.macosguru.de/
www.easysoft.com/solutions/osx.phtml
www.hallogram.com/dezign/


There are 100^s more. Not all of them are open source. It depends strongly on
which platform you are running the software.

  If you have the luck to find customers which are willing to pay this,
  than

 you

  are probably the most terrific sales person  around for a while.
  All power to you.

 The InterBase and Firebird modules of Database Workbench have been
 successfull for quite some years and include many useful tools not offered
 in order applications. The per database engine modules allow you to
 make a difference between a one size fits all product, but still have the
 ability to use tools like the Test Data Generator

The Test data generator is nowadays integrated in quite a few tools.

 or Schema Migration tool
 without the need to buy licenses for hundreds or thousands of Euros.

That might be correct, but I still believe that you must be a terrific sales
person. Open source products can be installed on  unlimited machines without
buying any licenses ;-) (if you want to do so).

Dont get me wrong if it is a good product it might well be worth paying for
it, but right now I cant see that yet when I compare this to the 100^s of
open source products out there.

 With regards,

 Martijn Tonies
 Database Workbench - developer tool for InterBase, Firebird  MS SQL
 Server. Upscene Productions
 http://www.upscene.com

kind regards

--
Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql

Fwd: Re: ANN: Database Workbench 2.4 released

[Nils Valentin]

Hi List members,

 I just forward this for completeness of the thread .

Best regards

Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql


--  Forwarded Message  --

Subject: Re: ANN: Database Workbench 2.4 released
Date: Monday 10 November 2003 21:08
From: Martijn Tonies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

Hi Nils,

   How do I install this tool on a Unix, Linux or BSD based machine ?
 
  The tool itself is Windows based - however, people are running
  it under Wine and similar emulators. See
  http://www.upscene.com/documentation/dbw_freebsd_wine.htm
  for an example.

 That was 1 customer, yes thats right, but you dont want to argue that the
 performance will be the same ;-).

From what I've heard, the performance is good.

Wine is a good product, but it is more or
 less for an emergency and not for the everyday basis.  There are already

some

 products running on, but within limits.

I'm also not saying that it should run on Unix, Linux or FreeBSD. I'm not
argueing about it either. It's a Windows based tool, plain and simple. You
can connect, of course, to other systems running MySQL.

  perhaps messed up? The page is tested with IE and Opera and looks fine
  in both.

 Thank you for asking. I am using Mozilla, Opera and Konqueror. It looks

fine

 in all3 browsers, but it was not clear for me that the second note was

only

 for the InterXpress for Firebird product.

Thank you for confirming that at least the pages look the same :-)

 I believ it would help to list them up on separate pages or perhaps change

the

 background colour slightly to make it more obvious.

Perhaps a more detailed difference would enhance the page. Thank you for
the suggestion.

   The module system  is probably a nice idea, but shouldnt that allow to
 
  offer
 
   the drivers for a reasonable price ?
 
  You are mixing two things, the driver product has nothing to do with
  Database Workbench.
 
   I found 435$ for the full module software to expensive. I can get

similar

  and
 
   better software easily for under 100$ - ( sometimes even free) which
   offer more features and reliability than your product.
 
  I'm surprised you can say something like that just a few hours after
  release
 
  :-)
 
  Take another look: if you want to use Database Workbench for MySQL only,
  you can purchase a license for Euro 109,- not Euro 435,- ... If you want
  more
  database engines supported, the license price will increase.

 The most critical point to me is that the combination of closed source/
 features/price seesm to be a bit unlucky.

Did you take a look at the features available?

 First it doesnt seem to be an open source product (and please correct me

if I

 am wrong).

 Secodnly, I dont like the idea, that I have to buy for what is supposed to

be

 an addon. That should be included. And the modul type should easily allow
 cheaper prices for the whole package.

I'm unsure what you mean by addon in this particular context?

 Have a look at other products and let me know what you think;

 www.business.com/search/rslt_default.asp?r4=tquery=database
 +development+tool

  (over 100 tools introduced

 www.10xsoftware.com/products/

I'm unsure if any of their products are comparable.

 www.fabforce.net

Case tool, without after-case development tools.

 www.minq.se

Nice tool, but different feature set, $99.

 www.dbtools.com.br/EN/dbmanagerpro.php

The enterprise version isn't available for purchase yet.

 www.ems-hitech.com

$135 - which a lot less features, but does have a case tool
(visual design)

 www.quest.com/solutions/database_management_products.asp

If you have more than $2000,- then there are some nice tools
available, but none of them MySQL related. For example, their
test-data-generator tool is more expensive then Database
Workbench including all modules.

  (10 tools introduced)

 www.linuxadvisor.net/doc/12029

?

 www.macosguru.de/

MacOS tool. Looks pretty nice.

 www.easysoft.com/solutions/osx.phtml

ODBC driver for MacOS.

 www.hallogram.com/dezign/

DeZign is a case tool

 There are 100^s more. Not all of them are open source. It depends strongly

on

 which platform you are running the software.

There are more - you're right about that. Most of the ones you listed
are not open source though. And there are few good open source products
out there - I'm not saying there aren't. Not at all. If you prefer open
source,
the one thing I can say: stick with it. There's no law telling you to buy
tools.

But have you tried Database Workbench before you wrote this email? If you're
missing features, feel free to write me and they might be included in the
next version.

  The InterBase and Firebird modules of Database Workbench have been
  successfull for quite some years and include many useful tools not

offered

  in order applications. The per database engine modules allow you to
  make a difference between a one size fits all product, but still have

the

  ability to use tools

Fwd: Re: ANN: Database Workbench 2.4 released

[Nils Valentin]

Hi List members,

 I just forward this for completeness of the thread .

Best regards

Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql
--  Forwarded Message  --

Subject: Re: ANN: Database Workbench 2.4 released
Date: Wednesday 12 November 2003 01:00
From: Nils Valentin [EMAIL PROTECTED]
To: Martijn Tonies [EMAIL PROTECTED]

Hi Martijn,

thanks for the reply. You replied to me offline, so I keep it that way (if
 you want it so;-)

I already mentioned that I like Open source products, there is a good reason
for that, which I would like to explain.  When I buy a product I want to use
it for a long time. Ideally I want to be able to modify things within the
software to my needs. An I believe that open source products are good for
this, for other things as well.

I installed the software on a Windows 98 machine. The lowest speck machine
which I have (I always do this with new software).

The speed seems to be reasonable (nothing to complain here ;-)

I accessed a few Mysql databases when I got an Abstract error.

I am not sure what caused the software to choke, but I had to restart my
machine.

When you choose the Blob Editor and try to access a database which you dont
have access for then a screen tells me  Access violation at address 4002F584
in module RTL70.BPL Read of address 

While the software contains possibly all kind of tools and features I dont
think that the design of the interface is intuitive.

The File menu has a point called Preferences. Is there a point in listing up
the single sub sections when they lead to the same window containing all
properties ?

Also the functions should be grouped  context sensitive. ( I believe
DbVisualizer is a good sample here). See how the context of the menu changes
with the user interactions (try the export functions).

I would perhaps place the tool buttons on a vertical bar between the left and
the right window, letting the image icons change depending which tool you
have chosen to see. the tools would be shown in tabs, so that the user sees
basically only 1 tab at a time (unless he wants to see more windows than he
should be able to cascade the windows or arrange them on the screen).

I dont believe in Error No xxx messages. The window should display the
 meaning for the user. f.e

Not: error 1045
but: This combination of username, hostname,db and password is invalid.

Also I dont like popup windows reminding me that I have to register the
software evrytime when I start the software or click on a special feature.

That can be mentioned decently in the statusbar once or always, but NO POPUPS
- hope you got this ;-)

The Wizard screens remind me of another software called SQLyog (available
 here http://www.webyog.com/) which was freely available for quite a while
 ;-) , its right now 30 - 50$.

Perhaps the mixture of tools is unique the way you present them ;-) , but I
certainly think that the GUI could need a good and thoroughly sorting for
the functions.  Think about it this way KISS  - Keep it stupid simple. To
many options is like trying to find your car key in the forest (or so ;-).

Anyway thats my opinion. I could probaly go on like this for a while... At
 the end its the user who decides which products he likes and my result is
 that this product still needs lots of improvements regarding the GUIs
 intuitivity (and the pricing and the license model of course;-).


Best regards

Nils Valentin

Tokyo/Japan

On Monday 10 November 2003 21:08, you wrote:
 Hi Nils,

How do I install this tool on a Unix, Linux or BSD based machine ?
  
   The tool itself is Windows based - however, people are running
   it under Wine and similar emulators. See
   http://www.upscene.com/documentation/dbw_freebsd_wine.htm
   for an example.
 
  That was 1 customer, yes thats right, but you dont want to argue that the
  performance will be the same ;-).
 
 From what I've heard, the performance is good.
 
 Wine is a good product, but it is more or
  less for an emergency and not for the everyday basis.  There are already

 some

  products running on, but within limits.

 I'm also not saying that it should run on Unix, Linux or FreeBSD. I'm not
 argueing about it either. It's a Windows based tool, plain and simple. You
 can connect, of course, to other systems running MySQL.

   perhaps messed up? The page is tested with IE and Opera and looks fine
   in both.
 
  Thank you for asking. I am using Mozilla, Opera and Konqueror. It looks

 fine

  in all3 browsers, but it was not clear for me that the second note was

 only

  for the InterXpress for Firebird product.

 Thank you for confirming that at least the pages look the same :-)

  I believ it would help to list them up on separate pages or perhaps
  change

 the

  background colour slightly to make it more obvious.

 Perhaps a more detailed difference would enhance the page. Thank you for
 the suggestion.

The module system  is probably a nice idea, but shouldnt that allow

Fwd: Re: ANN: Database Workbench 2.4 released

[Nils Valentin]

Hi List members,

 I just forward this for completeness of the thread .

Best regards

Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql

--  Forwarded Message  --

Subject: Re: ANN: Database Workbench 2.4 released
Date: Monday 10 November 2003 22:15
From: Martijn Tonies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

Hi Nils,

 thanks for the reply. You replied to me offline, so I keep it that way (if

you

 want it so;-)

Actually, you started it in the last reply :-)

btw, thank you for your reply, I appreciate your comments.

 I already mentioned that I like Open source products, there is a good

reason

 for that, which I would like to explain.  When I buy a product I want to

use

 it for a long time. Ideally I want to be able to modify things within the
 software to my needs. An I believe that open source products are good for
 this, for other things as well.

They sure are good for that. Although I'm unsure if everything does it
that way - on a personal account, I am using open source products as
well, but never have felt the need to modify a single one of them.

 I installed the software on a Windows 98 machine. The lowest speck machine
 which I have (I always do this with new software).

 The speed seems to be reasonable (nothing to complain here ;-)

 I accessed a few Mysql databases when I got an Abstract error.

If you could retrace your steps and explain what you're doing here, than
it would be very useful. If you could give me simple instructions like
step 1, do this, step 2, do that - I would very much like to have them.

 When you choose the Blob Editor and try to access a database which you

dont

 have access for then a screen tells me  Access violation at address

4002F584

 in module RTL70.BPL Read of address 

Really? Can you explain in more detail?

 While the software contains possibly all kind of tools and features I dont
 think that the design of the interface is intuitive.

 The File menu has a point called Preferences. Is there a point in listing

up

 the single sub sections when they lead to the same window containing all
 properties ?

Actually, it has always been that way and no-one complained. Seems I gotta
change the behaviour then :-)

 Also the functions should be grouped  context sensitive. ( I believe
 DbVisualizer is a good sample here). See how the context of the menu

changes

 with the user interactions (try the export functions).

The main menu (top of the screen) is fixed. The context sensitive menus
in the Enterprise Manager and Database Navigator change all the time.

 I would perhaps place the tool buttons on a vertical bar between the left

and

 the right window, letting the image icons change depending which tool you
 have chosen to see. the tools would be shown in tabs, so that the user

sees

 basically only 1 tab at a time (unless he wants to see more windows than

he

 should be able to cascade the windows or arrange them on the screen).

This is more of a UI preference. Many people like the current interface...

 I dont believe in Error No xxx messages. The window should display the

meaning

 for the user. f.e

 Not: error 1045
 but: This combination of username, hostname,db and password is invalid.

Could you please clarify where this pops up? Would this error come straight
from the MySQL client?

 Also I dont like popup windows reminding me that I have to register the
 software evrytime when I start the software or click on a special feature.
 That can be mentioned decently in the statusbar once or always, but NO

POPUPS

 - hope you got this ;-)

Sorry, that's a trial version...

 The Wizard screens remind me of another software called SQLyog (available

here

 http://www.webyog.com/) which was freely available for quite a while ;-) ,
 its right now 30 - 50$.

Haha - I've seen that tool. You know what the biggest difference is between
the wizards? My graphics were drawn by me while the SQLyog graphics were
taken/copied from the Microsoft SQL Server Enterprise Manager tool. Every
graphic in it.

 Perhaps the mixture of tools is unique the way you present them ;-) , but

I

 certainly think that the GUI could need a good and thoroughly sorting for
 the functions.  Think about it this way KISS  - Keep it stupid simple.

To

 many options is like trying to find your car key in the forest (or so ;-).

 Anyway thats my opinion. I could probaly go on like this for a while... At

the

 end its the user who decides which products he likes and my result is that
 this product still needs lots of improvements regarding the GUIs

intuitivity

 (and the pricing and the license model of course;-).

Things improve over time, I believe that every release, beta-testers come up
with new things that they like so and so. Of course, one can never argue
about
taste - I actually do get quite some comments saying that many tools can be
found exactly where people expect them to be... :-)

Could you please reply with a message with more info

Fwd: Re: ANN: Database Workbench 2.4 released

[Nils Valentin]

Hi List members,

 I just forward this for completeness of the thread .

Best regards

Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql

--  Forwarded Message  --

Subject: Re: ANN: Database Workbench 2.4 released
Date: Wednesday 12 November 2003 01:26
From: Nils Valentin [EMAIL PROTECTED]
To: Martijn Tonies [EMAIL PROTECTED]

Hi Martijn ,

I was not aware of that  I started to post offlist if its alright with you I
post it also to the list.

Give me moment. I will have dinner and then come back to each point so that
you can follow it up  and hopefully improve the product ;-).

(I do this off the list from now)

Nils Valentin
Tokyo/Japan

On Monday 10 November 2003 22:15, you wrote:
 Hi Nils,

  thanks for the reply. You replied to me offline, so I keep it that way
  (if

 you

  want it so;-)

 Actually, you started it in the last reply :-)

 btw, thank you for your reply, I appreciate your comments.

  I already mentioned that I like Open source products, there is a good

 reason

  for that, which I would like to explain.  When I buy a product I want to

 use

  it for a long time. Ideally I want to be able to modify things within the
  software to my needs. An I believe that open source products are good for
  this, for other things as well.

 They sure are good for that. Although I'm unsure if everything does it
 that way - on a personal account, I am using open source products as
 well, but never have felt the need to modify a single one of them.

  I installed the software on a Windows 98 machine. The lowest speck
  machine which I have (I always do this with new software).
 
  The speed seems to be reasonable (nothing to complain here ;-)
 
  I accessed a few Mysql databases when I got an Abstract error.

 If you could retrace your steps and explain what you're doing here, than
 it would be very useful. If you could give me simple instructions like
 step 1, do this, step 2, do that - I would very much like to have them.

  When you choose the Blob Editor and try to access a database which you

 dont

  have access for then a screen tells me  Access violation at address

 4002F584

  in module RTL70.BPL Read of address 

 Really? Can you explain in more detail?

  While the software contains possibly all kind of tools and features I
  dont think that the design of the interface is intuitive.
 
  The File menu has a point called Preferences. Is there a point in listing

 up

  the single sub sections when they lead to the same window containing all
  properties ?

 Actually, it has always been that way and no-one complained. Seems I gotta
 change the behaviour then :-)

  Also the functions should be grouped  context sensitive. ( I believe
  DbVisualizer is a good sample here). See how the context of the menu

 changes

  with the user interactions (try the export functions).

 The main menu (top of the screen) is fixed. The context sensitive menus
 in the Enterprise Manager and Database Navigator change all the time.

  I would perhaps place the tool buttons on a vertical bar between the left

 and

  the right window, letting the image icons change depending which tool you
  have chosen to see. the tools would be shown in tabs, so that the user

 sees

  basically only 1 tab at a time (unless he wants to see more windows than

 he

  should be able to cascade the windows or arrange them on the screen).

 This is more of a UI preference. Many people like the current interface...

  I dont believe in Error No xxx messages. The window should display the

 meaning

  for the user. f.e
 
  Not: error 1045
  but: This combination of username, hostname,db and password is invalid.

 Could you please clarify where this pops up? Would this error come straight
 from the MySQL client?

  Also I dont like popup windows reminding me that I have to register the
  software evrytime when I start the software or click on a special
  feature. That can be mentioned decently in the statusbar once or always,
  but NO

 POPUPS

  - hope you got this ;-)

 Sorry, that's a trial version...

  The Wizard screens remind me of another software called SQLyog (available

 here

  http://www.webyog.com/) which was freely available for quite a while ;-)
  , its right now 30 - 50$.

 Haha - I've seen that tool. You know what the biggest difference is between
 the wizards? My graphics were drawn by me while the SQLyog graphics were
 taken/copied from the Microsoft SQL Server Enterprise Manager tool. Every
 graphic in it.

  Perhaps the mixture of tools is unique the way you present them ;-) , but

 I

  certainly think that the GUI could need a good and thoroughly sorting for
  the functions.  Think about it this way KISS  - Keep it stupid simple.

 To

  many options is like trying to find your car key in the forest (or so
  ;-).
 
  Anyway thats my opinion. I could probaly go on like this for a while...
  At

 the

  end its the user who decides which products he likes and my result

Fwd: Re: WANTED: lots of data

[Nils Valentin]

Hi Mark,

I understand that Dbvisualizer 4.0 has this function built in. There is a
trial version available at

www.minq.se

I hope that helps

Best regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

On Saturday 08 November 2003 16:37, Mark Horton wrote:
 I'm working on some software that will generate all sorts of statistics
 on large volumes of data.  I'm looking for data to experiment on.  I'd
 like 100 million - 1 billion records.  These records can be anything
 from log files to database records, or whatever.  I just need tons of data.

 If you have lots of data and have been interested in getting it
 summarized, rolled-up, aggregated so that you can have nice summary
 reports on it then let me know.

 BTW, I'm not trying to sell anything.  This software is just an idea and
 I'm looking for lots of real world data to test with.

 Mark

--
Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

---

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

Setting up user acounts in 4.0.16

[Nils Valentin]

Hi Mysql fans ;-),

today I had a funny experience and I wanted to double check that. 
When I am trying to create a user account in the 4.0.16 -max version (tar.gz 
format from www.mysql.com) then it would create the user account put not set 
the privileges. The privileges would still stay at N.

Here is the command I tried:

grant all on xoops.* to 'xoops_root'@'%' identified by '';


Perhaps I have done a mistake somewhere, but I cant figure out what went 
wrong.

I had to manually update the fields with the update .. set command and a flush 
privileges.

Can anybody copy me on that ?

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

Fwd: Re: Setting up user acounts in 4.0.16

[Nils Valentin]

Hi Thierno,

you are right that the synatx I gave you is not correct. Thank you for
pointing this out. I made the mistake when typing the e-mail ;-)

However the original problem stays. It doesnt write the privileges (on my
machine).

Best regards

Nils Valentin
Tokyo/Japan

On Thursday 06 November 2003 17:42, you wrote:
 Hi Nils,
 your instruction of account creation don't agree with the syntax .
 To create an account do this :

 GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by '';
 The percent character '%' is enclosed by double-quote.

 Regards

 Thierno6C - MySQL 4.0.15.

 - Original Message -
 From: Nils Valentin [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, November 07, 2003 8:00 AM
 Subject: Setting up user acounts in 4.0.16

  Hi Mysql fans ;-),
 
  today I had a funny experience and I wanted to double check that.
  When I am trying to create a user account in the 4.0.16 -max version

 (tar.gz

  format from www.mysql.com) then it would create the user account put not

 set

  the privileges. The privileges would still stay at N.
 
  Here is the command I tried:
 
  grant all on xoops.* to 'xoops_root'@'%' identified by '';
 
 
  Perhaps I have done a mistake somewhere, but I cant figure out what went
  wrong.
 
  I had to manually update the fields with the update .. set command and a

 flush

  privileges.
 
  Can anybody copy me on that ?
 
  Best 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]

--
Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

---

-- 
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: Setting up user acounts in 4.0.16

[Nils Valentin]

Hi Thierno,

Please see below what I get. I would expect the privileges to be set to Y.



GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by '';
Query OK, 0 rows affected (0.00 sec)

mysql select * from user where User=xoops\G
*** 1. row ***
 Host: %
 User: xoops
 Password: 5a62d73531da5605
  Select_priv: N
  Insert_priv: N
  Update_priv: N
  Delete_priv: N
  Create_priv: N
Drop_priv: N
  Reload_priv: N
Shutdown_priv: N
 Process_priv: N
File_priv: N
   Grant_priv: N
  References_priv: N
   Index_priv: N
   Alter_priv: N
 Show_db_priv: N
   Super_priv: N
Create_tmp_table_priv: N
 Lock_tables_priv: N
 Execute_priv: N
  Repl_slave_priv: N
 Repl_client_priv: N
 ssl_type:
   ssl_cipher:
  x509_issuer:
 x509_subject:
max_questions: 0
  max_updates: 0
  max_connections: 0
1 row in set (0.00 sec)



-- 
Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

On Thursday 06 November 2003 23:00, Thierno Cissé wrote:
 Hi Nils,
 what want you to say by : It doesnt write the privileges (on my machine).
 It is because you succeed reaching all the database objects or what ?
 Give some more details.
 
 Regards.
 Thierno6C.
 
 - Original Message - 
 From: Nils Valentin [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, November 07, 2003 1:16 PM
 Subject: Fwd: Re: Setting up user acounts in 4.0.16
 
 

 
 
  Hi Thierno,
 
  you are right that the synatx I gave you is not correct. Thank you for
  pointing this out. I made the mistake when typing the e-mail ;-)
 
  However the original problem stays. It doesnt write the privileges (on
  my
 machine).
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
  On Thursday 06 November 2003 17:42, you wrote:
 
   Hi Nils,
   your instruction of account creation don't agree with the syntax .
   To create an account do this :
  
   GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by '';
   The percent character '%' is enclosed by double-quote.
  
   Regards
  
   Thierno6C - MySQL 4.0.15.
  
   - Original Message -
   From: Nils Valentin [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Friday, November 07, 2003 8:00 AM
   Subject: Setting up user acounts in 4.0.16
  
  
Hi Mysql fans ;-),
   
today I had a funny experience and I wanted to double check that.
When I am trying to create a user account in the 4.0.16 -max version
  
  
   (tar.gz
  
  
format from www.mysql.com) then it would create the user account put

 not

  
   set
  
  
the privileges. The privileges would still stay at N.
   
Here is the command I tried:
   
grant all on xoops.* to 'xoops_root'@'%' identified by '';
   
   
Perhaps I have done a mistake somewhere, but I cant figure out what

 went

wrong.
   
I had to manually update the fields with the update .. set command
and

 a

  
   flush
  
  
privileges.
   
Can anybody copy me on that ?
   
Best 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]
 
 
  --
  Nils Valentin
  Tokyo/Japan
 
  http://www.be-known-online.com/mysql/
 
  ---
 
  -- 
  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]

 

 
 
 

-- 
Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

Fwd: Re: Setting up user acounts in 4.0.16

[Nils Valentin]

Of course. That was it ;-)

I completely forgot about that for a moment. I looked in the wrong place,
 oooh no...

Thanks a lot, (such a shame I didnt realize first)...


Best regards

Nils Valentin
Tokyo/Japan

On Thursday 06 November 2003 23:23, gerald_clark wrote:
 You set db privileges, and then looked at the user table.
 Check the db table.

 If you want to set global privileges you need to specify *.* not xoops.*.

 Nils Valentin wrote:
 Hi Thierno,
 
 Please see below what I get. I would expect the privileges to be set to Y.
 
 
 
 GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by '';
 Query OK, 0 rows affected (0.00 sec)
 
 mysql select * from user where User=xoops\G
 *** 1. row ***
  Host: %
  User: xoops
  Password: 5a62d73531da5605
   Select_priv: N
   Insert_priv: N
   Update_priv: N
   Delete_priv: N
   Create_priv: N
 Drop_priv: N
   Reload_priv: N
 Shutdown_priv: N
  Process_priv: N
 File_priv: N
Grant_priv: N
   References_priv: N
Index_priv: N
Alter_priv: N
  Show_db_priv: N
Super_priv: N
 Create_tmp_table_priv: N
  Lock_tables_priv: N
  Execute_priv: N
   Repl_slave_priv: N
  Repl_client_priv: N
  ssl_type:
ssl_cipher:
   x509_issuer:
  x509_subject:
 max_questions: 0
   max_updates: 0
   max_connections: 0
 1 row in set (0.00 sec)

--
Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

---

-- 
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: Mysql Online Backup.

[Nils Valentin]

Hi All,

my $0.0.2... anybody correct me please if you know it better...;-)


2003 8 27  23:22P Srinivasulu :
 If the backup solutions are there already, why is that a future
 requirement for Mysql?

 Thanks,
 Srinivasulu.

  Chris Nolan [EMAIL PROTECTED] 8/27/2003 6:41:27 PM 

 Hi!

 You can currently do this with InnoDB with mysqldump (look at the
 --single-transaction switch). I use it for backing up a 12 GB mail
 database without problems.


mysqldump --single-transaction is backing up all tables in a single 
transaction, see the remark MUTUALLY exclusive with lock tables, meaning 
that NO other client can modify the tables/ data at that time (which may take 
some time for big databases ).

mysqlhotcopy is only working on MyISAM table formats yet and again locking the 
whole table. But as its a read lock other clients can still read the data. 
However, this perl script runs only local (must be run on the server).

As for the question about the online backup facility, I believe what meant is 
that you can run an online backup from a tool like phpmyadmin, xoops, 
basically a normal webpage, etc.

The difference of all these tools is 

a) how they accesss and lock the tables/data you want to backup
b) the format of the output file (txt,sql format, binary etc. 
c) the supported features

I hope this answers some of your questions. Let me know if you need more 
details.

Best regards

Nils Valentin
Tokyo/Japan



 Regards,

 Chris

 P.S. Keep up the great work over there at Novell! Tell us where to send

 the expensive bottles of alcohol for when you help put SCO out of their

 misery!

 P Srinivasulu wrote:
 Hi All,
 
 The link below says that online backup functionality will be provided
 in Mysql-5.1. I think its already there in the form of mysqlhotcopy.

 Is

 Mysql going to extend the functionality of mysqlhotcopy so that it

 works

 for Innodb tables also? or they are going to provide independent

 online

 backup functionality. Please clarify me.
 
 http://www.mysql.com/doc/en/TODO_MySQL_5.1.html
 
 Thanks,
 Srinivasulu.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Online Backup.

[Nils Valentin]

Hi Chris,


2003 8 28  00:54Chris Nolan :
 A very good question! One which I will attempt to provide a half-decent
 answer for.

 Trying to execute a transaction that involves grabbing massive amounts of
 data from various tables while still allowing updates to be committed can
 be tricky. At best, this means performance problems. Please don't get me
 wrong - MySQL is the fastest database on the planet (and it looks to only
 get faster, with additional query caches, better designed caches and a
 helper thread architecture in the works) but there are certain things that
 are just hard to do quickly, even if you are the demigods that work at
 Innobase Oy and MySQL AB.

 The advantage of other methods is that you avoid all sorts of nasty
 locking on various parts of your database. The advantage of the Hot Copy
 product that Innobase Oy sell is that it doesn't place any locks on your
 InnoDB table space when it runs.

Wouldn't that break the ACID ? The backup data would not be fully consistent, 
integrated anymore. Anyway thats my understanding.

I understand that the InnoDB  Hot Copy product is providing this feature by 
using the actual row locks to make sure that ACID is taken care of while 
creating a consistent backup.

Best regards

Nils Valentin


 In summary, it's not a question as to whether the current methods work,
 it's a question as to how well suited they are to your needs. For mine
 they work well, but if I was processing 600 queries / second, I think I'd
 want ibcopy to help me out.

 Regards,

 Chris

 quote who=P Srinivasulu

  If the backup solutions are there already, why is that a future
  requirement for Mysql?
 
  Thanks,
  Srinivasulu.
 
  Chris Nolan [EMAIL PROTECTED] 8/27/2003 6:41:27 PM 
 
  Hi!
 
  You can currently do this with InnoDB with mysqldump (look at the
  --single-transaction switch). I use it for backing up a 12 GB mail
  database without problems.
 
  Regards,
 
  Chris
 
  P.S. Keep up the great work over there at Novell! Tell us where to send
 
  the expensive bottles of alcohol for when you help put SCO out of their
 
  misery!
 
  P Srinivasulu wrote:
 Hi All,
 
 The link below says that online backup functionality will be provided
 in Mysql-5.1. I think its already there in the form of mysqlhotcopy.
 
  Is
 
 Mysql going to extend the functionality of mysqlhotcopy so that it
 
  works
 
 for Innodb tables also? or they are going to provide independent
 
  online
 
 backup functionality. Please clarify me.
 
 http://www.mysql.com/doc/en/TODO_MySQL_5.1.html
 
 Thanks,
 Srinivasulu.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Online Backup.

[Nils Valentin]

Hi Chris,

2003 8 28  00:54Chris Nolan :
 A very good question! One which I will attempt to provide a half-decent
 answer for.

 Trying to execute a transaction that involves grabbing massive amounts of
 data from various tables while still allowing updates to be committed can
 be tricky. At best, this means performance problems. Please don't get me
 wrong - MySQL is the fastest database on the planet (and it looks to only
 get faster, with additional query caches, better designed caches and a
 helper thread architecture in the works) but there are certain things that
 are just hard to do quickly, even if you are the demigods that work at
 Innobase Oy and MySQL AB.

 The advantage of other methods is that you avoid all sorts of nasty
 locking on various parts of your database. The advantage of the Hot Copy
 product that Innobase Oy sell is that it doesn't place any locks on your
 InnoDB table space when it runs.

You made an interesting point there with the locking mechanism. I double 
checked the innodb homepage.

http://www.innodb.com/hotbackup.html

While it says at the top as you stated no locks are written it also says under 
3) how it locks and unlocks the tables.

I guess thats best explained by Heikki ;-) - I copied her.

Best regards

Nils Valentin
Tokyo/Japan


 In summary, it's not a question as to whether the current methods work,
 it's a question as to how well suited they are to your needs. For mine
 they work well, but if I was processing 600 queries / second, I think I'd
 want ibcopy to help me out.

 Regards,

 Chris

 quote who=P Srinivasulu

  If the backup solutions are there already, why is that a future
  requirement for Mysql?
 
  Thanks,
  Srinivasulu.
 
  Chris Nolan [EMAIL PROTECTED] 8/27/2003 6:41:27 PM 
 
  Hi!
 
  You can currently do this with InnoDB with mysqldump (look at the
  --single-transaction switch). I use it for backing up a 12 GB mail
  database without problems.
 
  Regards,
 
  Chris
 
  P.S. Keep up the great work over there at Novell! Tell us where to send
 
  the expensive bottles of alcohol for when you help put SCO out of their
 
  misery!
 
  P Srinivasulu wrote:
 Hi All,
 
 The link below says that online backup functionality will be provided
 in Mysql-5.1. I think its already there in the form of mysqlhotcopy.
 
  Is
 
 Mysql going to extend the functionality of mysqlhotcopy so that it
 
  works
 
 for Innodb tables also? or they are going to provide independent
 
  online
 
 backup functionality. Please clarify me.
 
 http://www.mysql.com/doc/en/TODO_MySQL_5.1.html
 
 Thanks,
 Srinivasulu.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Online Backup.

[Nils Valentin]

2003 8 28  01:43Nils Valentin :
 Hi Chris,

 2003 8 28  00:54Chris Nolan :
  A very good question! One which I will attempt to provide a half-decent
  answer for.
 
  Trying to execute a transaction that involves grabbing massive amounts of
  data from various tables while still allowing updates to be committed can
  be tricky. At best, this means performance problems. Please don't get me
  wrong - MySQL is the fastest database on the planet (and it looks to only
  get faster, with additional query caches, better designed caches and a
  helper thread architecture in the works) but there are certain things
  that are just hard to do quickly, even if you are the demigods that work
  at Innobase Oy and MySQL AB.
 
  The advantage of other methods is that you avoid all sorts of nasty
  locking on various parts of your database. The advantage of the Hot Copy
  product that Innobase Oy sell is that it doesn't place any locks on your
  InnoDB table space when it runs.

 You made an interesting point there with the locking mechanism. I double
 checked the innodb homepage.

 http://www.innodb.com/hotbackup.html

 While it says at the top as you stated no locks are written it also says
 under 3) how it locks and unlocks the tables.

 I guess thats best explained by Heikki ;-) - I copied her.

 Best regards

 Nils Valentin
 Tokyo/Japan

  In summary, it's not a question as to whether the current methods work,
  it's a question as to how well suited they are to your needs. For mine
  they work well, but if I was processing 600 queries / second, I think I'd
  want ibcopy to help me out.
 
  Regards,
 
  Chris
 
  quote who=P Srinivasulu
 
   If the backup solutions are there already, why is that a future
   requirement for Mysql?
  
   Thanks,
   Srinivasulu.
  
   Chris Nolan [EMAIL PROTECTED] 8/27/2003 6:41:27 PM 
  
   Hi!
  
   You can currently do this with InnoDB with mysqldump (look at the
   --single-transaction switch). I use it for backing up a 12 GB mail
   database without problems.
  
   Regards,
  
   Chris
  
   P.S. Keep up the great work over there at Novell! Tell us where to send
  
   the expensive bottles of alcohol for when you help put SCO out of their
  
   misery!
  
   P Srinivasulu wrote:
  Hi All,
  
  The link below says that online backup functionality will be provided
  in Mysql-5.1. I think its already there in the form of mysqlhotcopy.
  
   Is
  
  Mysql going to extend the functionality of mysqlhotcopy so that it
  
   works
  
  for Innodb tables also? or they are going to provide independent
  
   online
  
  backup functionality. Please clarify me.
  
  http://www.mysql.com/doc/en/TODO_MySQL_5.1.html
  
  Thanks,
  Srinivasulu.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Case sensitive indexes

[Nils Valentin]

Hi Gord,


I understood that searches in general arecase insensitive (but I might be 
wrong of course).

Try to use the word BINARY when creating the table or when making a SELECT.

I am not sure how you would have to apply this to the index.


Best regards

Nils Valentin
Tokyo/Japan




2003 8 26  09:33gord barq :
 I have the following index:

 CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);

 Where songtitle, artist and album are varchar() columns.

 It appears that this index is not case sensitive. Is that correct? If so,
 how can I have it so that it is indeed case sensitive because I'm importing
 lots of data from Oracle which is case sensitive.

 Thanks.

 _
 Get MSN 8 and enjoy automatic e-mail virus protection.
 http://join.msn.com/?page=features/virus


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: own privileges

[Nils Valentin]

SHOW GRANTS FOR [EMAIL PROTECTED];

It is important that the mix of username and hostname is the one which is 
specified in the privilege database.

Please see the manual for details.

 show grants for [EMAIL PROTECTED];
++
| Grants for [EMAIL PROTECTED] 
 
|
++
| GRANT ALL PRIVILEGES ON *.* TO 'root 
  
|
++
1 row in set (0.09 sec)


Best regards

Nils Valentin
Tokyo/Japan


2003 8 25  21:[EMAIL PROTECTED] :
 Is there a way for a user to get knowledge about his own privileges?
 For example can a user know if he/she has rights to INSERT INTO some table?
 I'm using PHP4

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: differance between InnoDB and MyISAM tables ?

[Nils Valentin]

Hi Sanjay,

I made a chart which shows the tables and their supported functions.

Please have a look here:

http://www.knowd.co.jp/staff/nils/

I hope this helps.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 22  18:45sanjay gupta :
 Hi all ,

 can anybody tell me the differance between the innidb and myisam tables
 types .

 sanjay

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Spam from this list

[Nils Valentin]

Hi Thomas,

I report this stuff always to [EMAIL PROTECTED] and 20 minutes later its 
gone ;-)

Best regards

Nils Valentin
Tokyo/Japan



2003 8 23  22:25Thomas Andersson :
 Hmm

 This is not nice.. I posted on this list, and within seconds I got spam
 from some phone company which was a reply to my post to the list. Aparently
 a company is subscribed and use posts here to build a list of valid
 addresses to spam...
 The offending mailer was: [EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqlbinlog question

[Nils Valentin]

Hi MySQL Fans ;-),

This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat 9.

When I issue the command mysqlbinlog it does not show me the whole 
binary logfile but just the first line or so (below).

 mysqlbinlog baby-bumble-bee-bin.09
# at 4
#030814 14:38:17 server id  1   Start: binlog v 4, server v  created 
700101  9:00:00

I understood that I can use the tool to view the whole binary log data. 
Am I mistaken ?

Best regards

Nils Valentin
Tokyo/Japan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SHOW VARIABLES LIKE '%dir%'; (basedir and datadir)

[Nils Valentin]

Hello MySQL Fans,

This time I am using 4.0.13-max (tar format from www.mysql.com) on 
Redhat 9.

I have an understanding question why would the command SHOW VRAIABLES 
give me once the real output and once the symlink ouput for directory 
names ?

Sample (datadir and basedir) :

 mysql SHOW VARIABLES LIKE '%dir%';
+++
| Variable_name  | Value  |
+++
| basedir| /usr/local/mysql-max-4.0.13-pc-linux-i686/ |
| bdb_logdir ||
| bdb_tmpdir | /tmp/  |
| datadir| /usr/local/mysql/data/ |
| innodb_data_home_dir   ||
| innodb_log_arch_dir| ./ |
| innodb_log_group_home_dir  | ./ |
| innodb_max_dirty_pages_pct | 90 |
| tmpdir | /tmp/  |
+++
9 rows in set (0.04 sec)
Best regards

Nils Valentin

Tokyo/Japan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqlbinlog question

[Nils Valentin]

Hi Victoria,


2003 8 21  16:09Victoria Reznichenko :
 Nils Valentin [EMAIL PROTECTED] wrote:
  This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat
  9.
 
  When I issue the command mysqlbinlog it does not show me the whole
  binary logfile but just the first line or so (below).
 
   mysqlbinlog baby-bumble-bee-bin.09
  # at 4
  #030814 14:38:17 server id  1   Start: binlog v 4, server v  created
  700101  9:00:00
 
  I understood that I can use the tool to view the whole binary log data.

 Yes.

  Am I mistaken ?

 Probably your version of mysqlbinlog can't read binary logs 4.0.x MySQL
 server.


Thank you for the reply. I just had a chance to double check on a Suse Linux 
8.1 with mysql 4.1-alpha (rpm format) and it works there. 

H. so must be a bug ?? 


 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqlbinlog question

[Nils Valentin]

Hi Victoria,

2003 8 21  20:20Victoria Reznichenko :
 Nils Valentin [EMAIL PROTECTED] wrote:
  2003? 8? 21? ??? 16:09?Victoria Reznichenko :
  Nils Valentin [EMAIL PROTECTED] wrote:
   This time I am using 4.0.13-max (tar format from www.mysql.com) on
   Redhat 9.
  
   When I issue the command mysqlbinlog it does not show me the whole
   binary logfile but just the first line or so (below).
  
mysqlbinlog baby-bumble-bee-bin.09
   # at 4
   #030814 14:38:17 server id  1   Start: binlog v 4, server v  created
   700101  9:00:00
  
   I understood that I can use the tool to view the whole binary log
   data.
 
  Yes.
 
   Am I mistaken ?
 
  Probably your version of mysqlbinlog can't read binary logs 4.0.x MySQL
  server.
 
  Thank you for the reply. I just had a chance to double check on a Suse
  Linux 8.1 with mysql 4.1-alpha (rpm format) and it works there.
 
  H. so must be a bug ??

 Nils, what is the version of mysqlbinlog and what is the version of MySQL
 server, that produces binary logs?

Thank you for asking the right questions ;-).

the mysqlbinlog version 1.6 came with Mysql -4.0.13 (tar format from 
www.mysql.com) - used on RH9
the mysqlbinlog version 2.3 came with MySQL-4.1-alpha (rpm format from 
www.mysql.com) - used on Suse 8.1

After a long follow up I reallized that I must have used the mysqlbinlog 
version 1.6 on the file produced from the mysqbinlog version 2.3.

However looking inside of the binary logfile itself I found this in the very 
first line now:

#030814 14:38:17 server id 1  log_pos 4 Start: binlog v 3, server v 
4.1.0-alpha-Max-log created 030814 14:38:17
# at 79


It is saying ...binlog v 3...  does that signify the binlog protocol version 
?

If yes, is there a command line option to inquire this info ?


Best regards

Nils Valentin
Tokyo/Japan





 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fwd: Dynamic enabling of log files

[Nils Valentin]

Hi Prem,

Which version are you curently using 3.23.xxx ??

Whats the XXX in your version ???

What do the change log files say at the www.mysql.com homepage ?

Best regards

Nils Valentin
Tokyo/Japan


Prem Soman wrote:
Thanks neils!

  i have gone thru what u referred long before, i know
 that this set method is not fully supported in 3.23
version, thats why i posed this question, i wanted to
know whether there is any other way to do it.
when i make changes to my.cnf file i am able to do it
but it is not immediatly reflected since mysqld reads
from the my.cnf file only when it restarts i
thought there must be some sort of command line
utility  or ... to enable and disabke log files
without restarting the server.
can u also tell me from what version onwards is this
type of dynamic setting for log files allowed.
Regards,
Prem S 

--- Nils Valentin [EMAIL PROTECTED] wrote:  

Hi Prem,

That question was just here 2 days ago, so easy to
answer. ;-)


Logs can be enabled/disabled for the session with
SET SQL_LOG_OFF | 
SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are
not supported in 
v3.23.52:
   http://www.mysql.com/doc/en/SET_OPTION.html

Best regards

Nils Valenin
Tokyo/Japan
2003 8 13  13:30?Prem Soman
???:
Note: forwarded message attached.





Want to chat instantly with your online friends? 
Get the FREE Yahoo!

Messenger http://uk.messenger.yahoo.com/
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils



Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump w/o password

[Nils Valentin]

Hi Asif,

Just a guess, but how about

[mysqldump]
password = PASS
??

Best regards

Nils Valentin
Tokto/Japan


Asif Iqbal wrote:
Hi All

I have to run this to dump the database

mysqldump -u root -pPASS --opt database  database.tmp

Is there anyway I can hide the PASS is a file ? I was trying to put it in
/root/.my.cnf as this
[client]
password = PASS
That seems to be not working. I am not sure if mysqldump even reads that file.
The only option worked for me is putting the password in a file /root/.pass and
chmod it to 000 and then run this
mysqldump -u root -p`cat /root/.pass` --opt database  database.tmp

However I don't like this option because it tells you where the password is
residing. I need to put this in cron so I don't like the option of showing the
filename
Thanks



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query with inner join (Help!)

[Nils Valentin]

Hi Fongo,

http://www.mysql.com/doc/en/JOIN.html


Should work like this (untested):

 SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from
 Customers, Orders WHERE Customers.cust_id = Orders.cust_id AND
 cust_id = 2 inner join 


Best regards

Nils Valentin
Tokyo/Japan


2003 8 15  16:44B. Fongo :
 Hello!

 I ' m trying to extra some information from 2 tables using inner join,
 but receive an error warning.  Am newbie so I' m not able to feature out
 why my queries don't work.

 Scenario:

 I have 2 tables: Customers and orders. The have following structures:
 Customers Orders
 cust_id   Product
  Name Price
  City cust_id


 All that am trying to get out of these tables is to use a cust_id of a
 given customer to extract their orders. So I use something like this:

 SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from
 Customers WHERE cust_id = 2 inner join Orders ON Customers.cust_id =
 Orders.cust_id

 Can anyone help me on this?

 Thanks

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query with inner join (Help!)

[Nils Valentin]

Hi Fongo,

Steve gave a perfect explanation ( and made me realize my and Egor's small 
mistake ;-)


2003 8 15  17:08Nils Valentin :
 Hi Fongo,

 http://www.mysql.com/doc/en/JOIN.html


 Should work like this (untested):

  SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from
  Customers, Orders WHERE Customers.cust_id = Orders.cust_id AND
  cust_id = 2 inner join

SELECT Customers.Name, Customers.City, Orders.Product, Orders.Price from
Customers, Orders WHERE Customers.cust_id = Orders.cust_id AND
customers.cust_id = 2;

So you have 3 possibilities (1 above and 2 below ):

SELECT Customers.Name, Customers.City, Orders.Product, Orders.Price FROM
Customers inner join Orders ON customers.cust_id=Orders.cust_id WHERE 
customers.cust_id = 2;

SELECT Customers.Name, Customers.City, Orders.Product, Orders.Price FROM
Customers inner join Orders USING (cust_id) WHERE customers.cust_id = 2;


That should wrap it up nicely ;-). 


 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 15  16:44B. Fongo :
  Hello!
 
  I ' m trying to extra some information from 2 tables using inner join,
  but receive an error warning.  Am newbie so I' m not able to feature out
  why my queries don't work.
 
  Scenario:
 
  I have 2 tables: Customers and orders. The have following structures:
  Customers Orders
  cust_id Product
   Name   Price
   City   cust_id
 
 
  All that am trying to get out of these tables is to use a cust_id of a
  given customer to extract their orders. So I use something like this:
 
  SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from
  Customers WHERE cust_id = 2 inner join Orders ON Customers.cust_id =
  Orders.cust_id
 
  Can anyone help me on this?
 
  Thanks

 --
 ---
 Valentin Nils
 Internet Technology

  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Secure Database Design Part II

[Nils Valentin]

Hi Steven,

I believe I understand your concerns. I think the only way to reduce the risk 
of associating the wrong data is tripple checking it by different persons or 
even better make two tables which you can compare against each other. The 
second table only readable to you. This way you could always double check the 
correctness of the distrubutor table (as long as they are in sync ;-)

Best regards

Nils Valentin
Tokyo/Japan



2003 8 16  05:36Lefevre, Steven :
 Hey folks -

 Thanks to everyone who gave input to my concerns. Of course, we don't
 intend to have the mysql port open to the world. We will have Apache/PHP
 connect on a unix socket, or to another machine with a cross-cable on
 non-routeable IPs.

 But now I have another question. We are working on a web database to allow
 our suppliers to log on and submit information that they would otherwise
 fax, email, or phone to us. It would reduce work in our office, and reduce
 errors in duplication of our information. But, we are very concerned about
 security!

 We aren't worried so much about outside hackers as we are about legit users
 trying to gain access to information they shouldn't. Some of our suppliers
 are overseas and we think they have no qualms about trying to hack the
 system, knowing the stunts they have pulled in the past. It would be
 extremely difficult to pursue any problems legally, since it would be
 international, and the damage would be already done.

 So, here's my question. Good database design dictates that I normalize my
 tables. So, in this simplified example, we have a table of supplier quotes:

 supplier_id
 part_id
 quote_price
 quote_date

 All of our suppliers would be drawing from the same table, via php. I'm
 worried that good database design might be more susceptible to information
 'spilling over' -- what if I make a simple mistake and put the wrong
 supplier_id with a new user's logon? That new user would see all the parts
 that belong to whatever company I mistakenly associate them with.

 I'm not so worried about, say, suppliers seeing sales data. All the php
 pages will be protected by Unix filesystem permissions, so I can be
 reasonably certain that only those belonging to the suppliers group will be
 able to execute supplier_*.php. Even if they do load some sales_*.php page,
 then the MySQL user permissions will stop them from actually seeing any
 data on the page. So there are two layers of security between sales and
 suppliers, for example. I would have to make two mistakes for them to have
 access to sales data.

 But, when all suppliers are accessing the same pages, it's up to my careful
 hands to make sure they are pulling only their records out of the table. 
 If I make a mistake in a query, it might pull up other records, or even all
 records!

 Of course if I design it completely perfectly the first time, I don't have
 to worry about anything. But I'm not perfect and I don't make perfect
 things.

 So, I'm thinking I should violate good design principles, and setup
 identical tables for each supplier, salesperson, customer, etc. That way,
 since they share the same PHP pages, they aren't all pulling data from the
 same table. If there is any mixup in the query, the user doesn't have the
 MySQL permission to pull data from another suppliers table.

 Does this make sense?

 Steve Lefevre
 Network Administrator
 IMI International, Inc.
 614.839.2500

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: escape sequence question

[Nils Valentin]

Hi Roger,


2003 8 14  19:33Roger Baklund :
 * Nils Valentin

  I have problems understanding why the below two commands would
  return the same result.

 [...]

  mysql select * from sensei where link like
  '/var/www/html/xoops/2003\'s sum';

 [...]

  mysql select * from sensei where last_name like
  '/var/www/html/xoops/2003\\\'s sum';

 [...

  Note the three backslashes and the single backsplash (after the 2003)
 
  I understood the first sample looks  for ...2003's and the
  second one for ...2003\'s. or am I wrong ?

 They both look for 2003's.

Thats what I also thought at first sight, but there seems to be more to it.


 The LIKE operator is a pattern matching operator. The operand is evaluated
 twice: first by the parser, and then when the pattern matching is
 performed. For your last example, the first evaluation changes 2003\\\'s
 to 2003\'s, and the second evaluation changes 2003\'s to 2003's.
THis example works for the second one , how about the first one in comparison 
?
Best regards

Nils Valentin
Tokyo/Japan



 URL: http://www.mysql.com/doc/en/String_comparison_functions.html 

 --
 Roger

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A final Windows MySQL PHP plea

[Nils Valentin]

Hi Andrew,

I guess your reply was meant for Gary (the original poster of this e-mail).

I will foward your request to the mailing  list.

Best regards

Nils Valentin
Tokyo/Japan




 WOW!!!
 That kind of System Power and you are wasting it on Windows and IIS
 E!

 Sorry - but Dual Proc Support, with 2gigs of RAM would Love Redhat 9.0
 like a kid loves chocolate.

 I dont know about the more than 100 concurrent users, but bear in mind
 (as I understand it) that means that you can have up to 100 queries at 1
 time, as soon as the query is over, the next user is available for his
 query.

 Linux itself can support 1000's of users at one time -
 You might be surprised.

 Andrew

 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, August 12, 2003 10:04 PM
 To: Gary Broughton; [EMAIL PROTECTED]
 Subject: Re: A final Windows MySQL PHP plea


 Hi Gary,

 I understood that the packages provided by MySQL are set to 100
 concurrent
 users by default, so what you ae asking is actually if somebody
 successfully
 compiled a version for more than 100 concurrent users and was able to
 use it
 in a production environment ?

 Do I understand that correct ?

 My guess would be that you are more likely to find Linux users having
 done
 such a setup. Unfortunately I haven'Tt had such an experience yet, but
 as you
 probably now Dell has made a study (which is also announced on www.mysq.
 com)
 which describes their experience, perhaps it contains the one or the
 other
 useful tip.

 http://www.dell.com/us/en/biz/topics/power_ps2q03-jaffe.htm

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 13  01:21Gary Broughton :
  Hi all
 
  Is there anybody out there who has managed to successfully configure
  Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a
  couple of hundred users at any one time?  I have chucked absolutely
  everything I can think of at this, but the MySQL (it seems) simply
  eats all the available CPU within a short space of time (regardless of
 
  users) and brings the site to a halt.  My last throw of the dice today
 
  was to install all on a new Dual 1.8Ghz Pentium, with three hard disks
 
  in a RAID array, and 2GB memory, but it's achieved pretty much
  nothing.  I am now desperate, and if anyone has any flash of
  inspiration for me, I'm all ears.  The previous ASP version of the
  site runs like a dream, but there's something I'm either doing wrong,
  or this new combination of software simply doesn't like.
 
  Many thanks
 
  Stressed Gary

 --
 ---
 Valentin Nils
 Internet Technology

  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple field updates

[Nils Valentin]

;-)


Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  21:29Rudi Ahlers :
 Great thanx, this one worked wonders


 Kind Regards
 Rudi Ahlers
 +27(82) 926 1689

 The basic difference between an ordinary man and a warrior is that a
 warrior takes everything as a challenge while an ordinary man takes
 everything either as a blessing or a curse.

 - Original Message -
 From: Nils Valentin [EMAIL PROTECTED]
 To: Rudi Ahlers [EMAIL PROTECTED]; mysql groups
 [EMAIL PROTECTED]
 Sent: Tuesday, August 12, 2003 12:04 PM
 Subject: Re: Multiple field updates


 Hi Rudi,

 I would go for the UPDATE ...SET... syntax.

 http://www.mysql.com/doc/en/UPDATE.html

 Something like

 UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 3999 AND 8001;


 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 12  18:38Rudi Ahlers :
  Hi
 
  Can someone please tell me howto update a field (which is auto_increment)
  for a range from say 4000 - 8000?
 
  I only want to change info for listings in that range, if my database has
  about 75000 listings
 
 
  Kind Regards
  Rudi Ahlers
  Oc Software Support
  +27 (11) 661-9000
 
  The basic difference between an ordinary man and a warrior is that a
  warrior takes everything as a challenge while an ordinary man takes
  everything either as a blessing or a curse.

 --
 ---
 Valentin Nils
 Internet Technology

  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple field updates

[Nils Valentin]

Hi Cybot,

Thank you for spotting that. I was a bit careless ;-)

Best regards

Nils Valentin
Tokyo/Japan


2003 8 12  19:23Cybot :
 Nils Valentin wrote:
  Hi Rudi,
 
  I would go for the UPDATE ...SET... syntax.
 
  http://www.mysql.com/doc/en/UPDATE.html
 
  Something like
 
  UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 3999 AND 8001;

 UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 4000 AND 8000;

 If expr is greater than or _equal_ to min and expr is less than or
 _equal_ to max ...

 http://www.mysql.com/doc/en/Comparison_Operators.html#IDX1157

 Hi
 
 Can someone please tell me howto update a field (which is auto_increment)
 for a range from say 4000 - 8000?
 
 I only want to change info for listings in that range, if my database has
 about 75000 listings

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fwd: Dynamic enabling of log files

[Nils Valentin]

Hi Prem,

That question was just here 2 days ago, so easy to answer. ;-)

 

Logs can be enabled/disabled for the session with SET SQL_LOG_OFF | 
SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in 
v3.23.52:
http://www.mysql.com/doc/en/SET_OPTION.html


Best regards

Nils Valenin
Tokyo/Japan

2003 8 13  13:30Prem Soman :
  Note: forwarded message attached.

 
 Want to chat instantly with your online friends?  Get the FREE Yahoo!
 Messenger http://uk.messenger.yahoo.com/

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reading table structure and data from sql file.

[Nils Valentin]

Hi Binary,

I see you want  to use the original backup file, but just restore a part of 
it.

Unfortunately mysqlimport doesnt work that way. It must have the tables name 
as filename.

I also don't remember havin seen that option with the mysql client.

All I found was -o, --one-database which does what is says only one database 
will be updated (default database).

Seems like for now editing the backup file is the fastest solution (on a 
command line).

Best regards

Nils Valentin
Tokyo/Japan



2003 8 13  03:54Binay Agarwal :
 Hi Nils ,

 Thanks for quick reply.

 I know already about the selective Backup using mysqldump and then use it.
 But what i want is restoring the selective backup i.e restore just one
 table out of say 10 tabels structure and data.

 Binay



 - Original Message -
 From: Nils Valentin [EMAIL PROTECTED]
 To: Binay Agarwal [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Wednesday, August 13, 2003 11:59 AM
 Subject: Re: Reading table structure and data from sql file.

  Hi Binary,
 
  You could either make a new backup of only the table (see mysqldump

 manual).

  mysqldump --help
 
  Or you edit the backup file you have directly and save it under a new
  name

 and

  use it.
 
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
  2003 8 13  03:13Binay Agarwal :
   Hi everybody,
  
  I have backed(backup.sql) up one Mysql database which contains
   10 tables using mysqldump.
  
   Now I want to read just one table structure and it's data from

 backup.sql

   to another database. How do i achieve it.
  
   I have tried mysql databasename  backup.sql but it will populate the
   databasename with all the 10 tables present in backup.sql which i don

 want.

   Please help me out.
  
   Mysql verison : 3.23.52
 
  --
  ---
  Valentin Nils
  Internet Technology
 
   E-Mail: [EMAIL PROTECTED]
   URL: http://www.knowd.co.jp
   Personal URL: http://www.knowd.co.jp/staff/nils
 
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dropping primary key/unique key

[Nils Valentin]

Hi Victoria,

Victoria Reznichenko wrote:

Nils Valentin [EMAIL PROTECTED] wrote:
 

I have a problem understanding why MySQL is deleting a unique key instead of  
a primary key.

from Documentation: DROP PRIMARY KEY drops the primary index. If no such index 
exists, it drops the first UNIQUE index in the table. 

When I do it then I get this:

mysql desc uksample4;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11)  |  | UNI | 0   |   |
| name  | char(30) | YES  | | NULL|   |
| tel   | char(20) |  | PRI | |   |
+---+--+--+-+-+---+
3 rows in set (0.00 sec)
mysql alter table uksample4 drop primary key ;
Query OK, 0 rows affected (0.24 sec)
Records: 0  Duplicates: 0  Warnings: 0
mysql desc uksample4;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11)  |  | | 0   |   |
| name  | char(30) | YES  | | NULL|   |
| tel   | char(20) |  | PRI | |   |
+---+--+--+-+-+---+
3 rows in set (0.00 sec)
It deletes the unique key (id) instead of he primary key (tel).

Did I do something wrong ?

MySQL 4.0.14
   

Your example worked fine for me. Could you provide a test case?

 

I know that the example worked as decribed above, thank you for 
confirming it. :-)
My Question is, why would it not drop the primary key, but the unique 
key instead ??

Which command would  delete the primary key  ?

Best regards

Nils Valentin
Tokyo/Japan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

[Nils Valentin]

James Fryer wrote:
At 10:17 am 14/08/03, Nils Valentin wrote:

The simple answer would be that the syntax says:

http://www.mysql.com/doc/en/UNION.html

SELECT...
UNION...
SELECT...


Further down the page it says

If you want to use an ORDER BY for the total UNION result, you should 
use parentheses:

(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10)
ORDER BY a;
Yup James,

Well spotted, thats the exeption which I meant. See that each SELECT 
statement has a ORDER BY clause attached, the single SELECTS as well as 
the final one ?

That seeems to be the only exception so far which I know off..

Sorry if this didn't came out so clear in my wordinbg in the last e-mail.

Best regards

Nils Valentin
Tokyo/Japan


which is what I am doing.

The problem seems to be with the syntax of CREATE TABLE and INSERT INTO, 
not the syntax of UNION.

Jim


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advanced text search

[Nils Valentin]

Hi Rudy,


I believe you just forgot a dot here in front of the +:

phone=.+27-21-*

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  15:25Rudi Ahlers :
 Hi

 I'm trying to search for some tables in a database, that contains only
 certain parts of info. I have about 3000+ records, and I'm looking for all
 the records that has +27-21, from my phone column, where the phone
 column contains phone numbers in the format of +27-21-564 7389 or
 +27-11-661 9000

 My statement is as follows:
  select compid,company,phone from companies where (phone=+27-21-*);
 And it doesn't return any records. What am I doing wrong?


 Kind Regards
 Rudi Ahlers
 +27(82) 926 1689

 The basic difference between an ordinary man and a warrior is that a
 warrior takes everything as a challenge while an ordinary man takes
 everything either as a blessing or a curse.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Index existence

[Nils Valentin]

Hi Ian,


mysql SHOW INDEX FROM tbl_name;

Best regards

Nils Valentin
Tokyo/Japan


2003 8 14  12:13Ian Collins :
 Is there any way of determining the existence of an index?

 I have a colleague messing about porting an application from MS
 SQLServer to MySQL 5 (compiled from the source).
 This application uses (whether it be good or bad) stored procedures
 heavily.

 We just wanted to check to see if an index existed as part of a stored
 procedure.
 The only way I can see to do it is to use show index from table, but
 that gives all indexes and then parsing the results.

 We are after a more efficient way (like the sqlserver query select *
 from sysindexes where name=.)

 --

 Many Regards,
 Ian Collins
 System Manager
 KIWIPLAN NZ Ltd.
 

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Designing a secure database?

[Nils Valentin]

Hi Steve,

I understood that usually the data required to connect to a db is stored in a 
outsorced php file. For mysql clients you can define usernamepassword etc. in 
the my.cnf configuration file, but I am not sure if a PHP client would access 
this file.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  06:00Lefevre, Steven :
 I'm working on a website/database deal, and right now I'm designing the
 security model.

 It's using LAMP(HP), so all the tricks are going to be through PHP.

 First off, this will be behind a firewall with SSL encryption. We may also
 setup some kind of VPN tunneling.I'll be ignoring other security details
 that don't apply to the problem at hand, but please feel free to suggest.

 I'm going to have users enter a username and password, with PHP emulating
 the htaccess dialogue boxes. I would like to check the entered values in a
 permissions table. This table looks like:

 username | passwordhash | ipaddress | permission

 All users will have a static IP, so they have to match the
 username-password-ipaddress combination. I'm storing the passwords as an
 MD5 hash in case someone breaks in and reads the table.

 So what MySQL user does PHP  log onto as the database as, in order to read
 the permissions table? (After that, we just go with the logged user's
 permission). If I make a special user that just has permission to read the
 permission table, do I have to store that user's password plaintext in a
 php script somewhere, thus adding a security risk if someone were to get a
 hold of that password?

 Steve

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple field updates

[Nils Valentin]

Hi Rudi,

I would go for the UPDATE ...SET... syntax. 

http://www.mysql.com/doc/en/UPDATE.html

Something like

UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 3999 AND 8001;


Best regards

Nils Valentin
Tokyo/Japan


2003 8 12  18:38Rudi Ahlers :
 Hi

 Can someone please tell me howto update a field (which is auto_increment)
 for a range from say 4000 - 8000?

 I only want to change info for listings in that range, if my database has
 about 75000 listings


 Kind Regards
 Rudi Ahlers
 Oc Software Support
 +27 (11) 661-9000

 The basic difference between an ordinary man and a warrior is that a
 warrior takes everything as a challenge while an ordinary man takes
 everything either as a blessing or a curse.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error Code 28?

[Nils Valentin]

Hi ED,

thats a number to big for me yet. Sorry. I guess thats better posted to the 
mailing list.

The best I can do is an educated guess  (or whatever thats called).
And that would be some set limits either from mysql, because the search takes 
quite long (you could find out with log-slow-queries), or from the ASP side 
perhaps a time limit etc.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  01:00:
 Hey Nils,.

 Is there a way I can set error checking on a page?  I have a test mySQL
 db that displays all the records in an ASP page.  It works without a
 problem (it's only 10 records).  Then I try it with the main db (and the
 1.7 millions records), and it crashes, giving me a page cannot be
 displayed error.

 How can I find out where the problem is at?

 Thanks,

 Ed


 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, August 12, 2003 9:46 AM
 To: Ed Kraft
 Subject: Re: Error Code 28?


 Hi Ed,

 hmm, what does perror 28 say ?

 If I guess right than it shoud say  no space left on device  or
 something
 like this. This is only the partition where the data files are on. The
 other
 partitions are not of interest for this.

 Could you let me know which MySQL version and from where (MySQL or f.e
 Redhat)
 and which format (RPM or tar etc.) and  which Linux OS. I will see what
 I can
 find out

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 12  22:38:
  Thanks Nils.  I am running this on Linux, but when I check my hd
  usage, I'm not full.  I don't get it.  :)
 
  Thanks,
 
  Ed
 
 
  -Original Message-
  From: Nils Valentin [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, August 12, 2003 9:26 AM
  To: Ed Kraft; [EMAIL PROTECTED]
  Subject: Re: Error Code 28?
 
 
  Hi ED,
 
  Very close you are. If you run Linux than this message means get a
  new Harddisk for me please ;-) I am full ;-)
 
  You can check this with perror 28.
 
  Perror works only for the OS dependent messages (1-150) The other you
  will have to figure out yourself ;-)... or you can check my homepage
 
  http://www.knowd.co.jp/staff/nils/mysql-error-codes.html
 
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
  2003 8 12  21:18Ed Kraft :
   Hey All,
  
   Does anyone know what this error code means?  I think it may have
   something to do with the database being too large.  The exact error
   is, ERROR 1030: Got error 28 from table handler
  
   What I tried doing was importing into a mySQL db via a text file.
   There are approximately 1.7 million records in the text file (the
   text
  
   file is 467 mb).
  
   Any suggestions would be greatly appreciated.
  
   Thanks,
  
   Ed

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A final Windows MySQL PHP plea

[Nils Valentin]

Hi Gary,

I understood that the packages provided by MySQL are set to 100 concurrent 
users by default, so what you ae asking is actually if somebody successfully 
compiled a version for more than 100 concurrent users and was able to use it 
in a production environment ?

Do I understand that correct ?

My guess would be that you are more likely to find Linux users having done 
such a setup. Unfortunately I haven'Tt had such an experience yet, but as you 
probably now Dell has made a study (which is also announced on www.mysq.com) 
which describes their experience, perhaps it contains the one or the other 
useful tip.

http://www.dell.com/us/en/biz/topics/power_ps2q03-jaffe.htm

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  01:21Gary Broughton :
 Hi all

 Is there anybody out there who has managed to successfully configure
 Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a couple
 of hundred users at any one time?  I have chucked absolutely everything
 I can think of at this, but the MySQL (it seems) simply eats all the
 available CPU within a short space of time (regardless of users) and
 brings the site to a halt.  My last throw of the dice today was to
 install all on a new Dual 1.8Ghz Pentium, with three hard disks in a
 RAID array, and 2GB memory, but it's achieved pretty much nothing.  I am
 now desperate, and if anyone has any flash of inspiration for me, I'm
 all ears.  The previous ASP version of the site runs like a dream, but
 there's something I'm either doing wrong, or this new combination of
 software simply doesn't like.

 Many thanks

 Stressed Gary

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: escape sequence question

[Nils Valentin]

Hi Roger,

Thanks for the thorough explanation. I think I got it now ;-)


Best regards

Nils Valentin
Tokyo/Japan



2003 8 14  20:47Roger Baklund :
 * Roger Baklund

   They both look for 2003's.

 * Nils Valentin

  Thats what I also thought at first sight, but there seems to be
  more to it.
 
   The LIKE operator is a pattern matching operator. The operand
   is evaluated twice: first by the parser, and then when the
   pattern matching is performed. For your last example, the
   first evaluation changes  2003\\\'s to 2003\'s, and the
   second evaluation changes 2003\'s to 2003's.
 
  THis example works for the second one , how about the first one
  in comparison ?

 In your first example, the first evaluation changes 2003\'s to 2003's,
 and the second evaluation does not change anything, the value is allready
 unescaped.

 If you wanted to find columns containing a backslash you would need to use
 something like this:

 SELECT * FROM mytable WHERE mycol LIKE '%%'

 Because of the double evaluation, this is the same as LIKE %\% if
 backslahs is not the escape character. Note that since version 3.22.9 you
 can use the ESCAPE option to the LIKE operator:

 SELECT * FROM mytable WHERE mycol LIKE '%\%' ESCAPE '|'

 In this case, the backslash is not handled as an escape character, and the
 double doubling is not needed.

 --
 Roger

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: alter table froze entire machine!

[Nils Valentin]

Hi Dan,

Just a guess though, but you are sure you have PLENTY of harddisk space laying 
around ?

If not that would perfectly explain the behaviour.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  08:19Dan Edwards :
 Hi about 2 months ago I had trouble with alter table on large tables
 blocking all database activity and started a thread on this list called
 alter table blocks other tables!

 I tried to resolve the problems by upgrading to mysql 4.0.14, putting
 the database that I needed absolute best performance on a fast scsi
 drive all by itself.

 Then twice this week I needed to add a column to a large table (about a
 million records). The tables reside on the main system ide drive. For
 the first few minutes of the alter table everything was fine. I watched
 the file sizes of the temporary MYD and MYI files grow to about the size
 of the originals. Then a few minutes later tragedy,  the whole machine
 all but locked up. commands typed on open shell sessions freeze and
 after typing in my username/password to start another linux session that
 session froze, never got a prompt. After several minutes of waiting I
 had to hit the reset button on the server. After it booted backup
 everything was fine, the table I was altering had the new column, the
 alter table actually finished! Like I said this happend twice!

 This is a RedHat 8 machine, kernel 2.4.18-14, Athlon XP 1700+, 1 gig
 ram. mysql was installed from
 mysql-standard-4.0.14-pc-linux-i686.tar.gz.tar

 I have successfully executed alter tables on smaller tables without
 problems. Also I accidently ran one of the alter tables on the slave
 database before running it on the master, it completed fine. It is
 Redhat9, kernel 2.4.20-8, P4 2.4, 1 gig ram. Mysql 4.0.12


 What could possibly be causeing this? What to do to fix it? Is it a
 hardware problem? Kernel problem? I guess I should just put together a
 new machine and hope it doesn't happen to it. But thought I would post
 in case it helps anyone else.


 Thanks!
 Dan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: alter table froze entire machine!

[Nils Valentin]

Hi Dan,

O.K just making sure ;-)

How big is the table ?

Does it contain any indexes ? Could you remove the indexes, alter the table 
and than add the indexes again ?

I read over and over that the Kernel 2.4.18 has lots of BUGS, but I am not 
sure if this applies to your case. If you look in the archive you should find 
a message from heikki Thuri stating something like this.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  13:42Dan :
 Ya plenty of freespace, 27 gigs, that one has got me before though.
 Thanks!
 Dan

 Nils Valentin wrote:
  Hi Dan,
 
  Just a guess though, but you are sure you have PLENTY of harddisk space
  laying around ?
 
  If not that would perfectly explain the behaviour.
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
  2003 8 13  08:19Dan Edwards :
 Hi about 2 months ago I had trouble with alter table on large tables
 blocking all database activity and started a thread on this list called
 alter table blocks other tables!
 
 I tried to resolve the problems by upgrading to mysql 4.0.14, putting
 the database that I needed absolute best performance on a fast scsi
 drive all by itself.
 
 Then twice this week I needed to add a column to a large table (about a
 million records). The tables reside on the main system ide drive. For
 the first few minutes of the alter table everything was fine. I watched
 the file sizes of the temporary MYD and MYI files grow to about the size
 of the originals. Then a few minutes later tragedy,  the whole machine
 all but locked up. commands typed on open shell sessions freeze and
 after typing in my username/password to start another linux session that
 session froze, never got a prompt. After several minutes of waiting I
 had to hit the reset button on the server. After it booted backup
 everything was fine, the table I was altering had the new column, the
 alter table actually finished! Like I said this happend twice!
 
 This is a RedHat 8 machine, kernel 2.4.18-14, Athlon XP 1700+, 1 gig
 ram. mysql was installed from
 mysql-standard-4.0.14-pc-linux-i686.tar.gz.tar
 
 I have successfully executed alter tables on smaller tables without
 problems. Also I accidently ran one of the alter tables on the slave
 database before running it on the master, it completed fine. It is
 Redhat9, kernel 2.4.20-8, P4 2.4, 1 gig ram. Mysql 4.0.12
 
 
 What could possibly be causeing this? What to do to fix it? Is it a
 hardware problem? Kernel problem? I guess I should just put together a
 new machine and hope it doesn't happen to it. But thought I would post
 in case it helps anyone else.
 
 
 Thanks!
 Dan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Joins and Unions

[Nils Valentin]

Hi Kim,


just send a reply a minute ago. I got it now. You want to change the way the 
data is presented at the screen and thats a different issue. You would have 
to make this in your apllication, not with mysql itself I believe.

You basically want the DISTINCT function within the JOINS - but only applied 
for a certain column.

Thats not possibe yet I believe.

Best regards

Nils Valentin
Tokyo/Japan

2003 8 13  14:16Kim Kohen :
 G'day Nils

 Well, I can't speak for Daniel, and I'm not really up on his tables, but
 I'm not using left joins. The situation I have is not one where I need to
 display items that don't exist from one table or another.

 The data I get from a basic join is the _data_ I want - I just can't get it
 to display in a clear fashion. The join is forcing 'extra' superfluous data
 to be displayed. I know this could be eliminated if I could obtain all the
 data for a union, but I can't see a way to display as a union and query as
 a join.

 cheers

 kim

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Foreign Keys

[Nils Valentin]

Hi there,

here a simple sample (basicall taken from the documents) with 3 tables.

2 points to watch out for:

1) first declare the primary keys 
here (p1.id and p2.id) 
2) index the foreign key column 
here (child.id1 and child.id2)


mysql CREATE TABLE p1(id INT PRIMARY KEY)TYPE=INNODB;
Query OK, 0 rows affected (0.03 sec)

mysql CREATE TABLE p2(id INT PRIMARY KEY)TYPE=INNODB;
Query OK, 0 rows affected (0.01 sec)

mysql CREATE TABLE child(
- id1 INT,
- id2 INT,
- INDEX(id1),
- INDEX(id2),
- FOREIGN KEY (id1) REFERENCES p1(id),
- FOREIGN KEY (id2) REFERENCES p2(id))TYPE=InnoDB;
Query OK, 0 rows affected (0.01 sec)


In you case you haven't indexed IDTr

Create table y (
 IDTr INT NOT NULL,
INDEX (IDTr)
constraint FOREIGN KEY  IDTr REFERENCES x(ID)
 )Type=Innodb;


That should work. Best regards

Nils Valentin
Tokyo/Japan

2003 8 12  04:31b b :
  I am using MYSQL 4. I understand that it allows for
 foreign keys. Could someone show me an example of how
 to declare a foriegn key. I tried a combination of
 statements but I always got a syntax error.

  Here is what I am trying for example ...

  Create table x (
  ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  whatever int

 )Type=Innodb;


  Create table y (
  IDTr INT NOT NULL,
  constraint FOREIGN KEY  IDTr REFERENCES x(ID)
 )Type=Innodb;

  How would I create a foreign key linking IDTr to
 x(ID)?

 Cheers.

  Cheers.

 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MD5-read permission?

[Nils Valentin]

2003 8 14  12:50Nils Valentin :
 Hi Steven,

 while the general idea sounds not to bad, I guess the bad guess would

I meant the bad guys - what a silly typo ;-)

 just use a undecrypt function wich they either develop themself or get from
 somewhere.


 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 14  03:07Lefevre, Steven :
  Hey folks -
 
  While contemplating the design of a secure web database, an idea struck
  me. I'm thinking of submitting it as a feature request, so please
  critique it.
 
  I'm having php handle user logon with it's .htaccess emulation. I'm
  storing usernames and password hashes in a table. The problem is that php
  needs to open MySQL with *some user* with *some permission*, just to read
  the user table and check the password. So, It seems that I have to store
  the password plaintext somewhere in some php file.
 
  (I asked the list about this earlier and several others had great
  suggestions on how to hide this plain-text password -- Thanks Rob! --
  but, can we make it better?)
 
  So if some wily hacker were to get the contents of this php file, s/he
  would get a username and password for the database. Now of course, I'm
  only going to give this user permission to read the user database, and
  all the passwords are hashed... but :
 
  I propose a new permission that I will call MD5read. It's like select,
  only it just returns hashes.
 
 
  So, say you do something like:
 
  SELECT password FROM user;
 
  49726b60ccbf03d6c619632e1db6
  f8ec2c9d79b5f969a96be968e7152bbd
 
 
  SELECT username, password FROM user;
 
  24424b444b80831b677594a238f81dd9 | 4549625d8275b97b9b4f9662f1c550fa
  1e5143d05b327f7d3cce15f9e3e44ad2 | fe3b4b388a69ceed38d6a0066e6a221b
 
 
  SELECT username+password+somethingelse FROM user;
 
  49726b60ccbf03d6c619632e1db6
  f8ec2c9d79b5f969a96be968e7152bbd
 
 
 
  So that way, if someone gets the username/password for this user, they
  can't get any data off of the database.
 
  One thing you have to watch is that you don't use the md5 function for a
  user that has only md5read permission, because that would double-hash it,
  and whatever you're checking would fail.
 
  I know you can do
  SELECT md5(username), md5(password) FROM user
  (or whatever the syntax is), but the user doing that has to have read
  permission already. So if a hacker gets that username and password, they
  are probably not going to hash data they are trying to get out of the
  database.
 
  I would feel safe storing a user's name and password in a plain text php
  script if they had only this permission.
 
  Is this useful? Are there any flaws in my reasoning?

 --
 ---
 Valentin Nils
 Internet Technology

  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Root

[Nils Valentin]

Hi FT,

Thats because you specified the wrong host in the syntax below:

mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password'
 with grant option;

Try it again with the correct hostid (the one you are using with phpmyadmin) 
or put a wildcard like % for the 

mysql GRANT ALL ON *.* TO 'root'@'%' indentified by 'my_password'
 with grant option;

Best regards

Nils Valentin
Tokyo/Japan



2003 8 8  13:59FT :
 Thanks Nils,

 Now that phpmyadmin is working ..I can do just about everything on my
 db...but when I try to log on on the server by typing : myself  it
 still gives me the error 1045 access denied for user root @ localhost
 (using password:NO)

 I am a bit confused on why it does  work from phpmyadmin on the client side
 but not from the server...?
 any idea?

 Fabrice
 - Original Message -
 From: Nils Valentin [EMAIL PROTECTED]
 To: FT [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, August 04, 2003 9:51 AM
 Subject: Re: Root


 Hi FT,

 2003 8 4  09:24:
  Thanks Nils...good to have you around...in Tokyo
  This worked except for the UPDATE than was not recognized by MySql

 3.23.36

  but strangely all previous tables were still there and it looks like it
  is running again.. still worry about this UPDATE command ..but I am back
  on phpMyAdmin 4.3.0 as root @ localhost
  How do I change this one or do I need to keep it

 Well that depends if you use the account local  (login on the same machine
 the
 server is running ) or not.

 See the Grant command and the usage of the mysql client for details. Here
 just
 a rough sample:

 mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password'
  with grant option;

 If the user doesn't need to create new users than you can leave with grant
 option.

 Best regards
 Nils Valentin
 Tokyo/Japan

  Thanks
  - Original Message -
  From: Nils Valentin [EMAIL PROTECTED]
  To: FT [EMAIL PROTECTED]; [EMAIL PROTECTED]
  Sent: Sunday, August 03, 2003 3:11 PM
  Subject: Re: Root
 
 
  Hi there,
 
  First shutdown the running server.
 
  mysqladmin shutdown
  or
  /etc/init.d/mysql.server stop
  or
  /etc/init.d/mysqld stop
 
  (depending on your Linux distribution)
 
 
  Then  restart the mysql server with option --skip-grant-tables like

 this.

  safe_mysqld --skip-grant-tables
 
  You can then login without password. And then you reset your password

 with

  the update command like this:
 
  UPDATE user SET password='' WHERE user='root';
 
  Restart the server again.
 
  Set a new password with mysqladmin like this:
 
  mysqladmin -u root password xxx
  mysqladmin -u root flush-privileges
 
  (xxx is your new password)
  That should be it.
 
  Mysql has a nice manual by the way where it is all described detailed,
  comes in very handy to have such a print close, just in case ;-)
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
  2003 8 3  14:21FT :
   Hi everyone
   I am quiet new to DB and MySql
   I must have made a big mistake by changing the root @ localhost
   password via phpMyAdmin and now it is impossible to connect from
   neither the

 mysql

   prompt nor phpMyAdmin...
  
   Does anyone know how to recover this problem...I did try to reinstall
 
  MySql
 
   after uninstalling it and rebooted the server but no luck so far...
  
   Thanks for the hand
  
   Fabrice

 --
 ---
 Valentin Nils
 Internet Technology

  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dropping primary key/unique key

[Nils Valentin]

[Warning: LNG TEXT - enjoy ;-)]

Hi Victoria,

sorry for the misunderstanding. I just tried to reproduce the sample. While I 
have records what I did I did not write down all commands exactly as they 
are. 

The problem(s) occured on Redhat 8 or 9 and Mysql server-max 4.0.13 (tar 
format) from mysql homepage. I had to reinstall a machine to reproduce the 
problem,this is why it took so long.


 First the original problem
Redhat 9 + Mysql server-max 4.0.13 (tar format from mysql.com homepage)

create table uksample2 (id int unique not null ,name char(30),tel 
char(20))type=innodb;
Query OK, 0 rows affected (0.01 sec)

mysql alter table uksample2 add primary key (tel);
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql desc uksample2;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11)  |  | UNI | 0   |   |
| name  | char(30) | YES  | | NULL|   |
| tel   | char(20) |  | PRI | |   |
+---+--+--+-+-+---+
3 rows in set (0.00 sec)

mysql alter table uksample2 drop primary key;
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql desc uksample2;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11)  |  | | 0   |   |
| name  | char(30) | YES  | | NULL|   |
| tel   | char(20) |  | PRI | |   |
+---+--+--+-+-+---+
3 rows in set (0.00 sec)


Unique key was dropped. Why not Primary key, why no error message???

--
2nd  example where it complains about that no two primary keys are allowed,but 
lets me create them first ;-) This time on Redhat 8.
Redhat8 and 4.0.13 server-max (tar format from mysql.com homepage)

create table uksample2 (id int unique not null auto_increment,name 
char(30),tel char(20));
Query OK, 0 rows affected (0.01 sec)

mysql desc uksample2;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| id| int(11)  |  | PRI | NULL| auto_increment |
| name  | char(30) | YES  | | NULL||
| tel   | char(20) | YES  | | NULL||
+---+--+--+-+-++
3 rows in set (0.00 sec)

mysql alter table uksample2 add primary key (tel);
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql desc uksample2;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| id| int(11)  |  | UNI | NULL| auto_increment |
| name  | char(30) | YES  | | NULL||
| tel   | char(20) |  | PRI | ||
+---+--+--+-+-++
3 rows in set (0.00 sec)

mysql alter table uksample2 drop primary key ;
ERROR 1075: Incorrect table definition; There can only be one auto column and 
it must be defined as a key
mysql alter table uksample2 drop primary key (id);

Note that also alter table uksample2 drop index id; will give me the same
 error.

-

On a Suse Linux system 8.1 with mysql server max 4.1 -alpha (rpm format from 
mysql.com homepage) I get the below message, which I believe is correct.

mysql create table uksample2 (id int unique not null auto_increment,name 
char(30),tel char(20));
Query OK, 0 rows affected (0.07 sec)

mysql alter table uksample2 add primary key (tel);
ERROR 1171: All parts of a PRIMARY KEY must be NOT NULL;  If you need NULL in 
a key, use UNIQUE instead
mysql drop table uksample2;   
  
Query OK, 0 rows affected (0.00 sec)



Best regards

Nils Valentin
Tokyo/Japan




2003 8 6  19:22Victoria Reznichenko :
 Nils Valentin [EMAIL PROTECTED] wrote:
  Hi Victoria,
 
  Victoria Reznichenko wrote:
 Nils Valentin [EMAIL PROTECTED] wrote:
 I have a problem understanding why MySQL is deleting a unique key
  instead of a primary key.
 
 from Documentation: DROP PRIMARY KEY drops the primary index. If no such
  index exists, it drops the first UNIQUE index in the table.
 
 When I do it then I get this:
 
 mysql desc uksample4;
 +---+--+--+-+-+---+
 
 | Field | Type | Null | Key | Default | Extra |
 
 +---+--+--+-+-+---+
 
 | id| int(11)  |  | UNI | 0   |   |
 | name  | char(30) | YES  | | NULL|   |
 | tel   | char(20) |  | PRI | |   |
 
 +---+--+--+-+-+---+
 3

Re: How can I enable unicode and japanese support?

[Nils Valentin]

Hi there,

I haven't used unicode yet, but I use this setting in the my.cnf file:

default-character-set=ujis

Do you understand that Asian characters are using 2 bytes for each character ? 
It's not like English, German etc, which use the alphabet. 
This will restrict you also on the functions which you can use. Not all 
functions are yet double byte safe. The manual is discusssing this in more 
details.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 6  22:[EMAIL PROTECTED] :
 I am using cold fusion to make a small custom website using
 mysql to store the information a user inputs. I want it to
 be able to save japanese and unicode text, but whenever I
 enter any it comes back as garbage. Is there anything
 special I need to do to configure mysql to use unicode?
 Thanks!
 -Adam

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tricky INSERT

[Nils Valentin]

Hi Fraser,


I a sorry I dont understand what you want to do. Could you show how you want 
it to be and the queries which you used so far ?

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  08:30Fraser Hanson :
 I have table A with column id, and table B with columns id and
 content.

 I am trying to build a query that inserts all ids from table A into
 table B, and also sets the value field for all these new entries to
 a given value.


 For example:
 #Before the query, the tables are like this:
 mysql select * from a;
 +--+

 | id   |

 +--+

 | hal  |
 | ron  |
 | kip  |
 | dag  |
 | bob  |
 | max  |

 +--+

 mysql select * from b;
 +--+---+

 | id   | value |

 +--+---+

 | bob  |  4|
 | bob  |  5|
 | max  |  5|

 +--+---+

 # After the query,  b is like this:

 mysql select * from b;
 +--+---+

 | id   | value |

 +--+---+

 | bob  |  4|
 | bob  |  5|
 | dag  |  4|
 | hal  |  4|
 | kip  |  4|
 | max  |  4|
 | max  |  5|
 | ron  |  4|

 +--+---+

 I have been trying variations on the INSERT ... SELECT syntax, but
 I suspect this is a dead end.  The next best thing I can think
 of is building a temporary table that has the values that I want, and
 then using INSERT ... SELECT to copy them all into table b.

 Can anyone suggest a way to achieve this?
 --Fraser Hanson

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error Code 28?

[Nils Valentin]

Hi Ed,

wouldn't that be the same cause  no space left on device ??

A index is using perhaps another 30% of the whole table.

Best regards

Nils Valentin
Tokyo/Tokyo

2003 8 13  00:27:
 Hey Nils,

 I just tried it again, and it worked.  :)

 However, I tried creating a few indexes in the db within SQLyog (GUI
 front end), and got the same error (error 28 within table handler).
 Why would I be getting an error from trying to create an index?

 Thanks,

 Ed


 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, August 12, 2003 9:46 AM
 To: Ed Kraft
 Subject: Re: Error Code 28?


 Hi Ed,

 hmm, what does perror 28 say ?

 If I guess right than it shoud say  no space left on device  or
 something
 like this. This is only the partition where the data files are on. The
 other
 partitions are not of interest for this.

 Could you let me know which MySQL version and from where (MySQL or f.e
 Redhat)
 and which format (RPM or tar etc.) and  which Linux OS. I will see what
 I can
 find out

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 12  22:38:
  Thanks Nils.  I am running this on Linux, but when I check my hd
  usage, I'm not full.  I don't get it.  :)
 
  Thanks,
 
  Ed
 
 
  -Original Message-
  From: Nils Valentin [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, August 12, 2003 9:26 AM
  To: Ed Kraft; [EMAIL PROTECTED]
  Subject: Re: Error Code 28?
 
 
  Hi ED,
 
  Very close you are. If you run Linux than this message means get a
  new Harddisk for me please ;-) I am full ;-)
 
  You can check this with perror 28.
 
  Perror works only for the OS dependent messages (1-150) The other you
  will have to figure out yourself ;-)... or you can check my homepage
 
  http://www.knowd.co.jp/staff/nils/mysql-error-codes.html
 
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
  2003 8 12  21:18Ed Kraft :
   Hey All,
  
   Does anyone know what this error code means?  I think it may have
   something to do with the database being too large.  The exact error
   is, ERROR 1030: Got error 28 from table handler
  
   What I tried doing was importing into a mySQL db via a text file.
   There are approximately 1.7 million records in the text file (the
   text
  
   file is 467 mb).
  
   Any suggestions would be greatly appreciated.
  
   Thanks,
  
   Ed

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

[Nils Valentin]

Hi James,

The simple answer would be that the syntax says:

http://www.mysql.com/doc/en/UNION.html

SELECT...
UNION...
SELECT...

And thats all there is to it ;-) ... perhaps...


Exception:

The only reason to use the parenthis would be with ORDER BY (as you do), but 
than you will need to use this also in each SELECT statement.



Best regards

Nils Valentin
Tokyo/Japan


2003 8 14  18:06James Fryer :
 At 09:47 am 14/08/03, Jim Smith wrote:
 But why do you need the parentheses?

 This was a simplified query for example purposes.

 The real query looks more like

(SELECT ...) UNION (SELECT ...) ORDER BY ...

 I could rewrite this with subselects but I have found them to be slower.

 My question is, why do the parentheses cause a syntax error and is this a
 bug?

 Jim
 --
 James Fryer  /  [EMAIL PROTECTED]  /  [EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Root

[Nils Valentin]

Hi FT,


2003 8 8  16:15Nils Valentin :
 Hi FT,

 Thats because you specified the wrong host in the syntax below:

 mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password'
  with grant option;

Just ralized that I gave you the wrong syntax. So for the record the correct 
syntax must be

mysql GRANT ALL ON *.* TO 'root'@'hostname' indentified by 'my_password'
with grant option;

Note that the username and hostname are in separated single quotes. Sorry for 
that confusion.

Why did nobody correct me ???  never mind ;-)

Best regards

Nils Valentin
Tokyo/Japan


 Try it again with the correct hostid (the one you are using with
 phpmyadmin) or put a wildcard like % for the

 mysql GRANT ALL ON *.* TO 'root'@'%' indentified by 'my_password'
  with grant option;

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 8  13:59FT :
  Thanks Nils,
 
  Now that phpmyadmin is working ..I can do just about everything on my
  db...but when I try to log on on the server by typing : myself  it
  still gives me the error 1045 access denied for user root @ localhost
  (using password:NO)
 
  I am a bit confused on why it does  work from phpmyadmin on the client
  side but not from the server...?
  any idea?
 
  Fabrice
  - Original Message -
  From: Nils Valentin [EMAIL PROTECTED]
  To: FT [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Monday, August 04, 2003 9:51 AM
  Subject: Re: Root
 
 
  Hi FT,
 
  2003 8 4  09:24:
   Thanks Nils...good to have you around...in Tokyo
   This worked except for the UPDATE than was not recognized by MySql
 
  3.23.36
 
   but strangely all previous tables were still there and it looks like it
   is running again.. still worry about this UPDATE command ..but I am
   back on phpMyAdmin 4.3.0 as root @ localhost
   How do I change this one or do I need to keep it
 
  Well that depends if you use the account local  (login on the same
  machine the
  server is running ) or not.
 
  See the Grant command and the usage of the mysql client for details. Here
  just
  a rough sample:
 
  mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password'
   with grant option;
 
  If the user doesn't need to create new users than you can leave with
  grant option.
 
  Best regards
  Nils Valentin
  Tokyo/Japan
 
   Thanks
   - Original Message -
   From: Nils Valentin [EMAIL PROTECTED]
   To: FT [EMAIL PROTECTED]; [EMAIL PROTECTED]
   Sent: Sunday, August 03, 2003 3:11 PM
   Subject: Re: Root
  
  
   Hi there,
  
   First shutdown the running server.
  
   mysqladmin shutdown
   or
   /etc/init.d/mysql.server stop
   or
   /etc/init.d/mysqld stop
  
   (depending on your Linux distribution)
  
  
   Then  restart the mysql server with option --skip-grant-tables like
 
  this.
 
   safe_mysqld --skip-grant-tables
  
   You can then login without password. And then you reset your password
 
  with
 
   the update command like this:
  
   UPDATE user SET password='' WHERE user='root';
  
   Restart the server again.
  
   Set a new password with mysqladmin like this:
  
   mysqladmin -u root password xxx
   mysqladmin -u root flush-privileges
  
   (xxx is your new password)
   That should be it.
  
   Mysql has a nice manual by the way where it is all described detailed,
   comes in very handy to have such a print close, just in case ;-)
  
   Best regards
  
   Nils Valentin
   Tokyo/Japan
  
   2003 8 3  14:21FT :
Hi everyone
I am quiet new to DB and MySql
I must have made a big mistake by changing the root @ localhost
password via phpMyAdmin and now it is impossible to connect from
neither the
 
  mysql
 
prompt nor phpMyAdmin...
   
Does anyone know how to recover this problem...I did try to reinstall
  
   MySql
  
after uninstalling it and rebooted the server but no luck so far...
   
Thanks for the hand
   
Fabrice
 
  --
  ---
  Valentin Nils
  Internet Technology
 
   E-Mail: [EMAIL PROTECTED]
   URL: http://www.knowd.co.jp
   Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Password formats 3.23-4.x

[Nils Valentin]

Hi MySQL fans ;-),

I tried to get some experience with converting between the different password 
formats as describd here:

http://www.mysql.com/doc/en/Password_hashing.html

So I took this sample

mysql UPDATE user SET Password = OLD_PASSWORD('mypass')
- WHERE Host = 'some_host' AND User = 'some_user';
mysql FLUSH PRIVILEGES;

modified it a bit and found out that sometimes it would not let me do this 
with an logical operator like = but instead wants LIKE or RLIKE.

I am using 4.1 alpha , so it is possible hat this is a bug of course. Does 
anybody have similar experience ?


mysql UPDATE user SET Password=OLD_PASSWORD('mypassword') WHERE Host like 
'localhost' AND User like 'root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql UPDATE user SET Password=OLD_PASSWORD('mypassword') WHERE Host rlike 
'localhost' AND User rlike 'root';
Query OK, 1 row affected (0.24 sec)
Rows matched: 1  Changed: 1  Warnings: 0

See that finally the RLIKE worked. So Ia m a bit confused now as I would have 
expected the LIKE function to work, but perhaps this is a special case  ??

Any reply appreciated.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0.13 download

[Nils Valentin]

Hi Kirk,

In case you are on Linux and a TAR file format would be fine then I could help 
you out.

I keeep all 3 version locally and could e-mail it to you directly.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  04:28MightyData :
 How can I find a download for MySQL 4.0.13? I looked on the MySQL web site
 but could not find a link to download a prior release. I know 4.0.14 is the
 latest release but we completed our application testing against 4.0.13.

 -
 Kirk Bowman  Direct: 972-492-7523
 MightyData, LLC http://www.mightydata.com
 -

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

[Nils Valentin]

Hi James,

I don' t understand your question. Why do you hink you that the brackets 
would't work ?

I tried that without any problems. Please post your code.

Here is mine:

SELECT * FROM sensei WHERE last_name IN (SELECT last_name FROM sensei UNION 
ALL select last_name FROM sensei) ORDER BY e_mail;

Best regards

Nils Valentin
Tokyo/Japan




2003 8 14  17:04James Fryer :
 Assuming a legal SELECT statement, this works fine:

CREATE TABLE Foo SELECT ...

 but this does not:

CREATE TABLE Foo (SELECT ...)

 This is a problem for me as I'd like to use the output of a
 SELECT...UNION...ORDER BY statement as input to CREATE TABLE.

 Same holds for INSERT INTO.

 Is this a bug? I can't find it documented anywhere.

 Jim
 --
 James Fryer  /  [EMAIL PROTECTED]  /  [EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MD5-read permission?

[Nils Valentin]

Hi Steven,

while the general idea sounds not to bad, I guess the bad guess would just 
use a undecrypt function wich they either develop themself or get from 
somewhere.



Best regards

Nils Valentin
Tokyo/Japan


2003 8 14  03:07Lefevre, Steven :
 Hey folks -

 While contemplating the design of a secure web database, an idea struck me.
 I'm thinking of submitting it as a feature request, so please critique it.

 I'm having php handle user logon with it's .htaccess emulation. I'm storing
 usernames and password hashes in a table. The problem is that php needs to
 open MySQL with *some user* with *some permission*, just to read the user
 table and check the password. So, It seems that I have to store the
 password plaintext somewhere in some php file.

 (I asked the list about this earlier and several others had great
 suggestions on how to hide this plain-text password -- Thanks Rob! -- but,
 can we make it better?)

 So if some wily hacker were to get the contents of this php file, s/he
 would get a username and password for the database. Now of course, I'm only
 going to give this user permission to read the user database, and all the
 passwords are hashed... but :

 I propose a new permission that I will call MD5read. It's like select, only
 it just returns hashes.


 So, say you do something like:

 SELECT password FROM user;

 49726b60ccbf03d6c619632e1db6
 f8ec2c9d79b5f969a96be968e7152bbd


 SELECT username, password FROM user;

 24424b444b80831b677594a238f81dd9 | 4549625d8275b97b9b4f9662f1c550fa
 1e5143d05b327f7d3cce15f9e3e44ad2 | fe3b4b388a69ceed38d6a0066e6a221b


 SELECT username+password+somethingelse FROM user;

 49726b60ccbf03d6c619632e1db6
 f8ec2c9d79b5f969a96be968e7152bbd



 So that way, if someone gets the username/password for this user, they
 can't get any data off of the database.

 One thing you have to watch is that you don't use the md5 function for a
 user that has only md5read permission, because that would double-hash it,
 and whatever you're checking would fail.

 I know you can do
 SELECT md5(username), md5(password) FROM user
 (or whatever the syntax is), but the user doing that has to have read
 permission already. So if a hacker gets that username and password, they
 are probably not going to hash data they are trying to get out of the
 database.

 I would feel safe storing a user's name and password in a plain text php
 script if they had only this permission.

 Is this useful? Are there any flaws in my reasoning?

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

[Nils Valentin]

Hi J smith,

Below  was my sample not James. For my sample ou will need the brackets or it 
will give you an error.

Hi James,

You are right it gives an error, but as J Smith also pointed out in your case 
you dont need the brackets, in my case you would need it. ;-)

Best regards

Nils Valentin
Tokyo/Japan




2003 8 14  17:47Jim Smith :
 But why do you need the parentheses?

 What is wrong with

 CREATE TABLE Foo2
   SELECT * FROM sensei
   WHERE last_name IN (SELECT last_name
 FROM sensei UNION ALL
 select last_name
 FROM sensei)
   ORDER BY e_mail;

  -Original Message-
  From: James Fryer [mailto:[EMAIL PROTECTED]
  Sent: 14 August 2003 09:41
  To: [EMAIL PROTECTED]
  Subject: Re: CREATE TABLE, INSERT INTO with SELECT in parentheses
 
  At 09:22 am 14/08/03, Nils Valentin wrote:
  I don' t understand your question. Why do you hink you that
 
  the brackets
 
  would't work ?
  
  I tried that without any problems. Please post your code.
  
  Here is mine:
  
  SELECT * FROM sensei WHERE last_name IN (SELECT last_name
 
  FROM sensei UNION
 
  ALL select last_name FROM sensei) ORDER BY e_mail;
 
  Here's some code that demonstrates what I mean:
 
  -- Cut Here --
  CREATE DATABASE Foobar;
  USE Foobar;
  CREATE TABLE Bar (id int(10) unsigned);
 
  # Works
  SELECT * FROM Bar;
 
  # Works
  CREATE TABLE Foo1 SELECT * FROM Bar;
 
  # Works
  (SELECT * FROM Bar);
 
  # Fails (syntax error)
  CREATE TABLE Foo2 (SELECT * FROM Bar);
 
  DROP DATABASE Foobar;
  -- Cut Here --
 
  Using MacOS so please forgive any errors due to case-sensitivity.
 
  Jim
  --
  James Fryer  /  [EMAIL PROTECTED]  /  [EMAIL PROTECTED]
 
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
  http://lists.mysql.com/[EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

escape sequence question

[Nils Valentin]

Hi MySQL Fans ;-),

I have problems understanding why the below two commands would return the same 
result.

1)

mysql select * from sensei where link like '/var/www/html/xoops/2003\'s sum';
+---++-+---+
| instructor_id | llink  | character  | e_mail|
+---++-+---+
| KDC009| /var/www/html/xoops/2003's sum | Character's | [EMAIL PROTECTED] 
|
+---++-+---+
1 row in set (0.00 sec)


2)

mysql select * from sensei where last_name like 
'/var/www/html/xoops/2003\\\'s sum';
+---++-+---+
| instructor_id | link | charcter  | e_mail|
+---++-+---+
| KDC009| /var/www/html/xoops/2003's sum | Character's | [EMAIL PROTECTED] 
|
+---++-+---+

---

Note the three backslashes and the single backsplash (after the 2003)

I understood the first sample looks  for ...2003's and the second one for 
...2003\'s. or am I wrong ?


Best regards

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advanced text search

[Nils Valentin]

Hi Rudy,

I have to correct myself. I meant something like

...WHERE phone REGEXP '.+27-21-'


Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  15:39Nils Valentin :
 Hi Rudy,


 I believe you just forgot a dot here in front of the +:

 phone=.+27-21-*

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 13  15:25Rudi Ahlers :
  Hi
 
  I'm trying to search for some tables in a database, that contains only
  certain parts of info. I have about 3000+ records, and I'm looking for
  all the records that has +27-21, from my phone column, where the
  phone column contains phone numbers in the format of +27-21-564 7389
  or +27-11-661 9000
 
  My statement is as follows:
   select compid,company,phone from companies where (phone=+27-21-*);
  And it doesn't return any records. What am I doing wrong?
 
 
  Kind Regards
  Rudi Ahlers
  +27(82) 926 1689
 
  The basic difference between an ordinary man and a warrior is that a
  warrior takes everything as a challenge while an ordinary man takes
  everything either as a blessing or a curse.

 --
 ---
 Valentin Nils
 Internet Technology

  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reading table structure and data from sql file.

[Nils Valentin]

Hi Binary,

You could either make a new backup of only the table (see mysqldump manual).

mysqldump --help

Or you edit the backup file you have directly and save it under a new name and 
use it.


Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  03:13Binay Agarwal :
 Hi everybody,

I have backed(backup.sql) up one Mysql database which contains 10
 tables using mysqldump.

 Now I want to read just one table structure and it's data from backup.sql
 to another database. How do i achieve it.

 I have tried mysql databasename  backup.sql but it will populate the
 databasename with all the 10 tables present in backup.sql which i don want.

 Please help me out.

 Mysql verison : 3.23.52

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Joins and Unions

[Nils Valentin]

Hi Daniel and Kim,

Isn't 

 product_name product_category
 product_name product_category
 product_name product_category
 product_name product_category
 product_name product_category

the way its supposed to be ?

You are using the LEFT JOIN syntax, but actually using it just as a JOIN.

You could also use something like

SELECT * FROM products p, product_cat_join,product_category pc WHERE 
p.productID=pcj.productID AND pc.catID=pcj.catID;

if I remember that correctly. This does exactly the same as the LEFT JOIN 
above.

A LEFT JOIN is normally used to find records which exits in one table, BUT NOT 
in the other table.

So for example:

SELECT * FROM products p LEFT JOIN product_cat_join pcj ON
 p.productID=pcj.productID LEFT JOIN product_category pc ON
 pc.catID=pcj.catID WHERE pc.catID IS NULL


Anybody: Please correct me if I talk rubbish here ;-)


Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  13:[EMAIL PROTECTED] :
 he is getting the same problem as me as i explained

 i use joins left join and inner join

 SELECT * FROM products p LEFT JOIN product_cat_join pcj ON
 p.productID=pcj.productID LEFT JOIN product_category pc ON
 pc.catID=pcj.catID;

 products
 productID
 product

 product_cat_join
 joinID
 productID
 catID

 product_category
 catID
 product_category

 so say there are 5 records of a product category against a product it would
 result in

 product_name product_category
 product_name product_category
 product_name product_category
 product_name product_category
 product_name product_category

 instead of

 product_name product_category
  product_category
  product_category
  product_category
  product_category

  Hi Kim,
 
  no offense, but are you actually using the JOIN syntax correctly ?
 
  Could you post your query please ?
 
  My guess is you are doing a JOIN without any set conditions. hat would
  give  you the result as described (which is normal). You would use the
  WHERE clause  or for a LEFT JOIN ...the ON clause to filter to correct
  data which you are  requesting.
 
  Please have a look once more at the JOIN syntax:
 
  http://www.mysql.com/doc/en/JOIN.html
 
  Some examples:
 
  mysql SELECT * FROM table1,table2 WHERE table1.id=table2.id;
  mysql SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id;
  mysql SELECT * FROM table1 LEFT JOIN table2 USING (id);
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
 
  2003 8 13  09:25Kim Kohen
 
  :
  G'day all,
 
  I'm pretty new to MySQL and very new to v4.
 
  This is probably going to sound strange, but is it possible to create
  a union using the logic of a join?  I have 4 tables and I need to join
  data from them, but I'd like to display them like a Union. If I do a
  straight join, I get lots of multiple entries thus:
 
  PageAd_num  status  stories
  14312-T1308 Ad Complete 1-marchingband-A33Placed 1
  4312-T1308 Ad Complete 1-jobs-T33Placed 1
4312-T1308 Ad Complete 1-illegalbuild-A32  Placed 1
4312-T1308 Ad Complete 1-haldonstfesty-T33 Placed 1
  4312-T1308 Ad Complete 1-jobs-T33Corrected
  14312-T1308 Ad Complete 1-car crash-T33 Placed
 
  Where ad_num 14312-T1308 Ad Complete is replicated to
  accommodate all the Joined data from the  'stories' table
 
  What I'd like to see is something like this:
 
  14312-T1308  Ad Complete
  11-marchingband-A33Placed
  11-jobs-T33Placed
  11-jobs-T33Corrected
  11-illegalbuild-A32  Placed
  11-haldonstfesty-T33 Placed
  11-car crash-T33Placed
 
  Is this sort of thing possible?
 
  cheers
 
  kim
 
  --
  ---
  Valentin Nils
  Internet Technology
 
  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils
 
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
  http://lists.mysql.com/[EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Joins and Unions

[Nils Valentin]

Hi Daniel,

I am still not sure what exactly you are trying to achieve.

If you specify the WHERE condition correctly (or ON or USING for the LEFT 
JOIN) then there is no duplicate entry.

 I believe what you are asking has more  to do with the way how to present the 
data in the output.

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  14:[EMAIL PROTECTED] :
 well i'd like to join tables without duplicates, currently i cannot do this
 unless i select the category table in a second loop to list all the
 categories for that particular row/record

  Hi Daniel and Kim,
 
  Isn't
 
  product_name product_category
  product_name product_category
  product_name product_category
  product_name product_category
  product_name product_category
 
  the way its supposed to be ?
 
  You are using the LEFT JOIN syntax, but actually using it just as a
  JOIN.
 
  You could also use something like
 
  SELECT * FROM products p, product_cat_join,product_category pc WHERE
  p.productID=pcj.productID AND pc.catID=pcj.catID;
 
  if I remember that correctly. This does exactly the same as the LEFT
  JOIN  above.
 
  A LEFT JOIN is normally used to find records which exits in one table,
  BUT NOT  in the other table.
 
  So for example:
 
  SELECT * FROM products p LEFT JOIN product_cat_join pcj ON
  p.productID=pcj.productID LEFT JOIN product_category pc ON
  pc.catID=pcj.catID WHERE pc.catID IS NULL
 
 
  Anybody: Please correct me if I talk rubbish here ;-)
 
 
  Best regards
 
  Nils Valentin
  Tokyo/Japan
 
 
  2003 8 13  13:[EMAIL PROTECTED]
 
  :
  he is getting the same problem as me as i explained
 
  i use joins left join and inner join
 
  SELECT * FROM products p LEFT JOIN product_cat_join pcj ON
  p.productID=pcj.productID LEFT JOIN product_category pc ON
  pc.catID=pcj.catID;
 
  products
  productID
  product
 
  product_cat_join
  joinID
  productID
  catID
 
  product_category
  catID
  product_category
 
  so say there are 5 records of a product category against a product it
  would result in
 
  product_name product_category
  product_name product_category
  product_name product_category
  product_name product_category
  product_name product_category
 
  instead of
 
  product_name product_category
   product_category
   product_category
   product_category
   product_category
 
   Hi Kim,
  
   no offense, but are you actually using the JOIN syntax correctly ?
  
   Could you post your query please ?
  
   My guess is you are doing a JOIN without any set conditions. hat
   would give  you the result as described (which is normal). You would
   use the WHERE clause  or for a LEFT JOIN ...the ON clause to filter
   to correct data which you are  requesting.
  
   Please have a look once more at the JOIN syntax:
  
   http://www.mysql.com/doc/en/JOIN.html
  
   Some examples:
  
   mysql SELECT * FROM table1,table2 WHERE table1.id=table2.id;
   mysql SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id;
   mysql SELECT * FROM table1 LEFT JOIN table2 USING (id);
  
   Best regards
  
   Nils Valentin
   Tokyo/Japan
  
  
   2003 8 13 
09:25Kim Kohen
  
   :
   G'day all,
  
   I'm pretty new to MySQL and very new to v4.
  
   This is probably going to sound strange, but is it possible to
   create a union using the logic of a join?  I have 4 tables and I
   need to join data from them, but I'd like to display them like a
   Union. If I do a straight join, I get lots of multiple entries
   thus:
  
   PageAd_num  status  stories
   14312-T1308 Ad Complete 1-marchingband-A33Placed 1
   4312-T1308 Ad Complete 1-jobs-T33Placed
   1
 4312-T1308 Ad Complete 1-illegalbuild-A32  Placed
 1 4312-T1308 Ad Complete 1-haldonstfesty-T33 Placed 1
   4312-T1308 Ad Complete 1-jobs-T33
   Corrected 14312-T1308 Ad Complete 1-car crash-T33
 Placed
  
   Where ad_num 14312-T1308 Ad Complete is replicated to
   accommodate all the Joined data from the  'stories' table
  
   What I'd like to see is something like this:
  
   14312-T1308  Ad Complete
   11-marchingband-A33Placed
   11-jobs-T33Placed
   11-jobs-T33Corrected
   11-illegalbuild-A32  Placed
   11-haldonstfesty-T33 Placed
   11-car crash-T33Placed
  
   Is this sort of thing possible?
  
   cheers
  
   kim
  
   --
   ---
   Valentin Nils
   Internet Technology
  
   E-Mail: [EMAIL PROTECTED]
   URL: http://www.knowd.co.jp
   Personal URL: http://www.knowd.co.jp/staff/nils
  
  
   --
   MySQL General Mailing List
   For list archives: http://lists.mysql.com/mysql
   To unsubscribe:
   http://lists.mysql.com/[EMAIL PROTECTED]
 
  --
  ---
  Valentin Nils
  Internet Technology
 
  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http

Re: Joins and Unions

[Nils Valentin]

Hi Kim,

You can create a temporary table by using a table alias. The temporary table 
will only be accessable by the current connection. Any other connection will 
not be able to use it.

If you want to make a table which can be used by several connections (f.e for 
a join) you could create a HEAP table which  remains completely in the 
memory, but all data goes when the server crashes or powered off, the 
structure remains.


Best regards

Nils Valentin
Tokyo/Japan

2003 8 13  15:21:
 G'day Nils

  just send a reply a minute ago. I got it now. You want to change the way
  the data is presented at the screen and thats a different issue. You
  would have to make this in your apllication, not with mysql itself I
  believe. You basically want the DISTINCT function within the JOINS - but
  only applied for a certain column.
  Thats not possibe yet I believe.

 
 Ah, ok, now where getting somewhere:)

 I had already tried Distinct but as you say, it can't really work with the
 joins I have currently. I'm looking to see if it's possible to simply set
 the displayed columns (I'm using PHP) of the redundant stuff to .

 Which leads me to another question. I've never used temporary tables. Would
 it be possible for me to do a join and form a temporary table from it?  If
 that's possible, I could get all the data I need for a basic Union and I'd
 be happy - I think:)

 cheers

 Kim

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Joins and Unions

[Nils Valentin]

Hi Kim,

no offense, but are you actually using the JOIN syntax correctly ?

Could you post your query please ?

My guess is you are doing a JOIN without any set conditions. hat would give 
you the result as described (which is normal). You would use the WHERE clause 
or for a LEFT JOIN ...the ON clause to filter to correct data which you are 
requesting.

Please have a look once more at the JOIN syntax:

http://www.mysql.com/doc/en/JOIN.html

Some examples: 

mysql SELECT * FROM table1,table2 WHERE table1.id=table2.id;
mysql SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id;
mysql SELECT * FROM table1 LEFT JOIN table2 USING (id);

Best regards

Nils Valentin
Tokyo/Japan


2003 8 13  09:25Kim Kohen :
 G'day all,

 I'm pretty new to MySQL and very new to v4.

 This is probably going to sound strange, but is it possible to create a
 union using the logic of a join?  I have 4 tables and I need to join data
 from them, but I'd like to display them like a Union. If I do a straight
 join, I get lots of multiple entries thus:

 PageAd_num  status  stories
 14312-T1308 Ad Complete 1-marchingband-A33Placed
 14312-T1308 Ad Complete 1-jobs-T33Placed
 14312-T1308 Ad Complete 1-illegalbuild-A32  Placed
 14312-T1308 Ad Complete 1-haldonstfesty-T33 Placed
 14312-T1308 Ad Complete 1-jobs-T33Corrected
 14312-T1308 Ad Complete 1-car crash-T33 Placed

 Where ad_num 14312-T1308 Ad Complete is replicated to accommodate
 all the Joined data from the  'stories' table

 What I'd like to see is something like this:

 14312-T1308  Ad Complete
 11-marchingband-A33Placed
 11-jobs-T33Placed
 11-jobs-T33Corrected
 11-illegalbuild-A32  Placed
 11-haldonstfesty-T33 Placed
 11-car crash-T33Placed

 Is this sort of thing possible?

 cheers

 kim

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySql Control Center

[Nils Valentin]

Hi Ulises,

Is that option only available on a Windows MySQLCC ??
I didnt find it on the linux version.

Best regards

Nils Valentin
Tokyo/Japan 


2003 8 9  01:47Cabanillas Dulanto, Ulises 
:
 The option Automatically limit SELECT queries to  must be set in the
 Query Configuration Dialog.

 Regards,
 Ulises

 -Mensaje original-
 De: Trevor Morrison [mailto:[EMAIL PROTECTED]
 Enviado el: Viernes 8 de Agosto de 2003 09:36 AM
 Para: [EMAIL PROTECTED]
 Asunto: MySql Control Center


 Hi,

 I am new to using the Control Center-0.9.2-beta.  My problem is that I
 cannot seem to display more than 1000 rows in my result set when I know
 that there is 1534 rows.  I know that it is a setting somewhere, but is it
 in MySql or in the Control Center somewhere.  I am running this on a
 Windows 2000 machine.

 TIA

 Trevor

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: NT service starts, but I still have to start server manually.

[Nils Valentin]

Hi Tony,

First, as I just saw that everything is on C:\. In this case you wont even 
need the two settings basedir and datadir as far as my understanding goes.

I remember that after having registered the service itself  mysqld 
--install, I used the command net start mysql to start the service. I 
am not sure anymore if I had to go to the services and set it to automatic 
startup mode or not.

I have no Windows machine installed right now to quickly check it. Also I did 
this on Windows 2000, but I believe thats more or less the same ;-) - I hope 
nobody is flaming me for that statement. ;-)

Thats all really I can remember

1) mysqld --install
2) net start mysql
3) checking if the mysql servie is set to automatic startup in the services 
processlist.

I hope that this helps a bit. Le me know how it went.

Best regards

Nils Valentin
Tokyo/Japan



2003 8 11  19:50Tony Groves :
 Nils - Thanks for your response.

 Everything is on the C: drive, in the default locations.

 C:\winnt\my.ini consists of the following:
 [client]
 port=3306
 [mysqld]
 port=3306
 basedir = c:/mysql/
 datadir = c:/mysql/data/
 innodb_data_home_dir = c:/mysql/ibdata/
 innodb_log_group_home_dir = c:/mysql/iblogs/
 innodb_data_file_path = ibdata1:10M:autoextend
 set-variable = lower_case_table_names=0
 [WinMySQLAdmin]
 Server=C:/mysql/bin/mysqld-max-nt.exe
 All the file paths referred to there exist.

 The MySQL service runs using the system account, and uses the following
 ImagePath value:
 c:\mysql\bin\mysqld-max-nt.exe
 This is the same command that I use to start the server as an application.
 It is strange that the service starts but does not work, while an
 application program using the same command does work.

 Any more suggestions would be gratefully acepted.

 Thanks a lot.

 Tony Groves.

 - Original Message -
 From: Nils Valentin [EMAIL PROTECTED]
 To: Jason Kushmaul [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, August 11, 2003 9:52 AM
 Subject: Re: NT service starts, but I still have to start server manually.


 Hi Tony,

 Just out of interest. The NT installation itself and the MySQL server
 are both installed on the C:\ drive ?

 In case the MySQL server would be installed not on C:\ but f.e on E:\,
 then I would perhaps have a solution.

 In case the mysql server is installed in another drive (and only then),
 then you have to tell this to the MySQL server by setting the option
 --basedir or in the my.cnf file like

 [mysqld]
 basedir=E:/mysql


 But only then really.

 Another possibility would be that the installed service is pointing to
 the wrong location. I had this when I uninstalled the previous
 version,but forgot to unregister the service. The new installation was
 installed, but I did not get the service up and running, as it was
 pointing to the old installation (which was removed ;-)

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 11  16:58Jason Kushmaul :
  Is there a C:\my.cnf?  If not try copying a distributed
  my-medium,large,small.cnf it to C:\winnt\my.ini.  I had this problem on
  windows NT4, It seemed that everytime I created the file C:\my.cnf, it
  would get renamed to C:\my_cnf.bak, but no C:\my.cnf would exist.  I read
  somewhere that this happens when you do not have C:\winnt\my.ini.  It

 fixed

  my problem of mysql appearing to start, but it wasn't...
 
  - Original Message -
  From: Tony Groves [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Sunday, August 10, 2003 5:32 PM
  Subject: NT service starts, but I still have to start server manually.
 
   I have installed MySQL (latest version) on my Windows NT4 (SP6) machine
 
  and
 
   have started testing it. The MySQL service starts successfully at boot
 
  time
 
   as expected, but I can never connect to the database until I start the
   server manually - it makes no difference whether the service is already
   running or not, and whether it had been started automatically or
   manually.
  
   Any ideas, anybody?
  
  
   --
   MySQL Windows Mailing List
   For list archives: http://lists.mysql.com/win32
   To unsubscribe:
 
  http://lists.mysql.com/[EMAIL PROTECTED]

 --
 ---
 Valentin Nils
 Internet Technology

  E-Mail: [EMAIL PROTECTED]
  URL: http://www.knowd.co.jp
  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dropping primary key/unique key

[Nils Valentin]

Update:

2003 8 7  17:06Nils Valentin :
 [Warning: LNG TEXT - enjoy ;-)]

 Hi Victoria,

 sorry for the misunderstanding. I just tried to reproduce the sample. While
 I have records what I did I did not write down all commands exactly as they
 are.

 The problem(s) occured on Redhat 8 or 9 and Mysql server-max 4.0.13 (tar
 format) from mysql homepage. I had to reinstall a machine to reproduce the
 problem,this is why it took so long.


  First the original problem
 Redhat 9 + Mysql server-max 4.0.13 (tar format from mysql.com homepage)

Reproducable on Redhat 8 and Redhat 9 Table types tested :MyISAM and Innodb


 create table uksample2 (id int unique not null ,name char(30),tel
 char(20))type=innodb;
 Query OK, 0 rows affected (0.01 sec)

 mysql alter table uksample2 add primary key (tel);
 Query OK, 0 rows affected (0.04 sec)
 Records: 0  Duplicates: 0  Warnings: 0

 mysql desc uksample2;
 +---+--+--+-+-+---+

 | Field | Type | Null | Key | Default | Extra |

 +---+--+--+-+-+---+

 | id| int(11)  |  | UNI | 0   |   |
 | name  | char(30) | YES  | | NULL|   |
 | tel   | char(20) |  | PRI | |   |

 +---+--+--+-+-+---+
 3 rows in set (0.00 sec)

 mysql alter table uksample2 drop primary key;
 Query OK, 0 rows affected (0.03 sec)
 Records: 0  Duplicates: 0  Warnings: 0

 mysql desc uksample2;
 +---+--+--+-+-+---+

 | Field | Type | Null | Key | Default | Extra |

 +---+--+--+-+-+---+

 | id| int(11)  |  | | 0   |   |
 | name  | char(30) | YES  | | NULL|   |
 | tel   | char(20) |  | PRI | |   |

 +---+--+--+-+-+---+
 3 rows in set (0.00 sec)


 Unique key was dropped. Why not Primary key, why no error message???

 --
 2nd  example where it complains about that no two primary keys are
 allowed,but lets me create them first ;-) This time on Redhat 8.
 Redhat8 and 4.0.13 server-max (tar format from mysql.com homepage)

 create table uksample2 (id int unique not null auto_increment,name
 char(30),tel char(20));
 Query OK, 0 rows affected (0.01 sec)

 mysql desc uksample2;
 +---+--+--+-+-++

 | Field | Type | Null | Key | Default | Extra  |

 +---+--+--+-+-++

 | id| int(11)  |  | PRI | NULL| auto_increment |
 | name  | char(30) | YES  | | NULL||
 | tel   | char(20) | YES  | | NULL||

 +---+--+--+-+-++
 3 rows in set (0.00 sec)

 mysql alter table uksample2 add primary key (tel);
 Query OK, 0 rows affected (0.02 sec)
 Records: 0  Duplicates: 0  Warnings: 0

 mysql desc uksample2;
 +---+--+--+-+-++

 | Field | Type | Null | Key | Default | Extra  |

 +---+--+--+-+-++

 | id| int(11)  |  | UNI | NULL| auto_increment |
 | name  | char(30) | YES  | | NULL||
 | tel   | char(20) |  | PRI | ||

 +---+--+--+-+-++
 3 rows in set (0.00 sec)

 mysql alter table uksample2 drop primary key ;
 ERROR 1075: Incorrect table definition; There can only be one auto column
 and it must be defined as a key
 mysql alter table uksample2 drop primary key (id);

 Note that also alter table uksample2 drop index id; will give me the same
  error.

 -

 On a Suse Linux system 8.1 with mysql server max 4.1 -alpha (rpm format
 from mysql.com homepage) I get the below message, which I believe is
 correct.

 mysql create table uksample2 (id int unique not null auto_increment,name
 char(30),tel char(20));
 Query OK, 0 rows affected (0.07 sec)

 mysql alter table uksample2 add primary key (tel);
 ERROR 1171: All parts of a PRIMARY KEY must be NOT NULL;  If you need NULL
 in a key, use UNIQUE instead
 mysql drop table uksample2;
 Query OK, 0 rows affected (0.00 sec)



 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 6  19:22Victoria Reznichenko :
  Nils Valentin [EMAIL PROTECTED] wrote:
   Hi Victoria,
  
   Victoria Reznichenko wrote:
  Nils Valentin [EMAIL PROTECTED] wrote:
  I have a problem understanding why MySQL is deleting a unique key
   instead of a primary key.
  
  from Documentation: DROP PRIMARY KEY drops the primary index. If no
   such index exists, it drops the first UNIQUE index in the table.
  
  When I do it then I get this:
  
  mysql desc uksample4;
  +---+--+--+-+-+---+
  
  | Field | Type | Null | Key | Default | Extra |
  
  +---+--+--+-+-+---+
  
  | id| int(11)  |  | UNI | 0   |   |
  | name  | char(30) | YES  | | NULL

Re: column privilege problem--Solved

[Nils Valentin]

Hi Tiffany,

The Grant format for the Column privilege is a bit confusing ,bit here 
it goes:

GRANT privilege (column1,column2,  etc...) ON dbname.tblname TO 
'username'@'hostname' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

f.e
GRANT SELECT (student_id) ON training_db.student TO 
'columnuser'@'localhost' IDENTIFIED BY 'columnuser';

Best regards

Nils Valentin
Tokyo/Japan
Dathan Vance Pattishall wrote:

FYI
Note on this. Using column privs you take a performance penalty on reads
/ writes.
---Original Message-
--From: Tiffany Wilkes [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, August 05, 2003 3:48 PM
--To: mysql
--Subject: column privilege problem--Solved
--
--  I solved the problem--I needed ( ) around the column list.  I think
--the manual should make that more clear.
--
-- Original Message 
--Subject: column privilege problem
--Date: Tue, 05 Aug 2003 15:39:54 -0700
--From: Tiffany Wilkes [EMAIL PROTECTED]
--To: [EMAIL PROTECTED]
--
--
--
--Hi,
--
--I am having problems granting column privileges.  I want to grant the
--update privilege (only) to a column (called pass) in a table (called
--Acct).  Here's what I get:
--
--mysql grant update pass on practicedb.Acct to [EMAIL PROTECTED];
--ERROR 1064: You have an error in your SQL syntax near 'pass on
--practicedb.Acct to [EMAIL PROTECTED]' at line 1
--
--I don't understand how the syntax is wrong.  I think I followed the
--instructions in the manual.  I don't have any problems granting table
--privileges--just column.
--
--Tiffany Landry
--
--

--MySQL General Mailing List
--For list archives: http://lists.mysql.com/mysql
--To unsubscribe:
--http://lists.mysql.com/[EMAIL PROTECTED]
--
--
--
--
--

--MySQL General Mailing List
--For list archives: http://lists.mysql.com/mysql
--To unsubscribe:
--http://lists.mysql.com/[EMAIL PROTECTED]


 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Root

[Nils Valentin]

Hi there,

First shutdown the running server.

mysqladmin shutdown 
or
/etc/init.d/mysql.server stop
or
/etc/init.d/mysqld stop

(depending on your Linux distribution)


Then  restart the mysql server with option --skip-grant-tables like this.

safe_mysqld --skip-grant-tables

You can then login without password. And then you reset your password  with 
the update command like this:

UPDATE user SET password='' WHERE user='root';

Restart the server again.

Set a new password with mysqladmin like this:

mysqladmin -u root password xxx
mysqladmin -u root flush-privileges

(xxx is your new password)
That should be it.

Mysql has a nice manual by the way where it is all described detailed, comes 
in very handy to have such a print close, just in case ;-)

Best regards

Nils Valentin
Tokyo/Japan


2003 8 3  14:21FT :
 Hi everyone
 I am quiet new to DB and MySql
 I must have made a big mistake by changing the root @ localhost password
 via phpMyAdmin and now it is impossible to connect from neither the mysql
 prompt nor phpMyAdmin...

 Does anyone know how to recover this problem...I did try to reinstall MySql
 after uninstalling it and rebooted the server but no luck so far...

 Thanks for the hand

 Fabrice

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ansi characters in Fulltext search

[Nils Valentin]

Forgot to copy the list ;-)

Best regards

Nils Valentin
Tokyo/Japan

2003 8 4  07:45Nils Valentin :
 Hi Kevin,

 Correct me if I am wrong, but the sweddish character set is the default
 setting with mysql ;-).

 I was supposing that includes the most or all scandinavian characters.

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 3  22:47Kevin stmark :
  Does newer versions MySQL support words with Scandinavian letters like ,
  , , ,  etc in full-text searches? The server I'm on runs 3.23.53a. If
  so, from what version was it supported? And where can I find
  documentation on it? Can't find anything in the full-text manual..
 
  Best regards,
  Kevin stmark
  [EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Granting privileges

[Nils Valentin]

Hi Todd,


2003 8 4  08:01Todd Cary :
 Nils -

 What is the difference between *.*  and * ?
Hi Todd I just double checked.
There is no difference. Both work the same way. I originally thought that the 
first one wouldn't have worked, but I checked it now. However I believe that 
*.* is the prober syntax.


 Does Grant All give the user the rights to create a DB?

The below command allows the user todd all privileges (CREATE,INSERT,DELETE, 
UPDATE etc.) . The with grant option will also allow the user todd to 
create new users.

About the command itself, I just doule checked once more.

If you specify only the username then a wildcard is insert for the hostname 
(%) which allows the user todd to be able to login from anywhere. make sure 
thats what you really want !!

In any other case you could specify the user as '[EMAIL PROTECTED]' to limit it to 
only the one host.

Best regards

Nils Valentin
Tokyo/Japan




 Many thanks

 Todd

 Nils Valentin wrote:
 Hi Todd,
 
 try this
 
 grant all
 - on *.*
 - to todd indentified by 'my_password'
 - with grant option;
 
 
 I believe you forgot the .*  wich I added after grant all on...
 
 Best regards
 
 Nils Valentin
 Tokyo/Japan
 
 2003 8 4  01:52Todd Cary :
 I have installed Red Hat 9 and it installs MySQL.  After logging on as
 root, I did the following:
 
 mysql
 mysql use mysql;
 mysql grant all
 - on *
 - to todd indentified by 'my_password'
 - with grant option;
 
 I then log out of mysql and log out as root.  Logged in as todd I type
 the following:
 
 mysql -u todd -p
 
 I type in my password and I get the following error:
 
 Acess denied for [EMAIL PROTECTED]
 
 When I was in mysql as root, select * from user has todd listed.
 
 What have I missed?
 
 Todd

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Granting privileges

[Nils Valentin]

Hi Todd,


2003 8 4  08:17Todd Cary :
 Jamie -

 

 grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
 grant all;
 flush privileges;

Flush privileges is not necessary here I believe. Only when you update the 
privileges 'manually' with INSERT, UPDATE,DELETE

Best regards

Nils Valentin
Tokyo/Japan


 That definitely works, but what I am not sure about is now -u todd -h
 localhost has all Y in the privileges; before only the first few had Y.

 Why is that?  Is that due to the *.*?

 Todd

 Jamie Krasnoo wrote:
 You still need to flush the privileges. Changes in permissions are not
 automatically committed. Also you should add the host to the username.
 
 grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
 grant option;
 flush privileges;
 
 Jamie
 
 On Sun, 2003-08-03 at 09:52, Todd Cary wrote:
 I have installed Red Hat 9 and it installs MySQL.  After logging on as
 root, I did the following:
 
 mysql
 mysql use mysql;
 mysql grant all
 - on *
 - to todd indentified by 'my_password'
 - with grant option;
 
 I then log out of mysql and log out as root.  Logged in as todd I
 type the following:
 
 mysql -u todd -p
 
 I type in my password and I get the following error:
 
 Acess denied for [EMAIL PROTECTED]
 
 When I was in mysql as root, select * from user has todd listed.
 
 What have I missed?
 
 Todd
 --

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Root

[Nils Valentin]

Hi FT,

2003 8 4  09:24:
 Thanks Nils...good to have you around...in Tokyo
 This worked except for the UPDATE than was not recognized by MySql  3.23.36
 but strangely all previous tables were still there and it looks like it is
 running again.. still worry about this UPDATE command ..but I am back on
 phpMyAdmin 4.3.0 as root @ localhost
 How do I change this one or do I need to keep it

Well that depends if you use the account local  (login on the same machine the 
server is running ) or not.

See the Grant command and the usage of the mysql client for details. Here just 
a rough sample:

mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password'
 with grant option;

If the user doesn't need to create new users than you can leave with grant 
option.

Best regards
Nils Valentin
Tokyo/Japan

 

 Thanks
 - Original Message -
 From: Nils Valentin [EMAIL PROTECTED]
 To: FT [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Sunday, August 03, 2003 3:11 PM
 Subject: Re: Root


 Hi there,

 First shutdown the running server.

 mysqladmin shutdown
 or
 /etc/init.d/mysql.server stop
 or
 /etc/init.d/mysqld stop

 (depending on your Linux distribution)


 Then  restart the mysql server with option --skip-grant-tables like this.

 safe_mysqld --skip-grant-tables

 You can then login without password. And then you reset your password  with
 the update command like this:

 UPDATE user SET password='' WHERE user='root';

 Restart the server again.

 Set a new password with mysqladmin like this:

 mysqladmin -u root password xxx
 mysqladmin -u root flush-privileges

 (xxx is your new password)
 That should be it.

 Mysql has a nice manual by the way where it is all described detailed,
 comes in very handy to have such a print close, just in case ;-)

 Best regards

 Nils Valentin
 Tokyo/Japan

 2003 8 3  14:21FT :
  Hi everyone
  I am quiet new to DB and MySql
  I must have made a big mistake by changing the root @ localhost password
  via phpMyAdmin and now it is impossible to connect from neither the mysql
  prompt nor phpMyAdmin...
 
  Does anyone know how to recover this problem...I did try to reinstall

 MySql

  after uninstalling it and rebooted the server but no luck so far...
 
  Thanks for the hand
 
  Fabrice

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]