access denied .... php my admin .....
hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 1.3.24 mysql 3.23.58 i would really appriciat any help with this thnx a million toby _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to export data from multiple tables
these are linux machines on internet, one is web server and another db server, with real IPs. but I may optionally want to export data to my PC, also on internet connected through LAN to my web server and db server. thanx for ur time Nitin - Original Message - From: Christensen, Dave [EMAIL PROTECTED] To: 'Nitin' [EMAIL PROTECTED]; Mysql List [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 10:00 PM Subject: RE: how to export data from multiple tables What machines are you working with at each end? Internal network? -Original Message- From: Nitin [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 10:19 AM To: Andy Eastham; Mysql List Subject: Re: how to export data from multiple tables any idea, how to export data to a file on the remote machine? thanx for the help anyway Nitin - Original Message - From: Andy Eastham [EMAIL PROTECTED] To: Mysql List [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 9:49 PM Subject: RE: how to export data from multiple tables Nitin, Create a temporary table, then select each table into it in turn, then output that to the file? Andy -Original Message- From: Nitin [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 11:40 To: [EMAIL PROTECTED] Subject: how to export data from multiple tables Hi all, I've got a small problem (hope it's very small). Could any of you suggest me how to select my data into a simple text file from multiple tables (selected with union)! I've tried: select field-list into outfile filename from table1 union select field-list into outfile filename from table2 union select field-list into outfile filename from table3 It says check your version manualblah blah Any idea, how to do it? Thanx in advance Nitin -- 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]
Serious problem with replication
I still have this problem with replication, and i dont know how to fix it. I have a slave that has been running for a long time without any problems, but now its not replicating any more. So I tried to do a LOAD DATA MASTER; which always gives me this error now: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031008 15:07:59 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 357019 031008 15:08:14 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 357019 031008 15:08:14 Couldn't fix table with quick recovery: Found wrong number of deleted records 031008 15:08:14 Run recovery again without -q 031008 15:08:14 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031008 15:08:14 Couldn't fix table with quick recovery: Found wrong number of deleted records 031008 15:08:14 Run recovery again without -q 031008 15:08:14 Note: Retrying repair of: './otamanager/profile' with keycache 031008 15:08:16 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 357019 I have tried to do a REPAIR TABLE otafrontenduser,profile EXTENDED; but no success (its says ok, but the replication does still not work). I have attached my SHOW SLAVE STATUS; from the problem machine. I have tried dropping the database, rebooting the machine, and creating a new database, no success. Please let me know if I need to supply more info, I have no idea on what to do next. Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk +--+-+-+---+-+-+-+---+---+--+---+-+-+++--+-+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +--+-+-+---+-+-+-+---+---+--+---+-+-+++--+-+-+ | 172.16.1.103 | dba | 3306| 60| mysql-bin.037 | 11894440| waspstat1-relay-bin.001 | 4 | mysql-bin.037 | Yes | Yes | | | 0 || 0| 11894440| 4 | +--+-+-+---+-+-+-+---+---+--+---+-+-+++--+-+-+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Errors starting Mysql
Jose Rojas [EMAIL PROTECTED] wrote: I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the next messages in the ../var/*.err file: mysqld started /home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13) 031008 15:18:16 Could not use dns1-bin for logging (error 13) 031008 15:18:16 /home/mysql/libexec/mysqld: Can't create/write to file '/home/mysql/var/dns1.sinfin.net.mx.pid' (Errcode: 13) 031008 15:18:16 /home/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 031008 15:18:16 /home/mysql/libexec/mysqld: Error on delete of '/home/mysql/var/dns1.sinfin.net.mx.pid' (Errcode: 13) 031008 15:18:16 mysqld ended I changed group write permissions to ../var directory, but the other files about error 13 I don't know how to fix them The user under which MySQL server runs must be owner of the data dir. -- 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]
Ideas on Compression Protocol
Hi group, I recently asked about Compression and security and got nice answers. Now I have got a different question: What are the disadvantage of using that client/server Compression protocol? Does it increase speed? Does it decrease speed? Does it overload the server? The client? Any ideas and/or thoughts are welcome. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
Re: Backup, move, restore..?
Hi Taylor While I have only used mysqldump to backup MyIsam files, I have found the process to be fairly painless. Mysqldump creates batch f iles which effectively rebuild your database structure + database data. To restore the data all you need to do is run the backup files as a batch file i.e. : mysql -u root -p your_destination_db_name your_backup_file_name Then sit back and wait Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 8:49 PM Subject: Backup, move, restore..? Hi all. I am needing to do a backup of two smalldatabases, both live on the same server and under the same Mysql binary installation... I would like to back them up, dump them into a file(s), make my move, install the same database, and then restore/load this dumped information back into the new database. I am using mysql-max 4.0.13 on HP-UX 11.00, 64 bit... I am also using some InnoDB tables... Is it as simple as doing mysqldumps and taring/zipping up those files? If so, how do I load these files back into the new database? Thanks Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * -- 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: access denied .... php my admin .....
Hi Toby I am not an expert on permissions within mysql - boy, do I wish I was - but could the problem be that you have only granted permissions to [EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ? Here endeth my knowledge of MySQL permissions Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:57 AM Subject: access denied php my admin . hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 1.3.24 mysql 3.23.58 i would really appriciat any help with this thnx a million toby _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- 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: access denied .... php my admin .....
thnx rory the thing is kwexchange is localhost you know . so it should work alwayz has before this dammed day . anywayz . i did install mysql on another machine and installed all the rest , php, apache, phpmyadmin on another when it gave me these access denied errors the very bloody same . i thought there was somethin the matter with keepin these things on two separate machines u know but now i have got em all on the same thing . but to no use . do you or anyone else on this list think it could be the two network cards running on the machine that are actually screwin this all up fo me all though i have tried ma best to some how change this ip thinggy to the one i want mysql server to user .. can anyone tell me where to go and what to do as im at ma wits end now .. thnx a mill rory .. :) toby From: Rory McKinley [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: access denied php my admin . Date: Thu, 9 Oct 2003 11:09:06 +0200 Hi Toby I am not an expert on permissions within mysql - boy, do I wish I was - but could the problem be that you have only granted permissions to [EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ? Here endeth my knowledge of MySQL permissions Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:57 AM Subject: access denied php my admin . hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 1.3.24 mysql 3.23.58 i would really appriciat any help with this thnx a million toby _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access denied .... php my admin .....
Hi toby If I log in to mysql via the command line on the hosting machine it says [EMAIL PROTECTED] ... therefore, stating the obvious :) it doens't think you're connecting from localhost - this may be because of the two NICs but I don't know enough to be sure .when you connect to the mysql server (when php, apache and mysql are all on the same box) do you connect to 127.0.0.l (loopback address) or do you connect to the IP address of one of the two NICs (e.g. 192.168.y.z)? Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:18 AM Subject: Re: access denied php my admin . thnx rory the thing is kwexchange is localhost you know . so it should work alwayz has before this dammed day . anywayz . i did install mysql on another machine and installed all the rest , php, apache, phpmyadmin on another when it gave me these access denied errors the very bloody same . i thought there was somethin the matter with keepin these things on two separate machines u know but now i have got em all on the same thing . but to no use . do you or anyone else on this list think it could be the two network cards running on the machine that are actually screwin this all up fo me all though i have tried ma best to some how change this ip thinggy to the one i want mysql server to user .. can anyone tell me where to go and what to do as im at ma wits end now .. thnx a mill rory .. :) toby From: Rory McKinley [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: access denied php my admin . Date: Thu, 9 Oct 2003 11:09:06 +0200 Hi Toby I am not an expert on permissions within mysql - boy, do I wish I was - but could the problem be that you have only granted permissions to [EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ? Here endeth my knowledge of MySQL permissions Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:57 AM Subject: access denied php my admin . hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 1.3.24 mysql 3.23.58 i would really appriciat any help with this thnx a million toby _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 3.23.58 and sub-seletcs
Hi ! Are sub-selects supported by MySQL 3.23.58, because below query does not work (syntax error in console): select iphdr.ip_src, timestamp \ from iphdr , acid_event \ where iphdr.sid = acid_event.sid \ and iphdr.cid = acid_event.cid \ and acid_event.sig_name = STATEMENT \ and acid_event.timestamp select max(another_database.dataz.timestamp) \ from another_database.dataz; greetz boka -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0.15 FULLTEXT INDEX
Hi! On Oct 07, Dathan Vance Pattishall wrote: I have to drop the FULLTEXT INDEX added to a set of dbs containing a TEXT field with an average of 6K of text added to each row, at a growth of 250K rows added a day to a set of 100 tables. The reason for the drop is due to table corruption and non-related query slowdown. If mysql.com is interested in this issue, I can send a copy the table format etc. In the meantime I have to drop the FULL TEXT INDEX. Yes, sure, we're interested! We even have a public bug database on http://bugs.mysql.com/ where one can report a bug, and follow the progress of his bugreport. Actually http://bugs.mysql.com/ is The preferred place to report a bug. DELETES and Frequent UPDATES of a FULLTEXT INDEX column, IMO are the root cause of table corruption and query slow down time. Can you create a test case for this ? The reason for this opinion is based on the situation where after adding the FULL TEXT INDEX to the body of each user's message, table corruption occurred everyday, and query time of non related queries to a full text What are these non-related queries ? column multiplied by 10 or more. The application made frequents updates to a table and a batch job or a user action would cause deletes. Here are the corruption errors. Can't open file: 'messages_06.MYI'. (errno: 145) % perror 145 145 = Table was marked as crashed and should be repaired So, unfortunately, it does not say anything about the reason of corruption. The fix REPAIR TABLE messages_06; What does REPAIR say ? I would see dead lock queries as well: Explanation below. Prior to the FULL TEXT INDEX queries normally took no more then a second. These same queries took nearly 5 min before I killed them. What queries ? The stuck state was either waiting for table (btw no alter/flush change was going on) or Locked, but not locked on any particular query. The second granularity that show full processlist displays did not indicate which query was the problem. What does SHOW PROCESSLIST show ? Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 3.23.58 and sub-seletcs
No, its supported by version 4.1 gr. - Original Message - From: boka [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:54 AM Subject: MySQL 3.23.58 and sub-seletcs Hi ! Are sub-selects supported by MySQL 3.23.58, because below query does not work (syntax error in console): select iphdr.ip_src, timestamp \ from iphdr , acid_event \ where iphdr.sid = acid_event.sid \ and iphdr.cid = acid_event.cid \ and acid_event.sig_name = STATEMENT \ and acid_event.timestamp select max(another_database.dataz.timestamp) \ from another_database.dataz; greetz boka -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] http://www.beheervisie.nl/disclaimer. http://www.beheervisie.nl/disclaimer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 3.23.58 and sub-seletcs
Hi boka Nope sub-selects to my understanding ar only supported from version 4.1 onwards (still in beta I think) Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: boka [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:54 AM Subject: MySQL 3.23.58 and sub-seletcs Hi ! Are sub-selects supported by MySQL 3.23.58, because below query does not work (syntax error in console): select iphdr.ip_src, timestamp \ from iphdr , acid_event \ where iphdr.sid = acid_event.sid \ and iphdr.cid = acid_event.cid \ and acid_event.sig_name = STATEMENT \ and acid_event.timestamp select max(another_database.dataz.timestamp) \ from another_database.dataz; greetz boka -- 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: MySQL 3.23.58 and sub-seletcs
Bob Brands wrote: No, its supported by version 4.1 MySQL 4.1 -- Alpha release (use this for new development) ... is this stable enough to use it on production systems ? btw. is there any workaround for this functionality in 3.23.58 ? greetz boka -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ideas on Compression Protocol
Thank you for the ideas. Very helpful. Thanks Emery - Original Message - From: Danny Haworth [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:01 Subject: Re: Ideas on Compression Protocol We used compression on a project with about 90 simultaneous users. Overall it sped things up (especially since most users were on modem dialups). Load on the client wasn't noticeable, neither was load on the server, The server did have two 2Ghz processors in though so compression of 90 simultaneous streams shouldn't have been a problem =) On a standard 100mb switched lan, compression didn't make much of a difference, but there weren't any noticeable speed decreases either. HTH danny On Thu, 2003-10-09 at 09:39, Director General: NEFACOMP wrote: Hi group, I recently asked about Compression and security and got nice answers. Now I have got a different question: What are the disadvantage of using that client/server Compression protocol? Does it increase speed? Does it decrease speed? Does it overload the server? The client? Any ideas and/or thoughts are welcome. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sql syntax problem with mysql 3.23.49
Hello, This sql query works fine with mysql 4.0.15, but it gives an error with mysql 3.23.49: SELECT officiele_naam, rechtsvorm, activiteit1, activiteit2, adres, postnummer, gemeente, Biogarantie, Hefboom, Netwerk_Vlaanderen, Vibe, Fair_Trade, NULL , Vosec, Solidr, Demeter, Europees_Ecolabel, Belgisch_Sociaal_label, vestiging_ID FROM onderneming JOIN vestiging ON onderneming.bedrijfsnummer = vestiging.bedrijfsnummer LEFT JOIN rubrieken AS r1 ON onderneming.rubriek_ID_1 = r1.rubriek_ID LEFT JOIN rubrieken AS r2 ON rubriek_ID_2 = r2.rubriek_ID LEFT JOIN rubrieken AS r3 ON onderneming.rubriek_ID_3 = r3.rubriek_ID WHERE 1 ORDER BY officiele_naam LIMIT 100 #1064 - You have an error in your SQL syntax near 'ON onderneming.bedrijfsnummer = vestiging.bedrijfsnummer LEFT JOIN rubrieken AS' at line 3 What exactly is the cause of this error here? Could it be that mysql3 does not support the AS clause within a LEFT JOIN clause? How could I rewrite this query to make it work with mysql 3.23.49? Frederik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is wrong with this bloody MySQL?
I have posted the message with the subject Serious problem with replication, but nobody seems to know what to do? Now I have even tried to completly uninstall MySQL (with rpm -e), delete the /var/lib/mysql dir, and reinstall MySQL with rpm -i MySQL-server-4.0.15-0.i386.rpm. Then I create my database, create the tables, set up replication (as slave), and do a LOAD DATA FROM MASTER;, and still I get this bloody error: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031009 15:33:48 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 031009 15:34:33 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 1408472 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 Is there really nothing to do here, what the hell is the problem with MySQL? Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks!
Thanks for your help, just what I needed. I will play around but if you have a chance and know how, how would I order the results by count? (ie. highest counts first..) -Original Message- From: Mike Knox [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 5:09 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks! Paul How about select FIRST_NAME, count(*) from a table group by FIRSTNAME having count(FIRST_NAME) 1 Mike -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
When inserting data it insert 2 records one correct and one blank!
Hi, I have a page on a intranet where workers can insert data into a database, the thing is that when they type the info an press submit the page use the INSERT INTO db then when i check the data in the database i can see the record that the user entered and a second record that is all in blank, exept for the date and time field that the value is -00-00 and 00:00:00. What´s wrong? maybe something of the date and time format?? Any Clue. Thanks. Emilio. _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bug in 4.1.1 (current)
-- mysql select * from msg where Author=6213 and (Saved='s' or Saved='n') order by ID; Empty set (0.00 sec) --- mysql select COUNT(*) from msg where Author=6213 and (Saved='s' or Saved='n') order by ID; +--+ | COUNT(*) | +--+ | 191 | +--+ 1 row in set (0.01 sec) mysql select ID from msg where Author=6213 order by ID; .. | 18540 | +---+ 220 rows in set (0.01 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: When inserting data it insert 2 records one correct and one blank!
Emilio, Can you supply the full insert statement? Also, is this happening for all users, or one in particular? I ask, as I've seen issues with web app users double-clicking the submit button causing similar issues -Original Message- From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:02 AM To: [EMAIL PROTECTED] Subject: When inserting data it insert 2 records one correct and one blank! Hi, I have a page on a intranet where workers can insert data into a database, the thing is that when they type the info an press submit the page use the INSERT INTO db then when i check the data in the database i can see the record that the user entered and a second record that is all in blank, exept for the date and time field that the value is -00-00 and 00:00:00. What´s wrong? maybe something of the date and time format?? Any Clue. Thanks. Emilio. _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa -- 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: MySQL 3.23.58 and sub-seletcs
I am running it on a production server for about two weeks. So far it has been very stable. --ja On Thu, 9 Oct 2003, boka wrote: Bob Brands wrote: No, its supported by version 4.1 MySQL 4.1 -- Alpha release (use this for new development) ... is this stable enough to use it on production systems ? btw. is there any workaround for this functionality in 3.23.58 ? greetz boka -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble acquiring proper AVG with TIME
Charles Warren [EMAIL PROTECTED] wrote: I've searched the manuals and any websites I can find but am still at a loss on how to calculate what I thought was going to be an easy 'Average' of Call Times. Situation. Have a table which is updated daily for users metrics and have configured one column as TIME which should have the default format (if I understand correctly) of HH:MM:SS. However when I try to calculate an average for an individual who has the following two times listed: 00:09:15 00:04:26 it calculates the average as being 670.5 The query I'm running is SELECT AVG(avg_tt) FROM table WHERE agent_ln = name It is changing the times to 915 + 426 = 1341/2 = 670.5 Does anyone know what I'm doing wrong? You should use AVG() with SEC_TO_TIME() and TIME_TO_SEC() functions. -- 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: What is wrong with this bloody MySQL?
Hi, can you indicates your configuration about : - my.cnf - all tables type your using in the master (MyISAM, INNODB, BDB) This may help to see what goes wrong . Regards Thierno 6C - MySQL 4.0.15 - Original Message - From: Søren Neigaard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:32 PM Subject: What is wrong with this bloody MySQL? I have posted the message with the subject Serious problem with replication, but nobody seems to know what to do? Now I have even tried to completly uninstall MySQL (with rpm -e), delete the /var/lib/mysql dir, and reinstall MySQL with rpm -i MySQL-server-4.0.15-0.i386.rpm. Then I create my database, create the tables, set up replication (as slave), and do a LOAD DATA FROM MASTER;, and still I get this bloody error: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031009 15:33:48 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 031009 15:34:33 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 1408472 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 Is there really nothing to do here, what the hell is the problem with MySQL? Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk -- 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: What is wrong with this bloody MySQL?
Here is my my.cnf (had to zip it, my Windoze would not let me attache it??). As far as I know, im only using MyISAM (thats the standard version right), but how do I check this? Best regards Søren -Original Message- From: Thierno Cissé [mailto:[EMAIL PROTECTED] Sent: 9. oktober 2003 16:28 To: Søren Neigaard; [EMAIL PROTECTED] Subject: Re: What is wrong with this bloody MySQL? Hi, can you indicates your configuration about : - my.cnf - all tables type your using in the master (MyISAM, INNODB, BDB) This may help to see what goes wrong . Regards Thierno 6C - MySQL 4.0.15 - Original Message - From: Søren Neigaard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:32 PM Subject: What is wrong with this bloody MySQL? I have posted the message with the subject Serious problem with replication, but nobody seems to know what to do? Now I have even tried to completly uninstall MySQL (with rpm -e), delete the /var/lib/mysql dir, and reinstall MySQL with rpm -i MySQL-server-4.0.15-0.i386.rpm. Then I create my database, create the tables, set up replication (as slave), and do a LOAD DATA FROM MASTER;, and still I get this bloody error: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031009 15:33:48 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 031009 15:34:33 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 1408472 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 Is there really nothing to do here, what the hell is the problem with MySQL? Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk -- 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] my.zip Description: Zip compressed data -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation problem
I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: bug in 4.1.1 (current)
[EMAIL PROTECTED] wrote: -- mysql select * from msg where Author=6213 and (Saved='s' or Saved='n') order by ID; Empty set (0.00 sec) --- mysql select COUNT(*) from msg where Author=6213 and (Saved='s' or Saved='n') order by ID; +--+ | COUNT(*) | +--+ | 191 | +--+ 1 row in set (0.01 sec) mysql select ID from msg where Author=6213 order by ID; .. | 18540 | +---+ 220 rows in set (0.01 sec) What does CHECK TABLE say? -- 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]
FW: When inserting data it insert 2 records one correct and one blank!
sending on to list while I think... ;)
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:34 AM
To: Dan Greene
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Ok, here it is the full statement:
$sql = INSERT INTO llamadas
(destinatario,fecha,hora,apellido,nombre,telefono,mail,receptor,mensaje)
VALUES
('$destinatario','$fecha','$hora','$apellido','$nombre','$telefono','$mail','$receptor','$mensaje');
$result = mysql_query($sql);
And, yes it happens to all users, and i ve tested pressing only once the
submit button but i allways got 2 records add the first one is a blank one
and the second the correct one.
From: Dan Greene [EMAIL PROTECTED]
To: Emilio Ruben Estevez [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Date: Thu, 9 Oct 2003 10:09:00 -0400
Emilio,
Can you supply the full insert statement? Also, is this happening for all
users, or one in particular? I ask, as I've seen issues with web app users
double-clicking the submit button causing similar issues
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:02 AM
To: [EMAIL PROTECTED]
Subject: When inserting data it insert 2 records one correct and one
blank!
Hi, I have a page on a intranet where workers can insert data into a
database, the thing is that when they type the info an press
submit the page
use the INSERT INTO db then when i check the data in the
database i can
see the record that the user entered and a second record that
is all in
blank, exept for the date and time field that the value is
-00-00 and
00:00:00.
What´s wrong? maybe something of the date and time format?? Any Clue.
Thanks.
Emilio.
_
Add MSN 8 Internet Software to your existing Internet access
and enjoy
patented spam protection and more. Sign up now!
http://join.msn.com/?page=dept/byoa
--
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]
_
High-speed Internet access as low as $29.95/month (depending on the local
service providers in your area). Click here. https://broadband.msn.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
User defined under SGI-IRIS64 6.5
Hi, I wanted to add some new user defined functions (UDF) to mysql 4.0.12-standard-log. I read in the manual that it is possible if you can start with the option --with-mysqld-ldflags=-rdynamic. Then I found that my distribution is most likely build with --disable-shared, which makes me believe that I cant use any UDFs with the current version and that it is probably not save to recompile without the --disable-shared. So, my questions are: Has anyone done this already on IRIX 6.5? Can you give me some hints on how to start? If I have to recompile, what do I have to do? Can you give me some examples? Thanks a lot for your time. Bernd = Please note that this e-mail and any files transmitted with it may be privileged, confidential, and protected from disclosure under applicable law. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying, or other use of this communication or any of its attachments is strictly prohibited. If you have received this communication in error, please notify the sender immediately by replying to this message and deleting this message, any attachments, and all copies and backups from your computer.
RE: Installation problem
James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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: FW: When inserting data it insert 2 records one correct and one blank!
are you doing this insert in any sort of loop? if you emailed yourself the
final query, or printed it on the screen and then ran it directly into
mysql...do you get the same results?
Jeff
Dan Greene
[EMAIL PROTECTED]To: [EMAIL PROTECTED]
active.com cc:
Subject: FW: When inserting data
it insert 2 records one correct and one blank!
10/09/2003 10:43 AM
sending on to list while I think... ;)
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:34 AM
To: Dan Greene
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Ok, here it is the full statement:
$sql = INSERT INTO llamadas
(destinatario,fecha,hora,apellido,nombre,telefono,mail,receptor,mensaje)
VALUES
('$destinatario','$fecha','$hora','$apellido','$nombre','$telefono','$mail','$receptor','$mensaje');
$result = mysql_query($sql);
And, yes it happens to all users, and i ve tested pressing only once the
submit button but i allways got 2 records add the first one is a blank one
and the second the correct one.
From: Dan Greene [EMAIL PROTECTED]
To: Emilio Ruben Estevez [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Date: Thu, 9 Oct 2003 10:09:00 -0400
Emilio,
Can you supply the full insert statement? Also, is this happening for all
users, or one in particular? I ask, as I've seen issues with web app
users
double-clicking the submit button causing similar issues
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:02 AM
To: [EMAIL PROTECTED]
Subject: When inserting data it insert 2 records one correct and one
blank!
Hi, I have a page on a intranet where workers can insert data into a
database, the thing is that when they type the info an press
submit the page
use the INSERT INTO db then when i check the data in the
database i can
see the record that the user entered and a second record that
is all in
blank, exept for the date and time field that the value is
-00-00 and
00:00:00.
What´s wrong? maybe something of the date and time format?? Any Clue.
Thanks.
Emilio.
_
Add MSN 8 Internet Software to your existing Internet access
and enjoy
patented spam protection and more. Sign up now!
http://join.msn.com/?page=dept/byoa
--
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]
_
High-speed Internet access as low as $29.95/month (depending on the local
service providers in your area). Click here. https://broadband.msn.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble acquiring proper AVG with TIME
From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Trouble acquiring proper AVG with TIME Date: Thu, 9 Oct 2003 17:24:14 +0300 Charles Warren [EMAIL PROTECTED] wrote: I've searched the manuals and any websites I can find but am still at a loss on how to calculate what I thought was going to be an easy 'Average' of Call Times. Situation. Have a table which is updated daily for users metrics and have configured one column as TIME which should have the default format (if I understand correctly) of HH:MM:SS. However when I try to calculate an average for an individual who has the following two times listed: 00:09:15 00:04:26 it calculates the average as being 670.5 The query I'm running is SELECT AVG(avg_tt) FROM table WHERE agent_ln = name It is changing the times to 915 + 426 = 1341/2 = 670.5 Does anyone know what I'm doing wrong? You should use AVG() with SEC_TO_TIME() and TIME_TO_SEC() functions. -- 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] thank you sooo much Egor!! Finally got it to work with the functions you mentioned.. (think so at least.. if there is a better way please let me know. Used: SELECT SEC_TO_TIME(AVG(TIME_TO_SEC(AVG_TT))) AS Avg_Talk_Time FROM table WHERE agent_ln = name Came out with an average of 00:06:50 - when using 00:09:15 - 00:04:26 Thanks again! Chuck _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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: What is wrong with this bloody MySQL?
Hi, i suppose you do the necessary GRANTS on the master (before executing LOAD DATA FROM MASTER) as : - file - super - reload - select (on all tables you want to load) If not do this, and try again You can check if you are using only MyISAM tables with the client console by : show table status from database_name ; and look s in the column labelled TYPE. Regards Thierno 6C - MySQL 4.0.15 - Original Message - From: Søren Neigaard [EMAIL PROTECTED] To: 'Thierno Cissé' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:39 PM Subject: RE: What is wrong with this bloody MySQL? Here is my my.cnf (had to zip it, my Windoze would not let me attache it??). As far as I know, im only using MyISAM (thats the standard version right), but how do I check this? Best regards Søren -Original Message- From: Thierno Cissé [mailto:[EMAIL PROTECTED] Sent: 9. oktober 2003 16:28 To: Søren Neigaard; [EMAIL PROTECTED] Subject: Re: What is wrong with this bloody MySQL? Hi, can you indicates your configuration about : - my.cnf - all tables type your using in the master (MyISAM, INNODB, BDB) This may help to see what goes wrong . Regards Thierno 6C - MySQL 4.0.15 - Original Message - From: Søren Neigaard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:32 PM Subject: What is wrong with this bloody MySQL? I have posted the message with the subject Serious problem with replication, but nobody seems to know what to do? Now I have even tried to completly uninstall MySQL (with rpm -e), delete the /var/lib/mysql dir, and reinstall MySQL with rpm -i MySQL-server-4.0.15-0.i386.rpm. Then I create my database, create the tables, set up replication (as slave), and do a LOAD DATA FROM MASTER;, and still I get this bloody error: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031009 15:33:48 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 031009 15:34:33 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 1408472 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 Is there really nothing to do here, what the hell is the problem with MySQL? Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk -- 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: BLOB images in Crystal Reports
I want to ask you one thing: Is your Crystal Report accessing the database through the Mascon Utility or it uses MyODBC? I think the main problem to me is how Crystal Report is accessing the database. I will try to access the database using ADO and see if there is any change. Thanks Emery - Original Message - From: Danny Haworth [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 14:41 Subject: Re: BLOB images in Crystal Reports I've had no problems with MySQL, crystal reports and blob images. Main differences here are the following: Crystal Reports 8.5 (not 7) Myodbc 2.x (haven't tried 3.x yet with images) Images were also inserted into the MySQL database using a third party utility called Mascon (http://www.scibit.com/). They do a free, unlimited, version (annoying nag screens but still) if you want to try that out? If that works, you can see the differences between the way mascon stores them, and the way you are storing them.. I'm assuming if crystal is reading happily from mssql then that cant be at fault. hth danny On Thu, 2003-10-09 at 13:08, Director General: NEFACOMP wrote: It was a good idea but it is not feasible for my case since I will be displaying many images coming in a recordset with many records. If it was only one record, then I would follow your advice. When I get the images from a MS SQL 2000, Crystal Reports displays them without problems. But when I switch to MySQL, I fail. Thanks Emery - Original Message - From: DenBaguse MasRodjie [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:44 Subject: Re: BLOB images in Crystal Reports You can manually get that BLOB binaries from MySQL and copied to local file. And from CR get that file. Rgds, Roji - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mike Hillyer [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 4:23 PM Subject: BLOB images in Crystal Reports Hi group, has anyone tried to display BLOB pictures from MySQL through MyODBC in Crystal Reports? I have tried everything but I failed. Any ideas on how to achieve this is highly appreciated. I am using: MySQL 4.1.0 or MySQL 4.0.14 MyODBC 3.51.06 Crystal Reports Ver 7 (7.0.1.192) Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[MYSQL] Combine tables from two different systems
Hello All, I have two system, we shall call then system A (OLD) and system B (NEW), running MySQL that I want to combine their tables. The system B is the newer and most accurate. The table structure is the exact same. Some of the rows in system B (NEW) tables are also in system A (OLD). For those rows I want to leave the system B data unchanged. I have a select statement with a left join that will tell me the rows that are in system A but not in system B (the target). Question is how to I write a SQL statement to also insert these rows? System information. Windows NT4 (System A), Windows server 2003 (System B). MySQL 3.23.42-nt running on both systems. Paul
Compiling MySQL with SSL support
Hopefuly someone will be able to save me, before I destroy my system too bad. I am trying to compile mysql 4.1.0 alpha with openssl support. I know I have everything needed installed on my system, gcc 3.2.2, and two copies of openssl. I originaly tried installing with the rpm, to hopefuly be less of a head ache, but ended up being more of one. So I am going through and just compile from source code. From what I found out the hard way, this version only wants 0.9.6, won't accept 0.9.7 shared files. So I installed 0.9.6 in a different location and made the shared files, but I am unable to get the compiler to use the correct location for openssl. It always goes back to the default location which has 0.9.7 and fails. Right now 0.9.7 is installed in it's default location, and I installed 0.9.6 in /usr/local/openssl096. Is there a command or some commands that will tell the compiler use the new location over default? Thanks, Chris
Re: FW: When inserting data it insert 2 records one correct and one blank!
Emilio-
I ran into this problem just yesterday using some PHP code. The problem was in
control logic. I executed the insert within an if statement, but failed to see
that there was another mysql_query statement outside the if block. This caused
the same insert to happen again.
Basically, in psuedo code
if (found){
query = INSERT
mysql_query (query)
} else {
query = UPDATE
mysql_query (query)
}
mysql_query(query)
Stupid logic on my part. This doesn't adress the date being blank, but I would
suggest reviewing your logic to see if there is a mysql_query that is being
executed 2 times.
My 2 cents...
Quoting Dan Greene [EMAIL PROTECTED]:
sending on to list while I think... ;)
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:34 AM
To: Dan Greene
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Ok, here it is the full statement:
$sql = INSERT INTO llamadas
(destinatario,fecha,hora,apellido,nombre,telefono,mail,receptor,mensaje)
VALUES
('$destinatario','$fecha','$hora','$apellido','$nombre','$telefono','$mail','$re
ceptor','$mensaje');
$result = mysql_query($sql);
And, yes it happens to all users, and i ve tested pressing only once the
submit button but i allways got 2 records add the first one is a blank one
and the second the correct one.
From: Dan Greene [EMAIL PROTECTED]
To: Emilio Ruben Estevez [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Date: Thu, 9 Oct 2003 10:09:00 -0400
Emilio,
Can you supply the full insert statement? Also, is this happening for all
users, or one in particular? I ask, as I've seen issues with web app users
double-clicking the submit button causing similar issues
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:02 AM
To: [EMAIL PROTECTED]
Subject: When inserting data it insert 2 records one correct and one
blank!
Hi, I have a page on a intranet where workers can insert data into a
database, the thing is that when they type the info an press
submit the page
use the INSERT INTO db then when i check the data in the
database i can
see the record that the user entered and a second record that
is all in
blank, exept for the date and time field that the value is
-00-00 and
00:00:00.
What´s wrong? maybe something of the date and time format?? Any Clue.
Thanks.
Emilio.
_
Add MSN 8 Internet Software to your existing Internet access
and enjoy
patented spam protection and more. Sign up now!
http://join.msn.com/?page=dept/byoa
--
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]
_
High-speed Internet access as low as $29.95/month (depending on the local
service providers in your area). Click here. https://broadband.msn.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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]
MyIsam v. InnoDB and other questions
As I read the documentation, ALTER TABLE my_table DISABLE KEYS only works on MyIsam tables. When I run the command against an InnoDB database, however, I get no indication of a problem. I get the usual Query OK message. So, can I temporarily disable keys on an InnoDB database (say while doing a large load)? Second, I set up MySQL using all the defaults. So, the data directory is on C: and in the mysql\data subdir (Win2K platform). Things are a little tight on my C drive so the boss kindly bought me a 2nd drive which is now my D drive. Now, can I move my database from c: to d: just by copying the subdir and changing the path in my.cnf? (I forget what the my.cnf option is, but I'll find it.) Somehow, that sounds too easy... Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrade problem
I'm trying to move a bugzilla database from a MySql 3.23.54 - 3.23.56 database on a new machine. I have exported the database with the following mysqldump -u root -pPASSWORD --add-drop-table bugs bugs.dump.sql moved the file to the new machine and done mysql -u root -pPASSWORD bugs bugs.dump.sql and I get and error line 38. So I thought I would avoid the file and do the following ssh -l root IPADDRESS 'mysqldump -u root -pPASSWORD --add-drop-table bugs' | mysql -u root -pPASSWORD bugs and I get the same error.. This brings me to the list... is there any known problem with taking a 3.23.54 dump and importing it into a 3.23.56 system? I would not think so as the dump is SQL. The first table of the dump is attachments and the first entry is a large binary attachment. Is it possible that the binary data is Fing up the import. Is their a way to escape the binary data in the dump process? Steven Pokrandt Edifecs, The DNA of B2B Office: +1 425.452.0630 X 669 Email: stevenp mailto:[EMAIL PROTECTED] @edifecs.com http://www.hipaadesk.com/ www.hipaadesk.com F r e e Online HIPAA Testing Service
Re: BLOB images in Crystal Reports
Crystal was pulling the data through MyODBC, Mascon was just used for inserting the image into the database. hth danny On Thu, 2003-10-09 at 16:20, Director General: NEFACOMP wrote: I want to ask you one thing: Is your Crystal Report accessing the database through the Mascon Utility or it uses MyODBC? I think the main problem to me is how Crystal Report is accessing the database. I will try to access the database using ADO and see if there is any change. Thanks Emery - Original Message - From: Danny Haworth [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 14:41 Subject: Re: BLOB images in Crystal Reports I've had no problems with MySQL, crystal reports and blob images. Main differences here are the following: Crystal Reports 8.5 (not 7) Myodbc 2.x (haven't tried 3.x yet with images) Images were also inserted into the MySQL database using a third party utility called Mascon (http://www.scibit.com/). They do a free, unlimited, version (annoying nag screens but still) if you want to try that out? If that works, you can see the differences between the way mascon stores them, and the way you are storing them.. I'm assuming if crystal is reading happily from mssql then that cant be at fault. hth danny On Thu, 2003-10-09 at 13:08, Director General: NEFACOMP wrote: It was a good idea but it is not feasible for my case since I will be displaying many images coming in a recordset with many records. If it was only one record, then I would follow your advice. When I get the images from a MS SQL 2000, Crystal Reports displays them without problems. But when I switch to MySQL, I fail. Thanks Emery - Original Message - From: DenBaguse MasRodjie [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:44 Subject: Re: BLOB images in Crystal Reports You can manually get that BLOB binaries from MySQL and copied to local file. And from CR get that file. Rgds, Roji - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mike Hillyer [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 4:23 PM Subject: BLOB images in Crystal Reports Hi group, has anyone tried to display BLOB pictures from MySQL through MyODBC in Crystal Reports? I have tried everything but I failed. Any ideas on how to achieve this is highly appreciated. I am using: MySQL 4.1.0 or MySQL 4.0.14 MyODBC 3.51.06 Crystal Reports Ver 7 (7.0.1.192) Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[MYSQL] Licens problems.
Hello I am developing a small program for a small computer firm. Now I wonder when I have to buy the corporate licens? And when to use the free GPL-licens one. My application ´saves some data in the database and I have done NO change in the cource code of the free version of MySQL. Should I or shouldnt I buy it Thank you Thomas ### This message has been scanned by F-Secure Anti-Virus for Internet Mail. For more information, connect to http://www.F-Secure.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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: [MYSQL] Licens problems.
I am developing a small program for a small computer firm. Now I wonder when I have to buy the corporate licens? And when to use the free GPL-licens one. http://www.mysql.com/products/licensing-examples.html You need a license if you sell a product designed specifically for use with MySQL or that requires the MySQL server to function at all. This is true whether or not you provide MySQL for your client as part of your product distribution. So yes if your program is designed to work with MySQL, I guess you need to buy a license. Kaarel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL max_connections on Windows
Hello, list, What is a good setting for max_connections on a Windows machine with 1GB RAM, Dual Athlons, RAID, etc... The default of 100 seems a bit lean, we would like to increase this number, but don't have any experience history with MySQL to draw upon. The docs say that 500-1000 is good for Solaris/Linux systems, but that is all I can find. Anyone have a good place to start for Windows, with the hardware mentioned? TIA, --Scott Brown -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Errors starting Mysql
I installed all the stuff as root, so /home/mysql and beyond are root owner and group. Should I have to change to mysql user and group? - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:57 AM Subject: Re: Errors starting Mysql Jose Rojas [EMAIL PROTECTED] wrote: I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the next messages in the ../var/*.err file: mysqld started /home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13) 031008 15:18:16 Could not use dns1-bin for logging (error 13) 031008 15:18:16 /home/mysql/libexec/mysqld: Can't create/write to file '/home/mysql/var/dns1.sinfin.net.mx.pid' (Errcode: 13) 031008 15:18:16 /home/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 031008 15:18:16 /home/mysql/libexec/mysqld: Error on delete of '/home/mysql/var/dns1.sinfin.net.mx.pid' (Errcode: 13) 031008 15:18:16 mysqld ended I changed group write permissions to ../var directory, but the other files about error 13 I don't know how to fix them The user under which MySQL server runs must be owner of the data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INNODB vs MyISAM
Hi guys, Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15? If so, are the main advantages of using INNODB tables the added features of transactions, cascading deletes, and it's other more robust features? Any thoughts on any disadvantages of INNODB to MyISAM? I know that INSERTS, UPDATES and DELETES will be slower with INNODB cuz of the transaction overhead, but do you think the SELECT speed is about the same? any feedback appreciated. thanks, Don
Error: unable to execute query
hello, Im writing a db software using delphi7 mysql(3.23.41) (with standard dbexpress and data access components) The problem is: sometimes i get the error message unable to execute query, and the connection breaks. i only saw this occur on UPDATEs or INSERTs, but every time a different line in the code, which otherwise executes ok. If i use an xception handler, reconnect manually and execute the statement again it works fine, but it would be important to know whats causing this. I can invoke this error by executing updates or inserts repeatedly (needs about 30-50 repeated command) but it also happens when i update only 1 field in 1 record. Mysql logs show no error. The connection between the server clients is throught 10mbps lan, server runs on redhat 7.3, clients on windows machines. unfortunately, this is extremely urgent 4 me, any help would be appreciated...
MySQL 4.1 replication relay log control
The online manual at http://www.mysql.com/doc/en/Replication_Options.html says that these two variables: max-relay-log-size=# relay-log-purge=0|1 exist to control the size of the relay log. But when I try to start my slave server with: set-variable = max-relay-log-size=192MB set-variable = relay-log-purge=1 in my.cnf it won't start. Am I using them right? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INNODB vs MyISAM
On Thu, Oct 09, 2003 at 01:23:39PM -0400, Don Vu wrote: Hi guys, Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15? No. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 25 days, processed 959,424,306 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
Adam, Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything special when I downloaded and installed the latest version. I assumed that anything in need of doing would be taken care of during package install. I guess that was just wishful thinking. I'll make the ownership/group changes you suggest below and let you know the results. Thanks! jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:49 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James: Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain with the timeout and all. Anyway, at first blush I agree with you. When you installed mysql did you give mysql (or whatever account that runs MySQL) rights to the /usr/local/mysql/data directory? Make root the owner of the MySQL directory and place the directory under mysql (or whatever account that runs MySQL) group permissions? Assuming you're running MySQL as user 'mysql' in group 'mysql'. Do the following: chown -R root /usr/local/mysql chgrp -R mysql /usr/local/mysql chwon -R mysql /usr/local/mysql/data Then try mysqld_safe --user=mysql from the /usr/local/mysql directory. Got to run to lunch. Be back in about 45 min. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:21 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or
RE: Installation problem
Sounds like a plan. Actually, MySQL ships with OS X Server - sounds like your using the desktop version, which doesn't include it. Over lunch I threw 4.0.15 on a G4 running 10.2.6 - love that new installer. I had no issues. - Downloaded it. - Ran the installation package - kicked-off MySQL via mysqld_safe script I was able to rock and roll. It went even quicker than that ol'tar ball installation, which I thought was pretty easy. Let me know if the permission changes work. I'm curious to see what the issue is. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:02 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything special when I downloaded and installed the latest version. I assumed that anything in need of doing would be taken care of during package install. I guess that was just wishful thinking. I'll make the ownership/group changes you suggest below and let you know the results. Thanks! jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:49 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James: Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain with the timeout and all. Anyway, at first blush I agree with you. When you installed mysql did you give mysql (or whatever account that runs MySQL) rights to the /usr/local/mysql/data directory? Make root the owner of the MySQL directory and place the directory under mysql (or whatever account that runs MySQL) group permissions? Assuming you're running MySQL as user 'mysql' in group 'mysql'. Do the following: chown -R root /usr/local/mysql chgrp -R mysql /usr/local/mysql chwon -R mysql /usr/local/mysql/data Then try mysqld_safe --user=mysql from the /usr/local/mysql directory. Got to run to lunch. Be back in about 45 min. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:21 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original
Leaking Memory from mysql_real_query()
This is probably my mistake somewhere, but perhaps someone could shed some light on the matter: I have an app, compiled with the mysql c apis, that is leaking memory. I know this by fine-tuned debugging using mallinfo. The memory that is being leaked is allocated by calls to mysql_real_query(), and I can't figure out what needs to happen to free it. I *do* free the memory allocated by mysql_store_result(), but that does not rollback the memory allocated in mysql_real_query(). I am using the current production version of 4.0.15-standard, so I can't imagine this is an actual memory leak in mysql. Any idea what I might be doing wrong? --bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error: unable to execute query - Problems using Win32 MySQL ODBC driver
Hmm, that is weird. Actually, I had the same issue (sort of). I was grabbing some data from a MySQL instance on an OS X workstation. I had shared the tables in Access via ODBC. I'd start to update the MySQL DB and get an ODBC error. Usually I'd get about 93 rows done (out of 1000 or so). You're getting the same issue going from Win32 to Linux via ODBC. I wonder if its a bug with the ODBC driver? What version are you using? Anyone else have this problem? Regards, Adam -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:22 PM To: Fortuno, Adam Subject: Re: Error: unable to execute query instantly. if i execute inserts in loop, about 30 runs well, then comes the error. if i reconnect i can exec the next 30, and so on... - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Pak Gza' [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:16 PM Subject: RE: Error: unable to execute query Peko, it breaks in the sec the sentence is... what do you mean by sec? Regards, Adam -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:06 PM To: Fortuno, Adam Subject: Re: Error: unable to execute query no, it breaks in the sec the sentence is executed. and i can reconnect at once thanks! thats fast...:) - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Pak Gza' [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:02 PM Subject: RE: Error: unable to execute query Did the connection time out? -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:44 PM To: [EMAIL PROTECTED] Subject: Error: unable to execute query hello, Im writing a db software using delphi7 mysql(3.23.41) (with standard dbexpress and data access components) The problem is: sometimes i get the error message unable to execute query, and the connection breaks. i only saw this occur on UPDATEs or INSERTs, but every time a different line in the code, which otherwise executes ok. If i use an xception handler, reconnect manually and execute the statement again it works fine, but it would be important to know whats causing this. I can invoke this error by executing updates or inserts repeatedly (needs about 30-50 repeated command) but it also happens when i update only 1 field in 1 record. Mysql logs show no error. The connection between the server clients is throught 10mbps lan, server runs on redhat 7.3, clients on windows machines. unfortunately, this is extremely urgent 4 me, any help would be appreciated... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error: unable to execute query - Problems using Win32 MySQL ODBC driver
Pako, That blows my theory. Regards, Adam -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:32 PM To: Fortuno, Adam Subject: Re: Error: unable to execute query - Problems using Win32 MySQL ODBC driver i dont use odbc. i only need libmysql.dll dbexpmysql.dll - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Pak Gza' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:30 PM Subject: RE: Error: unable to execute query - Problems using Win32 MySQL ODBC driver Hmm, that is weird. Actually, I had the same issue (sort of). I was grabbing some data from a MySQL instance on an OS X workstation. I had shared the tables in Access via ODBC. I'd start to update the MySQL DB and get an ODBC error. Usually I'd get about 93 rows done (out of 1000 or so). You're getting the same issue going from Win32 to Linux via ODBC. I wonder if its a bug with the ODBC driver? What version are you using? Anyone else have this problem? Regards, Adam -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:22 PM To: Fortuno, Adam Subject: Re: Error: unable to execute query instantly. if i execute inserts in loop, about 30 runs well, then comes the error. if i reconnect i can exec the next 30, and so on... - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Pak Gza' [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:16 PM Subject: RE: Error: unable to execute query Peko, it breaks in the sec the sentence is... what do you mean by sec? Regards, Adam -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:06 PM To: Fortuno, Adam Subject: Re: Error: unable to execute query no, it breaks in the sec the sentence is executed. and i can reconnect at once thanks! thats fast...:) - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Pak Gza' [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:02 PM Subject: RE: Error: unable to execute query Did the connection time out? -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:44 PM To: [EMAIL PROTECTED] Subject: Error: unable to execute query hello, Im writing a db software using delphi7 mysql(3.23.41) (with standard dbexpress and data access components) The problem is: sometimes i get the error message unable to execute query, and the connection breaks. i only saw this occur on UPDATEs or INSERTs, but every time a different line in the code, which otherwise executes ok. If i use an xception handler, reconnect manually and execute the statement again it works fine, but it would be important to know whats causing this. I can invoke this error by executing updates or inserts repeatedly (needs about 30-50 repeated command) but it also happens when i update only 1 field in 1 record. Mysql logs show no error. The connection between the server clients is throught 10mbps lan, server runs on redhat 7.3, clients on windows machines. unfortunately, this is extremely urgent 4 me, any help would be appreciated... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
Adam, It works! I also had to run the initialization script... Thanks very much for the help. jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:49 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James: Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain with the timeout and all. Anyway, at first blush I agree with you. When you installed mysql did you give mysql (or whatever account that runs MySQL) rights to the /usr/local/mysql/data directory? Make root the owner of the MySQL directory and place the directory under mysql (or whatever account that runs MySQL) group permissions? Assuming you're running MySQL as user 'mysql' in group 'mysql'. Do the following: chown -R root /usr/local/mysql chgrp -R mysql /usr/local/mysql chwon -R mysql /usr/local/mysql/data Then try mysqld_safe --user=mysql from the /usr/local/mysql directory. Got to run to lunch. Be back in about 45 min. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:21 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411.
I've notice when running mysql interruptible sleep occurs
procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 0 1 0 5232 93140 26732 3736888 0 0 157510 388 343 11 1 88 0 1 0 5232 88552 26748 3741348 0 0 892 6 327 269 11 0 89 0 1 0 5232 95180 26780 3750820 0 0 1898 6 380 433 13 0 87 0 1 0 5232 55412 26820 3776584 0 0 5157 7 641 656 3 1 97 0 1 0 5232 35320 26864 3809160 0 0 6522 9 792 1091 6 0 94 0 1 0 5232 10484 26644 3833856 0 0 724614 1057 1917 1 1 98 0 1 0 5232 10504 18576 3841896 0 0 3164 6 663 833 0 0 99 0 1 0 5232 10528 18520 3841928 0 0 1656 6 517 442 0 0 99 Is this due to threads in a running D state, such as replication threads? Should I be alarmed? What C-flag(s) are used to purposely produce a process / thread to force it into interruptible sleep? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
Re: INNODB vs MyISAM
At 12:23 PM 10/9/2003, you wrote: Hi guys, Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15? If so, are the main advantages of using INNODB tables the added features of transactions, cascading deletes, and it's other more robust features? Any thoughts on any disadvantages of INNODB to MyISAM? I know that INSERTS, UPDATES and DELETES will be slower with INNODB cuz of the transaction overhead, but do you think the SELECT speed is about the same? any feedback appreciated. thanks, Don Don, For my tables the select speed with InnoDb is about 10x slower than MyISAM. I didn't do any tuning but my feeling is if the table is readonly, stick with MyISAM. If you have a lot of updates to the table, then InnoDb is recommended. You can of course this with your own table structure to see how well it performs. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which is the best MySQL book?
Is there one that's especially outstanding? Thanks, jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Leaking Memory from mysql_real_query()
usually, to release memory is used mysql_free_result(). You do that ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: bluejack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:26 PM Subject: Leaking Memory from mysql_real_query() This is probably my mistake somewhere, but perhaps someone could shed some light on the matter: I have an app, compiled with the mysql c apis, that is leaking memory. I know this by fine-tuned debugging using mallinfo. The memory that is being leaked is allocated by calls to mysql_real_query(), and I can't figure out what needs to happen to free it. I *do* free the memory allocated by mysql_store_result(), but that does not rollback the memory allocated in mysql_real_query(). I am using the current production version of 4.0.15-standard, so I can't imagine this is an actual memory leak in mysql. Any idea what I might be doing wrong? --bluejack -- 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: [mysql] Which is the best MySQL book?
On Thu, Oct 09, 2003 at 03:03:59PM -0400, Anderson, James H [IT] wrote: Is there one that's especially outstanding? I haven't read it front to back, but I have an affinity for New Rider's MySQL by Paul DuBois. (It's where I picked up PHP, and has been a useful reference for me these days, as I work as a newbie MySQL coder :^) ) I've also got O'Reilly's MySQL Cookbook (also by DuBois) sitting here on my desk, and have found it useful to get some real-world questions answered quickly. 'course, I'm working at a tech. book store right now, so I'll no doubt start poking my nose in the dozen other titles we have sitting on the shelf here. :^) -bill! -- [EMAIL PROTECTED] Got kids? Get Tux Paint! http://newbreedsoftware.com/bill/ http://newbreedsoftware.com/tuxpaint/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL Injections
Are there any SQL injection threats for MySQL less than 4.1? Dwight Trumbower T Systems Corp Custom Database Solutions [EMAIL PROTECTED] 920-667-4438 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and Php
Hi all I am new to the programming world so please forgive!!! Would like to get to get my hands on any info (Tutorials and such) to help me on me way whith SQL and Php Would appreciate any help... links / text / whatever... Thanx Casper South Africa Casper Matthee Consultant IT3 Educational Systems Tel: (021) 970 4005 Cell: 083 360 5669 Mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Injections
As I understand it, and I confess I am not totally sure I do, sql injection is more of a problem in your page code than what database (/version) you run. --ja On Thu, 9 Oct 2003, Dwight Trumbower wrote: Are there any SQL injection threats for MySQL less than 4.1? Dwight Trumbower T Systems Corp Custom Database Solutions [EMAIL PROTECTED] 920-667-4438 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Which is the best MySQL book?
MySQL the definitive guide to using, programming, and administering mySQL, version 2 by Paul Dubois, who is active on this list. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] --Sent: Thursday, October 09, 2003 12:04 PM --To: [EMAIL PROTECTED] --Subject: Which is the best MySQL book? -- --Is there one that's especially outstanding? -- --Thanks, -- --jim -- --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: MySQL and Php
Goto www.devshed.com some nice resources there, from introductions to advance topics. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Casper Matthee [mailto:[EMAIL PROTECTED] --Sent: Thursday, October 09, 2003 12:34 PM --To: --Subject: MySQL and Php -- --Hi all -- --I am new to the programming world so please forgive!!! -- --Would like to get to get my hands on any info (Tutorials and such) to --help me on me way whith SQL and Php -- --Would appreciate any help... links / text / whatever... -- --Thanx --Casper -- --South Africa -- --Casper Matthee --Consultant --IT3 Educational Systems -- --Tel: (021) 970 4005 --Cell: 083 360 5669 --Mail: [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: FW: FW: When inserting data it insert 2 records one correct and one blank!
I think I got it
What look like what is happening happening is that your page is running the insert
when you present the form to the user, which is why the php variables are empty. when
they submit the page, you are inserting the correct values. To test this, load the
page up, do not submit it, and see if you have your empty row.
If that is the case, then all you need to do is wrap the execution statement in an if
condition to only process when the form is submitted
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 3:39 PM
To: Dan Greene
Subject: Re: FW: FW: When inserting data it insert 2 records
one correct
and one blank!
Im lost, im new on php and mysql so i may be omitting some
statements or
logics i send you the entire script, its an lbi that i use on
DreamWeaber MX
if you can just take a look at it. Thanks.
meta http-equiv=Content-Type content=text/html;
charset=iso-8859-1
?php
$db = mysql_connect(localhost, root);
mysql_select_db(qllamo,$db);
$sql = INSERT INTO llamadas
(destinatario,fecha,hora,apellido,nombre,telefono,mail,recepto
r,mensaje)
VALUES
('$destinatario','$fecha','$hora','$apellido','$nombre','$tele
fono','$mail','$receptor','$mensaje');
$result = mysql_query($sql);
?
form method=post action=?php echo $PHP_SELF?
input type=hidden name=id value=?php echo $id ?
table bgcolor=#F2F0E0
tr
tdDestinatario:/tdtd align=centerinput type=Text
name=destinatario value=?php echo $destinatario ?br/td
/tr
tr
tdFecha:/tdtd align=centerinput type=Text name=fecha
value=?php print (date(Y-m-d)) ?br/td
/tr
tr
tdHora:/tdtd align=centerinput type=Text name=hora
value=?php print (date(h-i-d)) ?br/td
/tr
tr
td align=leftApellido:/tdtd align=centerinput type=Text
name=apellido value=?php echo $apellido ?br/td
/tr
tr
tdNombre:/tdtd align=centerinput type=Text name=nombre
value=?php echo $nombre ?br/td
/tr
tr
tdTeléfono:/tdtd align=centerinput type=Text
name=telefono
value=?php echo $telefono ?br/td
/tr
tr
tdMail:/tdtd align=centerinput type=Text name=mail
value=?php echo $mail ?br/td
/tr
tr
tdReceptor:/tdtd align=centerinput type=Text
name=receptor
value=?php echo $receptor ?br/td
/tr
tr
tdMensaje:/tdtd align=centertextarea
name=mensaje cols=70
rows=5 value=?php echo $mensaje ?/textareabr/td
/tr
tr
center td input name=reset type=reset
value=Borrar/td/center
center td input type=Submit name=submit
value=Grabar/td/center
/tr
/table
/form
From: Dan Greene [EMAIL PROTECTED]
To: Emilio Ruben Estevez [EMAIL PROTECTED]
Subject: FW: FW: When inserting data it insert 2 records one
correct and
one blank!
Date: Thu, 9 Oct 2003 13:27:45 -0400
-Original Message-
From: Matt Davies [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:10 AM
To: Dan Greene
Subject: Re: FW: When inserting data it insert 2 records one
correct and
one blank!
Emilio-
I ran into this problem just yesterday using some PHP code.
The problem was
in
control logic. I executed the insert within an if
statement, but failed to
see
that there was another mysql_query statement outside the if
block. This
caused
the same insert to happen again.
Basically, in psuedo code
if (found){
query = INSERT
mysql_query (query)
} else {
query = UPDATE
mysql_query (query)
}
mysql_query(query)
Stupid logic on my part. This doesn't adress the date being
blank, but I
would
suggest reviewing your logic to see if there is a
mysql_query that is being
executed 2 times.
My 2 cents...
_
Instant message in style with MSN Messenger 6.0. Download it
now FREE!
http://msnmessenger-download.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which is the best MySQL book?
At 02:03 PM 10/9/2003, you wrote: Is there one that's especially outstanding? Thanks, jim -- Jim, MySQL Cookbook also by Paul Dubois is also a good read. I got both books (including MySQL 2nd Edition) at a 30% discount off the list price plus another $10 off with a coupon plus free shipping. So don't pay retail (unless you have plenty of $$). I got one book from Amazon and the other from Chapters. You need to search around for a coupon site and you'll usually find a $10 off coupon that can be applied to each bookstore. Since there was free shipping it didn't cost me anything to order it from 2 different locations. If they were any cheaper, Paul would have to pay me to take them.vbg Mike (el cheapo) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [MYSQL] Licens problems.
You need a license if you sell a product designed specifically for use with MySQL or that requires the MySQL server to function at all. Actually, could someone from MySQL clarify this bit for future reference? If my application includes a standardized method of access such as ODBC, or provides the option to use MySQL in addition to other databases through specific classes and methods (e.g. accessing the old C libs from pre-4.0 days) then does it require a corporate license? -Rob -Original Message- From: Kaarel [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:34 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [MYSQL] Licens problems. I am developing a small program for a small computer firm. Now I wonder when I have to buy the corporate licens? And when to use the free GPL-licens one. http://www.mysql.com/products/licensing-examples.html You need a license if you sell a product designed specifically for use with MySQL or that requires the MySQL server to function at all. This is true whether or not you provide MySQL for your client as part of your product distribution. So yes if your program is designed to work with MySQL, I guess you need to buy a license. Kaarel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Which is the best MySQL book?
Cheap books - http://www.bookpool.com -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 4:16 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: Re: Which is the best MySQL book? At 02:03 PM 10/9/2003, you wrote: Is there one that's especially outstanding? Thanks, jim -- Jim, MySQL Cookbook also by Paul Dubois is also a good read. I got both books (including MySQL 2nd Edition) at a 30% discount off the list price plus another $10 off with a coupon plus free shipping. So don't pay retail (unless you have plenty of $$). I got one book from Amazon and the other from Chapters. You need to search around for a coupon site and you'll usually find a $10 off coupon that can be applied to each bookstore. Since there was free shipping it didn't cost me anything to order it from 2 different locations. If they were any cheaper, Paul would have to pay me to take them.vbg Mike (el cheapo) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Injections
\As I understand it, and I confess I am not totally sure I do, sql injection is more of a problem in your page code than what database (/version) you run.\ Absolutely. As I show at http://www.vbmysql.com/articles/sqlinjection.html SQL Injection is a flaw in the front-end code, and you are at risk in ANY MySQL version. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld maxing cpu
I recently got a redhat 9 server with mysql 3.23.54-log (what does the -log mean BTW?). Every time I start mysql it maxes out the cpu in a few minutes. Nothing is even connecting to mysql at this point, and SHOW PROCESSLIST doesn't show anything (except it's own query). Any idea what the problem is? Also, /etc/init.d/mysql stop always fails and I need to kill the various mysqld processes. CSN __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1 and TIMESTAMP Column Types
I am running MySQL 4.1 in a sandbox, trying to test some code against it. No matter what, even when no value is explicitly applied, or the field is not explicitly named in a SQL statement, the TIMESTAMP column refuses to update. I have tested this with several programs written in 3 different languages. Is this a known issue? Anybody got any pointers to info on this? Thanks, --Scott Brown -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 and TIMESTAMP Column Types
At 14:53 -0700 10/9/03, Scott Brown wrote: I am running MySQL 4.1 in a sandbox, trying to test some code against it. No matter what, even when no value is explicitly applied, or the field is not explicitly named in a SQL statement, the TIMESTAMP column refuses to update. I have tested this with several programs written in 3 different languages. Is this a known issue? Anybody got any pointers to info on this? What happens with this code (use with whatever you wish for the default database): DROP TABLE IF EXISTS t; CREATE TABLE t (ts TIMESTAMP, i INT); INSERT INTO t (i) VALUES(0); SELECT * FROM t; And then what happens with this code, after you wait a few seconds: UPDATE t SET i = i + 1; SELECT * FROM t; Finally, what's the output from this statement: SELECT @@sql_mode; -- 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]
Getting the value of a row you just inserted
Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of a row that was just inserted? I'm using PHP, I don't know if that makes a difference? Something like: INSERT INTO foo (bar) VALUES (bar); SELECT last_insert(id) FROM foo; Also, are there any problems with using this in an environment where you're forking processes? Thanks in advance, -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Getting the value of a row you just inserted
Here's the link to the on-line manual page that will help you. http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html -Original Message- From: Dan Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Getting the value of a row you just inserted Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of a row that was just inserted? I'm using PHP, I don't know if that makes a difference? Something like: INSERT INTO foo (bar) VALUES (bar); SELECT last_insert(id) FROM foo; Also, are there any problems with using this in an environment where you're forking processes? Thanks in advance, -Dan -- 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: Getting the value of a row you just inserted
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 09 October 2003 06:06 pm, Dan Anderson wrote: : Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of : a row that was just inserted? I'm using PHP, I don't know if that makes : a difference? : : Something like: : : INSERT INTO foo (bar) VALUES (bar); : SELECT last_insert(id) FROM foo; : : Also, are there any problems with using this in an environment where : you're forking processes? : : Thanks in advance, : : -Dan In php you can use mysql_insert_id() to get the id of the auto_increment column. See http://www.php.net/manual/en/function.mysql-insert-id.php todd[1] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/hd7v9xvMmfxCaFkRAsoZAJ9eL5aQf0dCHwY/nFdH5vQIny0BrgCgrcI3 V64M7/8+BnyHjJLlzYvG1C4= =MFdB -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
web interface...
Hi I have used other relational databases but am new to my sql. Where can I find documentation on how to connect my database to a web page? Thanks
web interface...
Hi I have used other relational databases but am new to my sql. Where can I find documentation on how to connect my database to a web page? Thanks
RE: web interface...
---Original Message- --From: Dora [mailto:[EMAIL PROTECTED] --Sent: Thursday, October 09, 2003 3:18 PM --To: [EMAIL PROTECTED] --Subject: web interface... -- -- --Hi -- --I have used other relational databases but am new to my sql. Where can --I find documentation on how to connect my database to a web page? Depends which language your using. Perl, C++, Java, PHP, etc. all do it differently. -- --Thanks -- - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 and TIMESTAMP Column Types
DROP TABLE IF EXISTS t; CREATE TABLE t (ts TIMESTAMP, i INT); INSERT INTO t (i) VALUES(0); SELECT * FROM t; At this point, the timestamp field is un-interpretable. SELECT returns -00-00 9:01 AM UPDATE t SET i = i + 1; SELECT * FROM t; Returns the same thing; -00-00 9:01 AM. JFYI, none of this is correct, not even the time. Finally, SELECT @@sql_mode; returns: ++ | @@sql_mode | ++ || ++ 1 row in set (0.01 sec) This is MySQL 4.1.0 alpha max nt, btw. Stranger and stranger... If I simply convert the column type to DATETIME, all of them are fine, and appear to have been properly stamped. So, my guess is, the error, or whatever it is that is happening, is occurring upon retrieval? Is this actually an ODBC driver issue? I am using the latest MyODBC, beta, I believe, 3.51.06.00 for Windows... Thanks! --Scott Brown -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web interface...
There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty - Original Message - From: Dora [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:21 PM Subject: web interface... Hi I have used other relational databases but am new to my sql. Where can I find documentation on how to connect my database to a web page? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: web interface...
Thank you. I'd like to do it myself though. -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:40 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: web interface... There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty - Original Message - From: Dora [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:21 PM Subject: web interface... Hi I have used other relational databases but am new to my sql. Where can I find documentation on how to connect my database to a web page? Thanks -- 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: web interface...
Martin Gainty wrote: There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty Who am I missing? I only counted 997. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: web interface...
I m open to suggestions. I use HTML and JavaScript regularly. If I have some sample code I could hack it do what I need. My website is on a UNIX CGI plant form. What are your thoughts? Thanks -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: web interface... ---Original Message- --From: Dora [mailto:[EMAIL PROTECTED] --Sent: Thursday, October 09, 2003 3:18 PM --To: [EMAIL PROTECTED] --Subject: web interface... -- -- --Hi -- --I have used other relational databases but am new to my sql. Where can --I find documentation on how to connect my database to a web page? Depends which language your using. Perl, C++, Java, PHP, etc. all do it differently. -- --Thanks -- - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL
PLEASE, I'M A STUDENT AND I´D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE CONFIGURATION TO RUN MYSQL SERVER. THANKS. _ Voce quer um iGMail protegido contra vírus e spams? Clique aqui: http://www.igmailseguro.ig.com.br Ofertas imperdíveis! Link: http://www.americanas.com.br/ig/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web interface...
On Thu, 9 Oct 2003 18:41:42 -0400, Dora [EMAIL PROTECTED] wrote: I m open to suggestions. I use HTML and JavaScript regularly. If I have some sample code I could hack it do what I need. My website is on a UNIX CGI plant form. Add PHP to your list of skills. There is so much documentation on this on the internet -- and so much sample code -- it will make your head swim. Start with google. Proceed intelligently. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web interface...
Dora wrote: I m open to suggestions. I use HTML and JavaScript regularly. If I have some sample code I could hack it do what I need. My website is on a UNIX CGI plant form. What are your thoughts? Thanks PHP... http://www.php.net And if PHP isn't doable, Perl. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web interface...
Dont worry The indians will put 3 more of us out of work by tommorrow am! -M - Original Message - From: John Nichel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:45 PM Subject: Re: web interface... Martin Gainty wrote: There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty Who am I missing? I only counted 997. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] MYSQL
On Thu, Oct 09, 2003 at 12:00:51PM -0300, [EMAIL PROTECTED] wrote: PLEASE, I'M A STUDENT AND I?D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE CONFIGURATION TO RUN MYSQL SERVER. THANKS. I think this depends on how big the database will be, how much it will be hit, etc!!! I've heard of MySQL being run on the 200MHz StrongARM based Sharp Zaurus with only 32MB of RAM and 32MB of 'disk' space. :^) I doubt that could handle a popular e-commerce site, though. Let us know what you think the strain might be on the database itself, and folks here will no doubt have some suggestions of the kind of iron that can handle it. Good luck! -bill! -- [EMAIL PROTECTED] Got kids? Get Tux Paint! http://newbreedsoftware.com/bill/ http://newbreedsoftware.com/tuxpaint/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: web interface...
If the are a UNIX CGI plant then they probably run PERL which then you can use DBI; this is much different then writing HTML since PERL by itself can't include raw imbedded html. So, I suggest using PHP it should be easier for you to make a transition to then a pure old fashion CGI script. Look below ?php mysql_connect() ? h2 I connected /h2 ?php # do something else ? h2 More html /h2 Check out www.php.net and PHP for programmers by WOX publishing. This will help you out allot. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Dora [mailto:[EMAIL PROTECTED] --Sent: Thursday, October 09, 2003 3:42 PM --To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED] --Subject: RE: web interface... -- --I m open to suggestions. I use HTML and JavaScript regularly. If I --have some sample code I could hack it do what I need. My website is on --a UNIX CGI plant form. -- --What are your thoughts? -- --Thanks -- ---Original Message- --From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] --Sent: Thursday, October 09, 2003 6:28 PM --To: [EMAIL PROTECTED]; [EMAIL PROTECTED] --Subject: RE: web interface... -- -- -- -- -Original Message- From: Dora [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 3:18 PM To: [EMAIL PROTECTED] Subject: web interface... Hi I have used other relational databases but am new to my sql. Where --can I find documentation on how to connect my database to a web page? -- --Depends which language your using. Perl, C++, Java, PHP, etc. all do it --differently. Thanks -- --- Dathan Vance Pattishall -- - Sr. Programmer and mySQL DBA for FriendFinder Inc. -- - http://friendfinder.com/go/p40688 -- -- -- -- -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
storing tables in ram / compressed myisam tables
So, we just got this handy dandy new G5 with 4GB of RAM and I'm trying to get it to store as much of our 4.3GB database in RAM as possible. I've tuned most of the usual parameters (query cache, tmp table size, sort buffer, key buffer, record buffer, table cache, myisam sort buffer, etc.) but then I was reading the section of the manual about how mysql uses memory (http://www.mysql.com/doc/en/Memory_use.html) and it said this: Only the compressed ISAM / MyISAM tables are memory mapped. This is because the 32-bit memory space of 4 GB is not large enough for most big tables. When systems with a 64-bit address space become more common we may add general support for memory mapping. I tried to find some more information about compressed ISAM / MyISAM tables. I found the options for CREATE TABLE to create a compressed table, but then I was reading about myisampack and I think I got confused. Can you still modify a compressed table? Or is it read only? Will it be mmap'd so the access is faster? Or is this configurable? If I could, I'd select a few of the tables to have stored in RAM to make the access as fast as possible. Can I do this? Also, considering that 64 bit systems like the PowerMac G5 and Athlon64 FX boxes are readily available now, will there soon be an option to choose whether or not a table (of any type) can be maintained in RAM via mmap like the manual said? TIA - Gabriel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting root password on OS X
I am a new mysql user. I am installing MySQL for the first time on my mac. I need to set a password for the 'root' user by using the following 2 commands: /usr/local/mysql/bin/mysqladmin -u root password password /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password The first worked, but i get the following error when i attempt to run the second: /usr/local/mysql/bin/mysqladmin: connect to server at 'skc.local.' failed error: 'Host ip address is not allowed to connect to this MySQL server' How do i know what my hostname is? I have entered a number of options of what i think it might be (like username 'localhost'...), but they have gotten me nowhere. I really don't know what im doing here, so i would appreciate any advice. Cheers Shane _ Get less junk mail with ninemsn Premium. Click here http://ninemsn.com.au/premium/landing.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lotus Notes/Domino Access MySQL DB
I've been searching the Lotus site and have gotten kind of lost. Does anybody have any experience using Lotus Notes as a front end to a MySQL database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I barking up the wrong tree? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: storing tables in ram / compressed myisam tables
Hi Gabriel, No, you can't currently modify compressed tables. For in memory tables, are you aware of the HEAP type for non-critical data? You're probably talking regular permanent tables, though. For those, the OS will use all free memory (that programs aren't using) to cache file data after it's accessed, so you shouldn't have to worry about doing anything special. Provided you don't have your key_buffer (or other global vars) set too large, most of that 4.3GB database should be able to be cached by the OS. Of course, the disk is still used for writes, but should hardly ever need to be hit for reads. BTW, I don't really know what memory mapped means... Surely this doesn't mean data is kept in memory *by MySQL*?? A big compressed table would take all your memory! Hmm. Matt - Original Message - From: Gabriel Ricard Sent: Thursday, October 09, 2003 7:09 PM Subject: storing tables in ram / compressed myisam tables So, we just got this handy dandy new G5 with 4GB of RAM and I'm trying to get it to store as much of our 4.3GB database in RAM as possible. I've tuned most of the usual parameters (query cache, tmp table size, sort buffer, key buffer, record buffer, table cache, myisam sort buffer, etc.) but then I was reading the section of the manual about how mysql uses memory (http://www.mysql.com/doc/en/Memory_use.html) and it said this: Only the compressed ISAM / MyISAM tables are memory mapped. This is because the 32-bit memory space of 4 GB is not large enough for most big tables. When systems with a 64-bit address space become more common we may add general support for memory mapping. I tried to find some more information about compressed ISAM / MyISAM tables. I found the options for CREATE TABLE to create a compressed table, but then I was reading about myisampack and I think I got confused. Can you still modify a compressed table? Or is it read only? Will it be mmap'd so the access is faster? Or is this configurable? If I could, I'd select a few of the tables to have stored in RAM to make the access as fast as possible. Can I do this? Also, considering that 64 bit systems like the PowerMac G5 and Athlon64 FX boxes are readily available now, will there soon be an option to choose whether or not a table (of any type) can be maintained in RAM via mmap like the manual said? TIA - Gabriel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access denied .... php my admin .....
sorry for this late reply rory i just got back to work .. i am trying to connect to 192.168.x.y but the jerk connects to 192.168.xx.xxx the other ip yeha it connects to an ip . not the loop back adrs am i supposed to connect to loop back adrs thinggy ? im all screwed with this thing .. :'( thnx a bill toby From: Rory McKinley [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: access denied php my admin . Date: Thu, 9 Oct 2003 11:47:25 +0200 Hi toby If I log in to mysql via the command line on the hosting machine it says [EMAIL PROTECTED] ... therefore, stating the obvious :) it doens't think you're connecting from localhost - this may be because of the two NICs but I don't know enough to be sure .when you connect to the mysql server (when php, apache and mysql are all on the same box) do you connect to 127.0.0.l (loopback address) or do you connect to the IP address of one of the two NICs (e.g. 192.168.y.z)? Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:18 AM Subject: Re: access denied php my admin . thnx rory the thing is kwexchange is localhost you know . so it should work alwayz has before this dammed day . anywayz . i did install mysql on another machine and installed all the rest , php, apache, phpmyadmin on another when it gave me these access denied errors the very bloody same . i thought there was somethin the matter with keepin these things on two separate machines u know but now i have got em all on the same thing . but to no use . do you or anyone else on this list think it could be the two network cards running on the machine that are actually screwin this all up fo me all though i have tried ma best to some how change this ip thinggy to the one i want mysql server to user .. can anyone tell me where to go and what to do as im at ma wits end now .. thnx a mill rory .. :) toby From: Rory McKinley [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: access denied php my admin . Date: Thu, 9 Oct 2003 11:09:06 +0200 Hi Toby I am not an expert on permissions within mysql - boy, do I wish I was - but could the problem be that you have only granted permissions to [EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ? Here endeth my knowledge of MySQL permissions Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:57 AM Subject: access denied php my admin . hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 1.3.24 mysql 3.23.58 i would really appriciat any help with this thnx a million toby _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ The new MSN 8: advanced junk mail protection and 2 months FREE*
newbie select statement question
Hi,
I have the following statement:
echo $tenureidP;
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid';
$result = mysql_db_query($database, $sql, $connection) or die (Error in query: $sql.
. mysql_error());
// obtain data from resultset
list($tenuredate) = mysql_fetch_row($result);
echo BDate Tenure Granted/B: ;
echo fixDate($tenuredate);
echo P;
}
else {
echo BDate Tenure Granted/B: NullP;
}
and I can't figure out why I always get the following result:
2
Date Tenure Granted: 31 Dec 1969
---
or
1
Date Tenure Granted: 31 Dec 1969
---
when 1) tenureid 3, and 2) no 31 Dec 1969 date in the database anywhere.
The only thing I can think of is that I modified the dropdown box for the tenure date
on the data entry page like this:
tr
tdDate Tenure Grantedbrfont size=-2(in mm-dd- format)/font/td
td
select name=tmm
option value=0 selected='selected'/option
? for ($x=1; $x=12; $x++) { echo option value=\ . sprintf(%02d, $x) . \ .
sprintf(%02d, $x) . /option; } ?
/select -
select name=tdd
option value=0 selected='selected'/option
? for ($x=1; $x=31; $x++) { echo option value=\ . sprintf(%02d, $x) . \ .
sprintf(%02d, $x) . /option; } ?
/select -
select name=t
option value=0 selected='selected'/option
!-- display from 1970 to (current year) --
? for ($x=(date(Y, mktime())); $x=1970; $x--) { echo option
value=$x$x/option; } ?
/select
/td
/tr
by adding option value=0 selected='selected'/option to those 3 fields as I want
null to be a default selection. but I can't imagine why that'll mess up the if
statement evaluation.
It seems that the 1st if statement just runs whatever the tenureid is.
Can anyone help me on this? I'm using PHP 4.2.2 and MySQL 3.23.54 btw.
Thanks millions!
Jordan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql binlog
Hi All, I have some doubts regarding Mysqlbinlog. Does Mysqlbinlog support this usage? mysqlbinlog --user=root --host=127.0.0.1 master-bin.001. I am repeatedly getting errors like master-bin.001 file not found in Linux . When I give the full path of the master-bin.001 its working. There is a mysqlbinlog test case newly added in Mysql-4.0.16 source tree which executes the mysqlbinlog command in the above form. Does any one succeded in passing this test case? ( For me its failing always). Regards, Srinivasulu. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] mysql_error() (was Re: Getting last insert id?)
On Thu, 2003-10-09 at 16:33, pete M wrote:
$new_id = mysql_query('select last_insert_id()');
your can also user it within a query - eg
$sql = ' insert into related table parent_id, data , data2) values
(last_insert_id(), 23, 45);
Is there also a similar way of getting the last error message, i.e.
$new_id = mysql_query('select error()');
I currently am trying to solve the problem or mysql_error() returning
nothing after an error. It may be something to do with globals and
something like the above may help.
Ben
--
* Ben Edwards Tel +44 (0)1179 553 551 ICQ 42000477 *
* Homepage - nothing of interest here http://gurtlush.org.uk *
* Webhosting for the masses http://www.serverone.co.uk *
* Critical Site Builderhttp://www.criticaldistribution.com *
* online collaborative web authoring content management system *
* Get alt news/views films online http://www.cultureshop.org *
* i-Contact Progressive Video http://www.videonetwork.org *
* Fun corporate graphics http://www.subvertise.org *
* Bristol Indymedia http://bristol.indymedia.org *
* Bristol's radical news http://www.bristle.org.uk *
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
