Possible bug in mysqldump with 5.0.0/InnoDB longblobs?
I have been running into problems with mysqldump. I have not been able to figure out why mysqldump isnt working as I hope it would. Anyway I thought I'll make the mysql-list aware of the problem and hopefully it will help someone. Or better yet someone knows what I am doing wrong and could point it out to me ;) Problem: After running mysqldump my longblob data gets corrupted. All other table data is dumped correctly. I have tried mysqldump on both a Linux and OpenBSD system with the same result. If I used SELECT INTO OUTFILE I was able to dump the longblod data and later use LOAD DATA INFILE to restore it correctly. How I use mysqldump: mysqldump --add-drop-table --force --single-transaction -u user -p password myDB dumpfile My linux specs: MySQL 5.0.0-alpha InnoDB tables My OpenBSD specs: MySQL 5.0.0 debug binary release from mysql.com InnoDB tables /Jonas
Select statement returning to many answers
Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this query I get 153 hits. SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b; But when I add this table to the where clause i get 5831 hits SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b, cd_donor as d; Why does this happend? I thought that these two queries would return the exact same amout of rows. Is there something I have forgotten or is the debug release of 5.x.x errornous? Regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select statement returning to many answers
Thank you everyone that responded, You were all correct. The query performed a cartesian product. I added a where statement and all was fine again. Thanks! /Jonas - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 24, 2004 12:16 PM Subject: Re: Select statement returning to many answers Jonas Lind?n [EMAIL PROTECTED] wrote: Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this query I get 153 hits. SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b; But when I add this table to the where clause i get 5831 hits SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b, cd_donor as d; Why does this happend? I thought that these two queries would return the exact same amout of rows. Is there something I have forgotten or is the debug release of 5.x.x errornous? You got in the result set cartesian product of cd_batch and cd_donor tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql blobs
Hello, I tried dumping my innodb tables that contain blobs. No errors are returned from mysqldump but I cannot restore the blob data. I have used the below mysqldump statement. mysqldump --opt --add-drop-table --force --single-transaction -uxxx -pxxx --databases myDB bakupFile I restore the backupFile with mysql -uxxx -pxxx backupFile Everything is included in the restured database except the blob data. When I look in backup file I can see that all my blod data has been replaced by -. What causes this? Regards /Jonas
LDAP and MySQL?
Has anyone fooled around with LDAP and MySQL? Could the standard user table in mysql be replaced with a LDAP binding? Have not done any research but I think I remeber people talking about this some time ago. Or maybe I am mistaken ;). Anyone tried something like this? /Jonas
NetBSD MySQL
Are there any NetBSD users on this list? Has anyone succesfully compiled MySQL 4.1x or 5.x on NetBSD? Why arent they in pkgsrc? Not just done yet or did something happend in the 4.1.x release that stopped MySQL from working on NetBSD? Regards /Jonas
Managing users in different OS enviroments with MySQL
Hello, Me and a few others are developing om linux boxes running MySQL 5.0.0. We often create users with different access rights on our development boxes and then it often occours problems with users when our programs goes into production. I would like to find a common user enviroment for our database users. I was thinking that we could perhaps use our Active Directory service which is running on a windows server in our network. Would it be possible to avoid using MySQLs own mysql (mysql.user, mysql.db and so on) database and instead directly authenticate against our active directory? Or is that not a smart way to go? Any suggestions are welcome /Jonas
Changeing a columns type with alter
Hello list, Could anyone help me on how I go about if I would like to change a coulmns type from say INT to FLOAT? Should I use the ALTER command? I cant seem to find any info on it in the manual. Regards /Jonas
Re: Changeing a columns type with alter
Doh! dont bother I found it in the manual ALTER TABLE t1 CHANGE c1 c1 BLOB; /Jonas - Original Message - From: Jonas Lindén [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 15, 2004 9:46 AM Subject: Changeing a columns type with alter Hello list, Could anyone help me on how I go about if I would like to change a coulmns type from say INT to FLOAT? Should I use the ALTER command? I cant seem to find any info on it in the manual. Regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binlog strangeness?
hello, I came upon a strange thing just recently. I was trying to pipe a few sql statements but got a 1025 error all the time. I restarted, erased database manually but nothing worked so I tried deleting the binlogs and then my error disapered and everything was as normal. In what way does the bin log interfere with my data? Does MySQL read bin log and compare them in some way with new data? Anyone ? /Jonas
Re: Binlog strangeness?
Hi MySQL 5.0.0, Mandrake 9.2 and the error pointed to my alter table statement where tried to add a foreign key constraint. I have been fiddling a little bit with replication priot to this error but I commented all of that data out of the my.cnf file. Regards /Jonas - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 05, 2004 2:17 PM Subject: Re: Binlog strangeness? Jonas Lind?n [EMAIL PROTECTED] wrote: hello, I came upon a strange thing just recently. I was trying to pipe a few sql statements but got a 1025 error all the time. I restarted, erased database manually but nothing worked so I tried deleting the binlogs and then my error disapered and everything was as normal. In what way does the bin log interfere with my data? Does MySQL read bin log and compare them in some way with new data? What SQL statements have you tried to execute? Which version of MySQL do you use? What OS? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication between different database names
Hello, Is this what you are lookin for? --replicate-rewrite-db=from_name-to_name Regards /Jonas I have a central mysql server that is required to be a slave to many different master databases on my customer sites. Is it possible to replicate many masters to one slave where the masters have the same DB name?? i.e. do this . customer Acentral site DB = cust --- replicate to - DB = cust_A customer B central site DB = cust replicate to - DB = cust_B etc etc Thanks Andy -- perl -e 'print qq^;@) [###]^^qq^z\.MY{eLQ9^' in:control developer, Telindus, RG27 9HY DDI: +44 1256 709211, GSM: +44 7810 636652 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems replicating
Hello, I still trying to get my replication working witout success. I included show processlist and show slave status. Can anyone make out from them what I am lacking? I am running mysql 5.0.0 on a linux master trying to replicate them on a windows slave Best regards /Jonas *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: myMaster.com Master_User: repl Master_Port: 3307 Connect_Retry: 60 Master_Log_File: myMaster-bin.01 Read_Master_Log_Pos: 1469782 Relay_Log_File: jonas-linden-relay-bin.05 Relay_Log_Pos: 231 Relay_Master_Log_File: myMaster-bin.01 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: celldb Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1469782 Relay_Log_Space: 136 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 238384 1 row in set (0.00 sec) mysql show processlist\G; *** 1. row *** Id: 255 User: root Host: localhost:1886 db: celldb Command: Query Time: 0 State: NULL Info: show processlist *** 2. row *** Id: 448 User: system user Host: db: NULL Command: Connect Time: 339 State: Waiting for master to send event Info: NULL *** 3. row *** Id: 452 User: system user Host: db: NULL Command: Connect Time: 317 State: Has read all relay log; waiting for the slave I/O thread to update Info: NULL 3 rows in set (0.00 sec)
Re: Problems replicating
Hola, I figured it out myself, The problem was that I didnt specify any tables. I thought that if you replicated a database the tables would be included. That is not the case. I added this to make it work. Replicate_Wild_Do_Table: CellDB%.% Regards /Jonas - Original Message - From: Jonas Lindén [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 10:33 AM Subject: Problems replicating Hello, I still trying to get my replication working witout success. I included show processlist and show slave status. Can anyone make out from them what I am lacking? I am running mysql 5.0.0 on a linux master trying to replicate them on a windows slave Best regards /Jonas *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: myMaster.com Master_User: repl Master_Port: 3307 Connect_Retry: 60 Master_Log_File: myMaster-bin.01 Read_Master_Log_Pos: 1469782 Relay_Log_File: jonas-linden-relay-bin.05 Relay_Log_Pos: 231 Relay_Master_Log_File: myMaster-bin.01 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: celldb Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1469782 Relay_Log_Space: 136 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 238384 1 row in set (0.00 sec) mysql show processlist\G; *** 1. row *** Id: 255 User: root Host: localhost:1886 db: celldb Command: Query Time: 0 State: NULL Info: show processlist *** 2. row *** Id: 448 User: system user Host: db: NULL Command: Connect Time: 339 State: Waiting for master to send event Info: NULL *** 3. row *** Id: 452 User: system user Host: db: NULL Command: Connect Time: 317 State: Has read all relay log; waiting for the slave I/O thread to update Info: NULL 3 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction Not supported
Sorry Mike, Joshua is absolutly correct. Dont listen to my nonses ;) What I did was trying to use something like this which to my knowledge doesnt work on MySQL servers. $dbh-commit(); $dbh-rollback(); /Jonas - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 9:02 AM Subject: Re: Transaction Not supported On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like: I dont think that transactions are supported (yet?) by the PERL DBI. to Mike Blezien [EMAIL PROTECTED]. My response follows. Yes they are...at least I have used them in a project before using Perl::DBI. [EMAIL PROTECTED] ~]$ perl use DBI; print $DBI::VERSION, \n; 1.37 [EMAIL PROTECTED] ~]$ My mysql.pm shows $VERSION = '2.0419' Are you sure you are connecting to an InnoDB database and that you are doing transactions on InnoDB tables? My code is rather simple: #Begins the transaction $dbh-do('BEGIN'); . . . . $dbh-do('COMMIT'); What does your code look like? j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction Not supported
I dont think that transactions are supported (yet?) by the PERL DBI. /Jonas - Original Message - From: Mike Blezien [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 9:42 PM Subject: Transaction Not supported Hello, I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too: Error: Transactions not supported by database at module. bla..bla I realize this maybe a DBI question, but I thought I'd check here first incase we missed something is the settings for the MySQL server Version: 4.0.17-standard - Official MySQL-standard binary and it has innodb enabled, the autocommit is set to 1, then when the transaction is executed, the autocommit is set to 0 untill the commit is called Is there something in the variables I can check to make sure transaction have been enabled ?? TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication in mysql5 between linux and windows
Hello list, I have successfully installed mysql5 on my windows box and my aim is set on replicating my mysql5 linux system. I think I am on the right track and the systems seem to talk to eachother according to my logs. My problem is that nothing is replicated in my databases but I think that the replication position pointer is increasing. My conclusion is that something is replicated but not add to my databases? This is a snippet from my mysql.err log on my windows box which to me seem to replicate something. If I add data to my linux mysql database and then restart the windows mysql system it seems that the log file has increased? My mysql.err file on my windows box at startup before updating. 040329 11:20:03 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3307', replication started in log 'lavazza-bin.04' at position 60801 Adding something on my linux box and the restarting my windows mysql database I recive this in my mysq.err 040329 11:28:41 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3307', replication started in log 'lavazza-bin.04' at position 112037 To me it seems that something has increased the log position pointer? But my database has not been updated. Has anyone a suggestion to what might be the reason for my problem? Could my problem be that I am running InnoDB tables? I successfully managed to update my slave tables with LOAD DATA FROM MASTER so there is some kind of connection between the two atleast. Best regards /Jonas Lindén
Re: replication in mysql5 between linux and windows
- Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 29, 2004 3:54 PM Subject: Re: replication in mysql5 between linux and windows Jonas Lind?n [EMAIL PROTECTED] wrote: Hello list, I have successfully installed mysql5 on my windows box and my aim is set on replicating my mysql5 linux system. I think I am on the right track and the systems seem to talk to eachother according to my logs. My problem is that nothing is replicated in my databases but I think that the replication position pointer is increasing. My conclusion is that something is replicated but not add to my databases? This is a snippet from my mysql.err log on my windows box which to me seem to replicate something. If I add data to my linux mysql database and then restart the windows mysql system it seems that the log file has increased? My mysql.err file on my windows box at startup before updating. 040329 11:20:03 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3307', replication started in log 'lavazza-bin.04' at position 60801 Adding something on my linux box and the restarting my windows mysql database I recive this in my mysq.err 040329 11:28:41 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3307', replication started in log 'lavazza-bin.04' at position 112037 To me it seems that something has increased the log position pointer? But my database has not been updated. Has anyone a suggestion to what might be the reason for my problem? Could my problem be that I am running InnoDB tables? I successfully managed to update my slave tables with LOAD DATA FROM MASTER so there is some kind of connection between the two atleast. Show the output of SHOW SLAVE STATUS command. What replication options do you use? Hello this is my show slave status. What replicatin options I use? well I want to replicate everything which I think I am doing but I havent explicitly noted that any where. Where do I set my replication options? regards /Jonas mysql show slave status\G; *** 1. row *** Slave_IO_State: Master_Host: lavazza.mydomin.com Master_User: repl Master_Port: 3307 Connect_Retry: 60 Master_Log_File: lavazza-bin.06 Read_Master_Log_Pos: 95 Relay_Log_File: jonas-relay-bin.09 Relay_Log_Pos: 231 Relay_Master_Log_File: lavazza-bin.06 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: myDB Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 95 Relay_Log_Space: 136 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 16013 1 row in set (0.00 sec) ERROR: No query specified -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
row level access?
Is it possible to grant access to individual rows in a table in MySQL? regards /Jonas
Replication question
Hello list, I am about to embark on a little repliction mission;) I was thinking about setting up a MySQL slave on my Windows box and replicate my MySQL 5.0 Master which runs on my Linux box. Could the mix of architectures become a problem? I also use innodb tables alot, are they replicateble? or are just MyISM tables replicatable. I have not tried anything yet just thought I ask around abit first:) Best regards /Jonas Lindén
install issues
Hello people, I made a mistake and installed mysql5 under /usr/local :(. Now I want to remove the files installed by make install how can I do that? regards /Jonas
How to present query time through perl
Hello list, I am trying to find a way to retrive the time a certain select statement took for debug purposes. If I execute a select statement in the mysql console I get the time that select statement took to execute. I am searching for a way to retrive that value. Right now I am using the perl:dbi to connect to my mysql db. Has anyone managed to do this? Best regards /Jonas
LIKE % not including NULL values?
Hello list SELECT * FROM testdb WHERE col1 LIKE '%' The above SELECT statement doesnt return columns with NULL values. Should it? ;). Should I approce the problem in another direction? Regards /Jonas
Re: LIKE % not including NULL values?
Thats true, but the actuall query looked more like this SELECT * FROM testdb WHERE col1 LIKE '$var%' and if I left the $var empty my plan was to get all columns. But I use the OR col1 IS NULL trick which solved my problem. Thanks anyway /Jonas If you want all values why not just do SELECT * FROM testdb ... The `%` will not match NULL values. Original Message On 3/3/04, 9:41:22 AM, Jonas Lindén [EMAIL PROTECTED] wrote regarding LIKE % not including NULL values?: Hello list SELECT * FROM testdb WHERE col1 LIKE '%' The above SELECT statement doesnt return columns with NULL values. Should it? ;). Should I approce the problem in another direction? Regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Transfering from access to MySQL?
Hello, Could someone help me with a tip on how I can convert my old Access DBs to MySQL? Regards /Jonas
Where to find ibbackup
Hello, I am runing mysql5.x and have just started fiddeling with how I should back up my innodb databases. I started reading about ibbackup and think it suits me. But the problem is I cant find it ;) Does ibbackup come with mysql or should I download it separatly from somewhere else? Anyone using it who could give me a hint? regards /Jonas
Re: Where to find ibbackup
alright, then I´ll probably go for mysqldump, thanks /Jonas Jonas Lind?n [EMAIL PROTECTED] wrote: Hello, I am runing mysql5.x and have just started fiddeling with how I should back up my innodb databases. I started reading about ibbackup and think it suits me. But the problem is I cant find it ;) Does ibbackup come with mysql or should I download it separatly from somewhere else? Anyone using it who could give me a hint? ibbackup is non-free software and it's not included in the MySQL distribution: http://innodb.com/order.php For backup of InnoDB tables you can also use mysqldump utility: http://www.mysql.com/doc/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL-HELP
Hello, you might want to try select DISTINCT ? http://www.mysqlfreaks.com/statements/18.php /Jonas - Original Message - From: Carl Schéle, IT, Posten [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 3:49 PM Subject: SQL-HELP Hello! I got a table, champions, looking like this: id winner_1 winner_2 0carl mattias 1daniel carl 2erik daniel 3erik johan What I want is to retrieve the unique names ie: carl mattias daniel erik johan I use MySQL 3.23.58 (which means I can't use sub-selects). /Carl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can mysql do DESC indexes?
Hello, can the new version of mysql 5 do reversed indexes? CREATE INDEX table ON (name(10) DESC); In manual it is described to be a fortcoming feature but and to be ignored in present version. regards /Jonas
path for my.cnf with dual mySQL installations
Hello, I have been fiddeling with MySQL5 alpha for a little testing sessions but I kept my MySQL4 installation. The problem is that I cant set the path for my my.cnf file for MySQL5. I can use my.cnf if I put in /etc but then it conflicts with my other MySQL installation. Does anyone have a tip for where I can staticly set the path for my.cnf` for one of my MySQL installations? Regards /Jonas