Hello All.

Is it possible to setup two instances of MySQL under windows? I am
wondering because I would like to setup and test replication

Thanks
Charles

This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CNFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.

Hi,

AFAWK, if you modify any of the variables in the .cnf, obviously have to
restart mysql. no other go.
To transmit between client and server you need to configure both the client
and the server. Through .cnf you are configuring the server variable and
for client you can go for either mysql or mysqldump.

shellmysql
or using
mysqlset @@SESSIN.max_allowed_packet=32M;
mysqlshow variables like "max%";

Thanks
ViSolve DB Team.
Message
From: "abhishek jain" <mail (AT) ejain (DOT) com>
To: <mysql (AT) lists (DOT) mysql.com>
Sent: Monday, February 05, 2007 11:37 AM
Subject: Re: max_allowed_packet in my.ini

2/3/07, abhishek jain <mail (AT) ejain (DOT) comwrote:
>>
>Hi friends,
>I am using mysql 5.0.23-nt on windows, i have to store large binary data
>in database, i have used setting like max_allowed_packet=16M in mysqld
>section of my.ini .
>Now i have a poblem that i want to create a setup so that the entry gets
>added itself into the my,ini , reason being i need to create many setups
>on
>diff. machine and i do not want to search the mysqld section and write
>the
>line and restart mysql . I can however would like to do via mysqladmin or
>so
>if it is possible as i can invoke that via mine .net program
>>
>Would appreciate your comments on this,
>Thanks .
>Abhishek jain
>>
>
Hi Friends.
Pl. reply,
Thanks,
Abhishek jain

In the last episode (Feb 05), abhishek jain said:
2/3/07, abhishek jain <mail (AT) ejain (DOT) comwrote:
>I am using mysql 5.0.23-nt on windows, i have to store large binary data
>in database, i have used setting like max_allowed_packet=16M in mysqld
>section of my.ini .
>Now i have a poblem that i want to create a setup so that the entry gets
>added itself into the my,ini , reason being i need to create many setups on
>diff. machine and i do not want to search the mysqld section and write the
>line and restart mysql . I can however would like to do via mysqladmin or
>so
>if it is possible as i can invoke that via mine .net program
>
>Would appreciate your comments on this,

Hi Friends.
Pl. reply,

Sorry; there is no way to change the config file from within mysql. If
you really can't modify the config file, you could just raise the value
temporarily from your client before you run your large queries:

SET SESSIN max_allowed_packet = 16*1024*1024;

Hello All.

Is it possible to setup two instances of MySQL under windows? I am
wondering because I would like to setup and test replication

Thanks
Charles

This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CNFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.

Don't store binary data in large blobs - You should instead chunk your
data for better performance and no packet limitation issues.

Good implementation article at:

Mon, 5 Feb 2007, abhishek jain wrote:

2/3/07, abhishek jain <mail (AT) ejain (DOT) comwrote:

Hi friends,
I am using mysql 5.0.23-nt on windows, i have to store large binary data
in database, i have used setting like max_allowed_packet=16M in mysqld
section of my.ini .
Now i have a poblem that i want to create a setup so that the entry gets
added itself into the my,ini , reason being i need to create many setups on
diff. machine and i do not want to search the mysqld section and write the
line and restart mysql . I can however would like to do via mysqladmin or so
if it is possible as i can invoke that via mine .net program

Would appreciate your comments on this,
Thanks .
Abhishek jain
--
Hi Friends.
Pl. reply,
Thanks,
Abhishek jain

2/5/07, Brown, Charles <CBrown (AT) bmi (DOT) comwrote:
Is it possible to setup two instances of MySQL under windows? I am
wondering because I would like to setup and test replication

Yes, theoretically you can, it should follow the same way of having
two mysql servers running, you just have to give them different TCP
ports to listen