http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150
On Nov 4, 2011 5:41 AM, "Satendra" wrote:
> Hi there,
> Could anybody suggest me to understand on which conf file (my.cnf) my
> server is readiing. how could I find that?
>
> On Fri, Nov 4, 2011 at 2:28 AM, Claudio Na
You can find which my.cnf your server is reading by using :
mysql --help
which displays something like this:
Default options are read from the following files in the given order:
C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf D:\Program
Files\MySQL\M
ySQL Server 5.5\my.ini D:\Program F
Hi there,
Could anybody suggest me to understand on which conf file (my.cnf) my
server is readiing. how could I find that?
On Fri, Nov 4, 2011 at 2:28 AM, Claudio Nanni wrote:
> All the previous hints are correct.
>
> I would also add: the arithmetic is only good for command line settings,
> som
All the previous hints are correct.
I would also add: the arithmetic is only good for command line settings,
something like:
max_allowed_packet = 16*1024*1024
is not valid in the my.cnf
max_allowed_packet = 16M
is the way to go in the my.cnf
Cheers
Claudio
2011/11/3 Michael Dykman
> If you
Thanks for the explanation.
LS
On Nov 3, 2011, at 4:41 PM, Dan Nelson wrote:
> In the last episode (Nov 03), List Man said:
>> I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I
>> attempted to change max packet with the following: SET GLOBAL
>> max_allowed_packet=16*10
If you changed the value in the .cnf and restarting the server did not pick
up he change, I would hazard a guess that the .cnf file you edited is not
the one your server is reading.
Check your paths and make sure you are editing the correct file. MySL
never rewrites it's own config files to refle
In the last episode (Nov 03), List Man said:
> I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I
> attempted to change max packet with the following: SET GLOBAL
> max_allowed_packet=16*1024*1024; but it did not work properly. The
> configuration did not change by using the
I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I
attempted to change max packet with the following: SET GLOBAL
max_allowed_packet=16*1024*1024; but it did not work properly. The
configuration did not change by using the show variables command. I changed
the configur
In the last episode (Nov 02), Nick Khamis said:
> Hello Everyone,
>
> I am looking to build just the mysql client, and not the entire server
> from source.
> Which cmake flags do I need to install just the mysql client/devel header
> files.
> The actualy mysql server is on a different machine.
T
- Original Message -
> From: "Adarsh Sharma"
> UPDATE website_master SET url= REPLACE( url,'"','');
Yep, that works fine, too, on condition that there are no quotes in the middle
of your value that need to remain where they are :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy
Thanks Johan,
I solved the problem by the below command :-
UPDATE website_master SET url= REPLACE( url,'"','');
Thanks
Johan De Meersman wrote:
- Original Message -
From: "Adarsh Sharma"
I need to remove the quotes in text columns in a mysql table. It has
You could go w
On 11/3/2011 02:29, Adarsh Sharma wrote:
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with ". I want to remove them.
Below is the snapshot :
*ID /URL Country Publication / Description ...and so o
- Original Message -
> From: "Adarsh Sharma"
>
> I need to remove the quotes in text columns in a mysql table. It has
You could go with regexes - s/^"(.*)"$/&1/ should do (in whatever syntax is
appropriate for the parser you're using); or you could go with something
similar to
upda
13 matches
Mail list logo