RE: automated character set conversions for tables
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 you have to concentrate on the screen all the time ;-). If somebody knows of a smart tool that is doing the hart work feel free to speak ;-) Best regards Nils Valentin Quoting Jerry Schwartz [EMAIL PROTECTED]: Columns can have character set definitions, also. In this case, I hope not. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 10:59 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: automated character set conversions for tables 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 database itself. so I had to do a separate ALTER TABLE ... for each table. The database encoding more establishes the default to use when creating new tables. As far as adjusting every single table, you can work with your Favorite Scripting Program (tm) and run the query: `SHOW TABLES` to get a list of all tables for that database (the column you want is called Tables_in_[database name here]), which you can get the exact column by running it in console or your Favorite SQL Program (tm). Then simply loop over the result set and run the alter table command on each table. -- 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]
automated character set conversions for tables
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 database itself. so I had to do a separate ALTER TABLE ... for each table. Are you aware of a much smarter way to do this ? (perhaps a function I missed, script, batch file etc.) Best regards 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: Your message to MySQL AB (ID#863700)
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 writing to you. May be there is a problem! We want to buy some MySQL 5.0 licenses. What happens after 1 year expires - do we have to buy another licences or not?! Also we want to upgrade from 4.1.18. Do we need a license for this purpose?! Best Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innobase sold to Oracle ?
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=rssurl=http://www.infoworld.com/article/05/10/12/HNnewmysql_1.html http://www.itmedia.co.jp/news/articles/0510/08/news012.html (ja) Best regards Nils Valentin Tokyo / Japan http://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: Innobase sold to Oracle ?
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 for our company or any of our customers. I can understand however, if you dont want this to be discussed on this mailing list ;-). Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com Quoting Joerg Bruehe [EMAIL PROTECTED]: Hi Valentin, all! [EMAIL PROTECTED] wrote: Hi MySQL fans, I just read in the news about Innobase being sold to Oracle. Correct. Does anybody know whats going on with Innobase and what impact the selling out to Oracle might have on MySQL ? What Oracle will do with Innobase is Oracle's matter, not much use in speculating about that IMO. Impact on MySQL: Very little, if any - see here: http://www.mysql.com/news-and-events/news/article_968.html In other words: MySQL has the rights to use, publish, and support InnoDB as a table handler, and will do so. No change for users. Regards, J?rg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innobase sold to Oracle ?
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 PROTECTED]: [EMAIL PROTECTED] wrote: speculating about that IMO. What Oracle will do with Innobase is Oracle's matter, not much use in 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 for our company or any of our customers. I of course cannot speak for MySQL or any of the other affected parties, but I have been very interested in this issue as we have many high-profile clients who are going to start asking the same kinds of questions very soon. As such, I have tried to be on top of this as much as possible and will share what I believe: Short-term, there is no real impact. MySQL and Innobase have an existing contract that runs (approximately - don't know the exact date) through the end of next year. As such, the existing terms will stay in place through then at the minimum. The only potential impact before then would involve the level of participation in Innobase employees with troubleshooting, patching, and new InnoDB features. However, from what I have heard third-hand, Heikki is continuing to assist as before. All in all, I do not believe any MySQL customers have anything to be concerned with before the end of next year. I agree that at this point in time, it is impossible to tell exactly what Oracle may or may not do with InnoDB. The exact terms of the purchase of Innobase have not been disclosed, so it is unknown if they are going to just acquire the rights to InnoDB and send Innobase employees packing, if they are going to employ the Innobase employees, if they are going to continue active development of InnoDB, etc. Any guesses or statements by anyone other than upper management at Oracle is mere speculation. I can come up with a number of possible scenarios, but none of them result in a dead in the water situation for any MySQL customers. Also, there are a number of things MySQL can do to hedge their bets against any decision Oracle may make regarding the future disposition of InnoDB. My advice is to not worry too much about the Oracle situation for now. Give MySQL some time to work through their options and let the MySQL-Oracle relationship do what it may. I have started working on an internal whitepaper to discuss the situation without all the FUD some journalists and some other DB companies (think ANTs) have started throwing around and to present a list of what I believe to be the most likely outcomes based upon what is publicly known and what options exist for MySQL and Oracle to take in this matter. Depending upon what information may be out by then and on whether or not I can get permission from upper management to release this paper into the open, I would be willing to share my analysis openly. I certainly understand the concerns that people have with this development, but it is truly too early to make a knowledgable call - to do so would be akin to speculating the World Series winner on opening day. Cheers, Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I forgot the admin password
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 With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- 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: I forgot the admin password
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 Microsoft environment it is usual practice to reinstall software when the original cause cant be find. Unfortunately that is poor practice. If feasable, it is important to understand what the original cause is and how to stop it, rather than fixing around it. Reinstalling an This time its perhaps not REAL data but when disaster strikes, often there is not much time to learn how it should have been done - mostly that means it is already to late. Its important to learn how to do it proberly with test data BEFORE disaster strikes. O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace ;-) Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com 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. Well, given that the OP only said I installed it a few weeks ago and now I want to start practicing , it doesn't really matter... Just reinstall it and you're fresh to go, right? NO! depending on how the Luis installed MySQL in the first place (which method was used), the uninstaller may not remove or overwrite the mysql.user table rendering this exercise fruitless as well as being overkill. I understand you work with many databases other than MySQL and for some of them the only way to recover from a lost admin password would be to remove/replace/restore. However, in this case Valentin was correct. Right -- perhaps I should have mentioned: uninstall and delete everything :-) Done that a couple of times myself... I understand that Valentin is correct for the normal approach, especially when you have a running server and/or databases. I kinda figured, the fastest way (without having to search for an e-mail list), would be just to reinstall the thing. MySQL - on Windows - has a very nice install these days, kudos for that. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I forgot the admin password
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 Microsoft environment it is usual practice to reinstall software when the original cause cant be find. Unfortunately that is poor practice. If feasable, it is important to understand what the original cause is and how to stop it, rather than fixing around it. Reinstalling an application, probably deleting the database would be a last desperate step for me personally. This time its perhaps not REAL data but when disaster strikes, often there is not much time to learn how it should have been done - mostly that means it is already to late. Its important to learn how to do it proberly with test data BEFORE disaster strikes. O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace ;-) Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com 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. Well, given that the OP only said I installed it a few weeks ago and now I want to start practicing , it doesn't really matter... Just reinstall it and you're fresh to go, right? NO! depending on how the Luis installed MySQL in the first place (which method was used), the uninstaller may not remove or overwrite the mysql.user table rendering this exercise fruitless as well as being overkill. I understand you work with many databases other than MySQL and for some of them the only way to recover from a lost admin password would be to remove/replace/restore. However, in this case Valentin was correct. Right -- perhaps I should have mentioned: uninstall and delete everything :-) Done that a couple of times myself... I understand that Valentin is correct for the normal approach, especially when you have a running server and/or databases. I kinda figured, the fastest way (without having to search for an e-mail list), would be just to reinstall the thing. MySQL - on Windows - has a very nice install these days, kudos for that. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQLyog Enterprise
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-known-online.com Hello, I find SQLyog Enterprise an indispensable tool. Your $49 will be saved within the first 3 days of use because of improved productivity with MySQL. Karam --- Scott Hamm [EMAIL PROTECTED] wrote: I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical) for personal use. Do anyone use it and how does it fare in your opinion? -- Power to people, Linux is here. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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: How do you become a MySQL DBA
Hi Mark, That is actually a very interesting question. I found the "Certification study guide" from Paul DuBois an indispensible guide. Other then what you would expect from a "study guide" it does actually go much further than just preparing you for an exam. You will get a whole lot of new ideas how to use and administrate your db. I am not sure, if the current version of the book still contains the 50$ discount exam voucher (which would basically oay for the book if you would be going to take an exam ;-) If you ned to spend the bugs of your company, why dont you opt for a support contract directly from MySQL. That asures you that you have support right when you need it. The MySQL mailing list is a great way to ask questions and get them answered generally in a matter of minutes, however the managers in your company may feel better when they can get assigned their personal MySQL staff. I hope that this gives you an idea. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com/mysql Here's an odd question for you, how do you become a MySQL DBA? I've got enough Solaris/Linux Experience under my belt and I was a Jr. Oracle DBA for a year, which got me really interested in RDBMS. I try to work with MySQL as much as possible, but I work with one of those large telco's that does not like anything where they can't pay large amounts of money. This means I have to work it into my spare time. I've been trying to tie MySQL into basic services: ftp, DSPAM, pop3, AND offer help for what we do have: running backups and repairing the odd table when needed. But the question is, what else could I do to help develope DBA skills? Right now I have very little data that goes beyond 2 tables, so my query skills are withering. mediis a t gmail d o t com -- 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: password is lose
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? Look carefully at the command prompt what you typed to lo into the mysql server or the GUI which you used. Hint: Did you specify a password for the login ? Hope that makes things clearer. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com Thanks as always! -Stone.wang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL bottleneck
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). Performancewise you have many options to stretch MySQLs legs. - Merge table format (for non transactions) - Raid options included in MySQL - Replication - Cluster Filesystem from MySQL - A REAL Cluster One thing that surprise me is that you obviously dont use transactions. Note that your data may corrupt not repairable if you dont take any precautions. Anyway, may I suggest 2 books to get you started quickly. MySQL Certification study guide from Paul DuBois High Performance MySQL from Zawodny You will probably need more info or books later, but that should get you up to speed within a few weeks. I trust that you have 2-10 boxes near you to get started and see how well that system scales. About posting: Just make Sure you create a new Subject line when starting a new threat or topic. That should do the trick and nobody gets confused. I hope that you find this information useful. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com So is karma :) From: sol beach [EMAIL PROTECTED] Reply-To: sol beach [EMAIL PROTECTED] To: B Wiley Snyder [EMAIL PROTECTED] Subject: Re: MySQL bottleneck Date: Sat, 16 Apr 2005 20:56:08 -0700 Incompetence is its own reward. Simply put, 360K is NOT a big number or DB given today's hardware. On 4/16/05, B Wiley Snyder [EMAIL PROTECTED] wrote: Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I do that ! Sorry From: [EMAIL PROTECTED] To: B Wiley Snyder [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: MySQL bottleneck Date: Sun, 17 Apr 2005 01:21:36 - (UTC) 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 need transaction support ? 3) Do you need the data to be EASY transferable between different OS (MAC/WIN/Unix/Linux) ? BTW: You posted into another thread (which is not good). I suggest you think about the above questions and start a new topic again. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com Hello there, let's say I have 365,000 users I need to enter their data, pull from it and modify it regularly. Is MySql the way to go ? Or do I need to buy an oracle or ms server ? thanks in advance for a clue From: [EMAIL PROTECTED] To: B Wiley Snyder [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: How to retain Key order when Deleting a Row Date: Tue, 12 Apr 2005 14:48:54 -0400 B Wiley Snyder [EMAIL PROTECTED] wrote on 04/11/2005 10:38:12 PM: Hello experts, I just need someone to please point me in the right direction on retaining my key or id order in my table when I delete a row. So for example I have 10 rows Id 1-10 that are created automatically when the record is inserted. So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but 1,2,3,4,5,6,7,8,9 ??? thanks _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ It sounds like you are confusing a data storage requirement (a unique, non-repeating identifier for every row) with a presentation requirement (a neatly numbered list of records). If I need a nicely ordered list of numbers, I use my programming language to provide it. If I need to uniquely identify a record, I use the ID. When an ID has been issued, it generally stays used even if that record no longer exists. Shawn Green Database Administrator Unimin Corporation - Spruce Pine _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- 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] _ Express yourself instantly with MSN Messenger! Download today - it's FREE!
Re: MySQL bottleneck
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 need transaction support ? 3) Do you need the data to be EASY transferable between different OS (MAC/WIN/Unix/Linux) ? BTW: You posted into another thread (which is not good). I suggest you think about the above questions and start a new topic again. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com Hello there, let's say I have 365,000 users I need to enter their data, pull from it and modify it regularly. Is MySql the way to go ? Or do I need to buy an oracle or ms server ? thanks in advance for a clue From: [EMAIL PROTECTED] To: B Wiley Snyder [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: How to retain Key order when Deleting a Row Date: Tue, 12 Apr 2005 14:48:54 -0400 B Wiley Snyder [EMAIL PROTECTED] wrote on 04/11/2005 10:38:12 PM: Hello experts, I just need someone to please point me in the right direction on retaining my key or id order in my table when I delete a row. So for example I have 10 rows Id 1-10 that are created automatically when the record is inserted. So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but 1,2,3,4,5,6,7,8,9 ??? thanks _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ It sounds like you are confusing a data storage requirement (a unique, non-repeating identifier for every row) with a presentation requirement (a neatly numbered list of records). If I need a nicely ordered list of numbers, I use my programming language to provide it. If I need to uniquely identify a record, I use the ID. When an ID has been issued, it generally stays used even if that record no longer exists. Shawn Green Database Administrator Unimin Corporation - Spruce Pine _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- 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: book advice
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 possible. Best regards Nils Valentin Tokyo / Japan www.be-known-online.com Hi, I'm a newbie and looking for a book to help me learn mysql. I have come across a book called Beginning MySQL by Robert Sheldon and Geoff Moes. Can anyone recommend this book? Or, if not, what book can you recommend for a newbie. David -- 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: license question
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 yes, than you DONT need a commercial license. if NO, (in other words you dont want to publish any changes you made to the code) then you need a commercial license. 2) Are you selling the product or a service ? If you are trying to sell the customer the very same MySQL product for $$ that he can download, then you must be good at sales, no questions asked. If you are selling a service (Consulting, Installation and setup etc. than you also dont need a commercial license ( + same as under 1 applies). Summary: You only need the commercial license if you change the code and want to distribute it as closed source. You can however at any time make a support contract or buy a commercial license to show your gratitude for the MySQL guys. That is usually a nice gesture, gets you support and backup when you need it and last but not least makes you feel good (peace of mind ;-). I hope that makes things clearer. Nils Valentin Tokyo / Japan http://www.be-known-online.com Suppose i distribute MySQL-4.1 with an appliance, which is a sealed x86 machine running a Linux distribution made by another entity (ok, it's Red Hat). I don't write any code that's directly linked to MySQL, I'm only using the existing php-mysql, etc., packages already provided by the distribution, plus some third-party apps that are under GPL and link to MySQL (applications that access MySQL, not written by me, but are Open Source GPL projects off SourceForge and other places - i just bundle them with the appliance). Any code that I write personally is PHP and sits on top of the php-mysql module provided by Red Hat. The end-user has no direct visibility to the database, in fact, the end-user might never know it's MySQL - all that is visible is the PHP interface, via Apache. In this case, what's the license? Is MySQL still free (under GPL)? -- Pat Ballard __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- 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: mysqlimport blocks all access to database
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 not help. Is this the normal operation? If not how can I still have concurrent read access to the database while mysqlimport is running? Correct me if I am wrong, but the write request has privilege. So ANY read request is queued until the write request finishes. Otherwise you would get inconsistent read results. Am I correct assuming that you are appending the imported data to the existing data in the database ? 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: Where do I get the Username?
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 dbs etc. I am trying to create a MySQL datasource in coldfusion with the MySQL (3.x) driver. It is asking me for the username, is there any way to find that out from MySQL Command line client or is there a file in the mysql folder on my pc? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL license and GPL
Hi Lotte, MySQL's dual License policu is very simple. If you use the GPL license than you have to show the source code (modified or not), and include the Copyright info when passing the code on. If you dont want to do this (or in other words if you want to keep your modifications hidden) than you need a commercial license. So if you use mysql within your commercial product and sell it as a package and want to hide how/if you modified or improved the mysql source code than you will need the commercial license. Does that make sense ? Best regards Nils Valentin Tokyo / Japan Hello, My understanding of the GPL license is that if you link your own software with GPL-licensed software, then the GPL forces you to release the whole thing under GPL. I am a bit confused that MySQL seems to require that even stand-alone applications are released as open source. Does MySQL have a more strict interpretation of the GPL? Or is the license on the MySQL GPL + more terms? Or? BR Lotte -- 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: ut8 turkish character problem
What does [Show VARIABLES LIKE "%char%" ;] return ? How does the character look when selected on the command line ? -- If correct then inserting works fine -- If not corect check your character settings You might also find the information below useful: http://www.be-known-online.com/mysql/ (Using_MySQL_in_a_Japanese_environment (380KB PDF)) http://dev.mysql.com/doc/mysql/en/charset.html Best regards Nils Valentin Tokyo / Japan I have mysql-4.1.9 installed. I am trying to insert and select turkish characters. My tables are utf8. I tried everything but not succesfull. turkish characters returns to "?" or crops on turkish character. "example: insert: Bing?, select: Bing" What is the secret of inserting turkish characters. I tried things like; SET NAMES 'utf8'; SET CHARACTER SET 'utf8'; But nothing solved problem. If anoybody knows how to insert and select turkish characters please help. PS. I tried using myODBC 2.5, 3.51.* all 3.51 versions but i got same result on all versions of myodbc. Also I tried with ASP and ASP.NET -- 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: list of error codes
http://www.be-known-online.com/mysql/ Best regards Nils Valentin [snip] I looked around and didn't see documentation of MySQL error codes. I did find a short list of INNODB codes but nothing comprehensive. Is there such a page? [/snip] You can use perror to find out want a mysql errno means. http://dev.mysql.com/doc/mysql/en/perror.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- 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: list of error codes
Hi Emmett, Please try http://www.be-known-online.com/mysql/ Note that this error list is for the Linux version (parts differs for another OS). More error descriptions can be found in the header files. (forgot currently which ones). If you search the forum for error codes and my name than you will find the info (roughly a year+ old) perror (the way I remember it) will only cover a limited scope of the errors (ca.10%) Best regards Nils Valentin [snip] I looked around and didn't see documentation of MySQL error codes. I did find a short list of INNODB codes but nothing comprehensive. Is there such a page? [/snip] You can use perror to find out want a mysql errno means. http://dev.mysql.com/doc/mysql/en/perror.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- 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: Mysql upgrade problem 3.23 to 4.1
Hi Jerry, Did you read the documentation ? It explains that you have to upgrade the mysql database wqith the mysql_fix_privileges script. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com I upgraded mysql mysql-3.23.58-1 to mysql4.1 In mysql-3.23 ( I have this field) password | varbinary(45) | YES | | NULL | I inserted data into this field as password('pass'). I have php script that checks if login valid. mysql-3.23 and mysql-4.1 have identical data. It worked on mysql-3.23 but doesn't work on mysql4.1. Password don't match. Any ideas why? -- 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: Debian package of MySQL 4.1
Hi Ryan, Just making sure : Its not an issue with old style and new style passwords like between version 3.x and 4.1.x ? (I asume you did upgrade from an older version and did run the tables upgrade script ) Soory for the insulting question, but this came straight into my head when I read your question, especially as you said you could set the root password. Actually, I would need much more detail to really troubleshoot your problem, but its an educated geuss what I am doing here ;-) Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com Hello all: I am running Debian woody and am using the Debian package for MySQL 4.1. I am trying to set the root password but nothing appears to work. Apparently I managed to set it but now I cannot login with what I set it to. So I have followed the directions to reset a root password (start MySQL with --skip-grant-tables and use mysqladmin to reset the password). I have been using MySQL for a couple of years and this method has always worked. Has anybody else encountered this problem with the Debian MySQL 4.1 package? It is 'experimental', after all. And yes, I would much rather use the Debian package than install a MySQL binary, for a number of reasons. Thanks, Ryan -- 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: MySQL support for AMD64
Hi Lynn, If you look in the archives you will find some strong recommendations agianst RH and for Suse (performance reasons). (Look for "AMD 64 bit" or "perfomance") I am personally using Debian (sid) which you may not want to do for your production ;-). Suse 9.2 unfortunately seems to be quite buggy (mostly obvious things) That starts with the installation itself. http://www.be-known-online.com/ http://www.be-known-online.com/modules/newbb/viewforum.php?forum=46 Shows some of my personal notes. Dont expect anything spectacular. Anyway I hope that you may find the info useful. BTW I am not running anything near Terabyte operations. Best regards Nils Valentin Tokyo/ Japan I just received a box with the following specs: Dual AMD64 8G ram Two 3ware 2.4 terabyte RAID 5 arrays. My company has been using Redhat for most of its production machines. 1. Does anyone have any success/horror stories running MySQL 4.0.x on RHES 3/ AMD64? 2. Does anyone have alternate recommendations for running MySQL databases in the terabyte range on AMD64? Thanks Lynn Bender UnsubCentral Secure Email List Suppression Management Neutral. Bonded. Trusted. You are receiving this commercial email from a representative of UnsubCentral, Inc. 13171 Pond Springs Road, Austin, TX 78729 Toll Free: 800.589.0445 To cease all communication with UnsubCentral, visit http://www.unsubcentral.com/unsubscribe or send an email to [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: Leasing time on a superfast mysql box
I didnt seeing it making it to the list, so please allow me to resend it. Hi Mark, I have the parts for 4 Opteron systems here (Dual CPU machines) All Types 844 to 848 luying right in front of me. 2x Sata HDD 2x SCSI HDD 6-12GB MEMORY I also have Fedora Core 1 Suse Linux 9.0 Turbo Linux 8 Mandrake 10 rc1 Windows 64 BETA What I am currently figuring out is how to get the SiL 3114 driver installed. I already spend a week (without success). http://www.be-known-online.com/modules/newbb/viewforum.php?forum=46 http://www.be-known-online.com/modules/newbb/viewtopic.php?topic_id=214forum=46 I give myself max another week before its up and running (I have to do it besides my real job). I would be using a dynamic dns connection unless you will afford a static IP (30$ /month). Following the Opteron discussions closely I would recommend Suse Linux. If this could be of interest than please contact me privately and let me know your requirements. The servers will be based in Tokyo/Japan. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com/mysql I have a large database of zip codes with longitude and latitude of each, and I periodically generate a lookup table for each zip showing all zip codes within various radii. The process takes a day on my poor workstations 2.5GHz CPU, but I need to do it faster. Does anyone know of somewhere I can borrow or lease some time on a very fast mysql server to do this? All I need is mysql and perl on the machine. All processing including the trig is done by mysql. Thanks, Mark -- 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: Problem with replication
Hi Dana, the tool might be free for developers, but is it also Open source ?? Does it solve the issues described by the threat owner ? If not, can the owner easily adapt it to solve his problems with it ? I am just adding this question, to make it not look like your are missusing the mailing list to just advertise your product and we get some real usable info here. Best regards Nils Valentin Tokyo /Japan On Mon, Sep 27, 2004 at 10:43:53AM -0400, Dana Henderson wrote: My name is Dana Henderson. I am from IT-Map. A My SQL Migration Technology Partner. We have announced in this months MySQL Newsletter(Partners Corner) That you can get a fantastic, mature MySQL database toolkit for your company for free. http://www.it-map.com/html/mydbpal_.html dbPAL can be downloaded at www.it-map.com. This will help for migration, conversion, replication, database documentation, etl and change management. Go ahead and try it out then let me know what you think. Does it solve this problem? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- 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: Leasing time on a superfast mysql box
Hi Mark, I have the parts for 4 Opteron systems here (Dual CPU machines) All Types 844 to 848 luying right in front of me. 2x Sata HDD 2x SCSI HDD 6-12GB MEMORY I also have Fedora Core 1 Suse Linux 9.0 Turbo Linux 8 Mandrake 10 rc1 Windows 64 BETA What I am currently figuring out is how to get the SiL 3114 driver installed. I already spend a week (without success). http://www.be-known-online.com/modules/newbb/viewforum.php?forum=46 http://www.be-known-online.com/modules/newbb/viewtopic.php?topic_id=214forum=46 I give myself max another week before its up and running (I have to do it besides my real job). I would be using a dynamic dns connection unless you will afford a static IP (30$ /month). Following the Opteron discussions closely I would recommend Suse Linux. If this could be of interest than please contact me privately and let me know your requirements. The servers will be based in Tokyo/Japan. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com/mysql I have a large database of zip codes with longitude and latitude of each, and I periodically generate a lookup table for each zip showing all zip codes within various radii. The process takes a day on my poor workstations 2.5GHz CPU, but I need to do it faster. Does anyone know of somewhere I can borrow or lease some time on a very fast mysql server to do this? All I need is mysql and perl on the machine. All processing including the trig is done by mysql. Thanks, Mark -- 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: Storing foreign characters in DB
Hello Rhino, I am not sure how familiar you are with the character set settings. I am not using 3.xx versions anymore, but if I remember correctly they only allow a limited control for setting character sets. Your best guess might be the documentation that comes with your installation. (Man pages, Info, Chapter 11 of the MySQL docs. etc.) You can view it also online http://dev.mysql.com/doc/mysql/en/Charset.html but as this is the newest version, you will have to filter out what doesnt apply to your version yet. In order to be able to give you any advice you need to be more specific. Which character sets are set now for the server and the client as default ? Are the "foreign characters" in the same character set ? Are you attempting to store the "foreign character" together with your default characters in the same table / same DB ? You may also read through my presentation "Using MySQL in a Japanese environment" which can be found here http://www.be-known-online.com/mysql I am not sure if this really helps you, as I dont yet fully understand were to start trouble shooting. If you could be a bit more specific that would help a lot. best regards Nils Valentin Tokyo/Japan - Original Message - From: "MySQL" [EMAIL PROTECTED] To: "MySQL" [EMAIL PROTECTED] Sent: Sunday, September 05, 2004 2:05 AM Subject: Storing foreign characters in DB I'm having a problem figuring out how to deal with foreign characters in text that was copied from an MS Word document and pasted into a form field, then stored in a MySQL DB. (I have MySQL 3.23.58 running). I'm not how sure how these characters are being stored in the MySQL database, but, when I retrieve the text and run it through PHP's htmlentities() function, each foreign character is converted into 2 other foreign characters that don't at all represent the original. For example, a lowercase u with an umlat over it (? is somehow displayed as an uppercase A with an umlat over it followed by the 1/4 symbol after parsed by htmlentities(). A lowercase o with an ulmat displays as an uppercase A with an umlat over it followed by the paragraph symbol. It seems that the uppercase A w/umlat is a constant, and the next character changes. How are these foreign characters being stored in the DB? Do I need to do something in order to store these characters properly, or is this something I need to somehow do on the PHP side of things?? -- Have you looked at the manual, particularly the Localization and International Usage section at http://dev.mysql.com/doc/mysql/en/Localisation.html? Have you tried the MySQL archives (http://lists.mysql.com/) where this matter has been discussed? Rhino -- 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: Core Certification
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 carefully and playaround with the system at the same time to practice the read things. The exam which I was taking was beta at that time. It was hard but fair I felt. Take your time when reading the guide question the details mentioned (or not) in the book to get a really good grasp of the subject. Thats the best you can do, do get into the exam relaxed and without any unneccesary pressure. Best regards Nils Valentin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 28, 2003 4:51 AM Subject: Core Certification Hello everybody ! I have question regarding the MySQL core certification. Does anybody have any general insights on taking the exam ? I am studying from the manual, but I am pretty nervous about the exam as I don't know how much in depth the questions will be or even if studying from the manual alone will be sufficient. I would appreciate any thoughts or comments from anyone about the exam.Thanks ! -- 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]