Re: start up problem

2002-04-29 Thread Steven Hajducko
The var dir is usually where the databases and logs go. At least, from the sources I've compiled, thats where it always gets stored. On Mon, 2002-04-29 at 10:03, Cindy wrote: OK, it seems like every time I install mysql, I run smack dab into some type of access problem -- if it isn't a

Re: start up problem

2002-04-29 Thread Steven Hajducko
Hey Cindy, Usually you can get a better idea of the real problem by looking in the hostname.err (where hostname is the hostname of your machine) file in whatever directory you are storing your logs in. Is there any info in that file that you can post? You can check to make sure another

Re: How to Install as non-root user in Unix system?

2002-04-23 Thread Steven Hajducko
I think the general procedure is the same, just a couple things you have to consider. 1. The mysql daemon will have to run under your user name. 2. You might not be able to use port 3306, you'll have to check with the sys admin for this. 3. You'll have to install it into your home directory (

Re: MyODBC

2002-04-17 Thread Steven Hajducko
Sounds like a user permission problem. Make sure you're allowed to connect from that ip. ( You can check in the 'user' table in the 'mysql' db. ) -- sh On Wed, 2002-04-17 at 09:34, Jim Bahr wrote: Hi Gang, Im trying to set my remote xp pc to connect to my server databases using MS Access.

Re: load data infile file location???

2002-04-12 Thread Steven Hajducko
Hey BJ, Can the mysql user actually get into that directory ('/home/user/directory')? If the mysql user can't read that directory, then it doesn't matter than it owns that file. You might want to check, do an 'su - mysql' ( replace mysql with whatever user is running the mysql daemon ), then

Re: Design decision on generating data

2002-04-12 Thread Steven Hajducko
Usually I build my queries dynamically. I store all the values into a hash ( this is in perl mind you.. ) Then do something like this.. my (@fields, @vals); my ($field_str, $val_str); foreach $field_name (keys %hash) { if ($hash{$field_name}) { push @fields,

Re: update question number in mysql

2002-04-12 Thread Steven Hajducko
On Fri, 2002-04-12 at 13:52, Christopher Thompson wrote: You shouldn't be storing the questio number at all. You have denormalised your database and this is why you are experiencing this problem. Maybe I don't understand bin's problem, but storing the question # wouldn't seem to be

Re: Converting VARCHAR 255 column to TEXT 64

2002-04-11 Thread Steven Hajducko
It'll expand the limit. You'll lose the data if you convert from a larger form back to a smaller one. ( Text to Varchar.. if the text is longer than 255. ) -- sh On Thu, 2002-04-11 at 12:09, Alex Pilson wrote: Does converting one type of column to a bigger type such as listed in my subject

Re: Access Denied

2002-04-11 Thread Steven Hajducko
Did you run the mysql_install_db? http://www.mysql.com/doc/P/o/Post-installation.html -- sh On Thu, 2002-04-11 at 13:53, Jane Tsai wrote: Hello, All: Once I complete the installation, I try to set up password for root user: /usr/bin/mysqladmin -u root -p password 'mypassword' It did

Re: change local hostname

2002-04-10 Thread Steven Hajducko
Ir. You got rid of localhost? :) D'oh! What kind of system is this running on? If it's a Unix type, what do you have in /etc/hosts? -- sh On Wed, 2002-04-10 at 19:19, Jule Slootbeek wrote: Hey, i just installed MySQL and i can't change anything since it's configured to search for

Mysql client question

2002-04-04 Thread Steven Hajducko
Alright, this may come across as a stupid question - In the mysql client, is there any way to get rid of the damn - sign when you are writing a query out? I ask because it'd make it alot easier to copy and paste the query back in, if lets say, I messed up on a single item. mysql create table

RE: Help. I have truly blundered.

2002-04-04 Thread Steven Hajducko
What do the contents of the ns1.acculock.com.err file look like? -- sh On Thu, 2002-04-04 at 14:45, john wrote: Yeah, I wish it were that easy. I have attempted to do so, and here is a transcription of my recent events to catch you up to me: ...and by the way thanks, john I was working

RE: Help. I have truly blundered.

2002-04-04 Thread Steven Hajducko
: Address already in use 020404 17:00:28 Do you already have another mysqld server running on port: 3306 ? 020404 17:00:28 Aborting mysqld ended on Thu Apr 4 17:00:28 CST 2002 mysqld ended on Thu Apr 4 17:21:00 CST 2002 John From: Steven Hajducko [mailto:[EMAIL PROTECTED]] What do

SQL join question

2002-04-03 Thread Steven Hajducko
Alright, I've got a little bit of a problem with this query. This is what the current query looks like ( I know I'm doing it wrong, I just don't know how to fix it.. I'm not that familiar with the LEFT JOIN/subquery stuff.. ) select cluster.cid, cluster.isp, cluster.country_id-20 as

Re: Error 2002:

2002-03-29 Thread Steven Hajducko
Hey Andy, mysql is the client connection program. mysqld is the actual mysql database daemon that runs. You might want to take a look at the error logs to see what it's actually complaining about. That, or go peek at the Mysql documentation first and read up on the actual install so you can

Re: Backups

2002-03-29 Thread Steven Hajducko
Personally I just tar up the data dir every hour and have a script to rotate the tar file ( up to 10 tar files.. ). There are some other utilities out there that are nicer tho. I can't remember them off the top of my head tho. -- sh On Fri, 2002-03-29 at 11:05, Tab Alleman wrote: What do you

Re: queries ( your help appreciated)

2002-03-28 Thread Steven Hajducko
Hey David. I think this is what you want? select * from table order by date_column ASC; ( for ascending order..) select * from table order by date_column DESC; ( for descending order..) Replace 'table' with the name of your table and date_column with the name of the column that contains the

Re: Repost

2002-03-28 Thread Steven Hajducko
Is there a master.info file somewhere? What's your my.cnf look like? If you want, you can email me the file and I'll be happy to try and help. -- sh On Thu, 2002-03-28 at 10:40, Jonathan Wilzig wrote: Sorry to repost. I got one answer and stumped the guy trying to help (thanks again btw).

Re: queries ( your help appreciated)

2002-03-28 Thread Steven Hajducko
D'oh. Forgot he wanted after now :) Thanks. On Thu, 2002-03-28 at 10:46, DL Neil wrote: David, Steven, I think this is what you want? select * from table order by date_column ASC; ( for ascending order..) select * from table order by date_column DESC; ( for descending order..)

Re: MYSQL REPLICATION

2002-03-28 Thread Steven Hajducko
Let's say A and B are running together. Then someone does a large update query and A is done with, while B is in the middle of it, and A crashes. You can switch over to B, which won't contain the data, but it'll have a good snapshot of what the data was before the crash. When you recover the A

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

2002-03-27 Thread Steven Hajducko
Hrm, I'll take a stab at it, since I've got replication working atm... Have you tried basic connectivity tests between the slave and master? ( Just making sure.. ie - can you telnet to port 3306 on the master, from the slave? ) Did you flush the privileges after adding the repl user? Here's my

Re: sum of a column

2002-03-27 Thread Steven Hajducko
select sum(col) from tab; On Wed, 2002-03-27 at 13:32, Aman Raheja wrote: Hi all How do I get the sum of all values in a column 'col' of a table 'tab' I am using CGI-Perl and mysql. Thank you. Aman _ Send and receive

Re: how to check if table exists?

2002-03-27 Thread Steven Hajducko
You can do a couple of things.. Are you using any other language besides SQL? ( perl, PHP? ) If you're just looking for a way to do it with sql.. you can try - show tables like tablename; It'll either give an empty set, or return the tablename. -- sh On Wed, 2002-03-27 at 14:29, Ken

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

2002-03-27 Thread Steven Hajducko
Leonard, What command are you using to start the slave server? I was thinking maybe it wasn't reading the correct configuration file? This one is pretty strange. Have you thought about upgrading the slave mysql version, just to disregard that it might be a problem between the two versions?

RSA encrypted strings - what data type?

2002-03-26 Thread Steven Hajducko
Hi, I'm new to the list and I joined because I couldn't figure out the answer to this problem. I'm trying to take a string ( In this case, a password ), and encrypt it with RSA encryption via the perl module, Crypt::RSA. Later on, I want to be able to pull the encrypted string back out and

Re: RSA encrypted strings - what data type?

2002-03-26 Thread Steven Hajducko
On Tue, 2002-03-26 at 14:35, Christopher Thompson wrote: On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote: I'm trying to take a string ( In this case, a password ), and encrypt it with RSA encryption via the perl module, Crypt::RSA. Later on, I want to be able to pull

Re: RSA encrypted strings - what data type?

2002-03-26 Thread Steven Hajducko
. Thanks for the help guys, Steve On Tue, 2002-03-26 at 14:35, Christopher Thompson wrote: On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote: I'm trying to take a string ( In this case, a password ), and encrypt it with RSA encryption via the perl module, Crypt::RSA. Later on, I want