Move couple files to another directory/hard drive

. -- Grzegorz Paszka -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

problem with encoding utf8 in text field

Hi all. In my apps I use two languages: english and my national polish. Translates i keep in MySQL 5.0 in text field (MyISAM engine) with utf8 encodings. I don't know why but i can get polish translates from databes properly, my national character are seen from webb like sign ?. I connect to

Strange problem with index

table, mysqldump and insert it again, but problem still exists. I read that such error occurs when I insert no unique value to column with unique property. But as you can see I haven't UNIQUE key anywhere. I need help becouse I don't know what to do. Regards. -- Grzegorz Paszka -- MySQL

Optimize table vs. dump and insert

Hi. I wonder if optimize table results are equal to dump such table and insert it back ? Regards. -- Grzegorz Paszka sql,mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqld problem

I have problem with running mysqld I installed the following rpm packages incladed with RedHat 7.1 (Seawolf) edition cd`s which I am running on my machine: -mysql-3.23.36-1 - mysql-server-3.23.36.1 - mysql-devel-3.23.36-1 First I tried to initialize as a root tables with following command:

Re: FULLTEXT index on two tables and many columns

unlimited qualifiers without having to modified the structure of your tables or indexes. Your idea is very interesting. Of course, this is all based on your simplified example. Now I must think over if I am able to implement it in my more complex situation :) Thanks. -- Grzegorz mysql,sql,query

FULLTEXT index on two tables and many columns

there is need to perform search on many columns than I should create 5 indexes on a,b,c,d and e. These should to be enough. Maybe search won't be so fast as with 31 indexes but should be faster than search without 31 indexes. Regards. -- Grzegorz mysql,sql,query

Escape char in fulltext search

On Tue, Nov 26, 2002 at 02:30:41PM +0100, Sergei Golubchik wrote: On Nov 25, Grzegorz Paszka wrote: Hi. Could You explain me for what is macro misc_word_char ? A word must have true_word_char on both ends, and there should not be two adjacent misc_word_char's in the word. E.g

FULLTEXT search and ORDER BY

. Results are still sorted by score from MATCH AGAINST phrase. I know that such order by breaks philosophy of MATCH AGAINST, but when I want sort results in different way I should be able to do this. How can I solve this problem and force mysql to do what I want ? :) Regards. -- Grzegorz

Words in fulltext search

. -- Grzegorz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED

Strange FULLTEXT search results in 4.0.2alpha

ft_static.c file and there isn't rpm word. Regards. -- Grzegorz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Problem: myisamchk: error: Checksum for key....

On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote: Grzegorz Paszka writes: Yes, I say more, that I created new database and filled it by perl script from data source and I have the same situation. I think that is the best way of rebuild index file :) See in our manual

Re: Problem: myisamchk: error: Checksum for key....

On Mon, Nov 12, 2001 at 03:22:31PM +0200, Sinisa Milivojevic wrote: Grzegorz Paszka writes: Hi. I've problem with mysql. I had i386 RH71 (kernel 2.4.13, 1.5GB RAM, single procesor) with mysql 3.23.36 (now I have 3.23.41 and problem still exists). I run myisamchk on table