Re: Maximum number of simulatneous connections

[venkata ramana]

On Fri, 11 Jun 2004 13:16:12 +0200, Alberto Mucignat <[EMAIL PROTECTED]> wrote:
> 
> 
> venkata ramana wrote:
> 
> >Hi,
> >   What is the maximum number of simulataneous connections
> >that can exist for MySQL. Can we change this limit? If yes please tell
> >me how to do this. I am using MySQL4.1 in Linux.
> >
> >Thanks,
> >ramana.
> >
> >
> 
> look at max_connections in my.cnf
> 
I couldn't find any entry with that name(max_connections) in
/etc/my.conf.  Is this the file you are talking about or is there any
other?

thanks,
ramana

> bye
> 
> a
> 
> --
> "Imagination is more important than knowledge"
> 
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Maximum number of simulatneous connections

[venkata ramana]

Hi,
   What is the maximum number of simulataneous connections
that can exist for MySQL. Can we change this limit? If yes please tell
me how to do this. I am using MySQL4.1 in Linux.

Thanks,
ramana.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

php to mysql

[venkata ramana]

Hi,
   I don't know whether I can ask this question on this mailing
list or not, but I want to know how the php communicates with mysql,
when it is on the localhost. Does it use unix domain sockets or it
uses TCP sockets only? Any help or pointers in this regard will be of
great help for me.

Thanks,
ramana.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: problem restoring backup made from mysqlhotcopy

[venkata ramana]

On Tue, 1 Jun 2004 18:33:53 -0700 (PDT), Abuzar Chaudhary
<[EMAIL PROTECTED]> wrote:
> 
> Aye, wish the documentation said something to that effect, it only said
> to restore it, simply copy the files back, without any examples or
> further explanation.
> 
> Okay, so I'm not very good at linux, how do I stop and start the server
> without messing up how it starts or stops when the server is booted or
> shutdown?  i.e. is it like Apache where "apache stop", and "apache
> start" kind of commands will do the job?
login as superuser and try

service mysqld stop
servive mysqld start

If your system complains that service command not found try
/sbin/service mysqld stop
/sbin/service mysqld start

> 
> Thanx :)
> Abuzar
> 
> 
> 
> --- gerald_clark <[EMAIL PROTECTED]> wrote:
> > Don't EVER copy  to database files while the server is running.
> > This is a guaranteed way to crash your database files.
> >
> > Shutdown the server.
> > Copy the files.
> > Start the server.
> >
> > Abuzar Chaudhary wrote:
> >
> > >Hi,
> > >
> > >Using a sample database, I have tablea and tableb. I populate tablea
> > >with some records and I can see the tablea.MYD file size increase on
> > >the drive, while tableb.MYD remains at zero bytes.
> > >
> > >Then I make a backup:
> > >mysqlhotcopy -u username -p password sample ./backup
> > >
> > >Next I modify the database:
> > >I delete the records from tablea and insert records in tableb and
> > >observe tableb file size increase on the drive, then I remove the
> > >sample directory inside /var/lib/mysql which contains the sample
> > >database
> > >
> > >Now I restore it like this:
> > >mv backup/sample .
> > >
> > >and I see the tableb.MYD file get adjusted back to zero, as it was
> > >before the modification, yet when I look at the database through
> > mysql
> > >and through mysqlcc, it still shows the modified database!
> > >
> > >Anyone know why it isn't restoring to the original backup ?!?
> > >
> > >Thanx,
> > >
> > >Abuzar ([EMAIL PROTECTED])
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >__
> > >Do you Yahoo!?
> > >Friends.  Fun.  Try the all-new Yahoo! Messenger.
> > >http://messenger.yahoo.com/
> > >
> > >
> > >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> 
> __
> Do you Yahoo!?
> Friends.  Fun.  Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]