Re: Win Linux
-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/onedisc/Program\ Files/mysql/data/db1 create a symlink /var/lib/mysql/db2 - /mnt/onedisc/Program\ Files/mysql/data/db2 create a symlink /var/lib/mysql/db3 - /mnt/onedisc/Program\ Files/mysql/data/db3 this way you can control which databases will be shared between win and lin. Regards, Ivan -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAlmSuTGB93IULb3YRAmt1AJ4wyI31vgXS/OwdpkxerolyfLdpiQCfZcFW PZ26ss5LaXM9KFosh2PEd8Y= =pdaD -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Win Linux
-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 and 4 concerning authentification? You should install the same versions even if it doesn't fix this error. Ivan - -- To mess up a Linux box, you need to work at it; to mess up your Windows box, you just need to work on it. - - Scott Granneman, Security Focus -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAk4MDTGB93IULb3YRAnmjAKCA/OYTxhHwKDhxrcsVk9trcttXBQCfSe4n pzotE7mWlxu9zEet6KmP5O4= =ayfv -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: oblivious to the obvious
-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($result); and not in the lines you've marked, because there is no result of the UPDATE command. Best regards, Ivan - -- To mess up a Linux box, you need to work at it; to mess up your Windows box, you just need to work on it. - - Scott Granneman, Security Focus -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAiXisTGB93IULb3YRAswrAKDdEicezEU0azJ/0jLQAp+nveMehACfV27e 9biw3qvLCcz4BS5nYAmPFE4= =yuzU -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UTF text sorting
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 Unicode standard) Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting the Parent Table for Returned Columns in a Relational Search
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 parent table for each column in the record set? Thanks kindly. dave SELECT a.name as aname, b.name as bname FROM atable as a, btable as b WHERE ...; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Change storage location
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. -mysql - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing Copy /var/lib/mysql to /mysql and create symlink /var/lib/mysql - /mysql Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Duplicate combination
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_english, name_english) and others... UNIQUE KEY unique_key_name (surname_english, name_english) Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Licence question
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 function at all. This is true whether or not you provide MySQL for your client as part of your product distribution. If I get GPLicensed mySQL I can distribute it (according to GPL) with my commercial (even non GPL) product or with anything I like if I don't merge it with my project or similar which is mentioned in GPL. Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Licence question
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-commercial? (since I use mySQL as my main DBMS) This part is surely not covered by GPL. Especially because GPL doesn't cover commercial aspect of software. GPL Our General Public Licenses are designed to make sure that you GPL have the freedom to distribute copies of free software GPL (and charge for this service if you wish), According to this I can even redistribute mySQL under the terms of GPL and even to get money from such business. Which doesn't comply with the text from the mySQL's website... Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]