I'm trying to explicitly specify the location of the my.ini file on Windows XP
I'm using:
u:\mysql5.1\bin\mysqld --install --defaults-file="u:\\mysql5.1\\my.ini"
and it complains "Failed to install the service (Couldn't create service)"
I've tried "
Hi,
On Fri, Apr 4, 2008 at 1:46 PM, Ed W <[EMAIL PROTECTED]> wrote:
> It appears that since updating from mysql 5.0.44 to 5.0.54 I have also lost
> my DEFAULT "" option on all my varchar columns.
>
> For colums which are also NOT NULL this is causing a bunch of problems in
> my existing app (tryi
It appears that since updating from mysql 5.0.44 to 5.0.54 I have also
lost my DEFAULT "" option on all my varchar columns.
For colums which are also NOT NULL this is causing a bunch of problems
in my existing app (trying to insert NULLS)
Anyone can explain what happened and why this has chan
uot; <[EMAIL PROTECTED]> wrote:
> Which cnf file (small,medium,large,huge) has params
> that are closer to mysql defaults for starting up
> server?
>
> I see default unix socket file is /tmp/mysql.sock
> which could be removed by someone accidently.
> Is it nor
Which cnf file (small,medium,large,huge) has params
that are closer to mysql defaults for starting up
server?
I see default unix socket file is /tmp/mysql.sock
which could be removed by someone accidently.
Is it normal to keep it that way or keep in a
protected directory ?
Thanks
esday, August 11, 2004 8:32 PM
Subject: Re: Changing Fulltext defaults in Win32
>
> On Wed, 11 Aug 2004 20:29:54 +0300, "Cemal Dalar" <[EMAIL PROTECTED]>
> said:
> > put a line like below to your my.cnf file under [mysqld] section
> >
> > ft_min_word_len=2
On Wed, 11 Aug 2004 20:29:54 +0300, "Cemal Dalar" <[EMAIL PROTECTED]>
said:
> put a line like below to your my.cnf file under [mysqld] section
>
> ft_min_word_len=2
I assume I should shutdown-restart MYSQL after I do that ?
Thanks,
Lee G.
snip
--
MySQL General Mailing List
For list archi
Sent: Wednesday, August 11, 2004 8:12 PM
Subject: Changing Fulltext defaults in Win32
> I'm using MYSQL 4.x on Win2k. I want to change the default smallest word
> size from the default (4 chars I think) to 2chars. Any links, how-to's
> appreciated.
> Thanks,
> Lee
I'm using MYSQL 4.x on Win2k. I want to change the default smallest word
size from the default (4 chars I think) to 2chars. Any links, how-to's
appreciated.
Thanks,
Lee G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> what are the defaults for the following options?
>
> net_read_timeout
30 seconds.
> net_write_timeout
60 seconds.
See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html for details.
--
For technical suppo
Hello,
what are the defaults for the following options?
net_read_timeout
net_write_timeout
Regards
Marten Lehmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
al Message -
From: "Boyd E. Hemphill"
Sent: Friday, April 09, 2004 9:49 PM
Subject: Question regarding defaults
> Hello:
>
> I have need to declare a column as type integer then default is at '0'
> (that is a string with a zero in it).
>
> An example may
Hello:
I have need to declare a column as type integer then default is at '0'
(that is a string with a zero in it).
An example may be:
Create table foo (
foo_id int not null default '0'
)
My question centers on the notion of implicit type conversion. Is the
server converting the type
At 17:04 02/04/2003 +0100, Simon Tyler wrote:
Hi,
Looking at the code (3.23, 4.0 and 4.1) it looks as if it is getting
confused in the main (in mysqld.cpp) and just calls Service.Init without
loading the default file.
Doing the above without a service name works OK, doing it without
over-riding
I've been trying to install MySQL (3.23.55) as a named NT service and using a
specified defaults file and I can't get it to work.
The source code has the example:
mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini
in it. The results in a service ImagePath of
C:
/etc/my.cnf: Global options
DATADIR/my.cnf: Server-specific options
defaults-extra-file: The file specified with --defaults-extra-file=#
~/.my.cnf: User-specific options
By default, data is in /var/lib/mysql.
Jon Miller wrote:
Can someone tell me how do I find the default settings in MySQL
Can someone tell me how do I find the default settings in MySQL. Mainly
I'm interested in knowing where are the data files stored. I'm building
a application server (RH7.3) and need to know which partition should be
sized to handle the database.
--
Jon Miller <[EMAIL PROTECTED]>
MMT Networks Pty
On Mon, Mar 03, 2003 at 08:21:58AM -0700, Zak Greant wrote:
...
> To keep closer to standard SQL, wrap the SET call in an executable
> comment, like so:
>
> /*! SET table_type=innodb; */
>
> Most (all that I know of :) databases except MySQL will treat the
> comment like a nor
On Mon, Mar 03, 2003 at 09:36:37AM -0500, Warren W. Gay VE3WWG wrote:
> I would like to create a Table default (Type=InnoDB) for a particular
> database. Is there a way to do this, or is this being planned for in
> a future release?
>
> For most of my databases, I am only interested in transact
I would like to create a Table default (Type=InnoDB) for a particular
database. Is there a way to do this, or is this being planned for in
a future release?
For most of my databases, I am only interested in transactions. Having
to remember to specify that table type = InnoDB for each table crea
At 20:50 +0300 8/30/02, Andrew Sitnikov wrote:
>Hello mysql,
>
>Can not start mysqld with --defaults-file
>
>>mysqld
>>--no-defaults--defaults-file=/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/my.cnf
>
>/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/bin/mys
Hello mysql,
Can not start mysqld with --defaults-file
>mysqld
>--no-defaults--defaults-file=/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/my.cnf
/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/bin/mysqld: ERROR: unknown variable
'defaults-file=/usr/local/mysql-4.0.3-beta-pc-lin
On Mon, Jul 29, 2002 at 06:05:02PM -0400, Keith C. Ivey wrote:
> On 28 Jul 2002, at 17:56, Paul DuBois wrote:
> > At 14:34 -0700 7/28/02, Charlie wrote:
> > >Is there any storage / performance penalty for specifying '' or 0 as
> > >default values, as opposed to allowing null's in the table structu
On 28 Jul 2002, at 17:56, Paul DuBois wrote:
> At 14:34 -0700 7/28/02, Charlie wrote:
> >Is there any storage / performance penalty for specifying '' or 0 as
> >default values, as opposed to allowing null's in the table structure?
>
> NULL values take less storage space. (One bit per NULL value
At 14:34 -0700 7/28/02, Charlie wrote:
>Is there any storage / performance penalty for specifying '' or 0 as default
>values, as opposed to allowing null's in the table structure?
NULL values take less storage space. (One bit per NULL value in a row,
if I remember correctly).
>
>sql, query
>
>T
Is there any storage / performance penalty for specifying '' or 0 as default
values, as opposed to allowing null's in the table structure?
sql, query
Thanks,
Charlie
-
Before posting, please check:
http://www.mysql.com/manu
Hi,
I had an odd thing happen yesterday. I had replication running, the master
being on a server farm, the slave being in our office. I tested it early in
the morning by creating a table on the master, it showed up on the slave
right away.
Of course as soon(a few hours later) as I went to sho
/ALTER_TABLE.html
Gurhan
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 2:44 PM
To: [EMAIL PROTECTED]
Subject: defaults
How do I add defaults to a table? In SQL Server I can simply write
columnname bit null constraint defaultname default
How do I add defaults to a table? In SQL Server I can simply write
columnname bit null constraint defaultname default (0)
when I create the table.
Thanks,
Eddie
-
Before posting, please check:
http
29 matches
Mail list logo
