how to upgrade mysql from 3.20 to 3.23
Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to upgrade mysql from 3.20 to 3.23
Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL extensions in C
Hello, I read in the docs about the extensions but I didn't met any example. Please, if you could, give me a link or a site with extensions in C/C++ for MySQL. Best Regards, Iulian Teodosiu Economist/software developer Falticeni Municipality -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to 'tell' the select what to omit
Hallo suppose you have a table with great number of columns (20 or 30), and you would like to specify every one but two or tree columns in a SELECT statement. Is there a way to specify only those two or tree columns for omission (which would be the 'short' way to do the job) instead of specifying every column that needed (which would be the 'long' way to do the job). Example: The 'TName' table header: id | name | surname | dateOB | idSCHOOL | idCITY | idSTATE | sex | idParent1 | idParent2 | interests | weight | height | age | auditDate | idAudittor | You need every field except the 'dateOB' and 'idSCHOOL' Ordinary select wold be: SELECT id,name,surname,idCITY,idSTATE,sex,idParent1,idParent2,interests,weight,height,age,auditDate,idAudittor, FROM TName It is too long expression, is there a way to specify only 'dateOB' and 'idSCHOOL' - the two column that are unwanted in the result set - in order to make the SELECT shorter? The SELECT should return every column but the specified ones.
Problem reading my.cnf
Hi, I have just upgraded mysql server version from 4.0.13 to 4.0.14, from FreeBSD 5.1 ports collection. Before upgrade mysql command line client could read password from /etc/my.cnf file and I could use mysql without supplying -p option. But after upgrade it could read password only up to # sign. For instance in /etc/my.cnf file: [client] password= test#istest$ port= 3306 socket= /tmp/mysql.sock When I issue command mysql --print-defaults it prints: mysql would have been started with the following arguments: --password=test --port=3306 --socket=/tmp/mysql.sock --no-auto-rehash Is this a bug of mysql command line client or it is something different? Is there anybody who solved this already? thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to Ask Questions the Smart Way...
Maybe the weed has got me high right now, but here is something some of you on this list may find funny, others may find this useful. This is not spam, this is actually a good manual you should all read: http://catb.org/~esr/faqs/smart-questions.html Good Reading. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem reading my.cnf
Try to not use # if you want the password to be in my.cnf file. The # is for comments if my.cnf file. - Original Message - From: Ganbold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:08 AM Subject: Problem reading my.cnf Hi, I have just upgraded mysql server version from 4.0.13 to 4.0.14, from FreeBSD 5.1 ports collection. Before upgrade mysql command line client could read password from /etc/my.cnf file and I could use mysql without supplying -p option. But after upgrade it could read password only up to # sign. For instance in /etc/my.cnf file: [client] password= test#istest$ port= 3306 socket= /tmp/mysql.sock When I issue command mysql --print-defaults it prints: mysql would have been started with the following arguments: --password=test --port=3306 --socket=/tmp/mysql.sock --no-auto-rehash Is this a bug of mysql command line client or it is something different? Is there anybody who solved this already? thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to Ask Questions the Smart Way...
Ralph, Yes, indeed. It's a good idea to read this book. Iulian - Original Message - From: Ralph Guzman [EMAIL PROTECTED] To: mySQL Mailing List [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:13 AM Subject: How to Ask Questions the Smart Way... Maybe the weed has got me high right now, but here is something some of you on this list may find funny, others may find this useful. This is not spam, this is actually a good manual you should all read: http://catb.org/~esr/faqs/smart-questions.html Good Reading. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem reading my.cnf
Hi, It was Ok in previous version of mysql. Why they changed ? Thanks anyway. Ganbold At 11:21 AM 8/4/2003 +0300, you wrote: Try to not use # if you want the password to be in my.cnf file. The # is for comments if my.cnf file. - Original Message - From: Ganbold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:08 AM Subject: Problem reading my.cnf Hi, I have just upgraded mysql server version from 4.0.13 to 4.0.14, from FreeBSD 5.1 ports collection. Before upgrade mysql command line client could read password from /etc/my.cnf file and I could use mysql without supplying -p option. But after upgrade it could read password only up to # sign. For instance in /etc/my.cnf file: [client] password= test#istest$ port= 3306 socket= /tmp/mysql.sock When I issue command mysql --print-defaults it prints: mysql would have been started with the following arguments: --password=test --port=3306 --socket=/tmp/mysql.sock --no-auto-rehash Is this a bug of mysql command line client or it is something different? Is there anybody who solved this already? thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem reading my.cnf
Ganbold Because the bug that did not recognise the comment character in the password line has been fixed? Andy -Original Message- From: Ganbold [mailto:[EMAIL PROTECTED] Sent: 04 August 2003 09:51 To: Primaria Falticeni Cc: [EMAIL PROTECTED] Subject: Re: Problem reading my.cnf Hi, It was Ok in previous version of mysql. Why they changed ? Thanks anyway. Ganbold At 11:21 AM 8/4/2003 +0300, you wrote: Try to not use # if you want the password to be in my.cnf file. The # is for comments if my.cnf file. - Original Message - From: Ganbold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:08 AM Subject: Problem reading my.cnf Hi, I have just upgraded mysql server version from 4.0.13 to 4.0.14, from FreeBSD 5.1 ports collection. Before upgrade mysql command line client could read password from /etc/my.cnf file and I could use mysql without supplying -p option. But after upgrade it could read password only up to # sign. For instance in /etc/my.cnf file: [client] password= test#istest$ port= 3306 socket= /tmp/mysql.sock When I issue command mysql --print-defaults it prints: mysql would have been started with the following arguments: --password=test --port=3306 --socket=/tmp/mysql.sock --no-auto-rehash Is this a bug of mysql command line client or it is something different? Is there anybody who solved this already? thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem reading my.cnf
Try to quote the password: password= 'test#istest$' or password= test#istest$ Not sure if MySQL is doing command expansion. If yous, use the first example, if not, it should not matter. Cheers /rudy -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 11:00 To: Mysql List Subject: RE: Problem reading my.cnf Ganbold Because the bug that did not recognise the comment character in the password line has been fixed? Andy -Original Message- From: Ganbold [mailto:[EMAIL PROTECTED] Sent: 04 August 2003 09:51 To: Primaria Falticeni Cc: [EMAIL PROTECTED] Subject: Re: Problem reading my.cnf Hi, It was Ok in previous version of mysql. Why they changed ? Thanks anyway. Ganbold At 11:21 AM 8/4/2003 +0300, you wrote: Try to not use # if you want the password to be in my.cnf file. The # is for comments if my.cnf file. - Original Message - From: Ganbold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:08 AM Subject: Problem reading my.cnf Hi, I have just upgraded mysql server version from 4.0.13 to 4.0.14, from FreeBSD 5.1 ports collection. Before upgrade mysql command line client could read password from /etc/my.cnf file and I could use mysql without supplying -p option. But after upgrade it could read password only up to # sign. For instance in /etc/my.cnf file: [client] password= test#istest$ port= 3306 socket= /tmp/mysql.sock When I issue command mysql --print-defaults it prints: mysql would have been started with the following arguments: --password=test --port=3306 --socket=/tmp/mysql.sock --no-auto-rehash Is this a bug of mysql command line client or it is something different? Is there anybody who solved this already? thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication question
HI all, Is it possible to perform replication as follow? HOW? master (innodb) ---replication--- slave (myisam) Rgds, Ringo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: replication question
Replication just executes the commands in the binary log (i.e INSERT, UPDATE, DELETE, ...). So if you make sure that you do not issue a DDL for creation/altering in the master DB, everything should work fine. However, I would advice against it (it is not a supported feature, but a trick) Cheers /rudy -Original Message- From: unplug [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 12:03 To: mysql Subject: replication question HI all, Is it possible to perform replication as follow? HOW? master (innodb) ---replication--- slave (myisam) Rgds, Ringo -- 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]
Convert date from .txt file
How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Convert date from .txt file
[snip] How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? [/snip] LOAD DATA INFILE cannot do the conversion on-the-fly. You could use a scripting language (sed, awk,etc.) to read and convert the dates. HTH! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Convert date from .txt file
Or load the date into a column date_str and then convert and copy the date into a column date AFTER loading. Cheers /rudy ps: I already posted a function of how to convert this date format into a MySQL date format somewhere on this list (prev month I think) -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 14:08 To: Andre Winarko; [EMAIL PROTECTED] Subject: RE: Convert date from .txt file [snip] How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? [/snip] LOAD DATA INFILE cannot do the conversion on-the-fly. You could use a scripting language (sed, awk,etc.) to read and convert the dates. HTH! -- 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]
Security related! Not possible to hide table structure. I couldn't find..... ?
Hello, Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4 You want to give a specific permission to a user named USER1 For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1. and you did not assignany other permission to USER1. Now everything is OK! USER1 can only select FIELD1 and FIELD4, and can not see data or change or etc.. to FIELD2 or FIELD3.. So we think that everything is OK! But, USER1 is still able to see the table structure of TABLE1. He see fields which i don't want him to see! As i searched internet related to this topic i couldn't find any satistfactory solution to this one. Anyone has idea to prevent USER1 to be able to see table structure and only permission to SELECT FIELD1 and FIELD4 as i assigned? Also there should be some default error message for these users when they try to select from another field. why? Because if my first question gets answered and solved, then, USER1 can try to SELECT FIELD3 FROM TABLE1.. .and it will say something like "you have no permission for FIELD3" insted of this, it can be "This field does not exist".. Thanks. QWERTY IncrediMail - Email has finally evolved - Click Here
RE: Security related! Not possible to hide table structure. I couldn't find..... ?
If you give access rights to a user on a DB, he will always be able to see the table structure. This is how it is implemented in MySQL (which does not mean that I like this). Cheers /rudy -Original Message- From: QWERTY [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 14:47 To: [EMAIL PROTECTED] Subject: Security related! Not possible to hide table structure. I couldn't find. ? Hello, Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4 You want to give a specific permission to a user named USER1 For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1. and you did not assign any other permission to USER1. Now everything is OK! USER1 can only select FIELD1 and FIELD4, and can not see data or change or etc.. to FIELD2 or FIELD3.. So we think that everything is OK! But, USER1 is still able to see the table structure of TABLE1. He see fields which i don't want him to see! As i searched internet related to this topic i couldn't find any satistfactory solution to this one. Anyone has idea to prevent USER1 to be able to see table structure and only permission to SELECT FIELD1 and FIELD4 as i assigned? Also there should be some default error message for these users when they try to select from another field. why? Because if my first question gets answered and solved, then, USER1 can try to SELECT FIELD3 FROM TABLE1.. .and it will say something like you have no permission for FIELD3 insted of this, it can be This field does not exist.. Thanks. QWERTY http://www.incredimail.com/redir.asp?ad_id=309lang=9 IncrediMail - Email has finally evolved - Click Here http://www.incredimail.com/redir.asp?ad_id=309lang=9
Re: Creating Grant Tables on WinXP
[EMAIL PROTECTED] wrote: I've installed 4.0.13 on a WinXP system. The service starts and stops just fine, but I cannot connect to the server, nor can I ping the 3306 port. I think the problem may be failure to complete the post-installation processing. The doc says to run installdir\scripts\mysql_install_db. However that file looks like a Unix shell script, not a Windows .bat file (and windows refuses to run it) Am I looking in the wrong place? Is there a Win script elsewhere? Do I have an even more basic problem? Privilege tables are created during installation on Windows. Use telnet to check if the server is up. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to 'tell' the select what to omit
Miroslav I. [EMAIL PROTECTED] wrote: suppose you have a table with great number of columns (20 or 30), and you would like to specify every one but two or tree columns in a SELECT statement. Is there a way to specify only those two or tree columns for omission (which would be the 'short' way to do the job) instead of specifying every column that needed (which would be the 'long' way to do the job). Example: The 'TName' table header: id | name | surname | dateOB | idSCHOOL | idCITY | idSTATE | sex | idParent1 | idParent2 | interests | weight | height | age | auditDate | idAudittor | You need every field except the 'dateOB' and 'idSCHOOL' Ordinary select wold be: SELECT id,name,surname,idCITY,idSTATE,sex,idParent1,idParent2,interests,weight,height,age,auditDate,idAudittor, FROM TName It is too long expression, is there a way to specify only 'dateOB' and 'idSCHOOL' - the two column that are unwanted in the result set - in order to make the SELECT shorter? The SELECT should return every column but the specified ones. You can't. -- 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]
Extensions for MySQL in C not MySQL API
Hello, I want to make some extensions for MySQL in C/C++. Please give me some samples. I read the documentation but I didn't find anything about this. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_connections doesn't change
Jan Josefowicz [EMAIL PROTECTED] wrote: I'm trying to change the value of max_connections variable but mysqld doesn't accept that. I use mysql 3.23.54 and my config file /etc/my.cnf looks like: [mysql.server] ... ... set-variable max_connections=200 After a newstart of mysqld the value of max_connections is unchanged and equals 100. mysql.server understands only basedir, datadir and pid-file options. Put entry for max_connections to the [mysqld] section of my.cnf. -- 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]
Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing
Hello programmers this is my path, C:\mysql\binpath PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\mysql\bin After installing 4.1.0-alpha-max-debug I try to start winmysqladmin.exe Then I get this error, === Die dynamic link library libmysql.dll wurde nicht im angegebenen Pfad C:\mysql\bin;.; C:\WINNT\System32; C:\WINNT\System; C:\WINNT; C:\WINNT\System32; C:\WINNT; C:\WINNT\System32\Wbem; C:\mysql\bin Gefunden. === However I found it in C:Mysql\lib\debug And C:Mysql\lib\opt What can I do, please ? I think my path identifier is correct, I simply appended the last ;C:\mysql\bin entry myself and it run fine under 4.1 beta. Also with support for InnoDB tables. In english the error means that winmysqladmin.exe can't run under 4.0.1 alpha, unfortunately Is this true ? When is final release of 4.1.0 scheduled please ? I highly appreciate and thank you all eternally for Enabling nested selects like SELECT article, dealer, price FROM shop WHERE price=(SELECT MAX(price) FROM shop) Which is pure SQL-99 I think, and compatible with oracle sql. And finally I'd like to know what is support for named pipes? Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing
At 16:06 4/8/2003 +0200, Morten Gulbrandsen wrote: Hi, Just copy c:\mysql\lib\opt\libmysql.dll into the c:\mysql\bin directory. When is final release of 4.1.0 scheduled please ? I highly appreciate and thank you all eternally for Enabling nested selects like SELECT article, dealer, price FROM shop WHERE price=(SELECT MAX(price) FROM shop) Which is pure SQL-99 I think, and compatible with oracle sql. And finally I'd like to know what is support for named pipes? Yours Sincerely Morten Gulbrandsen -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication and LOAD DATA INFILE MySQL Max 3.23.56-1
Hello, After recently replicating using the stop databases and copy innodb and mysql files method, things were fine... Until the slave thread stopped complaining about duplicate rows after one of our developers did a LOAD DATA INFILE operation on the master. Unfortunately the insert's are into a table using AUTO_INCREMENT as well and this may be compounding the problem. I have read the docs, but it's sort of unclear, does LOAD DATA INFILE work in a replicated 3.23.56-1 setup, only under certain circumstances, or not at all? Your help is greatly appreciated. Thanks. -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. signature.asc Description: This is a digitally signed message part
MySQL, IIS and PHP
Hi all I've just recoded a website in PHP from ASP, running off IIS 5. It has been tested by a dozen users over the weekend, but now I have put it live the CPU utilisation is up at 100%, mainly swallowed up by mysql-nt.exe. I wondered if anyone could offer any advice as to why this could be (the MySQL settings have not changed, and are as they were when it was accessed via the ASP code). Regards Gary
table error 127
I have mysql setup on two computers with identical databases. When I run a group of queries on the one computer I get back an error 127 which I checked on an it appears to be a table corruption error. On the other computer, the queries run fine. Since I had all the data for the table in question in a data file, I just dropped the table and recreated it. The error still appeared. Any suggestions on what to try next? The only other thing I can think of is to compare the mysql versions to see if I have an older version on the other computer.
Open Source Software Survey
Dear MySQL Contributors, I am studying for a Master's degree with Henley Management College in the UK, and in the past have used a variety of Open Source Software. As part of my course I am conducting a survey in an attempt to identify the critical success factors for Open Source projects. If you are a user or developer for MySQL, I would be very grateful if you could spare 2 or 3 minutes to fill in my questionnaire at the following URL: http://surveys.ideoconcepts.com/surveyor/index.php?sid=4projectid=MySQL This survey is completely confidential. Please accept my apologies if this is regarded as an off-topic posting. Thank you very much for your help, Neil Hambleton Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SubQuery bug in 4.1
Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should work. But it does not, and sets the Value fields to incorrect values. update main set Value = (select SubValue from sub where main.ID = sub.mainID order by KeyDate desc limit 1) Any ideas? Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SubQuery bug in 4.1
Daniel Kiss writes: Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should work. But it does not, and sets the Value fields to incorrect values. update main set Value = (select SubValue from sub where main.ID = sub.mainID order by KeyDate desc limit 1) Any ideas? Thanks, Dan Can you try (with 4.1.1 from our BK tree): update main set Value = (select max(SubValue) from sub); There should also be a WHERE clause for update statement or all rows will be updated. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator ___/ www.mysql.com Larnaca, Cyprus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SubQuery bug in 4.1
Surely this will just work? update main,sub set main.Value = sub.subValue where main.id=sub.mainid; Or have I misunderstood what you are wanting? -- Mark - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 04, 2003 4:09 PM Subject: SubQuery bug in 4.1 Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should work. But it does not, and sets the Value fields to incorrect values. update main set Value = (select SubValue from sub where main.ID = sub.mainID order by KeyDate desc limit 1) Any ideas? Thanks, Dan -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL extension
Hello, Would you help me with some samples for making a MySQL extension in C/C++? Please! Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SubQuery bug in 4.1
Your primary query has no where clause, so you are setting all Value to a value from a random record for the most recent date. Hardly looks like a 'bug' to me. And why the cross post? Daniel Kiss wrote: Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should work. But it does not, and sets the Value fields to incorrect values. update main set Value = (select SubValue from sub where main.ID = sub.mainID order by KeyDate desc limit 1) Any ideas? Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books advice
At 21:04 -0400 7/31/03, Asif Iqbal wrote: I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois Comparison information: http://www.kitebird.com/mysql-book-comparison.php This page also includes links to each book's home page that provides other information about the book such as ISBN. On Thu, 31 Jul 2003, Ralph Guzman wrote: Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extensions for MySQL in C not MySQL API
At 16:40 +0300 8/4/03, Primaria Falticeni wrote: Hello, I want to make some extensions for MySQL in C/C++. Please give me some samples. I read the documentation but I didn't find anything about this. Thanks Anticipated, Iulian What do you mean by extension? If you mean user-defined function, the manual addresses that topic: http://www.mysql.com/doc/en/Adding_functions.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to ADD databases
Hello All - I'm just started the process of learning MySQL and databases in general. I just bought the book 'MySQL' written by Paul DuBois, who I gather is really active in this community. Anyhow.. Here's the problem that I'm having. mysql GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDENTIFIED BY 'secret'; Query OK, 0 rows affected (0.00 sec) mysql show databases; +--+ | Database | +--+ | helpdesk | | mysql| | test | +--+ 3 rows in set (0.01 sec) Anyone notice the problem? Even though I get no error.. the sampdb is not being greated. This is weird as I've been able to use this exact command in the past with no problems. I even tried logging in as root before starting the mysql client, still made no difference. Thanks in advance.. Jeff
Re: table error 127
Jonathan Patton wrote: I have mysql setup on two computers with identical databases. When I run a group of queries on the one computer I get back an error 127 which I checked on an it appears to be a table corruption error. On the other computer, the queries run fine. Since I had all the data for the table in question in a data file, I just dropped the table and recreated it. The error still appeared. Any suggestions on what to try next? The only other thing I can think of is to compare the mysql versions to see if I have an older version on the other computer. Jonathan, Have you tried running myisamchk on the database in question before running queries on it? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books advice
Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff +---+ | Jeffery C Baldwin | Computer Consultant II | | University of North Carolina - Chapel Hill | 213 Miller Hall | CB# 1105 | Chapel Hill, NC 27599 | | Phone: (919) 843-2725 | Fax: (919) 966-8928 | E-Mail: jeff_baldwin at unc dot edu +---+ -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:02 PM To: Asif Iqbal; Ralph Guzman Cc: 'Fawad Siddiqui'; [EMAIL PROTECTED] Subject: RE: Books advice At 21:04 -0400 7/31/03, Asif Iqbal wrote: I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois Comparison information: http://www.kitebird.com/mysql-book-comparison.php This page also includes links to each book's home page that provides other information about the book such as ISBN. On Thu, 31 Jul 2003, Ralph Guzman wrote: Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to ADD databases
Jeffery C. Baldwin wrote: Hello All - I'm just started the process of learning MySQL and databases in general. I just bought the book 'MySQL' written by Paul DuBois, who I gather is really active in this community. Anyhow.. Here's the problem that I'm having. mysql GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDENTIFIED BY 'secret'; Query OK, 0 rows affected (0.00 sec) mysql show databases; +--+ | Database | +--+ | helpdesk | | mysql| | test | +--+ 3 rows in set (0.01 sec) Anyone notice the problem? Even though I get no error.. the sampdb is not being greated. This is weird as I've been able to use this exact command in the past with no problems. I even tried logging in as root before starting the mysql client, still made no difference. Thanks in advance.. Jeff Jeff, You probably need to create the database first. create database sampdb then do the grant all walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unable to ADD databases
A GEEZ! I apologize to all, I did not take the time to 'think' before I wrote. Sorry for the waste of bandwidth :-) And thank you to Leonardo for the reply. Jeff -Original Message- From: Leonardo Rodrigues Magalhães [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:21 PM To: Jeffery C. Baldwin Subject: Re: Unable to ADD databases Seems no problem at all. GRANT does not CREATE databases, it just GRANT privileges. If you need to create a new database, you should try: create database mynewdatabase; Sincerily, Leonardo Rodrigues - Original Message - From: Jeffery C. Baldwin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 1:06 PM Subject: Unable to ADD databases Hello All - I'm just started the process of learning MySQL and databases in general. I just bought the book 'MySQL' written by Paul DuBois, who I gather is really active in this community. Anyhow.. Here's the problem that I'm having. mysql GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDENTIFIED BY 'secret'; Query OK, 0 rows affected (0.00 sec) mysql show databases; +--+ | Database | +--+ | helpdesk | | mysql| | test | +--+ 3 rows in set (0.01 sec) Anyone notice the problem? Even though I get no error.. the sampdb is not being greated. This is weird as I've been able to use this exact command in the past with no problems. I even tried logging in as root before starting the mysql client, still made no difference. Thanks in advance.. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books advice
At 12:14 -0400 8/4/03, Jeffery C. Baldwin wrote: Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Thanks, I hope you find it helpful. I agree that it would be nice were the book a bit shorter. If there is a third edition, I will probably trim the 3.22/3.23 material to an appendix or web-accessible-only addendum and make 4.0 the baseline version to keep the size down. :-) Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff +---+ | Jeffery C Baldwin | Computer Consultant II | | University of North Carolina - Chapel Hill | 213 Miller Hall | CB# 1105 | Chapel Hill, NC 27599 | | Phone: (919) 843-2725 | Fax: (919) 966-8928 | E-Mail: jeff_baldwin at unc dot edu +---+ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to ADD databases
On 4 Aug 2003 at 12:06, Jeffery C. Baldwin wrote: Anyone notice the problem? Even though I get no error.. the sampdb is not being greated. When are you attempting to create it? All you've shown is a GRANT statement, which creates *permissions* for the database (and works even if the database doesn't exist yet). To actually create the database you need to use CREATE DATABASE: http://www.mysql.com/doc/en/CREATE_DATABASE.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adv. Mysql query
- Original Message - From: Andy Jackman [EMAIL PROTECTED] To: Mattias Larsson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 02, 2003 4:23 PM Subject: Re: Adv. Mysql query Mattias, It may not be such a good idea to store the 6 items in 1 record. An alternative structure is one table with Item ID and Name and another with Item Id and Component Id, both of which point back to item id in the first table. I also thought that using the SET datatype would be good. But with a set you first of all are doing string instead of numeric matching. Second of all, I don't know if there is a way to take a set as a result set and pass each individual element of the set from a subquery. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extensions for MySQL in C not MySQL API
Yes, indeed! Sorry for mistake. I'd like to know functions in MySQL I can use for replacing. For example: in the docs it's writing about xxx_reset This function is called when MySQL finds the first row in a new group. . I need the description of such kind of the functions which can be wrapped and the results which can be provided by them. Thank Anticipated, Iulian - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Primaria Falticeni [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 04, 2003 7:05 PM Subject: Re: Extensions for MySQL in C not MySQL API At 16:40 +0300 8/4/03, Primaria Falticeni wrote: Hello, I want to make some extensions for MySQL in C/C++. Please give me some samples. I read the documentation but I didn't find anything about this. Thanks Anticipated, Iulian What do you mean by extension? If you mean user-defined function, the manual addresses that topic: http://www.mysql.com/doc/en/Adding_functions.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Security related! Not possible to hide table structure. I couldn't find..... ?
what is so bad at seeing the table structure? i mean to work with the table, you need to know the fields and their types to avoid syntax errors. and what should happen on a SELECT * FROM...? do you want to see nothing, because it would let the user know about the structure, or all fields, as normal? or what about sql admin progs like phpmyadmin? i think they rely on getting all the fields to show a table. i've heard about table views in mysql 5. would that already be a solution for that? -yves -Ursprüngliche Nachricht- Von: Rudy Metzger [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Montag, 4. August 2003 14:50 Betreff: RE: Security related! Not possible to hide table structure. I couldn't find. ? If you give access rights to a user on a DB, he will always be able to see the table structure. This is how it is implemented in MySQL (which does not mean that I like this). Cheers /rudy -Original Message- From: QWERTY [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 14:47 To: [EMAIL PROTECTED] Subject: Security related! Not possible to hide table structure. I couldn't find. ? Hello, Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4 You want to give a specific permission to a user named USER1 For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1. and you did not assign any other permission to USER1. Now everything is OK! USER1 can only select FIELD1 and FIELD4, and can not see data or change or etc.. to FIELD2 or FIELD3.. So we think that everything is OK! But, USER1 is still able to see the table structure of TABLE1. He see fields which i don't want him to see! As i searched internet related to this topic i couldn't find any satistfactory solution to this one. Anyone has idea to prevent USER1 to be able to see table structure and only permission to SELECT FIELD1 and FIELD4 as i assigned? Also there should be some default error message for these users when they try to select from another field. why? Because if my first question gets answered and solved, then, USER1 can try to SELECT FIELD3 FROM TABLE1.. .and it will say something like you have no permission for FIELD3 insted of this, it can be This field does not exist.. Thanks. QWERTY http://www.incredimail.com/redir.asp?ad_id=309lang=9 IncrediMail - Email has finally evolved - Click Here http://www.incredimail.com/redir.asp?ad_id=309lang=9 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RE: Books advice
Paul's book is long, but like good code, it's modular, so the length isn't an issue. From: Jeffery C. Baldwin [EMAIL PROTECTED] Date: 2003/08/04 Mon AM 11:14:29 CDT To: 'Paul DuBois' [EMAIL PROTECTED], 'Asif Iqbal' [EMAIL PROTECTED], 'Ralph Guzman' [EMAIL PROTECTED] CC: 'Fawad Siddiqui' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Books advice Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff +---+ | Jeffery C Baldwin | Computer Consultant II | | University of North Carolina - Chapel Hill | 213 Miller Hall | CB# 1105 | Chapel Hill, NC 27599 | | Phone: (919) 843-2725 | Fax: (919) 966-8928 | E-Mail: jeff_baldwin at unc dot edu +---+ -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:02 PM To: Asif Iqbal; Ralph Guzman Cc: 'Fawad Siddiqui'; [EMAIL PROTECTED] Subject: RE: Books advice At 21:04 -0400 7/31/03, Asif Iqbal wrote: I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois Comparison information: http://www.kitebird.com/mysql-book-comparison.php This page also includes links to each book's home page that provides other information about the book such as ISBN. On Thu, 31 Jul 2003, Ralph Guzman wrote: Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Order by umm OR?
Hey Kevin, Ya I know thousands of items in the IN clause is not a good way, and it takes a while but from all the other process I've tried it has been actually the quickest (join for instance takes longer on my tests). Like yourself though I'm quiet clueless on what another way to do this might be even though I believe there should be one. As it is right now I simply think I need a faster server that could handle such processes faster. It gets even worse when I try to do a SUM() when dealing with thousands of records.. Now that takes a long time. But other then creating cache type tables when that happens I don't know a work around for that either. Best, Yoed -Original Message- From: Kevin Fries [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 10:59 AM To: 'Yoed' Subject: RE: Order by umm OR? Wow. Thousands of items in your IN clause? That sounds like a justification for finding another way to do this. I don't have much in mind, but maybe joining to another table containing those ID's would help you further. Might be a worthy experiment. As for the FIELD() function, yes. Sounds great. And more terse than my CASE statement. One thing to consider is that the CASE statement is ANSI compliant, and I use it on Oracle, Sql Server, MySQL, and a host of other DBMS's. FIELD and ELT (the corollary) are mysql specific. Good luck, Kevin -Original Message- From: Kevin Fries [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 3:06 PM To: 'Yoed'; [EMAIL PROTECTED] Subject: RE: Order by umm OR? Not surprising, the dbms has no built-in support for ordering rows by the filters in the where clause. But with a bit of programming you should be able to construct a useful ORDER BY clause to do what you want... SELECT * FROM company WHERE id='3' OR id='1' OR id='7' ORDER BY CASE id when '3' then 1 when '1' then 2 when '7' then 3 else 4 end; So you'll have to construct the ORDER BY to relate each successive OR item into a 'when ... then' subclause. It's not pretty, but it works. Kevin PS: consider using WHERE id in ( '3', '1', '7') instead for brevity. -Original Message- From: Yoed [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 12:34 PM To: [EMAIL PROTECTED] Subject: Order by umm OR? Hi, Lets say I have a query similar to: SELECT * FROM company WHERE id='3' OR id='1' OR id='7' ; I want to be able to get the results to come out ordered by the order the ids were searched (the sequence in the WHERE OR; 3 first then 1, then 7...), so the results would be like: Row | id| name --- 0 | 3 | Joe's Co 1 | 1 | Buymart 2 | 7 | The big evil As it is the results returns it like id 1, then 3, and 7. Thanks for your help guys, Best, Yoed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table error 127
I have been getting this type of error ever since I upgraded from MySQL 3 to 4. I actually have set up a cron to check/repair tables hourly because of this. The following diagnoses have been suggested, but I would bet it's an obscure MySQL bug: 1. Kernel 2.4.18 IO problem 2. Another shared library linked to MySQL (I use RPMs) 3. RAID issue causing corruption Unfortunately I haven't been able to pinpoint which query causes the issue so I can't report a bug. It anyone else has experienced this or has information on it, I would really appreciate it. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: walt [EMAIL PROTECTED] To: Jonathan Patton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:11 PM Subject: Re: table error 127 Jonathan Patton wrote: I have mysql setup on two computers with identical databases. When I run a group of queries on the one computer I get back an error 127 which I checked on an it appears to be a table corruption error. On the other computer, the queries run fine. Since I had all the data for the table in question in a data file, I just dropped the table and recreated it. The error still appeared. Any suggestions on what to try next? The only other thing I can think of is to compare the mysql versions to see if I have an older version on the other computer. Jonathan, Have you tried running myisamchk on the database in question before running queries on it? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table error 127
On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote: I have been getting this type of error ever since I upgraded from MySQL 3 to 4. I actually have set up a cron to check/repair tables hourly because of this. The following diagnoses have been suggested, but I would bet it's an obscure MySQL bug: 1. Kernel 2.4.18 IO problem 2. Another shared library linked to MySQL (I use RPMs) 3. RAID issue causing corruption Unfortunately I haven't been able to pinpoint which query causes the issue so I can't report a bug. It anyone else has experienced this or has information on it, I would really appreciate it. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Richard, You may already know this, but here is a snipit out of the manual If you run mysqld with --skip-locking (which is the default on some systems, like Linux), you can't reliably use myisamchk to check a table when mysqld is using the same table. If you can be sure that no one is accessing the tables through mysqld while you run myisamchk, you only have to do mysqladmin flush-tables before you start checking the tables. If you can't guarantee the above, then you must take down mysqld while you check the tables. If you run myisamchk while mysqld is updating the tables, you may get a warning that a table is corrupt even if it isn't. -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak it CONFIDENTIALITY NOTICE The information contained in this email may contain legally privileged and confidential information intended only for the use of the individual noted above. If you are not the intended recipient or employee or agent of the entity listed above, you are hereby notified that any reading, disclosure, distribution, or copying of this email communication in any way, or the taking of any action in relation to this communication, is strictly prohibited. If you have received this email in error, please immediately notify the sender and contact our Privacy Officer at (800) 782-5150 ext: 1601. If you were not the intended recipient, please delete it from your files. Thank you for your compliance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SubQuery bug in 4.1
Mark, I agree there is no reason for the sub-select. I'd make one change in response to the original request - asking for the most recent item. Take Mark's statement and suffix AND m.KeyDate = MAX(m.KeyDate); to the last WHERE statement (see example). UPDATE main m, sub s SET m.Value = s.subValue WHERE m.id= s.mainid AND m.KeyDate = MAX(m.KeyDate); I'm not sure if this is a bug with MySQL. What are the results you're getting? The sub-select you wrote will retrieve multiple rows (assuming you have multiple rows for a sub.MainId, which I assume you do by the requirment for the most recent item). Maybe I'm really off :( Regards, A$ - Original Message - From: Mark Hedges [EMAIL PROTECTED] Date: Monday, August 4, 2003 11:16 am Subject: Re: SubQuery bug in 4.1 Surely this will just work? update main,sub set main.Value = sub.subValue where main.id=sub.mainid; Or have I misunderstood what you are wanting? -- Mark - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 04, 2003 4:09 PM Subject: SubQuery bug in 4.1 Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should work. But it does not, and sets the Value fields to incorrect values. update main set Value = (select SubValue from sub where main.ID = sub.mainID order by KeyDate desc limit 1) Any ideas? Thanks, Dan -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
File Permission
Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2. Thank you. - David Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
doubts
Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ Sir, My name is Reji.Iam studying for a master degree in computer applications.Iam new to mySQL.I don't know how to connect java with mySQL.Iam using home pc.Following are the tools that iam using. operating system:windowsXP java:jdk1.3 on D:\jdk1.3 mySQL :ver 12.21 server version 4.0.14-nt for win95/98 (i32) on c:\mysql SSl :not in use connection :local host via TCP/IP tcp port:3306 MySQL control center:mysqlcc-0.9.2-win32 on F:\mysqlcc connector/j :mysql-connector-java-3.0.8-stable on d:\jdk1.3\bin (copied both com and org in another folder(comorg) and put it in the bin folder of jdk I have the following problems: (1) I can't make a connection to mySQl through java.When I tried to run it,an error is displayed as follows: ClassNotFoundException:com.mysql.jdbc.Driver SQLException : No suitable driver (2) I can't change the user [EMAIL PROTECTED] I tried it using the grant option, (GRANT ALL PRIVILEGES ON MYDATABASE.* TO REJI@'%' IDENTIFIED BY '' WITH GRANT OPTION;), an error is displayed as follows: ERROR 1044:Access denied for user:'@localhost' to database 'hhtransport' When i tried it with the console manager(control center),the message displayed is 'user created sucessfully'.But when I use mysql the same error(1044) occurs.Please give me a solution to these problems. Thanks REJI.M.S MUDUVILAKOM THOTTAVARAM ATTINGAL(PO) TRIVANDRUM KERALA INDIA PIN695101 EMAIL:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: File Permission
Since you don't show your grant statement, it is difficult tell you what the problem is. Since FILE is a global permission you need to grant it on *.* not somedatabase.* David Scott wrote: Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2. Thank you. - David Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query Help
I have a table that records connections from customers to our server. When there is a software problem with our customer's that have older versions of our software, it will dial our server constantly over and over again. I want to be able to detect this by having a query that does something like this.. (I know this where clause won't really work) Select count(cust.id) from cust where cust.time UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1 HOUR)) count(cust.id) 5 Group by cust.id; Is there a way to do this with one query? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table error 127
Thanks walt. Actually I use mysqlcheck to check the databases. This can be safely run while the server is in use. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: walt [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED]; Jonathan Patton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 2:26 PM Subject: Re: table error 127 On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote: I have been getting this type of error ever since I upgraded from MySQL 3 to 4. I actually have set up a cron to check/repair tables hourly because of this. The following diagnoses have been suggested, but I would bet it's an obscure MySQL bug: 1. Kernel 2.4.18 IO problem 2. Another shared library linked to MySQL (I use RPMs) 3. RAID issue causing corruption Unfortunately I haven't been able to pinpoint which query causes the issue so I can't report a bug. It anyone else has experienced this or has information on it, I would really appreciate it. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Richard, You may already know this, but here is a snipit out of the manual If you run mysqld with --skip-locking (which is the default on some systems, like Linux), you can't reliably use myisamchk to check a table when mysqld is using the same table. If you can be sure that no one is accessing the tables through mysqld while you run myisamchk, you only have to do mysqladmin flush-tables before you start checking the tables. If you can't guarantee the above, then you must take down mysqld while you check the tables. If you run myisamchk while mysqld is updating the tables, you may get a warning that a table is corrupt even if it isn't. -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak it CONFIDENTIALITY NOTICE The information contained in this email may contain legally privileged and confidential information intended only for the use of the individual noted above. If you are not the intended recipient or employee or agent of the entity listed above, you are hereby notified that any reading, disclosure, distribution, or copying of this email communication in any way, or the taking of any action in relation to this communication, is strictly prohibited. If you have received this email in error, please immediately notify the sender and contact our Privacy Officer at (800) 782-5150 ext: 1601. If you were not the intended recipient, please delete it from your files. Thank you for your compliance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Query Help
So you want to group by the customer, but only show those gorupings with a count 5. That means you want to apply your restriction after the GROUP BY. Thus, the clause goes into the HAVING area. Try: Select count(*), cust.id from cust where cust.time UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1 HOUR)) Group by cust.id HAVING count(cust.id) 5; -Original Message- From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:44 AM To: [EMAIL PROTECTED] Subject: Query Help I have a table that records connections from customers to our server. When there is a software problem with our customer's that have older versions of our software, it will dial our server constantly over and over again. I want to be able to detect this by having a query that does something like this.. (I know this where clause won't really work) Select count(cust.id) from cust where cust.time UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1 HOUR)) count(cust.id) 5 Group by cust.id; Is there a way to do this with one query? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Cache slow downs?
Hey There, Our MySQL database server is: 1. Sun Ultra Enterprise 4500 System Chassis with SBus I/O 4. 6 System Boards, each with 2 UltraSPARC II 400 mhz CPU's and 2 GB's of memory (12 CPU, 12 GB memory) 2. 1 SBus I/O board, with SCSI-2 and dual fibre channel interfaces on it. 3. The SCSI-2 interfaces are connected to an on-board SCSI disk board that has 2 9GB SCSI disks that are mirrored. This is the boot disk for the system. 4. The fibre channel interfaces are attached to an external Sun A5000 enterprise network chassis, which as 14 * 9GB discs setup in RAID10. 5. Solaris is Solaris 8, latest patches. 6. We're running MySQL using the alternative LWP threading library that ships with Solaris 9 as standard and is backported to Solaris 8. We find that thread creation time is a lot faster with this version. Altogether, cost for this machine was -about- $15,000 USD from Solar Systems (refurbished). I highly recommend dealing with Solar as it's easily the cheapest way to get big iron. http://www.solarsys.com MySQL itself is the 64-bit Solaris MAX version, pre-compiled from MySQL.com. We're using InnoDB tables, with an 8GB InnoDB buffer cache. Right now (3:00pm on Monday), we're doing -about- 1500 queries per second, so by the evening, we'll be pushing 2500 or so. Anything else you want to know, let me know. Dylan On Monday, August 4, 2003, at 01:33 PM, Joe Shear wrote: Hi, Sorry to bring up something unrelated to your post, but I was curious about the hardware you have MySQL running on. Could you tell me about your setup? thanks, joe On Fri, 2003-08-01 at 23:46, Dylan Neild wrote: Hi everyone, I've been looking everywhere for an answer to this, so please excuse me if it should have been obvious. I have a very big MySQL server, under load, serving in the 1500 QPS range. Under times of high concurrenncy (many threads connected issuing queries), I start to see a lot of the threads with NULL as their state (rather then Sending data, sorting, etc). These threads seem to be blocked for some reason, as they eventually do get executed. Am I running into a locking issue? MySQL seems like it -should- scale to 12 CPU's... so I must be missing something. Up until this point, it's just grown and grown along with us (using InnoDB table system), so I'm hoping to continue. :) Thanks in advance, Dylan -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Query Help
Thanks, that did it! Jeff -Original Message- From: Kevin Fries [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 3:05 PM To: Jeff McKeon; [EMAIL PROTECTED] Subject: RE: Query Help So you want to group by the customer, but only show those gorupings with a count 5. That means you want to apply your restriction after the GROUP BY. Thus, the clause goes into the HAVING area. Try: Select count(*), cust.id from cust where cust.time UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1 HOUR)) Group by cust.id HAVING count(cust.id) 5; -Original Message- From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:44 AM To: [EMAIL PROTECTED] Subject: Query Help I have a table that records connections from customers to our server. When there is a software problem with our customer's that have older versions of our software, it will dial our server constantly over and over again. I want to be able to detect this by having a query that does something like this.. (I know this where clause won't really work) Select count(cust.id) from cust where cust.time UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1 HOUR)) count(cust.id) 5 Group by cust.id; Is there a way to do this with one query? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: File Permission
Thank you Gerald. That was the problem. I thought I read that FILE permission could not be set to a specific table so I was using somedatabase.*. David Scott On Monday, August 4, 2003, at 11:42 AM, gerald_clark wrote: Since you don't show your grant statement, it is difficult tell you what the problem is. Since FILE is a global permission you need to grant it on *.* not somedatabase.* David Scott wrote: Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2. Thank you. - David Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Searching on Two Keys with OR?
Joshua, Joshua Spoerri wrote: Which version is targetted for optimization of OR searching on two keys, that is, select * from sometable where f1 = 123 or f2 = 123, as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html ? As described there MySQL can use only one index per table. It will work same way untill next major Optimizer update which is scheduled for 5.1 Meanwhile your query can be optimized with using of composite index over both columns: mysql explain select * from t where f1 = 10 or f2 = 10; +---+---+---+--+-+--+---+--+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+---+--+ | t | index | f1| f1 | 10 | NULL | 16384 | Using where; Using index | +---+---+---+--+-+--+---+--+ Thanks -- Are you MySQL certified? - http://www.mysql.com/certification For technical support contracts, visit https://order.mysql.com/?ref=msal __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Check table script
Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
benchmarks
At the conference a few months ago, the mysql team said that the benchmarks they where running would be published here http://www.mysql.com/benchmarks but it doesn't look like this is the link. Basically I'm trying to figure out what a saturation level is for mysql when it has 2 2.4Ghz Intel XEON procs, 4GB ram, RAID-10 4-6 disk system in a Red-Hat 7.3 environment. I ran some tests in the past but I'd like to compare my tests verses other peoples or mysql.com itself. http://www.mysql.com/information/benchmarks.html This link above gives me an idea but I'm looking for more detail. Any pointers?
books advice
Dear all, Thank you very much for all your responses. I have settled on the at least one book, SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas. I would, however, ask Paul to recommend one from his list of numerous titles, that he feels would give me the best possible entry in to the wonders of MySQL. Rest assured Paul I would like to reach an administrative level understanding of MySQL, with options of programming in the future. Hope this helps in deciding a title. Many thanks people, and to Paul in advance for his attention. Sincerely, Fawad
Re: MySQL, IIS and PHP
Gary Broughton wrote: Hi all I've just recoded a website in PHP from ASP, running off IIS 5. It has been tested by a dozen users over the weekend, but now I have put it live the CPU utilisation is up at 100%, mainly swallowed up by mysql-nt.exe. I wondered if anyone could offer any advice as to why this could be (the MySQL settings have not changed, and are as they were when it was accessed via the ASP code). Regards Gary What does 'mysqladmin processlist -p PASSWORD' give? Are there any processes that have been running for ages? What about if you shut down MySQL and restart it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: books advice
At 21:47 +0100 8/4/03, Fawad Siddiqui wrote: Dear all, Thank you very much for all your responses. I have settled on the at least one book, SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas. I would, however, ask Paul to recommend one from his list of numerous titles, that he feels would give me the best possible entry in to the wonders of MySQL. Rest assured Paul I would like to reach an administrative level understanding of MySQL, with options of programming in the future. Hope this helps in deciding a title. For those purposes, I would recommend: MySQL, Second Edition http://www.kitebird.com/mysql-book/ Many thanks people, and to Paul in advance for his attention. Sincerely, Fawad -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Jean, Have you tried adding [mysqladmin] user=root password=blabla to the .my.cnf file for the user running the script? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
At 15:14 -0500 8/4/03, Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: -p doesn't take '=[pswd]'. If you wrote something like -p=pswd, it would take the '=' character as part of the password. You should use either -ppswd (no intervening space) or --password=pswd if you want to do this. /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
At 16:57 -0400 8/4/03, walt wrote: Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Jean, Have you tried adding [mysqladmin] user=root password=blabla to the .my.cnf file for the user running the script? You probably meant to say the [mysqlcheck] group here. The [mysqladmin] group would be read only by the mysqladmin program. walt -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't start up - access denied to root
I am fairly much a beginner and have probably done something wrong but version 4.0.12 will not let me in. I have been using MySQL (via MySQL Front and PHPMyAdmin as interfaces usually) on a Windows ME PC with Apache, all just for learning databases, SQL and PHP. I learn slowly since I have to do a lot of other things but it has gone reasonable well. As part exercise and part for use I have been building a small database. I did nothing on it for a couple of months for various reasons. Today I accessed the database in MySQL, typing in a password which I set up. The version running is - max. I tried to add some data from a prepared text file (which I have done several times before) and got the response that this version of MySQL does not recognise this command (ie import text file data.). Which was odd. Same response in both interfaces. It has previously worked nicely in either of MySQLFront or PHPMyAdmin.(4.3) so I assumed maybe the MySQL had becomedamaged - so I uninstalled it and reloaded it (leaving the data files untouched). Now I cannot get in at all and it simply tells me that error 1045 - access denied for user root 127.0.01 which leaves me stumped. Meanwhile WinMySQLAdmin sits in the tray at the bottom and after this error message seems to shut down. [Other possibly pertinent information, or not, is that since I last used MySQL I have loaded various other bits of software such as Open Office, Mozilla and more, in case some conflict is the reason.] So - please excuse what is probably a rather basic question but can anyone suggest what I should explore to get this going again? Or point me at an archive thread that deals with it? Regards Adrian G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Message
I am just learning mysql and I'm trying to write a cgi to update the database from a form. Also just learning Perl. I have the following script started that is called by an HTML form. I get the follwing message when I execute it. Where can I find the message descriptions. DBI::st=HASH(0x1b31f28) this is my script so far: #!c:\perl\bin\perl use DBI(); print Content-type:text/html\n\n; #Connect to database members. $database = members; $table = members; $dbh = DBI-connect(DBI:mysql:$database)or dienice(Can't connect:$DBI::errstr); $sth = $dbh-prepare(select membername,address,city,state,zipcode,phonenumber from members)or dienice(Can't prepare statement: ,$dbh-errstr); print $sth; exit; upscope -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Searching on Two Keys with OR?
That doesn't seem to work (and not with bigger table either): mysql create temporary table x (y int, z int, index (y), index(z)); insert into x values (1,2), (3,4), (5,6); explain select * from x where y = 1 or z = 1; Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 +---+--+---+--+-+--+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--+-+ | x | ALL | y,z | NULL |NULL | NULL |3 | Using where | +---+--+---+--+-+--+--+-+ 1 row in set (0.00 sec) mysql quit Bye $ rpm -qa | grep -i mysql perl-DBD-MySQL-1.2216-4 MySQL-devel-4.0.13-0 MySQL-client-4.0.13-0 MySQL-server-4.0.13-0 MySQL-shared-compat-4.0.13-0 (Thanks for your help) On Mon, 4 Aug 2003, Alexander Keremidarski wrote: Joshua, Joshua Spoerri wrote: Which version is targetted for optimization of OR searching on two keys, that is, select * from sometable where f1 = 123 or f2 = 123, as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html ? As described there MySQL can use only one index per table. It will work same way untill next major Optimizer update which is scheduled for 5.1 Meanwhile your query can be optimized with using of composite index over both columns: mysql explain select * from t where f1 = 10 or f2 = 10; +---+---+---+--+-+--+---+--+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+---+--+ | t | index | f1| f1 | 10 | NULL | 16384 | Using where; Using index | +---+---+---+--+-+--+---+--+ Thanks -- Are you MySQL certified? - http://www.mysql.com/certification For technical support contracts, visit https://order.mysql.com/?ref=msal __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Searching on Two Keys with OR?
Forgive me, that example is no good. Oddly, it works, but the following does not: mysql create temporary table x (y int, z int, q int, index (y, z)); insert into x values (1,2,3), (3,4,5), (5,6,7); explain select * from x where y = 1 or z = 1; Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 +---+--+---+--+-+--+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--+-+ | x | ALL | y | NULL |NULL | NULL |3 | Using where | +---+--+---+--+-+--+--+-+ 1 row in set (0.00 sec) On Mon, 4 Aug 2003, Joshua Spoerri wrote: That doesn't seem to work (and not with bigger table either): mysql create temporary table x (y int, z int, index (y), index(z)); insert into x values (1,2), (3,4), (5,6); explain select * from x where y = 1 or z = 1; Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 +---+--+---+--+-+--+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--+-+ | x | ALL | y,z | NULL |NULL | NULL |3 | Using where | +---+--+---+--+-+--+--+-+ 1 row in set (0.00 sec) mysql quit Bye $ rpm -qa | grep -i mysql perl-DBD-MySQL-1.2216-4 MySQL-devel-4.0.13-0 MySQL-client-4.0.13-0 MySQL-server-4.0.13-0 MySQL-shared-compat-4.0.13-0 (Thanks for your help) On Mon, 4 Aug 2003, Alexander Keremidarski wrote: Joshua, Joshua Spoerri wrote: Which version is targetted for optimization of OR searching on two keys, that is, select * from sometable where f1 = 123 or f2 = 123, as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html ? As described there MySQL can use only one index per table. It will work same way untill next major Optimizer update which is scheduled for 5.1 Meanwhile your query can be optimized with using of composite index over both columns: mysql explain select * from t where f1 = 10 or f2 = 10; +---+---+---+--+-+--+---+--+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+---+--+ | t | index | f1| f1 | 10 | NULL | 16384 | Using where; Using index | +---+---+---+--+-+--+---+--+ Thanks -- Are you MySQL certified? - http://www.mysql.com/certification For technical support contracts, visit https://order.mysql.com/?ref=msal __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Searching on Two Keys with OR?
Have you tried using the UNION statement? That worked great for me. So, something like: (select * from sometable where f1 = 123) UNION (select * from sometable where f2 = 123) ? -- Rudi Benkovic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Books advice
Jeff, thanks for our .02. I'm about done with my second SQL book so after reading your words the company just bought mePauls Mysql book. Thanks for your opinion. SJohnson On Mon, 4 Aug 2003 12:14:29 -0400 Jeffery C. Baldwin wrote: Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
post install of 4.0 complications
Hello- I just installed mySql 4.0.14-0 onto my redhat 9.0 based laptop. Everything works fine except that there are ten copies of mysqld running. I have removed the /etc/my.cnf file, changed the file, restored the file and nothing changes the number of daemons running. Another guy I worked with installed the same rpms from Mysql.org and ther is only one daemon running. Any suggestions would be appreciated. Thanks, [EMAIL PROTECTED]
Fw: table error 127
Even though we don't know what exact query produces this, is there a way to raise it up to the MySQL team to take a look at? It seems to be more than a random occurrence. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED] Sent: Sunday, August 04, 2002 3:16 PM Subject: Ynt: table error 127 *This message was transferred with a trial version of CommuniGate(tm) Pro* i got same err (once) on winNT (sp6) when i upgraded from 3.23.47 4.0.12. everything is OK for a long time... - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Jonathan Patton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 9:10 PM Subject: Re: table error 127 *This message was transferred with a trial version of CommuniGate(tm) Pro* I have been getting this type of error ever since I upgraded from MySQL 3 to 4. I actually have set up a cron to check/repair tables hourly because of this. The following diagnoses have been suggested, but I would bet it's an obscure MySQL bug: 1. Kernel 2.4.18 IO problem 2. Another shared library linked to MySQL (I use RPMs) 3. RAID issue causing corruption Unfortunately I haven't been able to pinpoint which query causes the issue so I can't report a bug. It anyone else has experienced this or has information on it, I would really appreciate it. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: walt [EMAIL PROTECTED] To: Jonathan Patton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:11 PM Subject: Re: table error 127 Jonathan Patton wrote: I have mysql setup on two computers with identical databases. When I run a group of queries on the one computer I get back an error 127 which I checked on an it appears to be a table corruption error. On the other computer, the queries run fine. Since I had all the data for the table in question in a data file, I just dropped the table and recreated it. The error still appeared. Any suggestions on what to try next? The only other thing I can think of is to compare the mysql versions to see if I have an older version on the other computer. Jonathan, Have you tried running myisamchk on the database in question before running queries on it? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]