RE: automated character set conversions for tables

2007-01-17 Thread valentin_nils
Hello Jerry, Thanks for the reply. You are right. Thats why it finally took me 10-12 work hours to convert a single DB (split over two work days) to a UTF-8 compliant version. While it wasnt necessarily difficult to do (once you figured it out), it can put extra pressure on your eyes if y

automated character set conversions for tables

2007-01-09 Thread valentin_nils
Hello fellow MySQL friends, I recently had the "fun" to convert some 60 tables within a DB f.e. from latin1 to UTF8. I did a DB conversion before that with "ALTER DATABASE db_name CHARACTER SET utf8" That worked wonderfully, except not as expected. ;-) It basically converted only the datab

Re: Your message to MySQL AB (ID#863700)

2005-11-24 Thread valentin_nils
Dear George, THis is a public mailing list, not the MySQL sales channel;-). You may want to contact MySQL directly. Their contacts are written at their homepage http://www.mysql.org. Best regards Nils Valentin Quoting George Vanev <[EMAIL PROTECTED]>: Dear Sirs, This is my 3rd time I am w

Re: Innobase sold to Oracle ?

2005-10-13 Thread valentin_nils
Hi Doug, Thanks for the reply. That is more or less what I was thinking too. (especially the ANT rant ;-) I would be looking forward to read the paper in case its published one day. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com Quoting "Douglas K. Fischer" <[EMAIL PRO

Re: Innobase sold to Oracle ?

2005-10-13 Thread valentin_nils
What Oracle will do with Innobase is Oracle's matter, not much use in speculating about that IMO. Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED how the environment around Innobase / Innodb will change - and with it any support options and other impacts that might have

Innobase sold to Oracle ?

2005-10-12 Thread valentin_nils
Hi MySQL fans, I just read in the news about Innobase being sold to Oracle. Does anybody know whats going on with Innobase and what impact the selling out to Oracle might have on MySQL ? http://www.infoworld.com/article/05/10/12/HNnewmysql_1.html?source=rss&url=http://www.infoworld.com/article/05

Re: I forgot the admin password

2005-09-21 Thread valentin_nils
Martijn, sorry if I sounded perhaps unfriendly. That was not against you. Imagine that many people read the list (+20.000), some which read this which might take your word for granted and just do as you told ;-). I just wanted to clear that before it becomes practice. I understand that in an Mic

Re: I forgot the admin password

2005-09-21 Thread valentin_nils
Martijn, sorry if I sounded perhaps unfriendly. That was not against you. Imagine that many people read the list (+20.000), some which read this which might take your word for granted and just do as you told ;-). I just wanted to clear that before it becomes practice. I understand that in an Mic

Re: I forgot the admin password

2005-09-21 Thread valentin_nils
Martijn, > Uninstall, reinstall. That will not work !! MySQL doesnt delete an existing database. No offense, but you should have known better as professional. "--skip-grant-tables" is what the original user wanted to know. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com

Re: SQLyog Enterprise

2005-07-20 Thread valentin_nils
Hi Karam, I have seen you recommending SQLyog on the list for quite some time by now. May I ask, are you just a REALLY happy customer or otherwise somehow involved in the company which is producing it posting from your private e-mail ;-) ? Best regards Nils Valentin Tokyo / Japan http://www.be-k

Re: How do you become a MySQL DBA

