RE: where i can write my script

2002-06-06 Thread RBRoa
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

safe_mysqld only runs if I su to mysql first

2002-06-06 Thread nate
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

Re: Maximum JOINED tables

2002-06-06 Thread Benjamin Pflugmann
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

Re: sub-queries

2002-06-06 Thread Benjamin Pflugmann
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

Stupid Q

2002-06-06 Thread Jason Soza
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

A DB Design Question

2002-06-06 Thread Michael Ivanyo
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

Re: sub-queries

2002-06-06 Thread Chris Knipe
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,

Re: Stupid Q

2002-06-06 Thread Chris Knipe
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

unable to install mysql 3.23.49 on solaris-sparc 5.8

2002-06-06 Thread Pushkar Pradhan
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

help - newbie question....

2002-06-06 Thread Prasanth Mudundi
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

Error in shared libraries

2002-06-06 Thread Charitha
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

Re: Error in shared libraries

2002-06-06 Thread Chris Knipe
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.

How to sort on multiple columns?

2002-06-06 Thread Tim Johnson
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?

Re: How to convert non latin characters?

2002-06-06 Thread Joel Rees
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

Re: Error in shared libraries

2002-06-06 Thread bvyas3
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

Re: to_asci

2002-06-06 Thread Joel Rees
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

Re: How to sort on multiple columns?

2002-06-06 Thread Chris Knipe
describe CL0420; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | ID | int(11) | YES | | 0 | | | Producer | char(255) | YES |

Re: Error in shared libraries

2002-06-06 Thread Chris Knipe
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

Re: to_asci

2002-06-06 Thread Chris Knipe
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

PHPMyAdmin Suggestion

2002-06-06 Thread mos
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

Please confirm your request to join ltsp-id

2002-06-06 Thread Yahoo! Groups
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:

Re: How to rotate replication logs

2002-06-06 Thread Jeremy Zawodny
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

Re: InnoDB Hot Backups... ALL OR NOTHING ???

2002-06-06 Thread Kiss Dániel
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

<    1   2