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-
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 woul
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 a
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
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
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
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 (than
e 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 t
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="
(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://list
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 Ma
find
your 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
s can slow down 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
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
sql failed.
Type perror errornumber to have 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
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 sea
on_connection | 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 Ro
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
on_connection | 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. B
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
.. the Cardinality of the key is null.
If I create the table without the second index, add some 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
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.
MYSQL>select dayofyea
join OCCUPAZIONI on
OCC_ID_AUL=AUL_ID and OCC_DATA='2004-11-10'
where 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]
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 Mailin
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 = &#x
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 k
ease, can someone help me?
Thanks
Santino
T
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
At
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 o
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 &
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`.`keywor
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,
aving ftfield rlike 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, d
Try to delete 'in boolean mode'
Santino
At 12:42 -0700 5-10-2004, Ed Lazor wrote:
> -Original Message-
Try this:
select column1, match(column1) against ('+orange -fruit' IN BOOLEAN MODE)
as score
from some_table where match(column1) against('+orange -fruit&
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
e licenses!!
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
serts 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 arch
use i 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 seri
Now a question:
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 w
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]
ion) 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 archi
PPE_A" in php
with a loop it takes less 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 t
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
but quite confusing. 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]
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]
lete are slow but I have a cron
script that start at 1:00AM
(nobody uses the DB 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
tak
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
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
Santino.o(.eh_frame+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
lds; k++)
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 follo
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
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 no
hars < 128 all works fine but ascii char > 128 are
mapped in different position so You have to convert them. (eg
á é).
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 Ma
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]
ry to execute mysqladmin --shutdown
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 fin
To stop
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 re
e is small. 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:
sele
atures with no great 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
in a terminal with mysql?
I 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 t
& MyIsam 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]
ve Globals 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() . "\n";
to see if there was an error.
Santino
--
MySQL G
ne 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. 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 .err file in /usr/local/mysql/data
I wrote a sample tutotial for MacOS 10.2 at
http://www.santinoc.com/mysql.html
Santino
Content-Tra
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
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'v
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 t
0.000 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&#x
owed 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]
82 matches
Mail list logo
