Re: command is not allowed with this MySQL version
- Original Message - From: yoku ts. yoku0...@gmail.com Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun to know what the OLD version was, too. Maybe you missed *mysql command-line client's --local-infile option* Not particularly helpful, since Christophe already said it's a PHP application :-) -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
[Solved] Re: command is not allowed with this MySQL version
Hi, Le 12/12/2014 11:51, Johan De Meersman a écrit : - Original Message - From: yoku ts. yoku0...@gmail.com Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun to know what the OLD version was, too. Absolutely no idea : The app was running on a shared hosting, and don't have access to it ... Maybe you missed *mysql command-line client's --local-infile option* Not particularly helpful, since Christophe already said it's a PHP application :-) Right :) and the solve was in PHP behavior (all seems fine now ...) . The configuration was fine, but to take care of 'local-infile' parameter in PHP configuration (and on Debian) the php5-mysqlnd package must be installed instead of php5-mysql. Hoping this can help someone in the future. Regards. Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: command is not allowed with this MySQL version
2014/12/12 02:10 +0100, Christophe When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables (local_infile for instance) can be used to get rid of this error, but can't really find the right configuration. Well, yes, if local_infile is 0 or FALSE then 'LOCAL' is forbidden. If 'LOCAL' is not used then the MySQL user needs privilege 'FILE' to read from the server s own disk. What else have you tryed, with what outcome? because the statement as it stands is good MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
command is not allowed with this MySQL version
Hi there, One of our customers would like to modernize his IT : new servers with new OS, etc. But he got an old fashion PHP/MySQL application that make queries like this : LOAD DATA LOCAL INFILE '/files/tmp_import.csv' IGNORE INTO TABLE users FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES (@dummy, nom, prenom, @dummy, @dummy, email, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy) When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables (local_infile for instance) can be used to get rid of this error, but can't really find the right configuration. Is there any way to do this ? Thanks and regards. Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: command is not allowed with this MySQL version
- Original Message - From: Christophe t...@stuxnet.org Subject: command is not allowed with this MySQL version 'The used command is not allowed with this MySQL version' Out of sheer morbid curiosity, what version were they running? -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: command is not allowed with this MySQL version
Hi, Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. Maybe you missed *mysql command-line client's --local-infile option* $ bin/mysql mysql SELECT @@version; ++ | @@version | ++ | 5.5.40-log | ++ 1 row in set (0.00 sec) mysql SELECT @@local_infile; ++ | @@local_infile | ++ | 1 | ++ 1 row in set (0.00 sec) mysql LOAD DATA LOCAL INFILE '/files/tmp_import.csv' INTO TABLE users FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES (@dummy, nom, prenom, @dummy, @dummy, email, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy); ERROR 1148 (42000): The used command is not allowed with this MySQL version $ bin/mysql --local-infile mysql LOAD DATA LOCAL INFILE '/files/tmp_import.csv' INTO TABLE users FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES (@dummy, nom, prenom, @dummy, @dummy, email, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy); ERROR 1146 (42S02): Table 'd1.users' doesn't exist Would you try it? yoku0825, 2014-12-12 11:00 GMT+09:00 Johan De Meersman vegiv...@tuxera.be: - Original Message - From: Christophe t...@stuxnet.org Subject: command is not allowed with this MySQL version 'The used command is not allowed with this MySQL version' Out of sheer morbid curiosity, what version were they running? -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: How to get all known bugs on specified mysql version?
don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the bugfix section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated! -- Phone: +86 1868061 Email Gtalk: yloui...@gmail.com Personal Blog: http://www.vmcd.org
Re: How to get all known bugs on specified mysql version?
Why do not use GTID? Just curious...WB 2014-07-07 3:18 GMT-03:00 louis liu yloui...@gmail.com: don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the bugfix section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated! -- Phone: +86 1868061 Email Gtalk: yloui...@gmail.com Personal Blog: http://www.vmcd.org
Re: How to get all known bugs on specified mysql version?
Am 07.07.2014 12:37, schrieb wagnerbianchi.com: Why do not use GTID? Just curious...WB just read the changelogs and endless count of bugreports it's a new feature and it works as buggy as replication years ago where you had the rebuild the slave all the time and maybe still if temporary tables and memory tables are part of the game - i had a reason to switch to normal tables with hash-names and remove them finally since that didn't break replication all the time 2014-07-07 3:18 GMT-03:00 louis liu yloui...@gmail.com: don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the bugfix section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated! signature.asc Description: OpenPGP digital signature
Re: How to get all known bugs on specified mysql version?
Hello, On 7/6/2014 7:42 PM, 娄帅 wrote: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the bugfix section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated! The easiest way to see which bugs are pending is to actually search the bugs database, http://bugs.mysql.com Here is one example search you can perform. Note, many of these bugs (such as bug #49728) are low-impact edge-cases that are prioritized lower than other more important high-impact bugs. Our development teams have limited resources. We triage and prioritize what they can work on based on how severe the bug is, how often is may be encountered, and how easy it may be to work around. http://bugs.mysql.com/search.php?search_for=status[]=Activeseverity=limit=Allorder_by=idcmd=displayphpver=5.5os=0os_details=bug_age=0tags=similar=target=last_updated=0defect_class=allworkaround_viability=allimpact=allfix_risk=allfix_effort=alltriageneeded= Anyone can join the fight! Start by submitting an OCA (Oracle Contributor's Agreement). http://www.oracle.com/technetwork/community/oca-486395.html If you have any questions about the OCA, please contact the MySQL community team. http://www.mysql.com/about/contact/?topic=community Then, any patches you provide can be analyzed, possibly improved, and potentially merged into the actual source code. For some recent examples, see: http://www.tocker.ca/2014/06/09/mysql-5-6-19-community-release-notes.html -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
How to get all known bugs on specified mysql version?
Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the bugfix section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated!
RE: MySQL version 3.23 to 5.x features
Assuming that your goal is to migrate an old database, perhaps the things that will bite you the fastest: * TYPE=MyISAM -- ENGINE=MyISAM. * CHARACTER SETs -- no concept in until 4.1. Use DEFAULT CHARACTER SET=latin1 for now. Later you can figure out how to migrate to utf8. (Note that 5.5 defaults to utf8, which is likely to dislike your bytes.) I would dump the data, then import into 5.x. Upgrading step by step would be quite tedious. Migration to InnoDB is also desirable, but not mandatory. -Original Message- From: Nagaraj S [mailto:nagaraj@gmail.com] Sent: Thursday, August 22, 2013 12:16 AM To: shawn green Cc: mysql@lists.mysql.com Subject: Re: MySQL version 3.23 to 5.x features wow it really helped me a lot. I really thank Shawn,Dale Jesper for there inputs On Wed, Aug 21, 2013 at 7:13 PM, shawn green shawn.l.gr...@oracle.comwrote: Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of mysql features While not exactly just one single page for all changes, there is a single page of the fine manual within each new major version that describes the big features that are new or changed within that version. http://dev.mysql.com/doc/**refman/5.0/en/mysql-nutshell.**htmlhttp:// dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html http://dev.mysql.com/doc/**refman/5.1/en/mysql-nutshell.**htmlhttp:// dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html http://dev.mysql.com/doc/**refman/5.5/en/mysql-nutshell.**htmlhttp:// dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html http://dev.mysql.com/doc/**refman/5.6/en/mysql-nutshell.**htmlhttp:// dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html Unfortunately, to learn what we changed between 3.23 - 4.0 or between 4.0 - 4.1, you are going to need to review the change logs http://dev.mysql.com/doc/**refman/4.1/en/news.htmlhttp://dev.mysql.co m/doc/refman/4.1/en/news.html from http://dev.mysql.com/doc/**refman/4.1/en/index.htmlhttp://dev.mysql.c om/doc/refman/4.1/en/index.html This manual describes features that are not included in every edition of MySQL 3.23, MySQL 4.0, and MySQL 4.1; such features may not be included in the edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1; licensed to you. I can pretty much summarize the deficiencies in 3.23 like this * No InnoDB, Archive, CSV, Federated, or Blackhole storage engines * No table partitioning * No Views * No Stored Procedures or Stored Functions * No Triggers * No Events * Severe scalability limits (won't run as fast with reasonably concurrent loads even on great hardware as later versions) * Completely out of print (unpublished) and unsupported. * Missing literally thousands of bug fixes and performance improvements Any new project should be starting out with 5.6. Any production server should be on 5.5 or 5.6 by now or migrating soon. It is also a fairly safe bet that if you are still operating a 3.23 instance of MySQL that it is also time to upgrade your hardware. Regards, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL version 3.23 to 5.x features
wow it really helped me a lot. I really thank Shawn,Dale Jesper for there inputs On Wed, Aug 21, 2013 at 7:13 PM, shawn green shawn.l.gr...@oracle.comwrote: Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of mysql features While not exactly just one single page for all changes, there is a single page of the fine manual within each new major version that describes the big features that are new or changed within that version. http://dev.mysql.com/doc/**refman/5.0/en/mysql-nutshell.**htmlhttp://dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html http://dev.mysql.com/doc/**refman/5.1/en/mysql-nutshell.**htmlhttp://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html http://dev.mysql.com/doc/**refman/5.5/en/mysql-nutshell.**htmlhttp://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html http://dev.mysql.com/doc/**refman/5.6/en/mysql-nutshell.**htmlhttp://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html Unfortunately, to learn what we changed between 3.23 - 4.0 or between 4.0 - 4.1, you are going to need to review the change logs http://dev.mysql.com/doc/**refman/4.1/en/news.htmlhttp://dev.mysql.com/doc/refman/4.1/en/news.html from http://dev.mysql.com/doc/**refman/4.1/en/index.htmlhttp://dev.mysql.com/doc/refman/4.1/en/index.html This manual describes features that are not included in every edition of MySQL 3.23, MySQL 4.0, and MySQL 4.1; such features may not be included in the edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1; licensed to you. I can pretty much summarize the deficiencies in 3.23 like this * No InnoDB, Archive, CSV, Federated, or Blackhole storage engines * No table partitioning * No Views * No Stored Procedures or Stored Functions * No Triggers * No Events * Severe scalability limits (won't run as fast with reasonably concurrent loads even on great hardware as later versions) * Completely out of print (unpublished) and unsupported. * Missing literally thousands of bug fixes and performance improvements Any new project should be starting out with 5.6. Any production server should be on 5.5 or 5.6 by now or migrating soon. It is also a fairly safe bet that if you are still operating a 3.23 instance of MySQL that it is also time to upgrade your hardware. Regards, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL version 3.23 to 5.x features
Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of mysql features -Naga
Re: MySQL version 3.23 to 5.x features
Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of mysql features While not exactly just one single page for all changes, there is a single page of the fine manual within each new major version that describes the big features that are new or changed within that version. http://dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html Unfortunately, to learn what we changed between 3.23 - 4.0 or between 4.0 - 4.1, you are going to need to review the change logs http://dev.mysql.com/doc/refman/4.1/en/news.html from http://dev.mysql.com/doc/refman/4.1/en/index.html This manual describes features that are not included in every edition of MySQL 3.23, MySQL 4.0, and MySQL 4.1; such features may not be included in the edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1; licensed to you. I can pretty much summarize the deficiencies in 3.23 like this * No InnoDB, Archive, CSV, Federated, or Blackhole storage engines * No table partitioning * No Views * No Stored Procedures or Stored Functions * No Triggers * No Events * Severe scalability limits (won't run as fast with reasonably concurrent loads even on great hardware as later versions) * Completely out of print (unpublished) and unsupported. * Missing literally thousands of bug fixes and performance improvements Any new project should be starting out with 5.6. Any production server should be on 5.5 or 5.6 by now or migrating soon. It is also a fairly safe bet that if you are still operating a 3.23 instance of MySQL that it is also time to upgrade your hardware. Regards, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL version 3.23 to 5.x features
Hi Naga, On 21/08/2013 23:43, shawn green wrote: Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of mysql features While not exactly just one single page for all changes, there is a single page of the fine manual within each new major version that describes the big features that are new or changed within that version. Just to add one reference to Shawn's list, there is also a MySQL Server Version Reference at https://dev.mysql.com/doc/mysqld-version-reference/en/index.html. It is lower level such as which options and functions are available in each major version. However it does not start out before version 5.0, so will not help you over the 3.23 - 4.0 - 5.0 hurdle. Best regards, Jesper Krogh MySQL Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
How often should we upgrade MySQL version
We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: How often should we upgrade MySQL version
Ever heard the old saying, If it ain't broke, don't fix it. ;-) I'd say that as a general rule: 1. if you aren't experiencing problems then don't upgrade. 2. if you aren't subject to any vulnerabilities that may be found, then don't upgrade 3. if you don't need a new feature introduced, then don't upgrade 4. if you need to be up 100%, then don't upgrade Having said that, it is possible to upgrade with minimal downtime if you're smart about it. Get another server (or two or three) that is a clone of the existing ones. Upgrade those. Test those. Swap over. Then for the next release, do the same thing with the servers you now have as the spares. If you're in such a mission critical situation, you should have spare servers and live hot-swapable backups anyways right. -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: Friday, November 18, 2011 11:54 AM To: MySQL ML Subject: How often should we upgrade MySQL version We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How often should we upgrade MySQL version
I love the answer On Fri, Nov 18, 2011 at 10:59 PM, Daevid Vincent dae...@daevid.com wrote: Ever heard the old saying, If it ain't broke, don't fix it. ;-) I'd say that as a general rule: 1. if you aren't experiencing problems then don't upgrade. 2. if you aren't subject to any vulnerabilities that may be found, then don't upgrade 3. if you don't need a new feature introduced, then don't upgrade 4. if you need to be up 100%, then don't upgrade Having said that, it is possible to upgrade with minimal downtime if you're smart about it. Get another server (or two or three) that is a clone of the existing ones. Upgrade those. Test those. Swap over. Then for the next release, do the same thing with the servers you now have as the spares. If you're in such a mission critical situation, you should have spare servers and live hot-swapable backups anyways right. -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: Friday, November 18, 2011 11:54 AM To: MySQL ML Subject: How often should we upgrade MySQL version We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=muadshib...@gmail.com -- *___* * * السجل .. كل الأخبار من كل مكان www.alsjl.com صفحة السجل على فيسبوك http://www.facebook.com/alsjl *Muad Shibani* * * Aden Yemen Mobile: 00967 733045678 www.muadshibani.com
Mysql version of database link?
Does anyone have a suggestion on how a database link (like in Oracle) could be established between two Mysql databases on different servers? It would be awesome if I could write sql that will query both databases in one query... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql version of database link?
At 12:16 PM -0600 12/7/09, Bryan Cantwell wrote: Does anyone have a suggestion on how a database link (like in Oracle) could be established between two Mysql databases on different servers? It would be awesome if I could write sql that will query both databases in one query... You are probably looking for federated tables: http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html And just for completeness, one can query multiple databases on the same server using the database.table.column syntax, eg: select db1.table1.column1 as a, db2.table2.column2 as b; One could also replicate a remote database to your server, and use the db.table.column notation: http://dev.mysql.com/doc/refman/5.0/en/replication.html I'm guessing the latter two options are not what you are asking for, but I include for completeness. DISCLAIMER: I haven't used federated tables yet... - steve -- ++ | Steve Edberg edb...@edberg-online.com | | Programming/Database/SysAdminhttp://www.edberg-online.com/ | ++ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql version of database link?
The FEDERATED engine is what you're looking for, but it probably doesn't quite do what you expect. Full documentation is at http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html . The major gotcha - in my opinion - is that it doesn't actually use indices. If you only need to run selects on data that's been inserted remotely, you might be better served by replicating the remote tables you need to your local server. On Mon, Dec 7, 2009 at 7:16 PM, Bryan Cantwell bcantw...@firescope.comwrote: Does anyone have a suggestion on how a database link (like in Oracle) could be established between two Mysql databases on different servers? It would be awesome if I could write sql that will query both databases in one query... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
How to enable partition in MySQL version 5.0.81-community
Hi, We are using MySQL version 5.0.81-community.We need to partition few tables but the have_partition option is not available that means this version doesn't support partition feature. Does MySQL provide any patch to enable the feature of partition in the same version of MySQL or how to enable the partition option in MySQL version 5.0.81-community? -- Regards, Jeetendra Ranjan SynapseIndia http://www.synapse.in I.T. Outsourcing @ Peace of Mind --
Re: Using Replication in mySQL version 5
Tompkins Neil wrote: Hi We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website data. Basically we have 2 websites located in the UK and US which share similar information, and we are going to be using replication as a way of keeping the data up to date and in sync. Based on your experiences, is there anything we should be aware of before investigating this route and putting it into practice ? I've had to take servers out for bad raid-controllers, bad ram, bad mobos. Disks have been the least of my problems. So make sure your architecture tolerates the ability to take members of your pool out without load-spiking the remaining members. And if you're doing filesystem snapshots from a master to a replicant, you will have to either have policy or extra servers available to maintain your uptime when you interrupt the master to flush all the tables, sync the filesystem and do an LVM snapshot. Innodb would require a shutdown. Don't forget that LVM snapshots are copy-on-write, so when that master comes back up and starts processing modifying tables, you'll get amazing system load on a busy system as your file system starts madly copying extents into the snapshot volume. Define a procedure for junior staff how to properly down and up a pool member. Like, if you get a disk-full on one member, and it borks replication, what's the step-by-step for a) determining if replication can re-establish after you do a FLUSH LOGS, b) under what conditions do you have to re-copy all data from one master to another because your replication window has expired and your logs have gotten flushed. Your replication binlogs get really big if you're pushing large materialized views regularly via replication, or your servers have fast disks, not enough size to handle a more than a weekend or whole day (for example) of neglect. Define a procedure for checking your my.cnf files for correct auto-increment-* settings and server-id settings. Junior staff, and even senior staff rarely add more members to the pool, so these settings are often mistaken during a midnight maintenance hour. Procedure for adding members and changing master replication settings is very important. Often your DBA is not racking and changing the equipment. Make sure that you have a good understanding of what kind of capacity you're growing at. I started a project with two four-core boxes with plenty of 15krpm disk and when they got into production, they regularly spiked to load 20 and 30. Not pretty. Not only had my old architecture refused traffic to lighten the load, my new architecture didn't. My data set was growing so fast my sort-buffer settings for the old servers were too small for new servers. I ended up with four DL380s with 8 cores per box. I really had to scramble to get more servers in there. The addition of two more read-only members really helped, and backups handled by replication to an off-site replicant. Another load capacity warning: if your traffic is very spiky, and you get high-load conditions, I've seen reset/dropped connections and also plain old connection timeouts. So if you have RAM for 1024 connections, you prolly can't service 1024 connections when you've got table contention and connections from your web-nodes just start failing. If they fail for too long, then you have to do some FLUSH HOSTS to reset connection attempt counters. I don't know what your application does, but I certainly monitor replication lag. Load spikes can certainly increase lag. I've had to move from single instances of mysql to mysqld_multi and separate databases by replication rate. Your monitoring should also track sql threads. You might need to define procedure on how to deal with pooling-out members that fall too far behind in replication. I've written an iptables script to block webnode connections but allow sql pool member connections. I use this to take a member out to run table repairs or to lighten the load while it does replication catch-up. WAN connectivity for replication is interesting! I did site-to-site transfer using stunnel. I had to negotiate weird Cisco 5502 VPN behavior. Copying gigs of myisam files between sites would knock over my vpn so I had to rate-limit using rsync --bwlimit. Bursting bandwidth charges were still brutal, though. Later, we ended up configuring CBQ (search freshmeat.net for cbq-init) on my backup replicant to limit bandwidth so it wouldn't provoke bursting charges. Jed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using Replication in mySQL version 5
Date: Mon, 17 Nov 2008 10:16:16 + From: Tompkins Neil [EMAIL PROTECTED] Subject: Using Replication in mySQL version 5 We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website data. Basically we have 2 websites ... hm, I can't tell you much yet, my first few experiences are: - it works. :) - be aware of auto_increment values, until now I found two possible sources of error relating to this, causing a 'duplicate entry for key...' error: 1. if u insert a row on slave-server only, auto_increment happens, and master-server is one behind, resulting in the 'duplicate entry' error on next insert on master-server. 2. we're replicating a typo3-cms. typo3 mostly doesn't really delete table rows, but instead sets a 'deleted' flag. so, basically the same issue as 1.: create a typo3-record on slave only, delete it via typo3 on slave only, but row is still occupied, next insert on master will fail. topics I've still got to look into for our setup: - harddisc space requirements of master server's binary log. i think it's about the same as the databases which are being logged, plus some overhead for the sql statements. one might want to keep this in mind if you expect your database to grow large. - performance and bandwidth. u can restrict replication to individual tables (on slave side - options 'replicate-do-table', etc.), so at least in our setup it'll be just a fraction of what the webserver/mysql has to deliver to the outside world (internet). - master-master replication, both server write to the same table, replication in both directions. currently this seems to work fine, but we haven't done any real-life-load-tests yet. regards, ro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Using Replication in mySQL version 5
You'll want an alert to page you when the replication slaves stop for an error; look for Matthew Montgomery's script; we added paging and an 'autofix' step to correct a limited number of duplicate key errors (and email when it does so); I page for other errors. We've had M-M 5.0 replication and M-S 5.1 replication configs running okay for a while -Original Message- From: Tompkins Neil [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 2:16 AM To: [MySQL] Subject: Using Replication in mySQL version 5 Hi We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website data. Basically we have 2 websites located in the UK and US which share similar information, and we are going to be using replication as a way of keeping the data up to date and in sync. Based on your experiences, is there anything we should be aware of before investigating this route and putting it into practice ? Thanks, Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using Replication in mySQL version 5
You will probably want to set read_only = 1 in the my.cnf on the slave so only super users can change tables. If you do partial replication, you must be sure your developers do not cross-reference schemas where one is replicated and the other is not. You will either get a replication error telling you that something doesn't exist or you won't get any error, but the slave may well get out of sync. On Mon, Nov 17, 2008 at 4:16 AM, Tompkins Neil [EMAIL PROTECTED] wrote: Hi We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website data. Basically we have 2 websites located in the UK and US which share similar information, and we are going to be using replication as a way of keeping the data up to date and in sync. Based on your experiences, is there anything we should be aware of before investigating this route and putting it into practice ? Thanks, Neil -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Using Replication in mySQL version 5
Hi We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website data. Basically we have 2 websites located in the UK and US which share similar information, and we are going to be using replication as a way of keeping the data up to date and in sync. Based on your experiences, is there anything we should be aware of before investigating this route and putting it into practice ? Thanks, Neil
We have just moved to a new web server where we are running mysql version: 5.0.45
We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name=xx; and then gave the following command, SELECT user_name FROM alon_protein_passwd WHERE (user_name = xx AND passwd=password('xx')) we got the expected results. Now when we do this, on the new machine, we get no result i.e. Empty set. Any help will be appreciated. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: We have just moved to a new web server where we are running mysql version: 5.0.45
At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote: We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name=xx; and then gave the following command, SELECT user_name FROM alon_protein_passwd WHERE (user_name = xx AND passwd=password('xx')) we got the expected results. Now when we do this, on the new machine, we get no result i.e. Empty set. Any help will be appreciated. The password hashing algorithm changed in MySQL 4.1. You can read about it here: http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html This is likely the cause of the changes that you're observing. I imagine that you'll either need to upgrade the passwords in your table, or look for them using OLD_PASSWORD() rather than PASSWORD(). -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: We have just moved to a new web server where we are running mysql version: 5.0.45
Thanks to Martin and Paul for their answers. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 On 4/9/2008 at 3:54 PM, in message [EMAIL PROTECTED], Paul DuBois [EMAIL PROTECTED] wrote: At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote: We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name=xx; and then gave the following command, SELECT user_name FROM alon_protein_passwd WHERE (user_name = xx AND passwd=password('xx')) we got the expected results. Now when we do this, on the new machine, we get no result i.e. Empty set. Any help will be appreciated. The password hashing algorithm changed in MySQL 4.1. You can read about it here: http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html This is likely the cause of the changes that you're observing. I imagine that you'll either need to upgrade the passwords in your table, or look for them using OLD_PASSWORD() rather than PASSWORD(). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stable MySQL Version
Hi Team Sorry for replying late, I have downloaded tried installation with 3 installers. I am getting the below messsage while trying the various installers. 1. mysql-essential-5.0.45-winx64 [28641KB] == This installation package is not supported by this processor type. Contact your product vendor 2. mysql-noinstall-5.0.45-winx64 [63336KB] == mysqld.exe is not a valid win32 application 3. Setup [53872KB] == This installation package is not supported by this processor type. Contact your product vendor Thanks Amit Tiago Cruz [EMAIL PROTECTED] wrote: On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 -- Tiago Cruz http://everlinux.com Linux User #282636 - Never miss a thing. Make Yahoo your homepage.
Re: Stable MySQL Version
On Dec 19, 2007 5:26 AM, Amit Nair [EMAIL PROTECTED] wrote: Hi Team Sorry for replying late, I have downloaded tried installation with 3 installers. I am getting the below messsage while trying the various installers. 1. mysql-essential-5.0.45-winx64 [28641KB] == This installation package is not supported by this processor type. Contact your product vendor 2. mysql-noinstall-5.0.45-winx64 [63336KB] == mysqld.exe is not a valid win32 application 3. Setup [53872KB] == This installation package is not supported by this processor type. Contact your product vendor Thanks Amit Tiago Cruz [EMAIL PROTECTED] wrote: On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 You said that you are running Windows XP, not Window XP x64, so the correct installer would be under Windows downloads , rather than Windows x64 downloads . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stable MySQL Version
Thanks Rob Team, Installer mysql-essential-5.0.45-win32 worked for me. Rob Wultsch [EMAIL PROTECTED] wrote: On Dec 19, 2007 5:26 AM, Amit Nair wrote: Hi Team Sorry for replying late, I have downloaded tried installation with 3 installers. I am getting the below messsage while trying the various installers. 1. mysql-essential-5.0.45-winx64 [28641KB] == This installation package is not supported by this processor type. Contact your product vendor 2. mysql-noinstall-5.0.45-winx64 [63336KB] == mysqld.exe is not a valid win32 application 3. Setup [53872KB] == This installation package is not supported by this processor type. Contact your product vendor Thanks Amit Tiago Cruz wrote: On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 You said that you are running Windows XP, not Window XP x64, so the correct installer would be under Windows downloads , rather than Windows x64 downloads . - Never miss a thing. Make Yahoo your homepage.
Re: Stable MySQL Version
On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Stable MySQL Version
Hello Team Could some one please let me know a stable version of MySQL for my computer? Configuration is as below: OS- Windows XP Professional Service Pack 2 Processor AMD Athlon 64 Processor 2800+ 1.8Ghz RAM 1 GB Actually I have downloaded one which was meant for AMD processor, but it was not even getting installed. Thanks Amit - Never miss a thing. Make Yahoo your homepage.
Re: MySql Version difference
How could i know the difference between these 2 version and there compatiblity. Read the Change History section of the manual for versions 5.0.19 through 5.0.27. PB - Nilesh wrote: Hi, I have a webapplication developed using J2EE. For the application, the database is on MySQL 5.0.18 version . Now I plan to use the lastest MySQL version (5.0.27). But before that i want to know the differences between these 2 versions and whether the current database will work fine with 5.0.27 version. How could i know the difference between these 2 version and there compatiblity. Thanks and Regards, Nilesh No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.410 / Virus Database: 268.17.8/649 - Release Date: 1/23/2007 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.410 / Virus Database: 268.17.8/649 - Release Date: 1/23/2007 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Version difference
Thanks Peter. But is there any other way to do that. Can't i directly compare the 2 version, instead of reading Change Histroy section for all the version in between. Regards, Nilesh _ From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 11:56 AM To: Nilesh Cc: mysql@lists.mysql.com Subject: Re: MySql Version difference How could i know the difference between these 2 version and there compatiblity. Read the Change History section of the manual for versions 5.0.19 through 5.0.27. PB - Nilesh wrote: Hi, I have a webapplication developed using J2EE. For the application, the database is on MySQL 5.0.18 version . Now I plan to use the lastest MySQL version (5.0.27). But before that i want to know the differences between these 2 versions and whether the current database will work fine with 5.0.27 version. How could i know the difference between these 2 version and there compatiblity. Thanks and Regards, Nilesh _ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.410 / Virus Database: 268.17.8/649 - Release Date: 1/23/2007
Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11
On Fri, 2006-07-14 at 09:47 -0300, Miles Thompson wrote: At 09:15 AM 7/14/2006, Jeremiah Foster wrote: Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. That is about 3 hours and a billion rows examined. Is it likely that this is the source of my problems? I'd say YES. But first, how much time does it take if you remove the join conditions for the LIKEs? The time it takes after removing the two likes is 7 hours; 100 rows in set (7 hours 23 min 43.04 sec) There are two difficulties there: 1. Use of LIKE with wildcard search forces a table scan, although see [1] below. 2. The two LIKEs are joined by an OR so Stdnsv will be scanned until the first condition is met, and if it is fulfilled, then pl is scanned until the second condition is met. Full scan on each table. Alternately ... If the first condition for Stdnsv is not met, then OR has failed, but you will have a full table scan on the left hand side of the OR regardless. Second, have you indexes on the columns which are being compared? Yes, I believe when I ran EXPLAIN it showed the tables were indexed. I will run explain again to make sure. Your memory usage is probably pretty high as well, as MySQL tries to do as much work as it can in memory. I will look into investing in more memory. Have you tried this: SELECT pp.art_num, pp.showprice as price, pc.custom_price, pc.custom_name, pc.custom_delivery, pd.instock, Stdnsv.Description FROM product_tags pt, products_prices pp, products_dists pd, filter_categories fc, product_linking pl, cds_Stdnsv Stdnsv WHERE Stdnsv.ProdID = pp.art_num AND pc.art_num = pp.art_num AND pp.art_num = pl.art_num AND pp.art_num = pd.art_num AND fc.filter_type_id = 1 AND fc.filter_id = pl.filter_id AND (Stdnsv.Description != 'None' OR Stdnsv.Description != '') GROUP BY pp.art_num ORDER BY pp.showprice DESC LIMIT 100; If that gives weird or unexpected results, try whacking off AND conditions until it's fast, then think about why the query slows when they are added. Note the simple WHERE is an implicit LEFT JOIN. Also formulate time query, and time it, with (Stdnsv.Description LIKE '%Media%Center%' OR pl.art_num LIKE '%Media% Center%') as the WHERE. Apologies if this has been too pedantic. Hope this is helpful - Miles Thompson Miles, this has been extremely helpful, not at all pedantic. Thank you. [1] MySQL 4.0 does another optimisation on LIKE. If you use ... LIKE %string% and string is longer than 3 characters, MySQL will use the Turbo Boyer-Moore algorithm to initialise the pattern for the string and then use this pattern to perform the search quicker. This is taken from http://mysqld.active-venture.com/MySQL_indexes.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11
Hello, Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. One of the entries in our slow_queries log looks like this; # Query_time: 14074 Lock_time: 0 Rows_sent: 11 Rows_examined: 1020472928 SELECT pp.art_num, pp.showprice as price, pc.custom_price, pc.custom_name, pc.custom_delivery, pd.instock, Stdnsv.Description FROM product_tags pt, products_prices pp, products_dists pd, filter_categories fc, product_linking pl LEFT JOIN cds_Stdnsv Stdnsv ON (Stdnsv.ProdID = pp.art_num) LEFT JOIN products_custom pc ON (pc.art_num = pp.art_num) WHERE pp.art_num = pl.art_num AND pp.art_num = pd.art_num AND fc.filter_type_id = 1 AND fc.filter_id = pl.filter_id AND (Stdnsv.Description != 'None' OR Stdnsv.Description != '') AND (Stdnsv.Description LIKE '%Media%Center%' OR pl.art_num LIKE '%Media% Center%') GROUP BY pp.art_num ORDER BY pp.showprice DESC LIMIT 100; That is about 3 hours and a billion rows examined. Is it likely that this is the source of my problems? Thanks very much, Jeremiah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11
At 09:15 AM 7/14/2006, Jeremiah Foster wrote: Hello, Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. One of the entries in our slow_queries log looks like this; # Query_time: 14074 Lock_time: 0 Rows_sent: 11 Rows_examined: 1020472928 SELECT pp.art_num, pp.showprice as price, pc.custom_price, pc.custom_name, pc.custom_delivery, pd.instock, Stdnsv.Description FROM product_tags pt, products_prices pp, products_dists pd, filter_categories fc, product_linking pl LEFT JOIN cds_Stdnsv Stdnsv ON (Stdnsv.ProdID = pp.art_num) LEFT JOIN products_custom pc ON (pc.art_num = pp.art_num) WHERE pp.art_num = pl.art_num AND pp.art_num = pd.art_num AND fc.filter_type_id = 1 AND fc.filter_id = pl.filter_id AND (Stdnsv.Description != 'None' OR Stdnsv.Description != '') AND (Stdnsv.Description LIKE '%Media%Center%' OR pl.art_num LIKE '%Media% Center%') GROUP BY pp.art_num ORDER BY pp.showprice DESC LIMIT 100; That is about 3 hours and a billion rows examined. Is it likely that this is the source of my problems? Thanks very much, Jeremiah Jeremiah, I'd say YES. But first, how much time does it take if you remove the join conditions for the LIKEs? There are two difficulties there: 1. Use of LIKE with wildcard search forces a table scan, although see [1] below. 2. The two LIKEs are joined by an OR so Stdnsv will be scanned until the first condition is met, and if it is fulfilled, then pl is scanned until the second condition is met. Full scan on each table. Alternately ... If the first condition for Stdnsv is not met, then OR has failed, but you will have a full table scan on the left hand side of the OR regardless. Second, have you indexes on the columns which are being compared? Your memory usage is probably pretty high as well, as MySQL tries to do as much work as it can in memory. Have you tried this: SELECT pp.art_num, pp.showprice as price, pc.custom_price, pc.custom_name, pc.custom_delivery, pd.instock, Stdnsv.Description FROM product_tags pt, products_prices pp, products_dists pd, filter_categories fc, product_linking pl, cds_Stdnsv Stdnsv WHERE Stdnsv.ProdID = pp.art_num AND pc.art_num = pp.art_num AND pp.art_num = pl.art_num AND pp.art_num = pd.art_num AND fc.filter_type_id = 1 AND fc.filter_id = pl.filter_id AND (Stdnsv.Description != 'None' OR Stdnsv.Description != '') GROUP BY pp.art_num ORDER BY pp.showprice DESC LIMIT 100; If that gives weird or unexpected results, try whacking off AND conditions until it's fast, then think about why the query slows when they are added. Note the simple WHERE is an implicit LEFT JOIN. Also formulate time query, and time it, with (Stdnsv.Description LIKE '%Media%Center%' OR pl.art_num LIKE '%Media% Center%') as the WHERE. Apologies if this has been too pedantic. Hope this is helpful - Miles Thompson [1] MySQL 4.0 does another optimisation on LIKE. If you use ... LIKE %string% and string is longer than 3 characters, MySQL will use the Turbo Boyer-Moore algorithm to initialise the pattern for the string and then use this pattern to perform the search quicker. This is taken from http://mysqld.active-venture.com/MySQL_indexes.html -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.10.0/388 - Release Date: 7/13/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
restoring database previous mysql version
Dear Sir, I have 8 mb total SQL database, i'm currently using mysql version: 4.1.11-debian. Our database uses latin5 character set and collate: latin5_turkish_ci And now... how can i restore this database without problem; previous mysql version? previous mysql version is: 4.0.25-standart Note: I have SSH Access. This is very important for me, thank you. _ Hava durumunu bizden ögrenin ve evden öyle çikin! http://www.msn.com.tr/havadurumu/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: restoring database previous mysql version
if I have to put in one line, then just taka a copy (zip, gzip, tar or whatever) of your old mysql data directory, like /usr/local/mysql/data, and then restore it into your new data directory under 4.1.x, and this should be fine assuming you have taken care of other things, also please refer to the doc on mysql for the upgrade http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html http://dev.mysql.com/doc/refman/4.1/en/upgrading-to-arch.html Kishore Jalleda http://kjalleda.googlepages.com On 4/3/06, murat . [EMAIL PROTECTED] wrote: Dear Sir, I have 8 mb total SQL database, i'm currently using mysql version: 4.1.11-debian. Our database uses latin5 character set and collate: latin5_turkish_ci And now... how can i restore this database without problem; previous mysql version? previous mysql version is: 4.0.25-standart Note: I have SSH Access. This is very important for me, thank you. _ Hava durumunu bizden ögrenin ve evden öyle çikin! http://www.msn.com.tr/havadurumu/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Warning but show warning not available (mysql version 3.21)
Hi all I use a script to build a query and while testing this script by copy'ing it into the mysql console, it shows me a warning. However, the SHOW WARNINGS; is not available on versions 4. mysql describe shop_products; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | intid | varchar(100) | | MUL | | | | shopid | varchar(100) | | | | | | name | varchar(255) | | | | | | sdesc | varchar(250) | | MUL | | | | ldesc | text | | | | | | active | set('0','1') | | | 0 | | | visible| set('0','1') | | | 0 | | | stock | double| | | 0 | | | unit | varchar(100) | | | | | | units | varchar(100) | | | | | | unitprice | decimal(10,5) | | | 0.0 | | | tax| double| | | 0 | | | min_units | double| | | 0 | | | max_units | double| | | 0 | | | delivery_inc_unitprice | decimal(10,5) | | | 0.0 | | | delivery_tax | double| | | 0 | | | delivery_time | varchar(100) | | | | | ++---+--+-+-++ 18 rows in set (0.00 sec) mysql UPDATE `shop_products` SET `name`='TestProd' , `shopid`='20-302' , `sdesc`='This is a test product' , `ldesc`='Long description for the test product\r\n\r\nIt supports formatting but not objectss\r\n\r\n' , `unit`='piece' , `units`='pieces' , `stock`='10' , `unitprice`='20.0' , `tax`='0' , `min_units`='1' , `max_units`='' , `delivery_inc_unitprice`='0.0' , `delivery_tax`='0' , `delivery_time`='' , `visible`='1' , `active`='' WHERE `id`='1' LIMIT 1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 To make you live a bit more easy, here is the same query but aligned UPDATE `shop_products` SET `name`='TestProd' , `shopid`='20-302' , `sdesc`='This is a test product' , `ldesc`='Long description for the test product\r\n\r\nIt supports formatting but not objectss\r\n\r\n' , `unit`='piece' , `units`='pieces' , `stock`='10' , `unitprice`='20.0' , `tax`='0' , `min_units`='1' , `max_units`='' , `delivery_inc_unitprice`='0.0' , `delivery_tax`='0' , `delivery_time`='' , `visible`='1' , `active`='' WHERE `id`='1' LIMIT 1; I know active, and visible are sets, and that there is no value for active, but I tried with active='0' and got the same warning. Thanks in advance. Kind regards Andy -- Registered Linux User Number 379093 -- ---BEGIN GEEK CODE BLOCK- Version: 3.12 GAT/O/CM d- s:+ a- C UL P+ L+++ E--- W+++ N++ o+ K w--- O+++ M- V PS+ PE++ Y+ PGP+++ t+ 5-- X R !tv b DI+++ D++ G e-- h+ r--- y+ -- ---END GEEK CODE BLOCK-- Check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- -- pgpqnJYBUP9Zo.pgp Description: PGP signature
Extract MySQL Version
I use the following to extract the version number. But it throws an error on newer version 5.xx. It works on version 4.0 and below. SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION On version 5.0.1-alpha-nt-log I get an error... Illegal mix of collations (utf8_general_ci,IMPLICIT)and(latin1_SWEEDIH_CI,coercible) for operation 'locate' Is this problem by design? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extract MySQL Version
- Original Message - From: Fredrick Bartlett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 29, 2004 12:08 PM Subject: Extract MySQL Version I use the following to extract the version number. But it throws an error on newer version 5.xx. It works on version 4.0 and below. SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION On version 5.0.1-alpha-nt-log I get an error... Illegal mix of collations (utf8_general_ci,IMPLICIT)and(latin1_SWEEDIH_CI,coercible) for operation 'locate' Is this problem by design? Try spelling SWEEDISH correctly and see if that helps. You left out the second 'S' in 'SWEEDISH_CI' ;-) Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extract MySQL Version
I use the following to extract the version number. But it throws an error on newer version 5.xx. It works on version 4.0 and below. SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION On version 5.0.1-alpha-nt-log I get an error... Illegal mix of collations (utf8_general_ci,IMPLICIT)and(latin1_SWEEDIH_CI,coercible) for operation 'locate' Is this problem by design? Try spelling SWEEDISH correctly and see if that helps. You left out the second 'S' in 'SWEEDISH_CI' ;-) How would spelling the error message correctly help with the query? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA LOCAL: The used command is not allowed with this MySQL version
Hi mysql-community! I have a problem with mysql 3.23.49a: If I try to use the statement 'LOAD DATA LOCAL INFILE '/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE test' mysql replys: 'The used command is not allowed with this MySQL version'. Why this error-message? Was LOAD DATA LOCAL not supported with 3.23? I read, that LOAD DATA LOCAL was added with 3.22.6 Do you have an idea? Thank you, Martin
Re: LOAD DATA LOCAL: The used command is not allowed with this MySQL version
Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html Martin Rytz [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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 version and sysklogd-sql problem
I'm banging my head against a somewhat strange problem I hope somewhat more proficient than me can help me with. I'm trying to setup a central logging-server and having it dump all input into a MySQL db for easier access from diferent analisys systems. I've found sysklogd-sql on Sourceforge, which is basicaly a patched version of the normal v1.4.2 syslog daemon so it can write to MySQL. It requires MySQL-shared in order to compile, and I thought this would make it able to work with all versions of MySQL. But after trying with v. 4.1.6 without luck I finaly revertet to 4.0.21 and lo and behold, it works perfectly, except for the fact that I want to use InnoDB, foreign keys and nested queries. The install of both v. 4.0.21 and v. 4.1.6 is the standard Linux RPM install on a standard Fedora Core 2 installation. It simply gives me a stadard 1064 syntax error message no matter what I try, even though syslog is simply trying a simple INSERT: INSERT INTO syslog (machine, facility, priority, message) VALUES ('cutter', 'syslog', 'info', 'syslogd-sql 1.4.2: restart (remote reception).') Has anyone tried running these two systems together? Maybe even allready resolved the problem? I'd LOVE hearing from you ;) Thank you in advance Frank Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to replace a installed mysql version?
Hi there, I am a bit confused. It is not clear to me that the version I am currently running is the one I compiled last. How can I check the date of compiling? In order to get more performance I did try to install mysql 4.0.18 with different configure commands, now I am not sure if the make install did really override the already installed version of 4.0.18. Is there a possibility to find this out? Maybe with a variable called build time or similar? Thanx for any hint, Andy _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
An doubt about mysql version 4.0.x agains 4.1.x
Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: An doubt about mysql version 4.0.x agains 4.1.x
Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote: Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this It's true. The above SELECT statement will work only from 4.1. -- 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 version 4.0.x ,LOCKS and Transactions
Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql version 4.0.x ,LOCKS and Transactions
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz I haven't had any problems. Did your friend elaborate? -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql version 4.0.x ,LOCKS and Transactions
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb If you program a certain way, you can run into deadlocks which will result in rolled back transactions that you will have to re-run in the application. See http://www.innodb.com/ibman.php#Cope.with.deadlocks -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL version 4.1.x
Hi! - Original Message - From: Sasha Pachev [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, February 19, 2004 12:58 AM Subject: Re: MySQL version 4.1.x lee wrote: Anyone know when 4.1.x is scheduled for going Production? The website says it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to have the improved subqueries, etc. in 4.1.x. I would guess 4.1.1 is roughly as good on the old features as the latest 4.0. However, I would stay away from subqueries for at least another six months except for a few that you really benefit from and have tested to make sure they work right and fast. A couple of months back my guess was that 4.1 would be labeled 'Production' in September 2004, or even a bit earlier. I would still give the same guess. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL version 4.1.x
Anyone know when 4.1.x is scheduled for going Production? The website says it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to have the improved subqueries, etc. in 4.1.x. From http://www.mysql.com/doc/en/News-4.0.x.html # C.2 Changes in release 4.1.x (Alpha) * C.2.1 Changes in release 4.1.2 (not released yet) * C.2.2 Changes in release 4.1.1 (01 Dec 2003) * C.2.3 Changes in release 4.1.0 (03 Apr 2003: Alpha) Thanks in advance! /lee = == /lee +---+ | This concludes our broadcast day| +---+ __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL version 4.1.x
lee wrote: Anyone know when 4.1.x is scheduled for going Production? The website says it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to have the improved subqueries, etc. in 4.1.x. I would guess 4.1.1 is roughly as good on the old features as the latest 4.0. However, I would stay away from subqueries for at least another six months except for a few that you really benefit from and have tested to make sure they work right and fast. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql version 4.1.2
I need MySQL version 4.1.2 build for Windows. Does anyone have a built version of it, or know when it will be released? Thanks for your help, Kate
mysql version problem
Hi Guys, I am running winxp with mysql. Seeing this is a home machine there is no workstation just one computer which I guess at this point is acting as my server and client for mysql. I am just getting acquainted with mysql so I have been playing around with both 4.1 and 5.0. Neither database is installed as a service on my windoze box, essentially I have two folders one is mysql4 the other mysql5. When I want to use one of the databases I rename the folder to mysql and then it makes use of my.ini and everything works just fine. My problem is accessing mysql 5.0 from perl,php etc... I get client authentication protocol errors. If I run command line everything works perfect but as soon as perl or php try to access the 5.0 database it bombs. What dll is responsible for this so i'll know where to find it and make sure it is the appropriate version(I'm assuming at this point both php/perl are seeing a 4.1 dll) Or is this a perl /php problem where they have a specific dll with them and I need to adjust their dll's. Thanks!
Somebody tried MySQL version 5 / Stored Procedures
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit and in an exception handler (eg) you can do a rollback). My question to somebody who has tried version 5 (or the development team), is this possible in MySQL stored procedures too? So it is not nessecery for me to write much code, but just a little and in version 5 I write my transactions to stored procedures... In anticipation much thanks!! Kind Regards Hans van Dalen/ NL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Somebody tried MySQL version 5 / Stored Procedures
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote: Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit and in an exception handler (eg) you can do a rollback). My question to somebody who has tried version 5 (or the development team), is this possible in MySQL stored procedures too? So it is not nessecery for me to write much code, but just a little and in version 5 I write my transactions to stored procedures... In anticipation much thanks!! Didn't you ask this roughly 3 days ago? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 15 days, processed 538,364,636 queries (407/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Somebody tried MySQL version 5 / Stored Procedures
Excuse me, I get an automatic reply from the mailinglist that my message wasn't send so I send it again. regards hans At 23:50 28-9-03 -0700, you wrote: On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote: Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit and in an exception handler (eg) you can do a rollback). My question to somebody who has tried version 5 (or the development team), is this possible in MySQL stored procedures too? So it is not nessecery for me to write much code, but just a little and in version 5 I write my transactions to stored procedures... In anticipation much thanks!! Didn't you ask this roughly 3 days ago? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 15 days, processed 538,364,636 queries (407/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Somebody tried MySQL version 5 / Stored Procedures
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit and in an exception handler (eg) you can do a rollback). My question to somebody who has tried version 5 (or the development team), is this possible in MySQL stored procedures too? So it is not nessecery for me to write much code, but just a little and in version 5 I write my transactions to stored procedures... In anticipation much thanks!! Kind Regards Hans van Dalen/ NL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
Try sqlimport (it is in the bin directory) Martin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 4:33 PM Subject: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] D. H. Craig, CSM Have a grateful day! -- 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]
mysqlimport : not allowed with this MySQL version
I have installed MySQL version Release: mysql-3.23.38 (as found in the mysqlbug.txt). When I use mysqlimport, I get the following error code ERROR 1148 : the used command is not allowed with this MySQL version. I get the same message whenever I use LOAD DATA. WHich version should I install ? Gert Cuppens Ranst - Antwerp (Belgium) _ Hotmail: je gratis e-mail ! http://www.msn.be/hotmail - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC and LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version
Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? Thank you Cédric. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version
Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis [EMAIL PROTECTED] [EMAIL PROTECTED] Wednesday, February 12, 2003 3:48:16 PM Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? Thank you Cédric. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC and LOAD DATA LOCAL INFILE : The used command is not allowedwith this MySQL version
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis [EMAIL PROTECTED] [EMAIL PROTECTED] Wednesday, February 12, 2003 3:48:16 PM Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? You have to use the 3.0 Connector/J drivers for 'LOAD DATA LOCAL INFILE'. See http://www.mysql.com/products/connector-j/ The support for 'LOAD DATA LOCAL INFILE' appeared in 3.0, the latest version. It was never in MM.MySQL (which is what you're using, I assume something like 2.0.14), so I don't know how it was _ever_ working for you :) -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Sk2MtvXNTca6JD8RAkjDAKDHfJR6jCsHRrGq3yxK+LTCPzRbWQCfc0Ld RUnZYHgbelXstPKvO2qOj8U= =IvB1 -END PGP SIGNATURE- - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
Hi! On Feb 05, Tue Tønning wrote: Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3 randomly = select fieldName from tableName order by RAND() limit 3 this have worked for the last year or so.but after upgrading our redhat 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the same 3 entires. try simply mysql -BNe 'select rand(), rand(), rand(), rand()' mysql -BNe 'select rand(), rand(), rand(), rand()' mysql -BNe 'select rand(), rand(), rand(), rand()' to see the problem. RAND() initialization for new connection isn't very random, so first few rand() values differ only slightly. It was fixed in 4.0. I will backport the fix to 3.23. You can either upgrade to MySQL 4.0, or wait till next 3.23 release, or use a simple workaround: run do benchmark(10,rand()); just after establishing connection - before first SELECT. Ohh, yeah - we code in PHP..and i have talked today with 3 other webdevelopment companies that have been struggeling with the same error after upgrading. Easy - no need to struggling, just submit a bugreport - the bug will be fixed at once :) Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
HINT: I have used PERL to generate random numbers and then do a SELECT on the auto_increment field in the mysql table, thus generating random picks from my tables; I'll be glad to bet informed of better ways around, though :) Thanks Aman Raheja AGF Inc. - Original Message - From: Tue Tønning [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 1:38 PM Subject: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux) Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3 randomly = select fieldName from tableName order by RAND() limit 3 this have worked for the last year or so.but after upgrading our redhat 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the same 3 entires. using a Seed doesnt make it perfect either (i know that the manual says that RAND() isnt perfect - but now it doesnt work at all). A quick search on google says me that im not the only one having the problem. I can also see on some Danish messageboards that other have the same problems with the new version. So my question is .What to do ? I cant imagine that you have removed the functionality of RAND from mysql again ? i know its only been in there since early ~3.23 I work professionally as a webdevolper (CEO of a firm) and we need to find a solution to this problem badly. I hope you can guide me to a solution. Cause i would hate to change all the sql calls in the projects we have coded the last 1½ year and it would be nice to know if we would be able to use RAND() in the future. Ohh, yeah - we code in PHP..and i have talked today with 3 other webdevelopment companies that have been struggeling with the same error after upgrading. Med venlig hilsen / Best regards Tue Tønning AT-Orbital I/S Helsingforsgade 27, 1 DK-8200 Aarhus N Denmark Phone +45 8942 5860 Web www.atorbital.com - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3 randomly = select fieldName from tableName order by RAND() limit 3 this have worked for the last year or so.but after upgrading our redhat 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the same 3 entires. using a Seed doesnt make it perfect either (i know that the manual says that RAND() isnt perfect - but now it doesnt work at all). A quick search on google says me that im not the only one having the problem. I can also see on some Danish messageboards that other have the same problems with the new version. So my question is .What to do ? I cant imagine that you have removed the functionality of RAND from mysql again ? i know its only been in there since early ~3.23 I work professionally as a webdevolper (CEO of a firm) and we need to find a solution to this problem badly. I hope you can guide me to a solution. Cause i would hate to change all the sql calls in the projects we have coded the last 1½ year and it would be nice to know if we would be able to use RAND() in the future. Ohh, yeah - we code in PHP..and i have talked today with 3 other webdevelopment companies that have been struggeling with the same error after upgrading. Med venlig hilsen / Best regards Tue Tønning AT-Orbital I/S Helsingforsgade 27, 1 DK-8200 Aarhus N Denmark Phone +45 8942 5860 Web www.atorbital.com - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Bug report: Embedded MySQL version 4.05a
Hi Paul! Thank you for the quick response. Indeed, we expect it to work otherwise. In our application, users are authenticated by the operating system, but we were hoping to use the built-in authorization of MySql instead of developing our own. Our strategy is to automatically add users to MySql as they are given to us by the OS and assign permissions to tables using these users. Does that seem reasonable? Thank you! Henry. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 9:09 PM To: Matt Solnit; Heikki Tuuri; [EMAIL PROTECTED] Cc: Henry Bequet Subject: Re: Bug report: Embedded MySQL version 4.05a At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. Would you expect otherwise? If you have the embedded server linked into an application, it's expected that the application will have full control over the server and can do anything with any of its databases. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug report: Embedded MySQL version 4.05a
=== Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. - Setup script: - USE mysql DELETE FROM user WHERE user=''; DELETE FROM user WHERE user='root' AND host!='localhost'; USE test CREATE TABLE mytable (a int); GRANT SELECT ON mytable TO joe@localhost; GRANT USAGE ON mytable TO jay@localhost; FLUSH PRIVILEGES; -- Observed behavior: -- Running the mysql.exe client, anonymous users cannot connect to the database, user 'joe' has read-only access to the table test.mytable, and user 'jay' as no privileges. Running the mysql-server.exe host, all users have full privileges. Additionally, the GRANT statement in mysql-server.exe returns error 1047 (Unknown command). --- Possible cause: --- The function acl_init() which loads the ACL's for each user on startup, includes a parameter, dont_read_acl_tables, that can be set to true to skip this step. The purpose of this parameter according to the comments is to support the --skip-grant command-line option. However, the mysql_server_init() function hard-codes this parameter value to 1, so the ACL's never get loaded and every access succeeds. --- My contact information: --- Matt Solnit [EMAIL PROTECTED] - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug report: Embedded MySQL version 4.05a
At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. Would you expect otherwise? If you have the embedded server linked into an application, it's expected that the application will have full control over the server and can do anything with any of its databases. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 1148 The error used Command is not allowed with this MySQL-Version
Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 1148 The error used Command is not allowed with this MySQL-Version
Greetings I think the path for the file is not correct. Try giving the complete path with (\) in the directory name changed to (/). Also specify the escaping characters properly. For more information you can check out the MySQL docs on LOAD LOCAL INFILE. Rgds Insane SQLyog - The Definitive Windows GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 5:57 PM Subject: Error 1148 The error used Command is not allowed with this MySQL-Version Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error 1148 The error used Command is not allowed with this MySQL -Version
Use the mysqlc.exe client instead of mysql.exe -- Geoff Morris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 7:28 AM To: [EMAIL PROTECTED] Subject: Error 1148 The error used Command is not allowed with this MySQL -Version Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL - version to install?
Mike, Friday, November 08, 2002, 6:29:29 PM, you wrote: MAS I've got to do a fresh install of mysql on a webserver (a new server, so it MAS isn't overwriting anything). Does anyone have any info as whether I should MAS use just MySQL or MySQL-MAX? What is the difference? If you use v3.23, MySQL-Max allows to use InnoDB and BDB tables: http://www.mysql.com/doc/en/mysqld-max.html Product names in 4.0 were changed to - MySQL Classic - MySQL Pro - MySQL Max http://www.mysql.com/news/article-111.html -- 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 - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL - version to install?
I've got to do a fresh install of mysql on a webserver (a new server, so it isn't overwriting anything). Does anyone have any info as whether I should use just MySQL or MySQL-MAX? What is the difference? Thanks! :) -Mike - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
highly recomended MySQL version
Hi all, Can anyone suggest me the highly recomended (non vulnerable)MySQL version. Thanks - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: highly recomended MySQL version
usha, Wednesday, October 16, 2002, 7:48:26 PM, you wrote: u Can anyone suggest me the highly recomended (non vulnerable)MySQL version. What about stable version? What OS do you use? 3.23.5X has some loading problems on Linux .. In Ensita we use v3.23.52 and v4.0.4 on production servers. Here is some that may help you: http://www.mysql.com/doc/en/Which_version.html -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
the highly recomended MySQL version
Hi Can anyone suggest me the highly recomended MySQL version(non vulnerable). Thanks - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Best MySQL version for replication
I am about to setup the following server layout using all Windows 2000 Server and XP Pro machines. Master Server-| |--Branch Office Server -| ||- Machine 1 ||... ||- Machine N | |--Second Branch Office -| |- Machine 1 | |- Machine N Objective: Client needs to have read access to the data even if the local lan goes down, so we Are going to put a local copy of mysql on each desktop machine that is a slave to the branch office Server. Updates will always go to the master server when the Master server is available. (We have A way to deal with saving when the Master is not available) Baically the branch offices are slaves to the master and the workstations will slave to the branch office server. I have the choice right now of using either MySQL 3.23 series or MySQL 4.0x series. This will be deployed in just over a week so the path with the least replication issues is the best One for me. Keep in mind that the workstations may be shutdown nightly. Can't control all the users;-) Thanks in advance Ross PS the link from the master to the branch offices is a 10MB/Second wireless link that is just being installed And hopefully reliable. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlimport: Error: The used command is not allowed with this MySQL version, when using table
Hello to everybody, I installed mysql ver 11.17 distrib 3.23.49a on redhat 7.2. I would like to import data into database table using command line instructions. I tried mysqlimport but I got the following error messagge mysqlimport: Error: The used command is not allowed with this MySQL version, when using table I looked up for the new command on the online documentation but I wasn't able to find anything and the mysqlimport command was not said to be dismissed. In the mysql mailing list repository I found an e-mail reporting the same error but on a windows operating system. Can anybody give me some suggestions on how to solve this problem? Thank you very much in advance for your time Bye Lana __ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità. http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 1148: The used command is not allowed with this MySQL version
Jeffrey, Sunday, July 28, 2002, 8:14:43 PM, you wrote: JAK Could you help me understand how to correct this error: JAK Error 1148: The used command is not allowed with this MySQL version JAK I have looked in the online manual under this section for help: JAK 4.2.4 Security issues with LOAD DATA LOCAL JAK Unfortunately I am very new to MySQL and don't have a clue as to how fix this error. I am using Windows. I think I need to modify the My.ini file under the mysqld section... I think it JAK should read local-infile=1. However when I try that, it still get this error when calling LOAD LOCAL FILE from a client application. Yes, I did start and stop the server. LOAD DATA LOCAL must be enabled in the client side, too. Put in [mysql] section on my.ini entry local-infile=1. -- 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 - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 1148: The used command is not allowed with this MySQL version
Dear Support, Could you help me understand how to correct this error: Error 1148: The used command is not allowed with this MySQL version I have looked in the online manual under this section for help: 4.2.4 Security issues with LOAD DATA LOCAL Unfortunately I am very new to MySQL and don't have a clue as to how fix this error. I am using Windows. I think I need to modify the My.ini file under the mysqld section... I think it should read local-infile=1. However when I try that, it still get this error when calling LOAD LOCAL FILE from a client application. Yes, I did start and stop the server. Please help! Wishing you the best, Jeffrey Kirby (608) 743-2117 [EMAIL PROTECTED] http://www.desktopemailblaster.com - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create Table error with MySQL version 3.23.39-max-nt, Access 2000, and MyODBC 2.50.39-nt
I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my gui, and MyODBC 2.50.39-nt I am able to run reports, queries and use the SQL pass through in access to retrieve data from the MySQL database through MyODBC. The problem is that I can not create a table in MySQL from Access in using the pass through to MyODBC. The SQL code works fine from the command line, but I am unable to get it to run through the pass-through in access. All of my other queries run fine, the only problem I have is with the create table and it gives me a generic error code. I have tested the DSN and it connects successfully. Any assistance would be helpful! TIA, Liz Craig - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql version 4.1?
Hi All, Anyone here got a hint about release date of My sql version 4.1 ? Gracias ! - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql version 4.1?
Remy, Friday, June 14, 2002, 4:14:54 PM, you wrote: RD Anyone here got a hint about release date of My sql version 4.1 ? RD Gracias ! There is no exact date of 4.1 release. It will suddenly come before then end of the year. :) -- 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 - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql version 4.1?
Remy Dufour [EMAIL PROTECTED] wrote: Anyone here got a hint about release date of My sql version 4.1 ? It was metioned on the mysql-bugs list today: Alpha version of 4.1 should come out this year. -- Mr. Sinisa Milivojevic [EMAIL PROTECTED] -- ./ premax ./ [EMAIL PROTECTED] ./ koniec i bomba, a kto czytal ten traba. w.g. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to deinstall old mysql version?
On Fri, 31 May 2002, andy wrote: I am just trying to configure my root server. The provider has preinstalled mysql on suse72. So I did try to get rid of this installation with yast, but this did not work out. After compiling php,apache and mysql, PHP is still trying to connect to the old server. The new server is running but how could I tell php to connect to the right server? Thanx for any help on that, Andy sql, query Andy, SuSE has a specific directory tree. When you are going to recompile on a SuSE system you have to use their configuration. Have a look at /usr/share/doc/packages/mysql/README.SuSE Thomas - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to deinstall old mysql version?
Hi there, I am just trying to configure my root server. The provider has preinstalled mysql on suse72. So I did try to get rid of this installation with yast, but this did not work out. After compiling php,apache and mysql, PHP is still trying to connect to the old server. The new server is running but how could I tell php to connect to the right server? Thanx for any help on that, Andy query - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Is there MySQL version 4.0.2 ?
Hi , CFc I've decided to provide a snapshot release system of the data on the CFc work.mysql.com server for 4.0.x you can access the nightly builds here: CFc CFc http://www.mysqldeveloper.com/snapshots/ thank you very much for the option to download the snapshot. Just my Intention is to by involved more seriously and therefore I would like to use the BitKeeper. LBc You can get the latest source code LBc take a look at LBc http://www.mysql.com/doc/I/n/Installing_source_tree.html LBc to see how to proceed At the moment I am using Windows 2000 and BitKeeper 2.1 for Windows. After applying the : bk clonebk://work.mysql.com:7001 mysql-4.0 I have got following message: == Sfio has detected a name conflict between BitKeeper/deleted/SCCS/s..del-Makefil e.w32 and BitKeeper/deleted/SCCS/s..del-makefile.w32; This usually happens when you transfer file from a case-sensitive file system (e.g. Unix) to a case insensitive file system (e.g FAT, NTFS) Please rename one of the files and retry (see also bk helptool mv) Note: You must do the rename in the sending repository. == In hope to fix it via bk pull and I have used the: cd mysql-4.0 bk pull bk://work.mysql.com:7001 Nothing to pull from bk://work.mysql.com:7001 when I have checked my local copy via: bk -r check -a I have got plenty of files that was not resolved. Am I doing something wrong or I shall forget about BitKeeper as I am using the Windown 2000? Any suggestion? Thanks, Viliam Batka - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there MySQL version 4.0.2 ?
Hi, as far as I know the only way that can be correct is to have one of the committers rename the files them selves that have duplicate names. Since windows isn't smart enough to realize that ABC doesn't mean abc. Good luck getting it working under windows ;-) Viliam Batka wrote: Hi , CFc I've decided to provide a snapshot release system of the data on the CFc work.mysql.com server for 4.0.x you can access the nightly builds here: CFc CFc http://www.mysqldeveloper.com/snapshots/ thank you very much for the option to download the snapshot. Just my Intention is to by involved more seriously and therefore I would like to use the BitKeeper. LBc You can get the latest source code LBc take a look at LBc http://www.mysql.com/doc/I/n/Installing_source_tree.html LBc to see how to proceed At the moment I am using Windows 2000 and BitKeeper 2.1 for Windows. After applying the : bk clonebk://work.mysql.com:7001 mysql-4.0 I have got following message: == Sfio has detected a name conflict between BitKeeper/deleted/SCCS/s..del-Makefil e.w32 and BitKeeper/deleted/SCCS/s..del-makefile.w32; This usually happens when you transfer file from a case-sensitive file system (e.g. Unix) to a case insensitive file system (e.g FAT, NTFS) Please rename one of the files and retry (see also bk helptool mv) Note: You must do the rename in the sending repository. == In hope to fix it via bk pull and I have used the: cd mysql-4.0 bk pull bk://work.mysql.com:7001 Nothing to pull from bk://work.mysql.com:7001 when I have checked my local copy via: bk -r check -a I have got plenty of files that was not resolved. Am I doing something wrong or I shall forget about BitKeeper as I am using the Windown 2000? Any suggestion? Thanks, Viliam Batka -- Colin Faber (303) 736-5160 fpsn.net, Inc. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there MySQL version 4.0.2 ?
At 9:59 -0600 5/15/02, Colin Faber wrote: Hi, as far as I know the only way that can be correct is to have one of the committers rename the files them selves that have duplicate names. Since windows isn't smart enough to realize that ABC doesn't mean abc. Good luck getting it working under windows ;-) The same thing happens under Mac OS X, which also uses case-insensitive filenames. One way around this is to clone the tree onto a system that has case sensitive filenames, tar it up and move it to the system where you really want it, and unpack it. One of the duplicate files will replace the other, but in this case it doesn't really matter because they're supposed to be deleted files anyway. Viliam Batka wrote: Hi , CFc I've decided to provide a snapshot release system of the data on the CFc work.mysql.com server for 4.0.x you can access the nightly builds here: CFc CFc http://www.mysqldeveloper.com/snapshots/ thank you very much for the option to download the snapshot. Just my Intention is to by involved more seriously and therefore I would like to use the BitKeeper. LBc You can get the latest source code LBc take a look at LBc http://www.mysql.com/doc/I/n/Installing_source_tree.html LBc to see how to proceed At the moment I am using Windows 2000 and BitKeeper 2.1 for Windows. After applying the : bk clonebk://work.mysql.com:7001 mysql-4.0 I have got following message: == Sfio has detected a name conflict between BitKeeper/deleted/SCCS/s..del-Makefil e.w32 and BitKeeper/deleted/SCCS/s..del-makefile.w32; This usually happens when you transfer file from a case-sensitive file system (e.g. Unix) to a case insensitive file system (e.g FAT, NTFS) Please rename one of the files and retry (see also bk helptool mv) Note: You must do the rename in the sending repository. == In hope to fix it via bk pull and I have used the: cd mysql-4.0 bk pull bk://work.mysql.com:7001 Nothing to pull from bk://work.mysql.com:7001 when I have checked my local copy via: bk -r check -a I have got plenty of files that was not resolved. Am I doing something wrong or I shall forget about BitKeeper as I am using the Windown 2000? Any suggestion? Thanks, Viliam Batka -- Colin Faber (303) 736-5160 fpsn.net, Inc. - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RAND and MySQL version!
Hello All, I am running 2 MySQL servers, one on Linux, and the other on FreeBSD. Linux, MySQL version: 3.23.49 FreeBSD, MySQL version: 3.22.32 Problem: The following code runs on the newer version of MySQL, and Linux, but when I run it on the other server, I get sql error. SELECT ID,Headlines,IsActive FROM DATABASE WHERE IsActive=1 ORDER BY RAND() LIMIT 1 Can anyone please tell me if it's the version of MySQL causing this problem or something else? Is there anyway to get around this, without upgrading MySQL? Thanks so much, Soheil - 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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php