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
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
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 (
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.
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
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,
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
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
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
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
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
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
: 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
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
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
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
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
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).
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..)
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
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
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
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
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?
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
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
.
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
27 matches
Mail list logo