Hi,
try to set the collation to utf8_unicode_ci.
I have had the inverse problem and I solved with utf8_general_ci.
Santino
At 19:33 +0100 16-02-2009, Salam Baker Shanawa wrote:
Hi,
How can I have accent sensitive, case insensitive fulltext query?
version: 5.0.45
The database, tables
Have you tried in boolean mode?
Santino Cusimano
At 16:30 -0500 20-11-2008, Little, Timothy wrote:
We are using MySQL 5.0.22 on CENTOS/redhat
linux. The table and database character-sets
are all utf8.
We have a database supporting numerous
languages. Of course, full-text works
Hi,
Try to make a table for each company with only one integer field than
insert a record and use the id to populate the other table.
You can also delete periodically records from there companies tables.
Santino
At 21:48 -0500 23-11-2007, David T. Ashley wrote:
Hi,
I am developing a large
/lib/mysql/mysql1.sock shutdown
I run MySql 4 5 in the same CPU. (different databases).
Santino Cusimano
At 11:23 +0530 15-04-2006, Mohammed Abdul Azeem wrote:
Hi,
I need to install 3 instances of mysqld server on a single machine. Can
anyone let me know how this can be acheived ?
It would
In MySql 5 you can write a filter function (plugin)
Santino
At 17:04 +1000 13-04-2006, Taco Fleur wrote:
Yes I have been thinking about the same, and already started collecting
search words, but its not really the direction I want to go in if I can
avoid it.
Kind regards,
Taco Fleur
Free
I do not try it :
select invoice_id, order_id, customer_id, invoice_timestamp,
invoice_total, null
from invoice
union all
select invoice_id, null, null, null, null, invoice_journal_id
from invoice_archive
Santino
At 12:08 +0200 11-04-2006, Kim Christensen wrote:
Hello everyone
I have
In current_date - 7 the date is converted to a string and than to an Integer.
Use adddate function:
adddate(CURRENT_DATE(),interval -1 day)
Santino
At 11:37 +0100 7-12-2005, christophe nauwelaers wrote:
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run
Try:
mysqldump -h yourhost.com -u username -ppasswd mydatabase mytable | mysql -h
yournewhost.som -u newuser -ppasswd newdatabase
Santino Cusimano
At 17:19 +0200 20-08-2005, John thegimper wrote:
Thanks, but that copies the whole database
right? Can i specify only one table?
Quoting Pooly
in script folder that creates users groups
(mysql-install-db).
It is possible that you have 2 versions of mysql (one from system
installer, the other from you).
Santino Cusimano
PS: In the installer .dmg disk you have 2 installers (one for mysql
database and the other install a script to launch
The permission of directory /usr/local/mysql/data and it's contents
must be mysql/mysql
so open the terminal and type
cd /usr/local/mysql
chown -R mysql:mysql ./data
and try to restart mysql.
Santino Cusimano
At 12:40 -0400 22-07-2005, Andy Hilton wrote:
Santino - many thanks (thanks
OK
Now open the terminal and type:
cd /usr/local/mysql/
./scripts/mysql_install_db
and restart mysql.
Santino Cusimano
At 14:34 -0400 22-07-2005, Andy Hilton wrote:
This would appear to be the relevant stuff - the err file was in the
mysql/data directory
050722 14:23:32 mysqld started
You need to run the script that creates MySql tables (user, hosts, ...)
mysql_install_db in scripts dir.
Santino
At 15:20 -0400 16-06-2005, Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option
in my.cnf: socket=/tmp
(libmyodbc3-3.51.11.so)
Give me a seg fault.
mysql-max-4.1.8-pc-linux-i686 + libmyodbc-2.50.39.so
Works (if I change the socket to
'/var/lib/mysql/mysql.sock' from '/tmp/mysql.sock'
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello,
I have a segmentation fault using MySql with PHP/ODBC on Linux.
I do a query with exec and I get a segmentation fault in my_SQLPrepare.
If I use the isql command line, all works fine.
Is it a MySql problem or a Php problem?
Thank you.
Santino Cusimano
--
MySQL General Mailing List
tables here then stop mysql, copy your tables (directory) with a
'cp -pr' (preserve recursive) to mysql/data and restart mysql.
Hope this solve your problem.
Santino Cusimano
At 15:35 -0700 21-04-2005, m i l e s wrote:
Hi,
I updated my 4.0 install to 4.1 and now NONE of my
databases and tables
connection time. (There is a
option to skip this).
Santino Cusimano
At 11:21 -0500 28-03-2005, Andre Matos wrote:
What kind of detail do you need? I checked the DNS, and it is seems to
working fine.
Andre
On 3/27/05 10:02 AM, Santino [EMAIL PROTECTED] wrote:
It could be a DNS problem, but you must
It could be a DNS problem, but you must give us more details.
Santino
At 10:47 -0500 26-03-2005, Andre Matos wrote:
Hi List,
I have 4 web based systems developed using PHP4 and MySQL accessed for 10
users. The Web Server and Database Server were running ok on a Mac OS X 10.3
G4 dual. However
a description of the error.
Try to check that:
- mysql user have access/read/write privileges in /tmp directory.
- /usr/local/mysql/data and all files inside it owner/group is mysql/mysql
- There are hosts and mysql tables in data directory.
Santino
At 16:45 -0600 8-03-2005, Jeff Justice wrote
At 15:50 -0800 27-01-2005, cristopher pierson ewing wrote:
Shawn,
Okay, it turns out that I can solve my problem by reordering the
elements of the WHERE clause at the end of the query I sent before.
I've gotten good results with the following version (it breaks all
the fields in the Fulltext
| latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+--+---+
3 rows in set (0.04 sec)
and if are different set the collation in your my.cnf file.
Santino
At 1:25 + 25-01-2005, Cecep Rosuludin wrote
Permission problem:
[EMAIL PROTECTED] santino]$ perror 13
Error code 13: Permission denied
Check /tmp permission
and check /usr/local/mysql/data/
user and group of this directory must be mysql:mysql
if not:
chown -R mysql:mysql /usr/local/mysql/data/
Santino
PS: /usr/local/mysql is a symbolic
| latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+--+---+
3 rows in set (0.04 sec)
and if are different set the collation in your my.cnf file.
Santino
At 8:59 -0800 30-11-2004, V. M. Brasseur wrote
Hello,
I installed a tar.gz version and I found it in a support directory:
there are some my.cnf file my{}.cnf where is large, huge,
...
Santino
At 15:26 -0500 29-11-2004, Andre Matos wrote:
I just have finished to install the version 4.1.7 on my Mac and I looked at
these directories
records and add the
second index the
cardinality is null.
At the moment I found that if I define a composite primary key ( old
PRIMARY+KEY) the query
works without the analyze.
Santino
OCC_ID is null;
==CUT
Results:
[EMAIL PROTECTED] bugs]# mysql v.sql
Before index
Before index
AUL_ID OCC_ID
2 NULL
3 NULL
After Index
After Index
[EMAIL PROTECTED] bugs]#
Is it a bug?
Santino
--
MySQL General Mailing List
For list archives: http
Store month*100+day
1999-03-01 -- 301
you can also say it's your birthday today when 02/29 doesn't exists!
Santino
At 13:05 -0500 18-11-2004, [EMAIL PROTECTED] wrote:
Good idea! But, that method will fail for dates past Feb 29th on leap
years.
MYSQLselect dayofyear('1999-03-01'), Dayofyear('2000
Update phpMyAdmin.
Santino
At 12:33 + 12-11-2004, Dilipan Sebastiampillai wrote:
Hello,
after restoring from a mysqldump I use phpMyAdmin to view my
database but the size field is unknown ...
how could I get a size display ?
--
Dilipan Sebastiampillai
--
MySQL General Mailing List
For list
The directory mysql is a symbolic link to one of the other dirs.
If mysql points to old one rename it and make a new one:
mv mysql mysqlold
ls -s mysql-max-4.1.7-apple-darwin7.5.0-powerpc mysql
Do not remove
mysql-max-4.0.20-apple-darwin7.3.0-powerpc/data
it contains your old databases!!!
Santino
Better:
select * from table as t1
left join table as t2 on t1.study=t2.study and not
t2.keyword ='K2'
where
t1.keyword = 'K1'
Santino
At 23:23 +0100 8-11-2004, Santino wrote:
Something like:
select * from table as t1, table as t2 where
t1.study=t2.study and
t1.keyword = 'K1' and not
t2.keyword
Something like:
select * from table as t1, table as t2 where
t1.study=t2.study and
t1.keyword = 'K1' and not
t2.keyword ='K2'
Santino
At 11:57 -0800 8-11-2004, L a n a wrote:
Hello,
I've had a problem:
statement SELECT data_id from table WHERE keyword = a NOT keyword
= b returns SQL error
I've
Hi,
Try to add an index on join fields ( search.lot_id,
exchange_rate.currency_id,lot.currency_id)
Your query can not use an index to sort because MySql can use only 1
index to search and sort and your sort is a function so it scans
result rows and then it sorts the working table.
Santino
me?
Thanks
Santino
T
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Search '+ford +focus' [in boolean mode]
Santino
At 13:22 + 3-11-2004, Lee Denny wrote:
Hello,
I'm doing fairly straight forward fulltext searches, but I want to nest
them - basically do a keyword search on 'phrase 1' and then search the
results this returns for 'phrase 2', for example
Do you use POST or GET in the form?
Try with a post.
Santino
At 8:31 -0500 3-11-2004, Ed Curtis wrote:
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = 1 1/2 it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when
Are you sure?
/usr/local/mysql is a symbolic link to another direcory (
/usr/local/mysql(version).
I think the installer overwrite the symbolic link so if you open a
terminal and type:
ls -l /usr/local
Santino
At 16:20 -0700 28-10-2004, Steven Roussey wrote:
Installing MySQL 4.1.7 (upgrading
Try to search in keyword table:
select * from keywords WHERE MATCH(keyword_txt) AGAINST
('$radio_keyword' IN BOOLEAN MODE);
If it works the problem is in the join.
Santino
$query = SELECT page.* FROM `page` LEFT JOIN `keywords` USING
(`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST
select count(1) from TABLEn;
select sum(C) as count from A;
drop table A;
Santino
At 6:54 -0400 14-10-2004, Michael J. Pawlowsky wrote:
Does anyone know of a quick way to get the number of rows in a
database from the command prompt.
I run a cron job that does a mysql dump nightly from a prod server
SELECT nameColumn,
otherColumn, count(*) as flag FROM theDatabase WHERE rowID = 1 group by rowID;
or make a temp table with the IDs and then left join it with
theDatabase and drop temp.
Santino
At 23:27 -0700 10-10-2004, John Mistler wrote:
Good idea. liang le's answer almost got it, but I
your regexp
Remember that fulltext words must have 4+ char (but you can change it
in my.cnf file).
Santino
At 21:14 -0600 7-10-2004, Elim Qiu wrote:
?Hi, instead of xml, i stored arbitrary data of the form
(the actual usage of such mechanism is for more fancy stuff,
say, dynamic configuration
You can use regular expression.
Santino
At 6:45 -0500 3-10-2004, Bob Ramsey wrote:
Hi,
I have some web pages in a database and I want to check to make sure
that all of the images have alt tags in them. So what I need to do
is ask something like this in psuedocode:
select page_name from
!!
Santino Cusimano
PS: technical support is very good and I appreciate it.
At 21:27 +1200 16-09-2004, Patrick Connolly wrote:
Somewhere about Mon, 13-Sep-2004 at 07:23PM +0300 (give or take),
Egor Egorov wrote:
| Patrick Connolly [EMAIL PROTECTED] wrote:
|
| I've been trying to contact MySQL AB
about a moderate costs.
The license is more restrictive about copyright and distribution but
it doesn't contain any money issue.
If you have some question you can write to gnu.org or you can report an abuse.
See http://www.gnu.org
Santino
--
MySQL General Mailing List
For list archives: http
don't know what labguage you use
(C, php, ...).
There is a command to reenable connection; if my memory is good:
mysqladmin -flush-hosts
or something (see mysqladmin reference or help).
Santino
At 9:02 -0700 1-09-2004, Michael Winston wrote:
Hi-
We've been running into a pretty serious problem
:
Where is the text of commercial license; I have one trouble:
Can I buy a license (1 for each server) and sell my application to a
reseller that will sell my application, hardware and technical
support to the real customer?
Santino
At 15:09 +0200 11-08-2004, Leonardo Francalanci wrote:
If you
Sorry, but I send an e-mail to sales two month ago but none replies me.
The question is very simple:
Can I buy 2 licenses and transfer them to an hardware reseller that
will transfer them to the customer?
Thank you.
Santino Cusimano
--
MySQL General Mailing List
For list archives: http
Hello,
Is there any plan to support fulltext indexes in Merge Tables?
Thank You.
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) to a hardware reseller that will sell the System
(HW, SW, technical support) to the customer via a leasing company?
What kind of document let the user use, according legal issues, MySql
(My and reseller invoices)?
Thank you.
Santino Cusimano
--
MySQL General Mailing List
For list archives: http
than a second.
Does someone have had this problem?
It is a bug?
The tables have indexes on search fields.
Santino Cusimano
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 15:21 -0500 29-05-2004, mos wrote:
At 01:39 PM 5/29/2004, you wrote:
Hello,
Does the cluster support fulltext indexes?
After a quick reading of preliminary documentation it seems NO.
Can someone confirm it?
Thank you.
Santino Cusimano
-
Santino,
Where does it say that in the docs? Can
Hello,
Does the cluster support fulltext indexes?
After a quick reading of preliminary documentation it seems NO.
Can someone confirm it?
Thank you.
Santino Cusimano
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
check the permission of /tmp folder.
I think mysql user can not access that dir:
chmod 777 /tmp
Santino
At 22:00 + 11-04-2004, Mustafa Hakim wrote:
I am trying to install MySql on MAC OS X. After the pkg is installed
I am not able to start the MySql server due to the Socket error.
ERROR
Not the 5.0!!!
Santino
At 10:02 -0400 7-04-2004, Victor Medina wrote:
James McConnell wrote:
Hey all. I had asked a few days ago if anyone had experience installing 4.1
on the Mac and got no reply, but that's cool :-). Has anyone installed 5.0
on the Mac? Any problems? I'd like to try
. Thanks in advance
~Elle~
http://www.fpdf.org/
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can try with a JNI native class.
Santino
At 10:53 -0600 1-03-2004, Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victor Medina wrote:
Hi!!
No there isn't
Although, you can try bdb(www.sleepycat.com), it comes with a java
access class that will let you use bdb
Is it possible to create a InnoDB table and a MyIsam table with
fulltext indexes and use a join to search in fulltext indexes?
Santino
At 18:43 -0600 23-01-2004, Paul DuBois wrote:
At 18:34 -0600 1/23/04, Sidar LC. wrote:
How can I implement fulltext search engine on InnoDB and MySQL 5.
You
I installed MySql 4.0.x on MacOs 10.2.x and it works fine.
There are some problems of permissions: check /tmp and mysql data directory.
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
at that time) that stop indexes, perform
deletes, restart index.
(There is a bug in MySql 4.0.15 that corrupts indexes after a
restart index so I do an alter table to rebuild indexes). This script
takes about 6 Minutes.
Santino
--
MySQL General Mailing List
For list archives: http
Have You tryed:
SELECT A.id, COUNT(A.id), A.category FROM A, C WHERE
C.content_id=A.id AND A.status='Active' AND (C.stem_word_id IN (10,20,30))
GROUP BY A.id
Santino
At 13:08 -0500 19-11-2003, Mike Boone wrote:
Hi all,
I have used PHP and MySQL for years but have never tackled the amount
I think that mysql_connect is not defined in the MySqlClient lib.
I try to use it in a C proram but I get a link error.
I have to use mysql_real_connect.
Try to install compat library.
Santino
At 9:35 -0600 29-10-2003, John Nichel wrote:
Rob Wierenga wrote:
Thanks for the new MySQL server.
My
++)
printf( %s\t, CurrentRow[ k]);
printf( \n);
}
and it works
Try to add
mysql_data_seek( Result, 0);
before your loop.
Santino
At 14:06 -0800 26-10-2003, Carl B. Constantine wrote:
I'm writing an application and have the following SQL Query written in
C/GTK+ code
+0x11): In function `main':
/home/santino/java/mysql/top/Santino.cp:75: undefined reference to
`__gxx_personality_v0'
collect2: ld returned 1 exit status
If I remove all MySql calls in Santino.cp all works fine.
Can someone help me?
Thanks.
Santino
--
MySQL General Mailing List
For list archives
At the moment MySql indexes only plain text.
You have to convert your document to text and then insert the text
into the column.
Santino
At 9:50 +0200 23-10-2003, Jan-Erik Öhman wrote:
Hi,
has anybody done full-text indexing of pdf and word documents stored in TEXT
columns?
I could find
Hello,
I developed a small C client on RH Linux 7 with MySql 3.xx.
In the past I upgraded to RH 9 and MySql 4.0.12 and the program doesn'l link.
It give a linker error:
undefined reference to `__gxx_personality_v0'
in every mysql_* function i call.
How can I solve this problem?
Santino
fine but ascii char 128 are
mapped in different position so You have to convert them. (eg
aacute; eacute;).
Attention: There are few chars ( 10) of MacRoman set that don't
have an equivalent in ISO (eg Apple Symbol 0xf0 quotes 0xd2-0xd5).
Santino
--
MySQL General Mailing List
For list archives
Have You test in operator?
select * from table where id in (10,20,30,50,60,90, )
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and then relaunch mysql
Santino
PS: Disable automatic startup of MySql 3.xx from Application Utility
MySqlManager.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
It could be a permission problem on /tmp and/or mysql data directory.
OR You have not mysql internal tables (host, user, etc) in data/mysql.
Try to open a file named (yourhost).err in data directory and see why
mysql ended.
Santino
Does the installation of the PKG itself finish
mysqladmin shutdown
Santino
At 8:47 -0400 5-09-2003, Fortuno, Adam wrote:
All:
(1) I've got /user/local/mysql/data in my path, but when I attempt to run
mysqld_safe I get a message reading:
Please do a cd to the mysql installation directory and restart this script
from there as follows: ./bin
. I expect a size greater or equal
than the data file
( 134 471 560 data 61 629 440 of index).
Santino
At 12:32 -0700 28-08-2003, Mark wrote:
Hi,
I have a fulltext index on a table with 80,000 rows. when I do a
search for a common word it is very slow, for example:
select count(*) from resources
speed degrade can improve MySql and open
new opportunity to MySql.
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
suppose your table is people.
select people.Name, count( *) as cParent
from people left join people as p on ( people.ID=p.Parent)
group by people.Name order by cParent
I have not tested this.
You have to make indexes on Parent and ID.
Santino
At 8:36 -0500 15-08-2003, John Macon wrote:
Hi all
used it many times and it works fine!
Santino
At 8:49 -0700 11-08-2003, James Johnson wrote:
All,
I'm building a member signup form. Fields that contain more than one word
are being truncated when being inserted into the MySQL table.
I'm using this code that I got from one of my PHP books
tables in a join.
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on in php.ini file
echo -.$_Request[ Text].-; // in php = 4
Then after the insert You can add:
if( mysql_errno() != 0)
echo mysql_errno() . : . mysql_error() . BR\n;
to see if there was an error.
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
to write/read/list data)
Then:
./scripts/mysql_install_db --force
check again data
I hope this solve your problem.
Santino
At 13:43 -0400 23-06-2003, Pushpinder Singh Garcha wrote:
Is there an mysql directory in /usr/local/mysql/data?
[psg:/usr/local/mysql] psgarcha% sudo ls data
127.0.0.1.err
1. check if /usr/local/mysql/data has mysql user and r/w privileges
2. if /usr/local/mysql/data doesn't exist You have to launch mysql_install_db
3. See the your system.err file in /usr/local/mysql/data
I wrote a sample tutotial for MacOS 10.2 at
http://www.santinoc.com/mysql.html
Santino
In mysql 4.0.12:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*' in boolean mode );
Santino
Hello,
I have a table with just one column and with 1000 rows. It's indexed using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE
Check permissions (mysql) of data files.
Do You have host and mysql data files in your filesystem?
If not launch ./scripts/mysql_installdb
and relaunch te server.
There is a file named (your machine).err where You found more info about errors
Santino
Hello All,
I am using phpMyAdmin to administer
Have You deleted or updated te my.cnf file?
It seems to me that MySql is looking in the wrong dir or it dosn't
have permision in data dir ( user mysql.mysql rw permission).
Santino
At 16:46 +0100 7-06-2003, David Leader wrote:
First could I apologize for joining a mailing list primarily to ask
records (about 2k each) and all
works fine:
I rebuild index in minutes and the query needs only 1 or 2 seconds.
Santino
At 9:59 +0200 5-06-2003, H M Kunzmann wrote:
Hello All.
I am using Redhat 9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where
these step with Mac OS X Server (10.2.3).
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
81 matches
Mail list logo