Re: Win & Linux

2004-05-03 Thread Ivan Cukic (Foment)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Another question how can see the compatibility of authentification? | I don't know. It should be written in docs... Anyway, try the next thing... Try to create a symlink for every db except for mysql. create a symlink /var/lib/mysql/db1 -> /mnt/onedis

Re: Win & Linux

2004-05-01 Thread Ivan Cukic (Foment)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | | 4) My question is: Is it possible that de datadir was the same to | Win and Linux because i can't duplicate my databases? The disk2 is | read and write. If it is possible, how? You can create a symlink. Have you tested compatibility between MySQL 5

Re: oblivious to the obvious

2004-04-23 Thread Ivan Cukic (Foment)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | $result = mysql_query("UPDATE sunday SET | a5_n_1='$sun_5a_n1',a5_t_1='$sun_5a_t1'") What do you expect the UPDATE command to return? I think that you have the error here: | while($row = mysql_fetch_array($result)) { and here | mysql_free_result($

UTF text sorting

2004-01-28 Thread Ivan Cukic (Foment)
IS it possible to force mySQL to sort letters in different order - for example BCADEFGHI... instead of ABCDEFGHI...? I ask this question 'cause when sorting Serbian cyrilic, I get some letters before A, but A should be the first (that mixture is produced because those letters are placed badly in

Re: Getting the Parent Table for Returned Columns in a Relational Search

2004-01-11 Thread Ivan Cukic (Foment)
David Hutchison wrote: I am new to the list and glad to joining the MySQL community. I am trying to ascertain the table to which each column in a MySQL record set belongs in a relational search query. There may well be duplicate column names across tables. How can I query MySQL to tell me the

Re: Change storage location

2003-12-21 Thread Ivan Cukic (Foment)
Mysql Mysql wrote: Hi All, I have newly installed mysql 3.23.54 in Red Hat 9 (The one which was bundled with the OS). And default the data storage file location went to /var/lib/mysql, how do I change the location to /mysql, I have also tried modifying my.cnf it didn't help. Any suggestion. -m

Re: Duplicate combination

2003-12-14 Thread Ivan Cukic (Foment)
fr0g wrote: I have a table with peoples names in 3 different languages. Fields are like: id, surname_english, name_english, surname_original, name_original, surname_greek, name_greek. What I want is to check if a person has been entered twice in that table. You can create unique index on (surname_

Re: Licence question

2003-12-08 Thread Ivan Cukic (Foment)
Does this mean that I must make all of my web sites non-commercial? (since I use mySQL as my main DBMS) This was sarcastic, not real question aiming the next sentence MySQL> "You need a license if you sell a product designed specifically for use with MySQL or that requires the MySQL server to fun

Re: Licence question

2003-12-07 Thread Ivan Cukic (Foment)
"You need a license if you sell a product designed specifically for use with MySQL or that requires the MySQL server to function at all. This is true whether or not you provide MySQL for your client as part of your product distribution." Does this mean that I must make all of my web sites non-co