Hi All,
I am using the MySQL full text search capability in the search workflow
in my appplication. I found that MySQL treats special character like
*./,* etc. as tokenizers if they are not specified within a
phrase(inside double quotes). For ex. If the search string entered is
M.B.A or 24/7
Hi,
recently, our slave stopped for a duplicate key error (which is a bug to me :
http://bugs.mysql.com/bug.php?id=9929
)
How do you usually check automatically that slaves are up and running ?
--
http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives:
How do you usually check automatically that slaves are up and running ?
echo show slave status\G|mysql -u user -ppassword|grep -i
slave.*running|grep -i no mail -s MySQL Slave stopped [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
echo show slave status\G|mysql -u user -ppassword|grep -i
slave.*running|grep -i no mail -s MySQL Slave stopped
[EMAIL PROTECTED]
well, actually
echo show slave status\G|mysql -u user -ppassword|grep -i
slave.*running|grep -i no echo .|mail -s MySQL Slave stopped
[EMAIL PROTECTED]
Hi,
our server crashed yesterday with the following error :
do_ypcall: clnt_call: RPC: Unable to receive; errno = Connection refused
do_ypcall: clnt_call: RPC: Unable to receive; errno = Connection refused
do_ypcall: clnt_call: RPC: Unable to receive; errno = Connection refused
mysqld got signal
Since a couple of recent stable versions back (and more recently, MySQL
5.0.22), MySQL has been returning the column length (C API) of the 'Type'
column of a show columns from.. statement as being 196605 (almost 192KB),
when this column only really contains data in the region of 10 bytes, if
Hi. I just installed MySQL 4.1.20 for the UTF-8 support it offers. I'm
trying to set the charcter set collation at the database level but
can't get it to work.
It works by setting it at the server level (in my.cnf) but I want to
set it at the database level because I'll be hosting the web
MySQL doesn't index the special characters, some of which are considered word separators, like the period. MySQL indexes words, not
strings (sort of).
I had a similar problem on one of my projects where I needed to index resumes for searching. Typical searches would include C++, C#,
.NET, etc.
Although I know nothing about C I imagine this is because the 'type' column can
contain all the possible values from an ENUM or SET field.
James Harvard
At 10:30 am + 6/7/06, SciBit MySQL Team wrote:
Since a couple of recent stable versions back (and more recently, MySQL
5.0.22), MySQL has
In the last episode (Jul 06), Dilipan Sebastiampillai said:
our server crashed yesterday with the following error :
do_ypcall: clnt_call: RPC: Unable to receive; errno = Connection refused
do_ypcall: clnt_call: RPC: Unable to receive; errno = Connection refused
do_ypcall: clnt_call: RPC:
Scott,
I do not think that is how it works under revision 4.0.21.
Thanks,
NĂ©stor :-)
On 7/5/06, Scott Haneda [EMAIL PROTECTED] wrote:
People,
I have the following table:
DROP TABLE IF EXISTS bid;
CREATE TABLE bid (
bid_id int(11) NOT NULL auto_increment,
bid_proj_name varchar(100)
Chris,
my situation is that I am reading a file using phpmyadmin and whne I do not add
the extra , then I get an invalid number of records, so I have to
have the extra ,
When I do an insert without the last comma, it does set the correct day.
I do not know that it will work if I add the fields
From: Spiros Philopoulos Sent: 06 July 2006 13:32
Hi. I just installed MySQL 4.1.20 for the UTF-8 support it
offers. I'm
trying to set the charcter set collation at the database level but
can't get it to work.
It works by setting it at the server level (in my.cnf) but I want to
set
What would be the best approach to remote monitoring of numerous mySQL
databases remotely i.e. number of threads. number of open tables etc etc
Can I do it with DBD::Perl
Thanks
Andy
--
perl -e print qq^bIG VeRN ! ^^qq^#'#Yv#=D+ ^
Managed Services (in:control) Developer, Telindus, RG27 9HY
Anyone have an idea on this?
Thanks
Ed Reed [EMAIL PROTECTED] 7/5/06 1:54:25 PM
Anyone have an idea on this?
Thanks
Ed Reed [EMAIL PROTECTED] 6/30/06 2:51:44 PM
Opps!
Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL
4.1.11
Any other suggestions?
Thanks
On 7/6/06, Ed Reed [EMAIL PROTECTED] wrote:
Anyone have an idea on this?
Upgrade. Or at least stop repeating the question.
Jochem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Andy Ford Sent: 06 July 2006 17:06
What would be the best approach to remote monitoring of numerous mySQL
databases remotely i.e. number of threads. number of open
tables etc etc
Can I do it with DBD::Perl
You could, run queries such as
SHOW STATUS;
SHOW TABLE STATUS;
against
I've the following SQL statement which I created in MS Access. My table
layout is the same in mySQL but it says I have an error and the query
doesn't run
SELECT AccommodationOverview.Title,
AccommodationOverview.AccommodationOverviewID,
AccommodationOverview.AccommodationID, Areas.Name
FROM
Today I also carried out some thing same as you. I already have
Primary Keys in all tables. Then I added a temporary timestamp field
with default as '1999-11-11 11:11:11'. Then I updated all such columns
with above value. There is no 'on_update current timestamp' settings,
just defined default
It's link is-
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_JetDatabaseEngineVersion30ODBCConnectivity.asp
CPK
*
On 7/6/06, C K [EMAIL PROTECTED] wrote:
Today I also carried out some thing same as you. I already have
Primary Keys in all
Friend, I need to see if a table is locked by some application or some
user. Do you know some tools for this? (gpl license better). Or some
sentence?
When a table is locked, how can i unlock this table?
My problem is that some applications cause an error and the user closes
it with the task
Your site has a bunch of JS errors (using IE) so I can't roll over ANY of
the menus (left or upper right). I also cannot write to 'contact' because of
this same error. Hence I send it here... To the list... *sigh*
Can I also suggest not using a dark red hyperlink with black text. I didn't
even
Hi, i'm having a bit of a headache with PHP and MySQL, i've some questions:
1) I've a database in UTF-8 and when i connect to it with mysql_connect,
and exec a query with mysql_query, the results are in latin1. (i proved
this with mysql_query(show variables like 'char%');
2) Is there any way to
Thanks for the helpful words. The fact of the matter is that I would love to
upgrade but since 5.0x doesn't have all the capabilities of 4.1x, an upgrade is
out of the question at this time. So I'm left to looking here for help.
Thanks for your time.
Anyone else have an idea on this?
Jochem
Is there a way to set the auto_increment start number? I am trying to set up a
development and test system and the application that is writing to the tables
is confused as to which MySQL it is writing to. I don't have any contrtol over
the other app but since the key value is taken back to the
On 7/6/06, Jake Peavy [EMAIL PROTECTED] wrote:
On 7/6/06, Chuck Holzwarth [EMAIL PROTECTED] wrote:
Is there a way to set the auto_increment start number? I am trying to
set up a development and test system and the application that is writing to
the tables is confused as to which MySQL it is
On 7/6/06, Ed Reed [EMAIL PROTECTED] wrote:
Thanks for the helpful words. The fact of the matter is that I would love to
upgrade but since 5.0x doesn't have all the capabilities of 4.1x, an upgrade is
out of the question at this time. So I'm left to looking here for help.
What? An higher
On Thu, 2006-07-06 at 13:41 -0700, Chuck Holzwarth wrote:
Is there a way to set the auto_increment start number? I
am trying to set up a development and test system and the
application that is writing to the tables is confused as
to which MySQL it is writing to. I don't have any contrtol
Always CC the list. You will get better / faster responses.
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
thats is the syntax it tells me to use so i typed
CREATE USER dimitri [IDENTIFIED BY [PASSWORD] '**'];
were the starts are my password, i hav tried fiddling with the syntax
Neil Tompkins wrote:
I've the following SQL statement which I created in MS Access. My table
layout is the same in mySQL but it says I have an error and the query
doesn't run
SELECT AccommodationOverview.Title,
AccommodationOverview.AccommodationOverviewID,
30 matches
Mail list logo