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 mysql.so
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 pa
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 ( che
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 Acce
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 de-norma
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, $fie
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 tr
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'
>
> I
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
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 local
ST 2002
> 020404 17:00:28 Can't start server: Bind on TCP/IP port: 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
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 worki
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
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
Country_
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 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 ge
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
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
> ord
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).
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 dat
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?
On
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 Anders
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
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
# prints "screwyou!"
print "$plaintext\n";
Mysql has no trouble keeping the binary version.
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 t
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 w
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 decr
27 matches
Mail list logo
