Hi All,
The production server on which mysql database was running, get
shutdown on one day. Then we have to manually start it. The server is
hpdl585. What can be the reason of shutdown. What has gone wrong with the
server. Is there is any to find the reason for shutdown.
Thanks,
Krishna
Krishna Chandra Prajapati schrieb:
Hi All,
The production server on which mysql database was running, get
shutdown on one day. Then we have to manually start it. The server is
hpdl585. What can be the reason of shutdown. What has gone wrong with the
server. Is there is any to find the
Weston, Craig (OFT) schrieb:
Hello everyone, hopefully a quick question: is there a functional
difference between the various text field sizes other than size? For
example if I wanted to could I run a FULLTEXT index against a LongText
field?
no
--
Sebastian
--
MySQL General Mailing List
Sebastian Mendel schrieb:
Weston, Craig (OFT) schrieb:
Hello everyone, hopefully a quick question: is there a functional
difference between the various text field sizes other than size? For
example if I wanted to could I run a FULLTEXT index against a LongText
field?
no
ay ...
Jim schrieb:
Is there any kind of timetable for when 5.1 is actually expected to be
released?
the is plan is before end of year - IMHO
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Jim, all !
Jim wrote:
Is there any kind of timetable for when 5.1 is actually expected to be
released?
Sorry, no - there cannot be any firm expectation yet, and consequently
no timetable.
Different people have different *hopes* when that may be, but these
personal estimates will be made
Ganesh's screen schrieb:
Is there a way to restrict the length of text field in MySQL. For example, it
is of 65K limit and could hold more than 2 characters. Is there a way to
restrict that to 4000 characters at table/field level. Coz the
max_allowed_packet constrainted the entire DB.
you
This line has not come later, it is standard in Debian, to be able to
have parts of your configuration in different files. This line does all
configuration files that are in /etc/mysql/conf.d/. Since this
directory is probably empty, nothing is done at all.
So you are safe with just leaving
Hi All,
I have installed debian on a system and then install mysql. Later i
found that in
my.cnf file one more line has been add ie
!include /etc/mysql/conf.d
I don't know how it comes to my.cnf file. Is it going to harm mysql or OS.
Why it has come.
Please help me.
Thanks,
Krishna
Thank you
This e-mail, including any attachments, may be confidential, privileged or
otherwise legally protected. It is intended only for the addressee. If you
received this e-mail in error or from someone who was not authorized to send
Hi All!
Here is a funny thing I come across when investigating our privilege control
system. Consider the following situation:
mysql GRANT ALL ON `%o`.* TO rafal;
mysql GRANT SELECT ON foo.* TO rafal;
The intention is that rafal has all privileges for all objects in databases
whose name
Hi Samuel,
The path /etc/mysql/conf.d/ is present in my.cnf file. When i checked conf.d/
contains a file named old_password.cnf The contents of the old_password.cnf
is below
#create by debconf
[mysqld]
old_password=false
Thanks,
Krishna
On 10/18/07, Samuel Vogel [EMAIL PROTECTED] wrote:
This
Thank you, Sebastian. Also does the usage of UTF-8 over Latin1 restraints the
usage or extensibility?
Sebastian Mendel wrote:
Ganesh's screen schrieb:
Is there a way to restrict the length of text field in MySQL. For
example, it
is of 65K limit and could hold more than 2 characters.
Hey all,
I've got a new server set up, with dual Intel quad core processors, 4 gig of
ram, OpenSuse 10.3 (64bit) and MySql 5.0.45.
The majority of the tables are MyISAM with a few InnoDB here or there. I'm
using the huge-my.cnf as the base for my config.
Can anyone suggest some tweeking
Hey all,
I've got a new server set up, with dual Intel quad core processors, 4 gig of
ram, OpenSuse 10.3 (64bit) and MySql 5.0.45.
The majority of the tables are MyISAM with a few InnoDB here or there. I'm
using the huge-my.cnf as the base for my config.
Can anyone suggest some tweeking to
hello
i would like to search a table column for a range of non-ascii
characters, or a particular non-ascii character. how can i do this?
the column can be any string like hello, world or norwegian
characters æøå here.
refer to these pseudo examples:
SELECT * FROM TABLE WHERE COLUMN CONTAINS
Hi,
Olav Mørkrid wrote:
hello
i would like to search a table column for a range of non-ascii
characters, or a particular non-ascii character. how can i do this?
the column can be any string like hello, world or norwegian
characters æøå here.
refer to these pseudo examples:
SELECT * FROM
Olav Mørkrid schrieb:
hello
i would like to search a table column for a range of non-ascii
characters, or a particular non-ascii character. how can i do this?
Maybe via a inverted regular expression [1] like this?:
SELECT * FROM TABLE WHERE COLUMN RLIKE '[^-, a-zA-Z0-9]'
[1]:
Hi-
I'm using the command 'mysqlimport -u usr -ppassh -h mysqlserver -P 3306 -v
db --local $workdir/$filename'to import a table into mysql from a file
$filename.
The data in $filename looks something like:
test test
where there is a blank space between the two 'test's to represent an empty
qt4x11 wrote:
Hi-
I'm using the command 'mysqlimport -u usr -ppassh -h mysqlserver -P 3306 -v
db --local $workdir/$filename'to import a table into mysql from a file
$filename.
The data in $filename looks something like:
test test
where there is a blank space between the two 'test's to
20 matches
Mail list logo