2005-05-31 Thread valentin_nils
Hi Mark, (B (BThat is actually a very interesting question. (B (BI found the "Certification study guide" from Paul DuBois an indispensible (Bguide. (B (BOther then what you would expect from a "study guide" it does actually go (Bmuch further than just preparing you for an exam. (B (BYou w

Re: password is lose

2005-05-20 Thread valentin_nils
Hi Stone, no offense, but that one you should really be able to answer yourself > Hello all, > I'm having a bit of trouble:. > Welcome to phpMyAdmin 2.5.0-rc1 > > > Error > > MySQL said: > > > Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > > how can I find my password? Lo

Re: MySQL bottleneck

2005-04-16 Thread valentin_nils
Hi Wiley, I am still not sure if we are talking about 360k threats or clients, but I take your word from the first e-mail. basically I think its possible to setup a big DB (as Google, Yahoo etc. have shown already). About the hardware may I recommend 64 bit Opteron systems and scsi drives (array

Re: MySQL bottleneck

2005-04-16 Thread valentin_nils
Hello there, no offence but that questions is not answerable. I wouldnt expect many replies. Let me try to help you out by asking YOU a few questions which might point you into the correct direction: 1) Is the data entered once and than mostly read access or is it frequently updated ? 2) Do you

Re: book advice

2005-04-14 Thread valentin_nils
Hi David; I can recommend any Paul Dubois books but especially the Certificate study guide which basically is free if you consider taking the exam. The book comes with a 50$ voucher for the exam if I remmember that correctly + it is one of the best books to get up and running as fast as possibl

Re: license question

2005-03-30 Thread valentin_nils
Hi Pat, I thought that was discussed before over and over on this mailinglist. I am surprised that many people have isues with that topic. Basically it boils down to 2 questions. 1) Will you include and ditsribute the source code and the changes (if any) and the GPL license in your product ? If

Re: mysqlimport blocks all access to database

2005-03-27 Thread valentin_nils
Hi Joseph, > I have been trying to use mysqlimport to load a primarily read only database with data at regular intervals. My problem occurs when my tables are myisam. In this case all access to the database and the tables blocks until mysqlimport completes. The -lock-tables=false parameter does no

Re: Where do I get the Username?

2005-03-16 Thread valentin_nils
Hello Ed, I am nost sure what you are trying to say, but is it possible that you login as user "root" ? I assumed that you probably just installed mysql and are new to mysql. Best regards Nils Valentin > I know the password for MySQL Command line client so I can login and > create and modify

Re: MySQL license and GPL

2005-02-16 Thread valentin_nils
Hi Lotte, (B (BMySQL's dual License policu is very simple. If you use the GPL license (Bthan you have to show the source code (modified or not), and include the (BCopyright info when passing the code on. (B (BIf you dont want to do this (or in other words if you want to keep your (Bmodificat

Re: ut8 turkish character problem

2005-02-01 Thread valentin_nils
What does [Show VARIABLES LIKE "%char%" ;] return ? (B (BHow does the character look when selected on the command line ? (B --> If correct then inserting works fine (B --> If not corect check your character settings (B (BYou might also find the information below useful: (B (Bhttp://www.be-k

RE: list of error codes

2005-01-27 Thread valentin_nils
Hi Emmett, (B (BPlease try http://www.be-known-online.com/mysql/ (B (BNote that this error list is for the Linux version (parts differs for (Banother OS). More error descriptions can be found in the header files. (B(forgot currently which ones). If you search the forum for error codes and (B

RE: list of error codes

2005-01-27 Thread valentin_nils
http://www.be-known-online.com/mysql/ (B (BBest regards (B (BNils Valentin (B (B (B> [snip] (B> I looked around and didn't see documentation of MySQL error codes. I did (B> find a short list of INNODB codes but nothing comprehensive. Is there such (B> a (B> page? (B> [/snip] (B> (B> Y

Re: Mysql upgrade problem 3.23 to 4.1

2004-12-21 Thread valentin_nils
Hi Jerry, (B (B (BDid you read the documentation ? (B (BIt explains that you have to upgrade the mysql database wqith the (Bmysql_fix_privileges script. (B (B (BBest regards (B (BNils Valentin (BTokyo / Japan (B (Bhttp://www.be-known-online.com (B (B (B (B> I upgraded mysql mysql

Re: Debian package of MySQL 4.1

2004-12-14 Thread valentin_nils
Hi Ryan, (B (BJust making sure : (B (BIts not an issue with old style and new style passwords like between (Bversion 3.x and 4.1.x ? (B (B(I asume you did upgrade from an older version and did run the tables (Bupgrade script ) (B (BSoory for the insulting question, but this came straight

Re: MySQL support for AMD64

2004-11-30 Thread valentin_nils
Hi Lynn, (B (BIf you look in the archives you will find some strong recommendations (Bagianst RH and for Suse (performance reasons). (Look for "AMD 64 bit" or (B"perfomance") (B (BI am personally using Debian (sid) which you may not want to do for your (Bproduction ;-). Suse 9.2 unfortunatel

Re: Leasing time on a superfast mysql box

2004-09-30 Thread valentin_nils
I didnt seeing it making it to the list, so please allow me to resend it. (B (B (B (B (B Hi Mark, (B (B I have the parts for 4 Opteron systems here (Dual CPU machines) (B (B All Types 844 to 848 luying right in front of me. (B 2x Sata HDD (B 2x SCSI HDD (

Re: Leasing time on a superfast mysql box

2004-09-27 Thread valentin_nils
Hi Mark, (B (BI have the parts for 4 Opteron systems here (Dual CPU machines) (B (BAll Types 844 to 848 luying right in front of me. (B2x Sata HDD (B2x SCSI HDD (B6-12GB MEMORY (B (BI also have (B (BFedora Core 1 (BSuse Linux 9.0 (BTurbo Linux 8 (BMandrake 10 rc1 (BWindows 64 BETA (

Re: Problem with replication

2004-09-27 Thread valentin_nils
Hi Dana, (B (Bthe tool might be free for developers, but is it also Open source ?? (BDoes it solve the issues described by the threat owner ? (BIf not, can the owner easily adapt it to solve his problems with it ? (B (BI am just adding this question, to make it not look like your are (Bmissu

Re: Storing foreign characters in DB

2004-09-05 Thread valentin_nils
Hello Rhino, (B (BI am not sure how familiar you are with the character set settings. (B (BI am not using 3.xx versions anymore, but if I remember correctly they (Bonly allow a limited control for setting character sets. (B (BYour best guess might be the documentation that comes with your in

Re: Core Certification

2003-12-29 Thread valentin_nils
Hi Arjun, I have taken both exams (July and August 2002). The best advice I can give you is to get your hands on the Mysql Certificate study guide coming out in 2 months (from Paul Dubois). I had the chance to preview bits of it and I believe that it will be a VERY good help. Just read through it