Thanks a lot Andrew.
- Original Message -
From:
To: ;
Sent: Thursday, October 07, 2010 3:07 AM
Subject: RE: my.ini
Open you're my.ini and correct the values as stated in the event viewer
Check the online documentation for the keys and values to set.
http://dev.mysql.com/doc/r
Open you're my.ini and correct the values as stated in the event viewer
Check the online documentation for the keys and values to set.
http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html
Regards
-Original Message-
From: ext Elim PDT [mailto:e...@pdtnetworks.net]
I recently upgraded mysql from 5.1.9-beta to 5.1.50
Since I used the custom data dir path, my upgrade is basically a replacement
of the bin folder and I used the old my.ini file that pointing the data dir
to the right path.
Then I found, in the event viewer, two warnings:
(1
ese commands as follows But it
> did
> not work.What I want is to specify a configuration file which is placed in
> the WINDOWS directory.The commands I ran
> C:\>NET STOP MySQL
> C:\>mysqld-nt --remove
> C:\>mysqld-nt --install MYSQL "--defaults-file=\"c:\WINDO
L
C:\>mysqld-nt --remove
C:\>mysqld-nt --install MYSQL "--defaults-file=\"c:\WINDOWS\my.ini\""
Service successfully installed.
C:\>net start mysql
System error 2 has occurred.
The system cannot find the file specified.
Why is the file not able to be found, I ha
Varuna,
obviously it doesn't make much sense, to specify the my.ini location
in my.ini itself.
The "--defaults-file" option is used as a direct start-up parameter
for mysql-server both, run as service or console-process.
It simply tells the server-process where to look for the on
Varuna Seneviratna schrieb:
I added a line to the [mysqld) group
As --defaults-file="C:\WINDOWS\my.ini" and then I restarted the
service.Everything was fine.Then I took out the my.ini file in the MySQL
instalation directory the result was an error message AS
Could Not start the MyS
I added a line to the [mysqld) group
As --defaults-file="C:\WINDOWS\my.ini" and then I restarted the
service.Everything was fine.Then I took out the my.ini file in the MySQL
instalation directory the result was an error message AS
Could Not start the MySQL Service on Local Computer
use of innodb tables. There is no my.cnf or my.ini file and the command to
start MySQL is:
/Applications/MAMP/Library/bin/mysqld_safe --port=8889
--socket=/Applications/MAMP/tmp/mysql/mysql.sock --lower_case_table_names=0
--pid-file=/Applications/MAMP/tmp/mysql/mysql.pid
--log-error=/Applications
L PROTECTED]> wrote:
> >
> > 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
In the last episode (Feb 05), abhishek jain said:
> On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wrote:
> >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 o
ruary 05, 2007 11:37 AM
Subject: Re: max_allowed_packet in my.ini
On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wrote:
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.
On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wrote:
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 th
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
>> It may not be. Do you specify this file when you start the server on
>> the command line? If you don't then you need to move my.ini to the
>>windows directory:
You are quite right. When I moved the my.ini file to c:\windows it worked.
I assumed that it would work &
Adam Lipscombe wrote:
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
Adam Lipscombe wrote:
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
extended-status is
Hello.
>I use my.ini in MySQL install directory
On Windows, MySQL programs reads startup options from the following files:
WINDIR\my.ini
C:\my.cnf
Use --defaults-file=/path/ command line option to specify exact location
of my.ini file.
Zimoo <[EMAIL PROTECTED]&
Hello.
Put this string into [client] section of my.ini.
Zimoo <[EMAIL PROTECTED]> wrote:
> Hello Gleb,
>
> Sunday, December 19, 2004, 10:02:58 PM, you wrote:
>
>> Also you can put in your [client] section of my.cnf something like:
>> default_character
Hello Gleb,
Sunday, December 19, 2004, 10:02:58 PM, you wrote:
> Also you can put in your [client] section of my.cnf something like:
> default_character_set=gbk
I use my.ini in MySQL install directory, not my.cnf .
My MySQL Server in windows services.msc is
"C:\Program File
t; wrote:
> Hi All,
>
> I am a newbie and use MySQL 4.1.8 on Windows XP, I put my.ini in
> MySQL directory. When I add "character_set_server = gbk" to my.ini,
> everything is OK. The Server could normal startup. But when I add
> other "character_set_xx
Hi All,
I am a newbie and use MySQL 4.1.8 on Windows XP, I put my.ini in
MySQL directory. When I add "character_set_server = gbk" to my.ini,
everything is OK. The Server could normal startup. But when I add
other "character_set_xxx" to my.ini, su
Renato Cramer wrote:
Hello All,
I'm using MySQL 4.1.0, InnoDB tables and Win2K.
I need set read_only=1 and want do via option file, it's possible?
According to
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html:
*
read_only
...
This variable was added in MySQL 4.0.14.
*
I already trie
> Hello All,
>
> I'm using MySQL 4.1.0, InnoDB tables and Win2K.
> I need set read_only=1 and want do via option file, it's possible?
>
> According to
> http://dev.mysql.com/doc/mysql/en/Server_system_variables.html:
> *
> read_only
> ...
> This variable was added in MySQL 4.0.14.
> *
>
> I alr
Hello All,
I'm using MySQL 4.1.0, InnoDB tables and Win2K.
I need set read_only=1 and want do via option file, it's possible?
According to http://dev.mysql.com/doc/mysql/en/Server_system_variables.html:
*
read_only
...
This variable was added in MySQL 4.0.14.
*
I already tried put of both modes
ail)
Assunto: Re: Is possible Autocommit within my.ini?
At 14:34 -0300 5/21/04, Renato Cramer wrote:
Hi All,
I already looking for Autocommit within my.ini at documentation and
archives
of the list, and not found.
Anybody can help me?
What is it that you want to accomplish?
--
Paul DuBois, MySQ
At 14:34 -0300 5/21/04, Renato Cramer wrote:
Hi All,
I already looking for Autocommit within my.ini at documentation and archives
of the list, and not found.
Anybody can help me?
What is it that you want to accomplish?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB
Hi All,
I already looking for Autocommit within my.ini at documentation and archives
of the list, and not found.
Anybody can help me?
Thanks in advance,
Renato Cramer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in
the manual. Sorry for the bother, all.
From: Tobias Asplund <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "'Rich Brant'" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject:
> # If you specify no service name, the server uses the default service name of MySQL
> and the server reads options from the [mysqld] group in the standard option files.
> # If you specify a service name after the --install option, the server ignores the
> [mysqld] option group and instead read
> Hello,
>
> What do I need to add to the my.ini file? Can anyone post a typical setup
> of this as an example?
I install with mysqld-nt-max --install servicename
servicename in those cases are MysQL40, MySQL41 and MySQL50
Those are the relevant rows:
[mysqld]
[mysql40]
basedi
gt;
Reply-To: <[EMAIL PROTECTED]>
To: "'Rich Brant'" <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: RE: my.ini file for two instances of MySql - need help
Date: Mon, 12 Jan 2004 10:55:21 -0600
Here is an example of what I used:
[mysqld]
# set basedir to your
AM
To: [EMAIL PROTECTED]
Subject: my.ini file for two instances of MySql - need help
Hello,
I need to get two instances of Mysql running on the same machine. It's a
windows 2000 server. The existing MySQL is 3.23 and is running in another
directory. It appears to be used for LiveStats.
I
both running.
What do I need to add to the my.ini file? Can anyone post a typical
setup of this as an example?
This section of the MySQL Reference Manual describes the use of multiple
servers:
http://www.mysql.com/doc/en/Multiple_servers.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisc
o the my.ini file? Can anyone post a typical setup
of this as an example?
Thank you!
BID
_
Check out the new MSN 9 Dial-up fast & reliable Internet access with prime
features! http://join.msn.com/?pgmarket=en-us&page=dia
I have this my.ini
--
[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld-max.exe
QueryInterval=10
[mysqlcheck]
host=localhost
user=root
force
fast
all-databases
silent
debug=c:\mychk.log
---
but do not check the BD at startup and do not write the log file. Some idea
To: "MySQL LIST" <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 10:45 PM
Subject: Re: Two Servers on Windows and my.cnf/my.ini groups
>
> Yes, that's the problem.
> Until now I started the two servers from the command line/batch
file/service
> and each server had its ow
Yes, that's the problem.
Until now I started the two servers from the command line/batch file/service
and each server had its own my.ini. The two servers are in replication: one
master and another slave. Two days ago I read that I can use a unique my.ini
for the both servers; and MySQ
m: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Primaria Falticeni" <[EMAIL PROTECTED]>; "MySQL LIST"
<[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 7:51 PM
Subject: Re: Two Servers on Windows and my.cnf/my.ini groups
At 19:37 +0300 7/22/03, Primaria Faltice
Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Primaria Falticeni" <[EMAIL PROTECTED]>; "MySQL LIST"
<[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 7:51 PM
Subject: Re: Two Servers on Windows and my.cnf/my.ini groups
> At 19:37 +0300 7/
my.cnf/my.ini 's groups?
If by Linux tool you mean mysqld_multi, it's inapplicable to Windows.
For instructions on running multiple servers on Windows, have a look
in the MySQL manual here:
http://www.mysql.com/doc/en/Multiple_servers.html
Thanks Anticipated,
Iulian
--
Paul DuBo
Hello,
I run two MySQL servers on Windows with the two services.
I read in the docs that it exists a way to identify the servers in my.cnf by
groups and about a tool from Linux to manage the groups.
How can I start a server on Windows through the my.cnf/my.ini 's groups?
Thanks Antici
r DBs, before service in WIN32 started? I try
>to include group [myisamchk] in my.ini files, but nothing happen. How
>can i include it?
Not sure if this is the case in Windows, but on OS X's version of
mysqld_safe there is a line that you can uncomment that will automatically
run myis
Repair in my.ini
How can i check and repair DBs, before service in WIN32 started?
I try to include group [myisamchk] in my.ini files, but nothing happen. How
can i include it?
Thanks
Luis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
How can i check and repair DBs, before service in WIN32 started?
I try to include group [myisamchk] in my.ini files, but nothing happen. How can i
include it?
Thanks
Luis
At 11:57 -0800 3/31/03, Michael Shulman wrote:
The first time I run winmysqladmin, it creates a my.ini file for me in the
windows directory. It prompts for a username and password, recommended for
first time users, it says.
What does the "user=" and "password=" fields in the
The first time I run winmysqladmin, it creates a my.ini file for me in the
windows directory. It prompts for a username and password, recommended for
first time users, it says.
What does the "user=" and "password=" fields in the my.ini file do? They
don't seem relat
30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Vicente Valero" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 8:59 AM
Subject: my.ini
> Hi,
>
> This is my 'my.ini' file where I specified 'language=s
Hi,
This is my 'my.ini' file where I specified 'language=spanish' but the sql
errors appear in English yet. I don't see another line after this that
changes the value. Can somebody help me?
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
At 17:27 -0500 11/4/02, <[EMAIL PROTECTED]> wrote:
Hello,
How do you enable logging of slow queries in the MY.INI file under Windows?
It's not Windows-specific:
[mysqld]
log-slow-queries
or
[mysqld]
log-slow-queries=filename
In the former case, the default name is HOSTNAME-slow
Hello,
How do you enable logging of slow queries in the MY.INI file under Windows?
Also, does anyone have a reasonably good MY.INI file for a configuration under
Windows 2000 for a local MySQL host?
Thanks,
Dan Cumpian
In the last episode (Sep 11), Paul DuBois said:
> At 23:51 +0100 9/11/02, nick gatsis wrote:
> >In win98 mysql keep configuration in my.ini.
> >Which is the same file in RH Linux 7.2?
>
> /etc/my.cnf, or the my.cnf file in the server's data directory.
A quick way to
At 23:51 +0100 9/11/02, nick gatsis wrote:
>In win98 mysql keep configuration in my.ini.
>Which is the same file in RH Linux 7.2?
/etc/my.cnf, or the my.cnf file in the server's data directory.
-
Before posting, p
In win98 mysql keep configuration in my.ini.
Which is the same file in RH Linux 7.2?
Thanx
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&a
Hello,
I have mysqld-max (3.23.51) running on a Windows 2000 machine. Is it
possible to run another MySQL server alongside it, using the same my.ini
file but set on a different port, e.g. with
mysqld-max --standalone --console --port=3307
The reason I want to do this is to check
ilto:[EMAIL PROTECTED]]
JA> Sent: Friday, August 02, 2002 7:52 AM
JA> To: [EMAIL PROTECTED]
JA> Subject:Re: various questions about my.ini /or my.cnf
JA> Jerry,
JA> Thursday, August 01, 2002, 7:13:04 PM, you wrote:
JA>> As a newcomer to MySql, I have
Jerry,
Thursday, August 01, 2002, 7:13:04 PM, you wrote:
JA> As a newcomer to MySql, I have struggled through the install and am working
JA> my way through the tutorial.
JA> My environment:
JA> Win2000
JA> MySql version 3.23.51-nt
JA> My.ini:
JA>
As a newcomer to MySql, I have struggled through the install and am working
my way through the tutorial.
My environment:
Win2000
MySql version 3.23.51-nt
My.ini:
[mysqld]
# set basedir to installation path, e.g., c:/mysql
basedir=c:/mysql
# set datadir to location of
As a newcomer to MySql, I have struggled through the install and am working
my way through the tutorial.
My environment:
Win2000
MySql version 3.23.51-nt
My.ini:
[mysqld]
# set basedir to installation path, e.g., c:/mysql
basedir=c:/mysql
# set datadir to location of
Eric,
Monday, April 29, 2002, 1:53:09 PM, you wrote:
EB> is there anyone out there who knows where I can find my.ini or my.cnf on a
EB> MacOS X system? I use the MYSQL version that came with the standard MacOS X
EB> installation (updated to 10.1.4)
You should create my.cnf by yourself.
Hi there,
is there anyone out there who knows where I can find my.ini or my.cnf on a
MacOS X system? I use the MYSQL version that came with the standard MacOS X
installation (updated to 10.1.4)
thanx, Eric
-
Before posting
MySQL Manual | 4.1.2 my.cnf Option Files MySQL Manual [2621454]
MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts
4.1.2 my.cnf Option Files MySQL can, since Version 3.22, read default
startup options for the server and for clients from option files. MySQL
reads default o.
Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Gary Penn writes:
>> I am having trouble with this error:
>> "Found option without preceding group in config file: c:\WINNT\my.ini
>> line: 1 Program aborted&q
Gary Penn writes:
> I am having trouble with this error:
> "Found option without preceding group in config file: c:\WINNT\my.ini
> line: 1 Program aborted"
>
> Before this I got the infamous 1067 error where the service would go to
> start on Win2000 and then
I am having trouble with this error:
"Found option without preceding group in config file: c:\WINNT\my.ini
line: 1 Program aborted"
Before this I got the infamous 1067 error where the service would go to
start on Win2000 and then stop unexpectedly.
Some background that will ho
Michael Widenius writes:
>
> Hi!
>
>
> MySQL will first read systemdir\my.ini and then C:\my.cnf
>
> Sorry, Sinisa, you can't get things right every time ;)
> (No one can...)
>
> I have updated the manual regarding this.
>
> Regards,
> Monty
Hi!
>>>>> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote:
>>
>> Hi!
>>
Sinisa> my.cnf will be read first and if it is found my.ini will not be read
Sinisa&g
On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote:
>
> Hi!
>
> Sinisa> my.cnf will be read first and if it is found my.ini will not be read
> Sinisa> at all.
>
> Sinisa> Take a look at mysys/default.c for futher details ...
>
> To refre
Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Jeremy Zawodny writes:
>> According to what I read in the manual, I'm lead to believe that MySQL
>> on Windows can read from either C:\my.cnf or systemdir\my.ini.
Jeremy Zawodny writes:
> According to what I read in the manual, I'm lead to believe that MySQL
> on Windows can read from either C:\my.cnf or systemdir\my.ini. Which
> will it read first?
>
> The manual also seems to say that you can only use one. So if you
> create bot
: (*nothing* should be installed in C:\ in that
situation!)
- It created my-example.cnf in the program installation directory - but with incorrect
paths in it (see below)
- instructions in both these files mention only C:\mycnf - no reference to my.ini
- It created my.ini in R:\ (the *root* of the
According to what I read in the manual, I'm lead to believe that MySQL
on Windows can read from either C:\my.cnf or systemdir\my.ini. Which
will it read first?
The manual also seems to say that you can only use one. So if you
create both, which will it prefer?
Here's the part I
jds writes:
> hi!
>
> i'm running 3.23.47 w/ mysql gui1.7.5-2 on win2k
>
> to config innodb, i edited the my.ini (with some help from heikki...thanks!)
>
> and learned on win my.cnf and my.ini cannot co-exist.
>
> now i'm ready to install mysqlgui to s
hi!
i'm running 3.23.47 w/ mysql gui1.7.5-2 on win2k
to config innodb, i edited the my.ini (with some help from heikki...thanks!)
and learned on win my.cnf and my.ini cannot co-exist.
now i'm ready to install mysqlgui to set up my admin, users, etc...
my question is: can i add th
-Original Message-
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, January 06, 2002 7:54 AM
Subject: Re: help with innodb my.ini config
>Hi!
>
>MySQL does not find your my.ini.
>
>Try renaming it to my.cnf and p
my.ini looks like this:
#This File was made using the WinMySQLAdmin 1.3 Tool
#12/21/2001 6:19:15 PM
#innodb code added 1/5/2002 1550CST
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld-max-nt]
basedir=C:/mysql
#bind-address=24.26.165.120
Hi!
Your my.ini looks ok, except that you should set
innodb_data_home_dir
equal to an empty string if you give absolute paths in innodb_data_file_path
Regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the
good day list,
i'm running 3.23.46a win on win2k and had no trouble installing and using
myISAM tables
and using a access front end w/myodc - this was easy and fun.
now i'm trying to config to use innodb tables
i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini
Iago:
Your my.ini file appears to be correct. Check to see if there is a my.cnf in
the root of the C: drive ... there should not be one.
Am I correct to assume you installed the service before attempting to start
it? Check the WinNT Service Control Manager in the Control Panel.
Make sure you
too).
The server failed at the moment of start the service.
The content of the my.ini file is:
#This File was made using the WinMySQLAdmin 1.3 Tool
#22/8/01 10.38.40
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/Archivos de prog
81 matches
Mail list logo
