RE: where i can write my script
Use TASK MANAGER in windows 98 It does what u wantjust run mysql scriptname; R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) 858-1028 (Home) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: Rubylinda F Otero [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 9:20 AM To: mysql mailing list Subject:where i can write my script i want to know where a can write my script in running and use mysql. recently i save in a file a two statement and it work what i expect to be done, i'm wondering what is the most easiest programming language could i use to write my script. for ur info i'm using win98 mysql 3.29.49 __ www.edsamail.com __ www.edsamail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
safe_mysqld only runs if I su to mysql first
this is weird. I have been running mysql 3.23.40 for a long time, no problems. I attempted an upgrade to 3.23.49, but mysql segfaults when I load safe_mysqld as uid root. my typical startup for mysql would be: /usr/local/mysql/bin/safe_mysqld --user=mysql -O key_buffer=128M -O table_cache=512 -O sort_buffer=32M -O record_buffer=10M (I have a bunch of other stuff too, but for this, I am only using the above command line, which doesn't work). btw this machine has 1GB of ram and 1GB of swap so there's plenty of memory for the buffers. even running with no options other then --user=mysql it segfaults. the .err file has some stack traces and stuff. but the REALLY weird thing, is if I su to mysql, and run that same command line it works fine. I am thinking it is a library problem, I had this error before a couple of months ago on 3.23.40 after I had upgraded libc6 (apt-get upgrade on debian), it was fixed by just recompiling mysql(I had the same source tree, I originally used, just did make clean ; make ; make install). it ran fine(and runs fine). I added /usr/local/mysql/lib/mysql to /etc/ld.so.conf and ran ldconfig, I added /usr/local/mysql/lib/mysql to $LD_LIBRARY_PATH and it still segfaults. for now I have it just running in su'd mode so one of the employees can run some tests to see if there is any difference over 3.23.40 for this one app we use. really weird the DB is fully functional from what I can see. I am not sure what is different by su'n to user mysql. if the .err file is required i can provide it, i would do it now but I overwrote it when i re-started it as user mysql and don't really want to shut the db down if my co worker is doing stuff on it. i can shut it down again later tonight though OS: Debian GNU/Linux 3.0 Kernel: 2.2.19+a few patches system runs a lot of other things such as openldap, apache, apache-ssl, and a bunch of stunnel processes for mysql and for openldap. system activity is pretty low though, my network doesn't have a lot of users. thanks for any pointers!! nate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Maximum JOINED tables
Hi. On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] wrote: [...] But... is this the only feature of mysql which is dependant on the processor architecture? See it the other way: You are not garantueed more than 31 tables in a join. If you happen to have a 64Bit architecture, you can use more. I'm kind of nervous about this, because I'm currently working on a 'very normalized' database schema, and it is possible I will need more than 31 tables in a single select... including multiple joins to the same tables, of course. It would be very bad if my design turned out to be 64-bit dependant... AFAIK, if you need so many tables, you get a major problem: MySQL figures out the best join order by trying all combinations. This becomes increasingly slow as you are going to join more tables. In other words: Trying to use 30 tables in one select probably will be too slow as that it would matter whether so many tables are allowed in a join or not. Of course, you could work around it by using STRAIGHT_JOIN, but I assume it is to cumbersome to figure out the optimal join order for all SELECTs. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sub-queries
Hi. On Fri 2002-06-07 at 01:55:18 +0200, [EMAIL PROTECTED] wrote: [...] Chris, sounds like you're looking for an exclusive left outer join. You want to see records from monitorhosts, where there is no corresponding record in monitorhostgroupdetails, right? Yes - and no. If a HostID 1, assigned to GroupID 1, 3, and 4, then I want to issue a query where I specify the GroupID to be 2, and HostID 1 must be returned. All the join statements I got so far, will only include the hostID if it is not in monitorhostgroupdetails AT ALL. Use: Select * from monitorhosts left join monitorhostgroupdetails on monitorhosts.HostID = monitorhostgroupdetails.HostID where monitorhostgroupdetails.HostID is null 1) I can't specify which GroupID I want to exclude, and I presume you refer to monitorhostgroupdetails.HostGroupID='1'? ON ... AND monitorhostgroupdetails.HostGroupID='1' WHERE 2) I can't limit the hostID on a CompanyID basis (only show hosts belonging to a certain company). WHERE ... AND monitorhosts.CompanyID = 5 3) This now, shows all the hosts that is not in a group at all. I need to specify which hostID, is NOT IN a GroupID. Isn't this only a variation of 1) ? I can't believe that this is so difficult ?!?!?!?!? No, it's probably not difficult at all. It simply seems as if people do not understand exactly what you want. A communication problem, IMHO. You already got some quite good pointer where to look at (LEFT JOIN, IS NULL, ...) and probably you just have to do some digging to figure out the correct query. Or else, write a more complete example (some sample data + result in a table form), which shows what you want. This prevents most ambiguities. The examples you provided earlier were hard to read (e.g. no column names) and provided to few rows to be unambigous. Or provide a sub-select that would do what you want. Just for completeness. The sub-query from your first post: SELECT monitorhosts.HostID FROM monitorhosts WHERE monitorhosts.HostID NOT IN ( SELECT HostID FROM monitorhostgroupdetails WHERE monitorhostgroupdetails.HostGroupID='1' ) is equivalent to SELECT mh.HostID FROM monitorhosts LEFT JOIN monitorhostsgroupdetails mhgd ON mhgd.HostID = mh.HostID AND mhgd.HostGroupID = 1 WHERE mhgd.HostID IS NULL (only adding your 1) to Kevin's query) Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stupid Q
Hoping someone can help me here: I've made a column using SET(y,n) NOT NULL - I want the default value in that column to be n, so if no data is entered for that column, it'd be n automatically. How do I do that? Not sure what to search for in the manual. Jason Soza filter fodder: sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A DB Design Question
I would like to set up a MySql database that will store distance information for a milage lookup program. The user will enter the origin city and the destination city for some predefined trips. Then the query will need to return the milage broken down by state. For example, for an origin city in NJ and a destination city in OH, the program would need to return how many miles were traveled within NJ, PA, and OH. It would be very inefficient to use one large table with columns for each state in the USA because most of them would be empty. A two table approach would use a primary table to store the origin, destination, and a unique reference key. While the secondary table would hold the reference key as a foreign key and a record for each state name and mileage. If anyone has had a similar design challenge I would appreciate hearing any comments you might have. Thanks -- Michael __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sub-queries
All sorted, thanks a million to Kevin Fries For archives purpose and anyone else that ever want to do anything like this... The query I was looking for apparently (Tested and working so far - I will test it a bit more later when I have more data in the tables): select monitorhosts.HostID, monitorhosts.HostDescription from monitorhosts left join monitorhostgroupdetails on monitorhosts.HostID = monitorhostgroupdetails.HostID AND monitorhostgroupdetails.HostGroupID = 2 where monitorhostgroupdetails.HostID is null AND monitorhosts.CompanyID='1'; Once again, my utmost thanks to Kevin for the solution This officially closes three days of headaches and sleepless nights... :-) No, it's probably not difficult at all. It simply seems as if people do not understand exactly what you want. A communication problem, IMHO. Kevin was also kind enough to point this out to me, and I have to agree with both of you. As I did explain to Kevin in private however, I do have very valid reasons for trying to expose as little as possible over the structures of the tables and the data that they contain. Perhaps a little greedy of me seeing that I am the one seeking the help here, but it paid off at long last. I'll try be more specific in future should any *serious* like problem come up in the future again. You already got some quite good pointer where to look at (LEFT JOIN, IS NULL, ...) and probably you just have to do some digging to figure out the correct query. I also have to admit... It was pointed out to me about two days ago that I would need to execute this query with a LEFT JOIN. Coming from a MSSQL background, and being used to simply using sub-queries, I did go and read the section in the manual about LEFT / RIGHT JOIN statements. After reading about three times a day, and still now after getting a query that works, I have to sadly admit, I understand absolutely 0% as to *why* this is working, or how it is working. At this stage, all that is importaint to me is that I got a solution to my direct problem - which is what I wanted. If anyone feel like taking 10 minutes of their time, and explaining exactly what the query does, I'll appreciate it allot. It may help me understand the basic logic behind the structure of the query, and aid me in the future when I may need to execute such queries again (although, I'm honestly hoping that when such a time comes, MySQL will support sub-queries). Or else, write a more complete example (some sample data + result in a table form), which shows what you want. This prevents most ambiguities. The examples you provided earlier were hard to read (e.g. no column names) and provided to few rows to be unambigous. Or provide a sub-select that would do what you want. Yes, and I'll admit that as a fault on my side. Table structures and some data was removed from the tables due to security concirns on my side. The data and structures removed was not relavent to the specific query however (tables / columns against which the query should be made), but I'll have to agree it did add to the confusion. Just for completeness. The sub-query from your first post: SELECT monitorhosts.HostID FROM monitorhosts WHERE monitorhosts.HostID NOT IN ( SELECT HostID FROM monitorhostgroupdetails WHERE monitorhostgroupdetails.HostGroupID='1' ) is equivalent to SELECT mh.HostID FROM monitorhosts LEFT JOIN monitorhostsgroupdetails mhgd ON mhgd.HostID = mh.HostID AND mhgd.HostGroupID = 1 WHERE mhgd.HostID IS NULL (only adding your 1) to Kevin's query) Yes, I see and understand that now as well. The original sub-query posted by me was incorrect. The query was originally posted to me via another member of the list, and seeing MySQL doesn't support sub-queries at all (I thought 3.23.49 might have had support), I was never able to test the query to confirm if it is working or not. However, a solution has been provided, it is working, and I am happy. Thanks to EVERYONE on here, as well as on the PHP-General mailing list for helping and trying to sort this out for me. I really do appreciate all the support, time and effort all of you guys put into this list. -- Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stupid Q
I'm talking under correction here, but SET('y'.'n') default 'n' NOT NULL - should work. I normally just do all this stuff via phpmyadmin, it works really great... -- me - Original Message - From: Jason Soza [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, June 07, 2002 5:06 AM Subject: Stupid Q Hoping someone can help me here: I've made a column using SET(y,n) NOT NULL - I want the default value in that column to be n, so if no data is entered for that column, it'd be n automatically. How do I do that? Not sure what to search for in the manual. Jason Soza filter fodder: sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unable to install mysql 3.23.49 on solaris-sparc 5.8
Hi, I'm new to this stuff. I first tried to install the binary distribution but it failed because of not finding libz.so, then I am trying to install with the source code, ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 make was okay, mesgs. were given about not finding libz.so but said it was okay and it could be linked later. but make install fails: /usr/local/gnu/bin/install -c test-ATIS /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/test-ATIS /usr/local/gnu/bin/install: `test-ATIS' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/test-ATIS' are the same file *** Error code 1 make: Fatal error: Command failed for target `install-benchSCRIPTS' Current working directory /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench *** Error code 1 make: Fatal error: Command failed for target `install-am' Current working directory /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench *** Error code 1 make: Fatal error: Command failed for target `install-recursive' I dont' have admin priveleges so I'm installing on my own partition, thus I can't even do: shell groupadd mysql shell useradd -g mysql mysql Is that the problem? Thanks, -Pushkar S. Pradhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help - newbie question....
i'm still going through the mysql documentation and am trying to jump ahead. i have written some perl based application. On NT it was easy to set up NTFS permissions on files for my security. the process for example is opening a new request ticket. While all the tickets are visible(that includes searching) world wide. new tickets need to be entered only by authorized personnel. I dont want to use web server authentication. i just want to mysql authenicate a user and them let him/her add a request into the DB. sample code is much appreciated. suggestions to alternate methods for implementation are very welcome. i'm Reading The Funny Manual so please dont flame me thank you for your time cheers prasanth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error in shared libraries
Hello all, I am having one application in which i am using mysql as database. When i run my application it gives following error. error:loading shared libraries libmysqlclient.so.10 (No such file or directory) I am having that library in /usr/lib/mysql/ Still it gives this error.Why is it so..? How to solve this problem? Thanks and regards, Charitha C. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error in shared libraries
It may be looking for the library in a different location, such as /usr/local/lib/mysql ldd application binary Should show you where exactly it is looking for the library, then you can try to symlink the library to that location. Alternatively, recompiling the application may also help. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 07, 2002 5:46 AM Subject: Error in shared libraries Hello all, I am having one application in which i am using mysql as database. When i run my application it gives following error. error:loading shared libraries libmysqlclient.so.10 (No such file or directory) I am having that library in /usr/lib/mysql/ Still it gives this error.Why is it so..? How to solve this problem? Thanks and regards, Charitha C. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to sort on multiple columns?
Hello All: I am using mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu on RH 7.2 I would like to sort on multiple columns, but Mysql tells my that the specified key would be too long (error 1071). If this is the case, what might be an alternative strategy? Specifically, here is an example table with description: describe CL0420; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | ID | int(11) | YES | | 0 | | | Producer | char(255) | YES | MUL | NULL| | | Varietal | char(255) | YES | MUL | NULL| | | Vineyard | char(255) | YES | MUL | NULL| | | Year | char(50)| YES | | NULL| | | Size | char(255) | YES | | NULL| | | Average | int(11) | YES | | 0 | | | Sold | smallint(6) | YES | | NULL| | +--+-+--+-+-+---+ I'd like to sort on Producer, Varietal, Vineyard (in that order) I would also appreciate being pointed towards appropriate documentation as well. Best Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to convert non latin characters?
This is a long response. I trimmed as much as I thought I could. Hmm. The short story is that you might want to invest some time going through the table by hand and editing the place names to a standard form. Note that I'm not going to suggest a standard form. Check Google. I suspect you'll want multiple sources. Explanation mixed in below. Hii there, I have a table containing cities of the world. Now I am running into problems because people are starting to complain that some mayor cities are not in the db like Tokyo. After checking my table I discovered that there lots of cities are written with some non latin characters. Tokyo is written like this: Tðkyð Well, it looks like my browser may not preserve those characters, so it may not be easy for lurkers to see what I'm talking about. (Got to learn how to use this new browser someday.) As someone mentioned, those characters were borrowed from an unrelated character set, probably on the whim of whoever wrote the stuff you got your lists from. The reason they borrowed unrelated characters may help you answer your question. I can't talk about other languages, but I can explain a little about Japanese. When writing Japanese with Latin characters (i. e., romanizing Japanese), one custom is to write an overscore on vowels that are doubled or lengthened. (There are other customs, as well.) For some reason, even the JIS character set does not contain vowels with overscores. So, I would assume that the non-Latin characters in this case are an attempt to indicate the lengthening of the vowels. (Both os are lengthened in Tokyo, which means it has four syllables when spoken in standard Japanese.) Another common custom is to simply repeat or transliterate, which would give you either Tookyoo or Toukyou, neither of which will be recognizable to anyone except (perhaps) a non-native resident of Japan, or a Japanese person with considerable experience in foreign countries. Another approach which I've seen would result in Tohkyoh which may be slightly more recognizable. Should, and if how, I convert this characters into latin ones. And what happens if somebody from Japan with a different keyboard tries to find Tokyo? As I said above, you will probably want to edit the names by hand to a standard form. But, the place where you got the lists may have a tool for filtering the names to a standard form. You might want to ask. I was going to say I wouldn't want to write such a tool myself, but it might not be so hard if you go country-by-country. Maybe. Depends on how consistent the authors were. Japanese has five vowels, a, i, u, e, and o. People don't usually do anything strange with the consonants, at least not in the last hundred years or so. But that doesn't help for Tibet or Myanmar, of course. Unicode is helping bring these sorts of tools a lot closer to reality. You can help, too, if you want. -- Joel Rees [EMAIL PROTECTED] sql, query filter fodder forgotten first time again - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error in shared libraries
or aalternatively, u can also do a echo $PATH and put the library in one of those path. eg: /usr/lib or someplave OR do PATH=$PATH:/usr/lib/mysql, if it work, put that command in your '.profile' so that it loads every time you log in. - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: Charitha [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 06, 2002 9:00 PM Subject: Re: Error in shared libraries It may be looking for the library in a different location, such as /usr/local/lib/mysql ldd application binary Should show you where exactly it is looking for the library, then you can try to symlink the library to that location. Alternatively, recompiling the application may also help. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 07, 2002 5:46 AM Subject: Error in shared libraries Hello all, I am having one application in which i am using mysql as database. When i run my application it gives following error. error:loading shared libraries libmysqlclient.so.10 (No such file or directory) I am having that library in /usr/lib/mysql/ Still it gives this error.Why is it so..? How to solve this problem? Thanks and regards, Charitha C. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: to_asci
Hello to you too. i need function that will convert non-english characters ($Bwzpz\boq (B to english. What were those? Can you give us some idea what the language (character encoding) and the values (code points) were? Some values in table contains non-english characters and i need search them. (via LIKE) In posgresql is function to_ascii. http://developer.postgresql.org/docs/postgres/functions-string.html At the bottom of the page, The to_ascii function supports conversion from LATIN1, LATIN2, WIN1250 (CP1250) only. I'm wondering if something like to_ascii() is really going to do what you want. I'm guessing you would prefer auxilliary fields or tables, but that is just my guess. -- Joel Rees [EMAIL PROTECTED] sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to sort on multiple columns?
describe CL0420; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | ID | int(11) | YES | | 0 | | | Producer | char(255) | YES | MUL | NULL| | | Varietal | char(255) | YES | MUL | NULL| | | Vineyard | char(255) | YES | MUL | NULL| | | Year | char(50)| YES | | NULL| | | Size | char(255) | YES | | NULL| | | Average | int(11) | YES | | 0 | | | Sold | smallint(6) | YES | | NULL| | +--+-+--+-+-+---+ I'd like to sort on Producer, Varietal, Vineyard (in that order) SELECT * FROM CL0420 ORDER BY Producer, Varietal, Vineyard; That *should* work ? query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error in shared libraries
Doesn't this need to be in ld's path? /etc/ld.conf ? I'm not to sure Not on *nix at the moment, but I believe the proper way to add it would be through /etc/ld.conf and running ldconfig to update the paths. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: [EMAIL PROTECTED] To: Charitha [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 07, 2002 9:14 AM Subject: Re: Error in shared libraries or aalternatively, u can also do a echo $PATH and put the library in one of those path. eg: /usr/lib or someplave OR do PATH=$PATH:/usr/lib/mysql, if it work, put that command in your '.profile' so that it loads every time you log in. - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: Charitha [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 06, 2002 9:00 PM Subject: Re: Error in shared libraries It may be looking for the library in a different location, such as /usr/local/lib/mysql ldd application binary Should show you where exactly it is looking for the library, then you can try to symlink the library to that location. Alternatively, recompiling the application may also help. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 07, 2002 5:46 AM Subject: Error in shared libraries Hello all, I am having one application in which i am using mysql as database. When i run my application it gives following error. error:loading shared libraries libmysqlclient.so.10 (No such file or directory) I am having that library in /usr/lib/mysql/ Still it gives this error.Why is it so..? How to solve this problem? Thanks and regards, Charitha C. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: to_asci
RANT, RAVE, SCREAM, MOAN, FLAME Now, that screwed up allot of MUAs!!! - Original Message - From: "Joel Rees" [EMAIL PROTECTED] To: "Dvoracek Michal" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 07, 2002 6:17 AM Subject: Re: to_asci Hello to you too. i query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHPMyAdmin Suggestion
I just installed PHPMyAdmin and it looks terrific. The only thing that it's missing is a Check Table on the selected tables. People could check to see if their tables are in good working order or are corrupted. They could specify what type of Check Table to perform (Quick, Extended etc.) By checking all the tables you could check everything in one go. I'm not sure why PHPMyAdmin is missing this. Or is it hidden away some where else and I haven't found it yet? (You wouldn't want to list each table in a Check Table query.) TIA Mike (I know I should be posting this to the PHPMyAdmin list but I don't have the energy to subscribe to yet another mailing list.g If anyone wants to post this on their list that would be fine.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please confirm your request to join ltsp-id
Hello [EMAIL PROTECTED], We have received your request to join the ltsp-id group hosted by Yahoo! Groups, a free, easy-to-use community service. This request will expire in 21 days. TO BECOME A MEMBER OF THE GROUP: 1) Go to the Yahoo! Groups site by clicking on this link: http://groups.yahoo.com/i?i=GFhFk5biYMiSFfoZXLaZ_0jzagQe=mysql%40lists%2Emysql%2Ecom (If clicking doesn't work, Cut and Paste the line above into your Web browser's address bar.) -OR- 2) REPLY to this email by clicking Reply and then Send in your email program If you did not request, or do not want, a membership in the ltsp-id group, please accept our apologies and ignore this message. Regards, Yahoo! Groups Customer Care Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to rotate replication logs
On Thu, Jun 06, 2002 at 10:03:54AM -0400, Dave Swindell wrote: What I'd like to do is to set up a mechanism where every week I rotate my replication log files and delete (or archive) the ones I no longer need. Can anyone point me to some docs where I can learn how to do this? Here's the Perl script we use... ---snip--- #!/usr/local/bin/perl -w # # $Source: /CVSROOT/yahoo/finance/mysql/bin/purge_binary_logs,v $ ## On a mysql server, purge the replication logs if there are too ## many sitting around and sucking up disk space. $|++; use strict; use RunMutex '/tmp/.write_heartbeat.lock'; use DBIx::DWIW; my $MIN_LOGS = 7; ## keep at least three binary logs around my $db = DBIx::DWIW-Connect( DB = mysql, User = root, Pass = secret, Host = 'localhost', ); if (not $db) { die Couldn't connect to database!; } my @logs = $db-FlatArray(SHOW MASTER LOGS); ## see if there are enough to bother if (@logs $MIN_LOGS) { exit; } ## if so, figure out what the last one we want to kee is my $last_log = $logs[-$MIN_LOGS]; print last log is $last_log\n unless $ENV{CRON}; ## and purge the rest $db-Execute(PURGE MASTER LOGS TO '$last_log'); exit; __END__ ---snip--- HTH, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 8 days, processed 192,694,624 queries (270/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB Hot Backups... ALL OR NOTHING ???
First of all, there are many aspects of your problem. 1. The InnoDB uses transaction safe table types, and uses the log files to restore if anything goes wrong during the tsanasction. So it is almost impossible to have a permanent database error, that cannot be repaired by InnoDB itself. If MySQL crashes, you just have to restart it, and InnoDB repaires automatically all the tables containing errors. 2. In spite of the first section, its a good idea to create backups of your InnoDB tablespace, because it can happen that the hard disk you have your tablespace files fails and in a case like this you don't have anything else, just your backup files. It's a little bit difficult to save all the InnoDB tablespaces onto another backup disk, because they can be very big, although they are compressable very well, because the empty spaces inside the tablespace contain zeros. A simple solution is not to backup directly the InnoDB tablespaces. Just convert the InnoDB tables into MyISAM and backup the MyISAM version of them. 3. The third aspect is that you can have many tablespaces, not only one big. For example instead of an InnoDB initialization command in my.cnf like this innodb_data_file_path = ibdata1:2000M you can use this innodb_data_file_path = ibdata1:200M;ibdata2:200M;ibdata3:200M;..ibdata10:200M Good luck, Daniel At 15:21 2002.06.06. -0600, you wrote: Can you backup/restore just one MySQL database with InnoDB hot backup? From what I gather it's an all or nothing proposition. As I understand it, there's only one tablespace (with any number of data files) and all database tables of type 'InnoDB' are comingled in the one tablespace. Therefore, if a single datafile becomes corrupt, all the databases with InnoDB type tables are down and you have to restore everything. Is that right? If so are there any plans to have multiple named tablespaces? We have a single server with 150+ databases (one for each hosted customer). If one customer database goes down then we can restore the MYISAM type tables without affecting the 24X7 availability for the other 149 customers. However, if we convert tables to type InnoDB and a data file is corrupted or lost, then all databases are down and we have to restore EVERYTHING. Is this correct? Sincere thanks in advance... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php