Move couple files to another directory/hard drive

2008-02-22 Thread Grzegorz Paszka
. -- 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

2006-03-24 Thread Grzegorz Smith
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 databa

Strange problem with index

2004-01-20 Thread Grzegorz Paszka
myisamchk -r , optimize table, repair 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.

Optimize table vs. dump and insert

2004-01-13 Thread Grzegorz Paszka
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

2003-06-04 Thread Grzegorz Golofit
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: mysql_i

Re: FULLTEXT index on two tables and many columns

2003-02-27 Thread Grzegorz Paszka
Finally, this structure allows you to create 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

FULLTEXT index on two tables and many columns

2003-02-26 Thread Grzegorz Paszka
s when 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. -- Grze

Escape char in fulltext search

2003-01-18 Thread Grzegorz Paszka
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

FULLTEXT search and ORDER BY

2002-10-01 Thread Grzegorz Paszka
select doesn't work as I want. 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 wa

Words in fulltext search

2002-08-17 Thread Grzegorz
ccepted" by fulltext search ? 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-mail <[EM

Strange FULLTEXT search results in 4.0.2alpha

2002-06-22 Thread Grzegorz Paszka
lues (10,'test'); And still: mysql> select * from test where match (body) against ('+rpm' IN BOOLEAN MODE); Empty set (0.00 sec) Am I doing something wrong ? I checked ft_static.c file and there isn't "rpm" word. Regards. -- Grzegorz ---

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

2001-11-22 Thread Grzegorz Paszka
usion. Best 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-mail <[EMAIL PROTECTED]&

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

2001-11-19 Thread Grzegorz Paszka
linux-kernel becouse my tests show that it may be a linux kernel (2.4.x) memory problem with 1.5GB of RAM. I'm waiting for any respose or advice now. Test on another hardware is in progress. When I'll have time I'll try my

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

2001-11-13 Thread Grzegorz Paszka
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 >inde

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

2001-11-12 Thread Grzegorz Paszka
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 prob