RE: [ANN] Blue World ...
Hi A few points 1. 1 (?)Spam, 40 people filling my in box with complaints about it. We get very little Spam on this list, if you don't like it, bin it. 2. MySql users are diverse. We have php, perl, c++, Delphi, Access and VB mentioned regularly. So why shouldn't we be interested in another language. 3. I am a php programmer. php does gifs, but I use Fireworks for graphics because it is a better tool for producing day to day pics. If Lasso were twice as fast at producing sites as php then I can earn twice as much for the same working time. If it could then I want to know about it because I get paid per site, mostly, and I want to earn money to feed my family. The real crime, I think, was to suggest Lasso was better than php. We get very attached to our software tools , and very aggressive when somebody attacks them. In reality I doubt the advantages (if any) will justify the time taken to cross train for any experienced php programmer, particularly as there are software costs as well as time, but that shouldn't mean we have closed minds. From my point of view, I can learn from anybody, and Lasso users will contribute knowledge to the group, which we should all welcome. So 'Welcome' Jim. A couple of points for Blue World 1. Don't send long notices - an intro and link is enough for anybody who might be interested. 2. Don't knock other peoples choice of language, productivity needs a good language, and somebody who enjoys using it. If Lasso is good then just say so. We wouldn't be using php (or vb or) if it didn't meet our needs. 3. Your comparisons are irrelevant to most. I have a code bank which means I can build an ecommerce site in a few days. It would take me longer than that to get started with Lasso, so it is not more productive for me, though it might be for somebody else. 4. The majority of bread and butter sites are relatively small and get few hits, so the performance advantages are mostly irrelevant too. If you want your company to be respected, show respect for others. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Jim Van Heule [mailto:[EMAIL PROTECTED]] Sent: 08 March 2002 13:32 To: [EMAIL PROTECTED] Subject: Re: [ANN] Blue World ... Okay, I'm a Lasso person who has been lurking on this list for some months now because I'm learning MySQL. I'm learning it because Blue World was cool enough to adopt MySQL in their latest version of Lasso Professional 5 (LP5). This is a great list and I'm learning a ton of stuff here without ever needing to ask a question. It seems whenever I have a question, it seems to have been covered in the past week or so and I simply go through my old emails from the list to find the answer. Reading this thread, it seems clear that the PHP people on this list feel that this list should only discuss things related to MySQL and PHP. I thought this was a MySQL list, not PHP. There is going to be a lot more Lasso people on this list as more and more of us switch to LP5. This list better start adjusting to the idea or MySQL will start losing a whole new group of MySQL converts. The really cool thing about all this is that MySQL is being adopted by more and more complimenting technologies. That's a good thing for the MySQL community. It's only natural that people are going to want comparisons of competing technologies as long as they can continue to use MySQL. Right? That's what I would want to see. sql, query - Lasso Summit 2002 - EuropeApril 15-16, 2002 in London, UK - Jim Van Heule The Data Web Center VH Publications, Inc. www.DataWebCenter.com www.VHPublications.com[EMAIL PROTECTED] [EMAIL PROTECTED] direct: 616.844.0066 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
BETWEEN function
Felix, Friday, March 08, 2002, 1:29:36 PM, you wrote: FR I could not find any documentation about the BETWEEN function. Am I just FR blind? Please point me to it. Or is it not stable yet? How does it FR perform in comparison to field1 = x AND field1 = y? You can find description of this function in the manual: http://www.mysql.com/doc/C/o/Comparison_Operators.html FR Thanks, FR Felix -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CREATE statment problem.
zlab, Saturday, March 09, 2002, 6:23:24 AM, you wrote: zz Hi, zz I¡¦m a new user of MySQL verison 4.01 and found that the following zz statement not working: zz CREATE TABLE test TYPE = HEAP SELECT * FROM customer zz If omit TYPE = HEAP, or using TYPE = INNOB or TYPE = MYISAM will work, is zz it a bug? I tested your example on version 3.23.46 and it worked fine. What type of error did you receive? What is the structure of your table 'customer'? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql/Solaris: can't run configure or mysql_install_db
Chuck, Friday, March 08, 2002, 5:56:59 PM, you wrote: CR Hi. We have Solaris 2.8 and just got Mysql 3.23. We installed the CR files and are now trying to run the mysql/configure or CR mysql/scripts/mysql_install_db scripts but I get an error CR Command not found. I logged in as chuck, then did su and CR logged in as superuser before running this command. I also logged CR in as root and used this command. All the files in mysql/ are CR owned by root and have a group of 'mysql'. CR Anyone know what I can try to run the install script? Try to install script in the following way: 1. cd to where you have unzipped the binary ditribution. 2. Then cd to scripts 3. Then run ./mysql_install_db CR Thanks. CR p.s. We also made a user 'mysql' and a group 'mysql'. The CR computer is a SPARC server and we have the appropriate mysql CR binary. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
adding a user to a database
I'm using MySQL 3.23 on FreeBSD 4.5-STABLE, and I am kinda new to MySQL. I created the database bsd as root. I need a remote user, connecting from any IP and logging in with shadowgrl and giving the password testing123 to have full access to the bsd database only. After making the bsd database, I did this: grant all on db.bsd to shadowgrl@ identified by testing123 with grant option; I know the last option is dangerous, but I trust this user fully, and the server is firewalled to only allow her network in. However, when connecting remotely, shadowgrl is getting error: user has no access to server What am I overlooking? Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re(2): [ANN] Blue World ...
From my point of view, I can learn from anybody, and Lasso users will contribute knowledge to the group, which we should all welcome. So 'Welcome' Jim. Thanks Peter. :-) A couple of points for Blue World If you want your company to be respected, show respect for others. Though I can't speak for Blue World, the Lasso talk list has vastly different rules than this one in which announcements are strongly encouraged. It would make sense Blue World innocently assumed this list had similar rules. Let's let this die as a one-time event that should be considered a good learning experience for Blue World. I would hope one hard-learned event won't sway the opinion of a really great company commited to bringing MySQL into their market. - Lasso Summit 2002 - EuropeApril 15-16, 2002 in London, UK - Jim Van Heule The Data Web Center VH Publications, Inc. www.DataWebCenter.com www.VHPublications.com[EMAIL PROTECTED] [EMAIL PROTECTED] direct: 616.844.0066 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: which JDBC is better
Jianping Zhu [EMAIL PROTECTED] wriites: mm.mysql.jdbc-1.2c.tar.gz mm.mysql-2.0.4-bin.jar Which of these two database driver for MySQL is better? Thanks Neither? They're both pretty old. Why don't you check out MM.MySQL 2.0.11 from http://sourceforge.net/projects/mmmysql/ -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to load binary data with Perl DBI?
Hello. How to load binary data into a table using Perl DBI module (the data is uploaded from a HTML form)? I failed to find any information on MySQL site. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: adding a user to a database
Hi, Try this request: grant all on db.bsd to shadowgrl@'%' identified by testing123 with grant option; Regards, Sébastien -Message d'origine- De : Michael Sharp [mailto:[EMAIL PROTECTED]] Envoyé : samedi 9 mars 2002 13:08 À : [EMAIL PROTECTED] Objet : adding a user to a database I'm using MySQL 3.23 on FreeBSD 4.5-STABLE, and I am kinda new to MySQL. I created the database bsd as root. I need a remote user, connecting from any IP and logging in with shadowgrl and giving the password testing123 to have full access to the bsd database only. After making the bsd database, I did this: grant all on db.bsd to shadowgrl@ identified by testing123 with grant option; I know the last option is dangerous, but I trust this user fully, and the server is firewalled to only allow her network in. However, when connecting remotely, shadowgrl is getting error: user has no access to server What am I overlooking? Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
xml
hi everybody: i was talking with a developer and he told the next thing: if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration then he says. the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar. Well, now I´m cofused. Some one can help me with this is that true, is XML the next generation of creating databases and tables for beast results. THANKs JAVIER GLORIA developer __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: xml
On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier Gonzalo Gloria Medina wrote: hi everybody: i was talking with a developer and he told the next thing: if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration then he says. the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar. Well, now I´m cofused. Anybody who tries to make blanket statements about the best solution does ___ is generally biased and probably being closed-minded. The best solution for YOU is the one which best meets your needs. It's as simple as that. If you're dealing with a lot of XML, then maybe it's an XML-based database. But if someone thinks that XML databases are just better really has their head buried in the sand. My 2 cents. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,024,381,424 queries (393/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: xml
Anyhow, Mysql can return data in XML. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 09, 2002 5:29 PM To: Javier Gonzalo Gloria Medina Cc: [EMAIL PROTECTED] Subject: Re: xml On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier Gonzalo Gloria Medina wrote: hi everybody: i was talking with a developer and he told the next thing: if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration then he says. the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar. Well, now I´m cofused. Anybody who tries to make blanket statements about the best solution does ___ is generally biased and probably being closed-minded. The best solution for YOU is the one which best meets your needs. It's as simple as that. If you're dealing with a lot of XML, then maybe it's an XML-based database. But if someone thinks that XML databases are just better really has their head buried in the sand. My 2 cents. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,024,381,424 queries (393/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New 4.0.x Replication Core Dump...
Sasha, Running the latest binary I just built, I had a single core dump and auto-restart early this morning. Here's the backtrace: ---snip--- Core was generated by `mysqld'. Program terminated with signal 6, Abort trap. Reading symbols from /usr/lib/libz.so.2...done. Reading symbols from /usr/lib/libcrypt.so.2...done. Reading symbols from /usr/lib/libm.so.2...done. Reading symbols from /usr/lib/libc_r.so.4...done. Reading symbols from /usr/libexec/ld-elf.so.1...done. #0 0x2839d330 in kill () from /usr/lib/libc_r.so.4 (gdb) bt #0 0x2839d330 in kill () from /usr/lib/libc_r.so.4 #1 0x283e9ab1 in abort () from /usr/lib/libc_r.so.4 #2 0x283c377d in __assert () from /usr/lib/libc_r.so.4 #3 0x80f75c8 in next_event (rli=0x8305e2c) at slave.cc:2376 #4 0x80f52da in exec_relay_log_event (thd=0x203b5818, rli=0x8305e2c) at slave.cc:1533 #5 0x80f646d in handle_slave_sql (arg=0x8305ae0) at slave.cc:1887 #6 0x2837403b in _thread_start () from /usr/lib/libc_r.so.4 #7 0x0 in ?? () ---snip--- And the relevant bits from the log, with an assert failure just before the restart: ---snip--- 020309 3:02:21 next log './db3-relay-bin.007' is not active 020309 3:14:59 Error in Log_event::read_log_event(): 'read error', data_len=283,event_type=2 020309 3:14:59 Slave SQL thread: I/O error reading event(errno=-1,cur_log-error=247) assertion ((cur_log)-pos_in_file + (uint) (*(cur_log)-current_pos - (cur_log)-request_pos)) == rli-relay_log_pos + rli-pending failed: file slave.cc, line 2376 020309 03:15:20 mysqld restarted Warning: One can only use the --user switch if running as root /home/mysql-4-bk/libexec/mysqld: ready for connections 020309 3:15:22 Error in accept: Software caused connection abort 020309 3:15:22 Slave I/O thread initialized 020309 3:15:22 Slave SQL thread initialized, starting replication in log 'binary-log.048' at position 535046117,relay log: name='./db3-relay-bin.007',pos='42811130' 020309 3:15:22 Error in Log_event::read_log_event(): 'read error', data_len=283,event_type=2 020309 3:15:22 Slave SQL thread: I/O error reading event(errno=-1,cur_log-error=247) 020309 3:15:23 next log './db3-relay-bin.008' is not active 020309 3:15:23 next log './db3-relay-bin.009' is not active 020309 3:15:23 next log './db3-relay-bin.010' is not active 020309 3:15:23 next log './db3-relay-bin.011' is not active 020309 3:15:23 next log './db3-relay-bin.012' is not active 020309 3:15:23 next log './db3-relay-bin.013' is not active 020309 3:15:23 next log './db3-relay-bin.014' is not active 020309 3:15:23 next log './db3-relay-bin.015' is not active 020309 3:15:23 next log './db3-relay-bin.016' is not active 020309 3:15:23 next log './db3-relay-bin.017' is not active 020309 3:15:23 next log './db3-relay-bin.018' is not active 020309 3:15:23 next log './db3-relay-bin.019' is not active 020309 3:15:23 next log './db3-relay-bin.020' is not active 020309 3:15:23 next log './db3-relay-bin.021' is not active 020309 3:15:23 next log './db3-relay-bin.022' is not active 020309 3:15:23 next log './db3-relay-bin.023' is not active 020309 3:15:23 next log './db3-relay-bin.024' is not active 020309 3:15:23 next log './db3-relay-bin.025' is not active 020309 3:15:23 next log './db3-relay-bin.026' is not active 020309 3:15:23 next log './db3-relay-bin.027' is not active 020309 3:15:23 next log './db3-relay-bin.028' is not active 020309 3:15:23 next log './db3-relay-bin.029' is not active 020309 3:15:23 next log './db3-relay-bin.030' is not active 020309 3:15:23 next log './db3-relay-bin.031' is not active 020309 3:15:23 next log './db3-relay-bin.032' is not active 020309 3:15:23 next log './db3-relay-bin.033' is not active 020309 3:15:23 next log './db3-relay-bin.034' is not active 020309 3:15:23 next log './db3-relay-bin.035' is not active 020309 3:15:23 next log './db3-relay-bin.036' is not active 020309 3:15:23 next log './db3-relay-bin.037' is not active 020309 3:15:23 next log './db3-relay-bin.038' is not active 020309 3:15:23 next log './db3-relay-bin.039' is not active 020309 3:15:23 next log './db3-relay-bin.040' is not active 020309 3:15:23 next log './db3-relay-bin.041' is not active 020309 3:15:23 next log './db3-relay-bin.042' is not active 020309 3:15:23 next log './db3-relay-bin.043' is not active 020309 3:15:23 next log './db3-relay-bin.044' is not active 020309 3:15:23 next log './db3-relay-bin.045' is not active 020309 3:15:23 next log './db3-relay-bin.046' is not active 020309 3:15:23 next log './db3-relay-bin.047' is not active 020309 3:15:23 next log './db3-relay-bin.048' is not active 020309 3:15:23 next log './db3-relay-bin.049' is not active 020309 3:15:23 next log './db3-relay-bin.050' is not active 020309 3:15:23 next log './db3-relay-bin.051' is not active 020309 3:15:23 next log './db3-relay-bin.052' is not active 020309 3:15:23 next log './db3-relay-bin.053' is not active 020309 3:15:23
Re: xml
On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote: Anyhow, Mysql can return data in XML. The client can, but not the server, right? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,024,611,977 queries (393/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Boolean Fulltext problems part III
Hi! On Feb 19, Alexander Belyaev wrote: Hello, Sergey, thanks for the patch, I applied it for 4.0.1 and seems like mentioned bug closed. But I found new bug :) Strange, but the query WORKS AS EXPECTED without fulltext index! The results for 4.0.1 with latest fulltext patch applied: If you need full testcase, please conteact me. Thanks, Alexander Thank you. It's fixed finally. 4.0.2 will contain the bugfix. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql error .
Can someone help and tell how can i fix this error . Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) Thanks . Carlos Arnt . -- Use o melhor sistema de busca da Internet Radar UOL - http://www.radaruol.com.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql error .
You can't log as root because a password has been set. You need to log like this root@yourbox# mysql -u root -p It will then ask you for a password If you ever have to log onto another box use a -h hostname. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein on 3/9/02 12:58 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Can someone help and tell how can i fix this error . Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) Thanks . Carlos Arnt . -- Use o melhor sistema de busca da Internet Radar UOL - http://www.radaruol.com.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: xml
Well, I assume the server can do it too - - i haven't checked the C api lately on that. James -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 09, 2002 5:52 PM To: James Cox Cc: [EMAIL PROTECTED]; Javier Gonzalo Gloria Medina Subject: Re: xml On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote: Anyhow, Mysql can return data in XML. The client can, but not the server, right? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,024,611,977 queries (393/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: xml
Frankly, it sounds like this guy understands neither XML nor relational databases. XML is a general-purpose structured data format. The term relational database also connotes a way of storing data, but is usually used to refer more to the way the data is organized and efficient ways for accessing, transforming, and re-organizing that data. SQL, the standard interface to relational databases, is (and let's not debate the subtleties of this statement) a programming language for working with structured data. One aspect of SQL is that you can use it as a format for storing data in files, and in this respect I totally agree with your friend: XML is a better choice in the vast majority of cases. SQL is not designed for this purpose: it's like passing text around by storing it in string constants in C language header files. In fact, we largely have the SQL crowd to thank for XML- it was designed largely as a platform-independent way for databases to exchange data files with one another because there are a lot of problems with using SQL for this. As a result, it is *very* easy to write a bridge for just about any relational database which returns result sets as XML files instead of the traditional row/column format. Many (or most) databases support this out of the box. Further, because XML is a format for storing structured data and databases (both relational and object-oriented) are focused on the storage and manipulation of data, you can write an interface that looks like a database as a method of accessing data in XML files. There are several systems and standards available for doing this to XML. Of course, while storing data in XML is very portable and readable, it is orders of magnitude less efficient in terms of both storage space and access time when compared with the internal formats of true database systems, so patching database interfaces onto XML files is a convenience, not a replacement for databases. If you really cared about efficiency, you'd just load the XML data into a database like mySQL and then access it in the database instead of emulating database functionality on the XML file itself. Finally, in addition to offering a structured data format, XML offers a unified syntax and approach to designing text-based cross-platform standards. Over the years a lot of text-based standards have been developed and it is from their mistakes in terms of awkward or non-standard syntax, portability, and industry adoption that XML has learned. As a result, many of these aging standards are being replaced with variants which are based on the XML syntax. SQL is no exception. Several query-processing XML languages are being developed and deployed, often designed as means of accessing other XML data-sources, but with possible long-term goals of replacing legacy data processing languages like SQL. Regardless of what comes of these languages, they fundamentally affect only the way you access data in a database; they do not change the nature of relational databases. As these languages gain acceptance, I see no substantial barrier to new query interfaces being added to mySQL- whether they come from the mySQL dev team or from other groups who simply write bridge code. And anyone who tells you that any use of joins suggests poor database design clearly doesn't know *anything* about relational database design. On 9/3/02 at 9:21 am, Javier Gonzalo Gloria Medina [EMAIL PROTECTED] wrote: hi everybody: i was talking with a developer and he told the next thing: if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration then he says. the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar. Well, now I¥m cofused. Some one can help me with this is that true, is XML the next generation of creating databases and tables for beast results. THANKs JAVIER GLORIA developer __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: xml
This 'developer' is feeding you some BS. MySQL handles XML data as well as any other type of data. The functioanlity of a particular database has a lot to do with the programmer who designs the schema. Maybe this 'developer' doesn't know how to design an XML/MySQL application ... but that doesn't mean there is a problem with MySQL. - Original Message - From: Javier Gonzalo Gloria Medina [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 11:21 AM Subject: xml hi everybody: i was talking with a developer and he told the next thing: if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration then he says. the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar. Well, now I´m cofused. Some one can help me with this is that true, is XML the next generation of creating databases and tables for beast results. THANKs JAVIER GLORIA developer __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to load binary data with Perl DBI?
At 16:39 +0200 3/9/02, [EMAIL PROTECTED] wrote: Hello. How to load binary data into a table using Perl DBI module (the data is uploaded from a HTML form)? Same way you load any other kind of data. Use placeholders or the quote() function. I failed to find any information on MySQL site. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: xml
On Sat, 2002-03-09 at 11:52, Jeremy Zawodny wrote: On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote: Anyhow, Mysql can return data in XML. The client can, but not the server, right? Jeremy, Correct, currently only the 'mysql' (-X option in MySQL 4.x) and 'mysqldump' (-X option in MySQL 3.23) client programs can return XML output. We believe that this sort of functionality belongs in the client programs and libraries. So that means for direct server XML interaction support would have to be added to the libmysqlclient library. Not bloat the 'mysqld' code. Of course inputting XML to a MySQL database is quite a different and more difficult task. It would require a lot more monkey business of some piece of software knowing how to map the XML schema into the DB schema. This is one of those fluffy features that is not traditionally in the RDBMS project scope -- and therefore lends itself to be a prime project for corporate sponsorship. Potential sponsors reading this should contact our sales team ([EMAIL PROTECTED]) if interested in helping. If seriously interested, we could develop some whitepaper specs and discuss options to for your company to help fund development. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com M: +1 952 250 5434 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: xml
Matt, Are you suggesting development of a wrapper around MySQL to convert XML to SQL and back, so that you would have a pseudo XML front end to mysqld? James -Original Message- From: Matt Wagner [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 09, 2002 7:07 PM To: [EMAIL PROTECTED] Cc: James Cox; Javier Gonzalo Gloria Medina Subject: Re: xml On Sat, 2002-03-09 at 11:52, Jeremy Zawodny wrote: On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote: Anyhow, Mysql can return data in XML. The client can, but not the server, right? Jeremy, Correct, currently only the 'mysql' (-X option in MySQL 4.x) and 'mysqldump' (-X option in MySQL 3.23) client programs can return XML output. We believe that this sort of functionality belongs in the client programs and libraries. So that means for direct server XML interaction support would have to be added to the libmysqlclient library. Not bloat the 'mysqld' code. Of course inputting XML to a MySQL database is quite a different and more difficult task. It would require a lot more monkey business of some piece of software knowing how to map the XML schema into the DB schema. This is one of those fluffy features that is not traditionally in the RDBMS project scope -- and therefore lends itself to be a prime project for corporate sponsorship. Potential sponsors reading this should contact our sales team ([EMAIL PROTECTED]) if interested in helping. If seriously interested, we could develop some whitepaper specs and discuss options to for your company to help fund development. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com M: +1 952 250 5434 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.x Replication Just Dumped Core...
On Sat, Mar 09, 2002 at 12:31:20PM -0700, Sasha Pachev wrote: Jeremy: I think I now understand what happened, or at least I have a pausilble theory that explains what I see in the logs. When I had you kill the broken mysqld last time it went down in the middle of updating db3-relay-bin.005 - that is the only explanation I can think of for it being truncated in the middle of event and especially at such a strange position that is not anywhere near your max_binlog_size value. That does make sense, yes. That reminds me of an easy feature request. Would it be possible to have a slave-auto-start=no option (or something like that) in my.cnf? There have been cases when I want to start a server but do not want replication to start on its own? To prove this, check modification time on db3-relay-bin.005 - should be around the time mysqld was killed and should be almost identical to the creation time on the first core, if you still have it around. Actually, I blew away the core file just a few hours ago. And the relay-bin file has been processed and is gone now. :-( Nevertheless, it was a blessing in disguise to have the stale broken log laying around - it helped me find a different bug. Excellent. However, we need to fix the stale log problem before we can go on. One way to do is to re-start the whole replication from scratch. A more creative way would be to use dd to trim db3-relay-bin.005 down to 214929332 bytes and re-start the server. The server is well past that point already with the new code, so I guess that won't be necessary. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,024,823,330 queries (392/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANNOUNCE: moodss-15.9
Note: I am temporarily unsubscribed from this list, so please Cc me at [EMAIL PROTECTED] if you reply to this message. Moodss (a modular monitoring application, graphical and daemon) fully supports the MySQL database and great efforts are made in collaboration with the MySQL AB developer Sinisa Milivojevic, in order to achieve a practical and thorough monitoring of MySQL servers. No less than 8 modules, such as the new myreplication, myerrorlog and myhealth modules, are available. This new version features the new myreplication module. It monitors a pool of replicated servers, which can include any number of masters and slaves, or even servers assuming both roles, for total forward compatibility. Also very useful for debugging your replicated servers, this module displays replication delays, identifiers, errors, ... allowing the administrator great flexibility in setting thresholds used to warn of any replication problems. For example, it is possible to be alerted with an email message when a slave stays late for too long in the replication process. Please refer to the http://jfontain.free.fr/moodss-15.9.CHANGES for a complete list of changes, including better module management, bug fixes, ... More examples and documentation can be found in the module help file, at http://jfontain.free.fr/myreplication/myreplication.htm, various screenshots and other modules for MySQL (myhealth, mystatus, myvars, myprocs, myquery, ...) are visible at the moodss and MySQL specific page: http://jfontain.free.fr/mysql/, whereas complete information on moodss itself can be found at http://jfontain.free.fr/moodss/. Development on moodss MySQL modules is very active, and your comments, bug reports, feature requests, ... will be greatly appreciated. Watch this space for new modules... Downloads: http://jfontain.free.fr/moodss-15.9.tar.bz2 http://jfontain.free.fr/moodss-15.9.zip http://jfontain.free.fr/moodss-15.9-1.i386.rpm http://jfontain.free.fr/moomps-1.3-1.i386.rpm http://jfontain.free.fr/moodss-15.9-1.spec Enjoy! -- Jean-Luc Fontaine mailto:[EMAIL PROTECTED] http://jfontain.free.fr/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.x Replication Just Dumped Core...
On Saturday 09 March 2002 12:46 pm, Jeremy Zawodny wrote: That reminds me of an easy feature request. ?Would it be possible to have a slave-auto-start=no option (or something like that) in my.cnf? There have been cases when I want to start a server but do not want replication to start on its own? Already there - --skip-slave-start. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About to pull my hair out :o) setting up Connection to MySQL
OK..here is my intention and my dilemma. I work with a new not-for-profit organization and I am creating a database for contact information. I would like this to be a dynamic DB in that it is available to the rest of the board members so they may search and view info on various types of contacts. Right now it will only be for lookup as I am keeping the master data elsewhere and just loading updates. However, I will eventually open it up so that data may be added/edited by the other board members. My hosting company supports MySQL and both Chilisoft ASP and PHP. They have phpMyAdmin installed as a management system (to create tables, load data, etc.) However, I need to set up pages in which users can look up and add/delete data. My problem is that I cannot connect to the DB other than through the phpMyAdmin interface they have set up. I have asked the provider to give me the connection information (I obviously have the login and password but need the host), but they sent me a link to http://list.cobalt.com/mailman/listinfo/cobalt-users (wtf...???) Either my provider does not know what to give me for the connection strings or I did not state my intentions clearly enough. Considering they host the site for free, I cannot complain too much :o) Thanks in advance for any advice anyone can provide. Theresa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About to pull my hair out :o) setting up Connection to MySQL
Hi Theresa, Your MySQL installation is most likely on the same box. Have you tried localhost as the hostname in the connection string? If that doesn't work, do you have shell access to this machine? If so, you can also look inside the phpMyAdmin directory for a file called config.inc.php. This usually contains all the configuration info for the program. There's a section in this file called 'Server configuration' and you should be able to find the host information there. --jeff - Original Message - From: Theresa Messenger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 12:40 PM Subject: About to pull my hair out :o) setting up Connection to MySQL OK..here is my intention and my dilemma. I work with a new not-for-profit organization and I am creating a database for contact information. I would like this to be a dynamic DB in that it is available to the rest of the board members so they may search and view info on various types of contacts. Right now it will only be for lookup as I am keeping the master data elsewhere and just loading updates. However, I will eventually open it up so that data may be added/edited by the other board members. My hosting company supports MySQL and both Chilisoft ASP and PHP. They have phpMyAdmin installed as a management system (to create tables, load data, etc.) However, I need to set up pages in which users can look up and add/delete data. My problem is that I cannot connect to the DB other than through the phpMyAdmin interface they have set up. I have asked the provider to give me the connection information (I obviously have the login and password but need the host), but they sent me a link to http://list.cobalt.com/mailman/listinfo/cobalt-users (wtf...???) Either my provider does not know what to give me for the connection strings or I did not state my intentions clearly enough. Considering they host the site for free, I cannot complain too much :o) Thanks in advance for any advice anyone can provide. Theresa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.x Replication Just Dumped Core...
On Sat, Mar 09, 2002 at 01:21:44PM -0700, Sasha Pachev wrote: On Saturday 09 March 2002 12:46 pm, Jeremy Zawodny wrote: That reminds me of an easy feature request. ?Would it be possible to have a slave-auto-start=no option (or something like that) in my.cnf? There have been cases when I want to start a server but do not want replication to start on its own? Already there - --skip-slave-start. Ah! It's amazing how I can look right past something when I'm already sure I know what I'm looking for.. *sigh* Thanks. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,025,808,589 queries (392/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing datatypes on the fly?
I have a column defined as varchar(255) in my MySql-database. Now I realized that there's not enough room for my inserts. Is there any chance to change it's datatype to tinytext without making an entirely new database and inserting data from the old one to it? -Jarkko _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changing datatypes on the fly?
On Sat, Mar 09, 2002 at 10:59:52PM +0200, Jarkko Toivonen wrote: I have a column defined as varchar(255) in my MySql-database. Now I realized that there's not enough room for my inserts. Is there any chance to change it's datatype to tinytext without making an entirely new database and inserting data from the old one to it? Sure, just use ALTER TABLE as described in the manual. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,025,822,488 queries (391/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL question -- can this be done?
I have a table with 3 fields: initDate datetime not null id int unsigned not null ipAddress int unsigned not null I'm trying to find the number of distinct ipAddresses associated with a particular id over a specified time frame -- for simplicity, let's say the time frame is the last 60 minutes. So, I use the following query: SELECT DISTINCT ipAddress FROM table WHERE initDate = DATE_ADD(now(), INTERVAL -60 MINUTE) AND id = [whatever id I'm looking for...]; This works and returns a result set with one row per distinct ipAddress. In my program, I can count the number of rows in the result set to get my answer. My question is this: is there any way to modify this query so it returns a *count* of the number of distinct ipAddresses, rather than having a row for each distinct ipAddress in the result set? Can I use some sort of aggregate function like COUNT() when also specifying DISTINCT? I've tried a few different things, but haven't been able to get it to work. Does anyone know if this can or can't be done? Thanks, --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL question -- can this be done?
I asked almost the exact same question just a few days ago. As of MySQL 3.23.2 you can use COUNT and DISTINCT together: SELECT COUNT(DISTINCT ipAddress) ... On 9/3/02 at 1:16 pm, Jeff Kilbride [EMAIL PROTECTED] wrote: I have a table with 3 fields: initDate datetime not null id int unsigned not null ipAddress int unsigned not null I'm trying to find the number of distinct ipAddresses associated with a particular id over a specified time frame -- for simplicity, let's say the time frame is the last 60 minutes. So, I use the following query: SELECT DISTINCT ipAddress FROM table WHERE initDate = DATE_ADD(now(), INTERVAL -60 MINUTE) AND id = [whatever id I'm looking for...]; This works and returns a result set with one row per distinct ipAddress. In my program, I can count the number of rows in the result set to get my answer. My question is this: is there any way to modify this query so it returns a *count* of the number of distinct ipAddresses, rather than having a row for each distinct ipAddress in the result set? Can I use some sort of aggregate function like COUNT() when also specifying DISTINCT? I've tried a few different things, but haven't been able to get it to work. Does anyone know if this can or can't be done? Thanks, --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL question -- can this be done? FOUND IT!
Aha! Figured it out... SELECT COUNT(DISTINCT ipAddress) FROM table WHERE initDate = DATE_ADD(now(), INTERVAL -60 MINUTE) AND id = [whatever id I'm looking for...]; Works semantically like it sounds. Probably the only variation I didn't try before posting! (always works that way...) Thanks, --jeff - Original Message - From: Jeff Kilbride [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 1:16 PM Subject: SQL question -- can this be done? I have a table with 3 fields: initDate datetime not null id int unsigned not null ipAddress int unsigned not null I'm trying to find the number of distinct ipAddresses associated with a particular id over a specified time frame -- for simplicity, let's say the time frame is the last 60 minutes. So, I use the following query: SELECT DISTINCT ipAddress FROM table WHERE initDate = DATE_ADD(now(), INTERVAL -60 MINUTE) AND id = [whatever id I'm looking for...]; This works and returns a result set with one row per distinct ipAddress. In my program, I can count the number of rows in the result set to get my answer. My question is this: is there any way to modify this query so it returns a *count* of the number of distinct ipAddresses, rather than having a row for each distinct ipAddress in the result set? Can I use some sort of aggregate function like COUNT() when also specifying DISTINCT? I've tried a few different things, but haven't been able to get it to work. Does anyone know if this can or can't be done? Thanks, --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL question -- can this be done?
Thanks, Rob. Yeah, I just figured it out myself. I think I convinced myself that it couldn't be that easy! --jeff - Original Message - From: Rob [EMAIL PROTECTED] To: Jeff Kilbride [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 1:26 PM Subject: Re: SQL question -- can this be done? I asked almost the exact same question just a few days ago. As of MySQL 3.23.2 you can use COUNT and DISTINCT together: SELECT COUNT(DISTINCT ipAddress) ... On 9/3/02 at 1:16 pm, Jeff Kilbride [EMAIL PROTECTED] wrote: I have a table with 3 fields: initDate datetime not null id int unsigned not null ipAddress int unsigned not null I'm trying to find the number of distinct ipAddresses associated with a particular id over a specified time frame -- for simplicity, let's say the time frame is the last 60 minutes. So, I use the following query: SELECT DISTINCT ipAddress FROM table WHERE initDate = DATE_ADD(now(), INTERVAL -60 MINUTE) AND id = [whatever id I'm looking for...]; This works and returns a result set with one row per distinct ipAddress. In my program, I can count the number of rows in the result set to get my answer. My question is this: is there any way to modify this query so it returns a *count* of the number of distinct ipAddresses, rather than having a row for each distinct ipAddress in the result set? Can I use some sort of aggregate function like COUNT() when also specifying DISTINCT? I've tried a few different things, but haven't been able to get it to work. Does anyone know if this can or can't be done? Thanks, --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
binaries not stripped Subject: synopsis of the problem (one line) mysqlshow doesnt work properly
Description: 2 problems with MySQL-3.23.49a-1 (linux x86 rpm) 1) binaries not stripped (= 40MB !!!) 2) mysqlshow doesnt work properly How-To-Repeat: from /etc/my.cnf: [client] socket = /tmp/.mysql.sock (work)~$ mysqlshow mysqlshow: Can't connect to local MySQL server through socket '' (111) (work)~$ mysqlshow mysql mysqlshow: Can't connect to local MySQL server through socket '/tm)' (2) Fix: (work)~$ mysqlshow -S /tmp/.mysql.sock Submitter-Id: submitter ID Originator:root Organization: MySQL support: none Synopsis: binaries not stripped mysqlshow doesnt work properly Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49a (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49a-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/.mysql.sock Uptime: 1 min 24 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.048 Environment: System: Linux wotrok.doma.cz 2.4.16-udf #3 Wed Dec 12 22:47:18 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 led 11 18:04 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285480 záø 9 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27487418 záø 9 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 záø 9 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
databases under users dir
Hi Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. Mark -- Obantec Support www.obantec.net WebHosting and Domains Nominet UK Tag Holder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: databases under users dir
Hi, Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. You can put them under each users homedir and symlink to them. I've used that method a couple of times where I had some pretty large tables taking up too much space on a particular partition. Remember to shut down mysql before moving the databases and remember to preserve ownership and rights to the files. :wq //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: databases under users dir
I am glad you asked that. I think for my application, I am going to set up a blank set of tables in the database, and as a new user subscribes, simply move the blank database into their personal directory, that way I can keep all of their data segregated from other users. It may take addition physical disk space, but it would simplify my management dramatically. Thank you for that question. Mark - Original Message - From: Andreas Frøsting [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 5:07 PM Subject: RE: databases under users dir Hi, Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. You can put them under each users homedir and symlink to them. I've used that method a couple of times where I had some pretty large tables taking up too much space on a particular partition. Remember to shut down mysql before moving the databases and remember to preserve ownership and rights to the files. :wq file://andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql from windows to linux
Hi all, I developp a site with some mysql table which are files myd myi n frm under windows x86 arch. I copy my table into a liinux box x86 arch too. Bu when trying to modidy tables I get an Error: 1036 - Table country is read only I manage the rigth of new created tables. I get things like that that I report to my read only tables : 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD 4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm 0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD 4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI I make a chown -R mysql.mysql * n chmod 660 * Nothing change. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from windows to linux
Stange I make a ps : mysql 6337 0.0 5.4 27588 15608 ? S23:22 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/ www. sassandra-conseil.com.pid --skip-locking mysql server is reunnig with mysql user. I make a su mysql : this works mysql update TableName set FieldName =1; Query OK, 1 row affected (0.00 sec) Rows matched: 2 Changed: 1 Warnings: 0 with new created table but with other nothings 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD 4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm 0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD 4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: databases under users dir
Hi Thanks for the tip! it works fine. Now all i need to do is modify my create database code to use $HOME/mysql and make symbolic link Mark -- Obantec Support www.obantec.net WebHosting and Domains Nominet UK Tag Holder - Original Message - From: Andreas Frøsting [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 10:07 PM Subject: RE: databases under users dir Hi, Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. You can put them under each users homedir and symlink to them. I've used that method a couple of times where I had some pretty large tables taking up too much space on a particular partition. Remember to shut down mysql before moving the databases and remember to preserve ownership and rights to the files. :wq //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL deamon won't start...
Dear All, Since I did some online updating from the SuSE website, only ssh and mod_php stuff, I'm unable to start the MySQL deamon. The error log says: 020310 00:08:00 mysqld started /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 212 error messages, but it should have at least 218 error messages. Check that the above file is the right version for this program! 020310 00:08:00 mysqld ended 020310 00:08:29 mysqld started /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 212 error messages, but it should have at least 218 error messages. Check that the above file is the right version for this program! 020310 00:08:29 mysqld ended 020310 00:12:52 mysqld started /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 212 error messages, but it should have at least 218 error messages. Check that the above file is the right version for this program! 020310 00:12:52 mysqld ended I'm using SuSE 7.3 Pro which has the 3.23.44 version of MySQL... according to their website. Anyone an idea how to solve this problem..!?? Thanks... Jurren -- Jurren Bouman email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BUGs in mysqldumpslow + fixes
(BTW, mysqldumpslow does not seem to be in the RPMs for v4.) mysqldumpslow (perl itself, I guess) dumps core and acts incorrectly when dealing with simplifying strings. Fix: Change: s/'([^\\\']|\\.|\'\')+'/'S'/g; s/([^\\\]|\\.|\\)+/S/g; To: s/''/'S'/g; s//S/g; s/(\\')//g; s/(\\)//g; s/'[^']+'/'S'/g; s/[^]+/S/g; I'm not a perl wizzard, so there is likely a better way. But this actually works. :) Also, there is a bug with getting the query and lock times. Change: s/^# Time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//; To: s/^# Query_time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//; Sincerely, Steven Roussey http://Network54.com/?pp=e sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
XML not so well-formed ?
I've tried to export some data from my MySQL database (3.23.49) using mysqldump -X to a XML file. And I've got something like that: ?xml version=1.0? tKsidata KSI1572160047KSI TYTULAmerican Gothic CookbookTYTUL WYDppressWYD ROK0/ROK NRW0/NRW STRON0/STRON ISBN1-57216-004-7ISBN D_POCZ1999-10-21D_POCZ Why some of the elements have a valid ending tag and some not? Regards, -- ./ premax ./ [EMAIL PROTECTED] P.S. C:\mysql3\binmysqldump -V C:\MYSQL3\BIN\MYSQLD~5.EXE Ver 8.21 Distrib 3.23.49, for Win95/Win98 (i32) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VC++ and mysqlclient
I wrote a MySQL client program using GCC in Linux. It works beautifully. However, I need to integrate it with a Windows-only Bluetooth stack, which means that I need to port my code to Windows. I am not happy about this situation, but I find myself in it nonetheless. I use standard C++ (with some STL in there) and calls to mysql_real_connect, mysql_query, etc. However, when I tried to import my code into a Microsoft Visual C++ project (copy files in, add a '/Ic:\path\to\header\files\from\http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win.zip;' entry to the C/C++ options, add the libmysql.lib to the Linker options, and compile), I got all kinds of errors. I searched a little more, and found such things as macro definitions in the .h files for MySQL conflicting with macro definitions in Windows header files. It was an irreconciliable nightmare. I tried to find documentation on how to build a Windows MySQL client in MS Visual C++, and I found *very* little on the web site (maybe one paragraph in section 2.6.2.6 that only says, Be sure to tell the compiler where the header files are and the linker where the library libmysql.lib is. Oh, and compile your code to be multi-threaded too.) Now that I've talked your ear off, here's what I'd really like to know: - Exactly what do I need to download and install to build a MySQL client in MS VC++? Where can I find these files? Are the headers and libaries in http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win.zip enough? - Exactly what specific parameters do I need to set in MS VC++ to get it to work, and where can I find these parameters? - Does anyone have a .tar file of a SIMPLE working MS VC++ project, with source and headers included, that performs a connect to a MySQL database, does a query, and exits? Thanks in advance for any direction you can give me. If I don't find a solution in the next week, I'm just going to have to drop MySQL and use something else. Mike -- | Michael Halcrow| [EMAIL PROTECTED] Research Assistant, Network Security Lab | Dept. of Comp. Science | Brigham Young University Give a man a fire, he will be warm for the | evening. Set a man on fire, he will be warm| for the rest of his life. | -- | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql from windows to linux
You should use mysqldump[.exe] to export/import, on the respective systems: 4.8.5 mysqldump, Dumping Table Structure and Data http://www.mysql.com/doc/m/y/mysqldump.html C:1 -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 09, 2002 2:22 PM To: [EMAIL PROTECTED] Subject: mysql from windows to linux Hi all, I developp a site with some mysql table which are files myd myi n frm under windows x86 arch. I copy my table into a liinux box x86 arch too. Bu when trying to modidy tables I get an Error: 1036 - Table country is read only I manage the rigth of new created tables. I get things like that that I report to my read only tables : 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD 4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm 0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD 4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI I make a chown -R mysql.mysql * n chmod 660 * Nothing change. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Lou Picciano / Essex SystemsTo: MySQL List [EMAIL PROTECTED], [EMAIL PROTECTED] Omnis@comcast cc: .netSubject: Re: Some PHP - mySQL help please ... new to both 03/08/2002 07:14 PM Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About to pull my hair out :o) setting up Connection to MySQL
Hi, If your hosting compamy provide PHP support then make a php page, ?php phpinfo(); ? --- view this page in browser and you will see lot of information including the HOSTNAME variable. Then use that host name in your connection string. Other wise it is always better to try first with localhost. Regards Praful - Original Message - From: Theresa Messenger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 02:10 Subject: About to pull my hair out :o) setting up Connection to MySQL OK..here is my intention and my dilemma. I work with a new not-for-profit organization and I am creating a database for contact information. I would like this to be a dynamic DB in that it is available to the rest of the board members so they may search and view info on various types of contacts. Right now it will only be for lookup as I am keeping the master data elsewhere and just loading updates. However, I will eventually open it up so that data may be added/edited by the other board members. My hosting company supports MySQL and both Chilisoft ASP and PHP. They have phpMyAdmin installed as a management system (to create tables, load data, etc.) However, I need to set up pages in which users can look up and add/delete data. My problem is that I cannot connect to the DB other than through the phpMyAdmin interface they have set up. I have asked the provider to give me the connection information (I obviously have the login and password but need the host), but they sent me a link to http://list.cobalt.com/mailman/listinfo/cobalt-users (wtf...???) Either my provider does not know what to give me for the connection strings or I did not state my intentions clearly enough. Considering they host the site for free, I cannot complain too much :o) Thanks in advance for any advice anyone can provide. Theresa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: databases under users dir
sorry to cross post. Actually I also want to achive the same thing for virtual hosting. Would you tell me how you will create a database in $home/mysql ? What I know is when you say create database , it creates under $mysqlhome/var/ Please calrify the doubts. Praful - Original Message - From: Support [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 04:40 Subject: Re: databases under users dir Hi Thanks for the tip! it works fine. Now all i need to do is modify my create database code to use $HOME/mysql and make symbolic link Mark -- Obantec Support www.obantec.net WebHosting and Domains Nominet UK Tag Holder - Original Message - From: Andreas Frøsting [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 10:07 PM Subject: RE: databases under users dir Hi, Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. You can put them under each users homedir and symlink to them. I've used that method a couple of times where I had some pretty large tables taking up too much space on a particular partition. Remember to shut down mysql before moving the databases and remember to preserve ownership and rights to the files. :wq //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bad table in fields list; mysql fails to update
Description: When selecting from multiple recently added tables, mysql returned a table does not exist error. table blatantly exists, i recently added it. nb: output from mysql (and mysqlbug) sanitized to protect IP. How-To-Repeat: mysql show tables; +---+ | Tables_in_dba | +---+ | co_info | | doc_user_info | +---+ 15 rows in set (0.00 sec) mysql select doc_user_info.id as did, co_info.id as cid, co_info.name as cname, doc_user_info.username from doc_user_info du,co_info co where co.id=du.id and du.id 150 and du.id 200 order by du.id; ERROR 1109: Unknown table 'doc_user_info' in field list mysql Fix: no idea. Submitter-Id: submitter ID Originator:root Organization: Wherewithal inc MySQL support: none - yet Synopsis: mysql fails to recognise tables Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL binary) Environment: System: Linux host sanitized 2.4.8-26mdkenterprise #1 SMP Sun Sep 23 16:36:00 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs gcc version 2.96 2731 (Mandrake Linux 8.1 2.96-0.62mdk) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Feb 21 20:07 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285480 Sep 9 19:57 /lib/libc-2.2.4.so -rw-r--r--1 root root 27487418 Sep 9 19:30 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 19:30 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: bad table in fields list; mysql fails to update
ok, disregard this, i worked out what i did wrongly. -Original Message- From: Sent: Sunday, March 10, 2002 2:38 AM To: [EMAIL PROTECTED] Subject: bad table in fields list; mysql fails to update Description: When selecting from multiple recently added tables, mysql returned a table does not exist error. table blatantly exists, i recently added it. nb: output from mysql (and mysqlbug) sanitized to protect IP. How-To-Repeat: mysql show tables; +---+ | Tables_in_dba | +---+ | co_info | | doc_user_info | +---+ 15 rows in set (0.00 sec) mysql select doc_user_info.id as did, co_info.id as cid, co_info.name as cname, doc_user_info.username from doc_user_info du,co_info co where co.id=du.id and du.id 150 and du.id 200 order by du.id; ERROR 1109: Unknown table 'doc_user_info' in field list mysql Fix: no idea. Submitter-Id: submitter ID Originator:root Organization: Wherewithal inc MySQL support: none - yet Synopsis: mysql fails to recognise tables Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL binary) Environment: System: Linux host sanitized 2.4.8-26mdkenterprise #1 SMP Sun Sep 23 16:36:00 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs gcc version 2.96 2731 (Mandrake Linux 8.1 2.96-0.62mdk) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Feb 21 20:07 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285480 Sep 9 19:57 /lib/libc-2.2.4.so -rw-r--r--1 root root 27487418 Sep 9 19:30 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 19:30 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VC++ and mysqlclient
At 18:29 09/03/2002 -0700, Michael Halcrow wrote: Hi! I use standard C++ (with some STL in there) and calls to mysql_real_connect, mysql_query, etc. However, when I tried to import my code into a Microsoft Visual C++ project (copy files in, add a '/Ic:\path\to\header\files\from\http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win.zip;' Why you don't try the source distribution: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win-src.zip Unzipped this file on any working directory. Besides the VC++ 6.0, you should need to install the Preprocessor package for to install the ml.exe assembler compiler, required for to compile the string stuff. This package you can get at Microsoft. Open the mysql.dsw workspace and add a new project for your client. Your client should be linked against the mysqlclient.lib and take a look in the settings of the mysql.dsp for to have some idea how you should set your code. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
A quick diagnostic? Try the page phpinfo.php in the phpMyAdmin directory - this will give you the 'whole picture' in terms of your php installation... Even easier? Any php page which contains the code: ? phpinfo(); Will give you this full info report. Very useful! Lou Picciano Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trouble with the Listings (C'n Double)
Is this me or the mysql lists, I am getting a lot of double messages, are people sending double, or is it me and my outlook.. Just checking it's kind of annoying. Later Kacey A. Murphy netBuilder's, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New 4.0.x Replication Core Dump...
On Saturday 09 March 2002 10:38 am, Jeremy Zawodny wrote: Sasha, Running the latest binary I just built, I had a single core dump and auto-restart early this morning. Jeremy: I've made a few more updates to the source and pushed it to the public repository. The most important one is that now you can do SLAVE START SQL_THREAD and SLAVE_START IO_THREAD, same with SLAVE STOP. I realized ( while testing at another user's site) that in some situations you may want only one or the other running. For example, if the slave is far behind, because I/O thread is so fast, you could have I/O thread racing against SQL thread to fill up the disk with relay logs. After you have gathered a lot of relay log data, it would be nice to just bring the I/O thread down and have the SQL thread catch up cleaning the disk in the meantime. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Trouble with the Listings (C'n Double)
At 00:02 2002-03-10, you wrote: Is this me or the mysql lists, I am getting a lot of double messages, are people sending double, or is it me and my outlook.. Just checking it's kind of annoying. Later Kacey A. Murphy netBuilder's, Inc. Methinks it's You, or the beer... ;) -- sql, query Tomasz Korycki [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL GUI
Hello all, After install XDarwin in Mac OSX and experimenting installing the GIMP and some other xapps I have tried to compile MySQL GUI unsuccesfully. Would somebody show me a link with some advice? TIA, Luque - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help, any convert(legacy) function? in mysql?
sql query Hello Folks, Hello, I am trying to convert this weird cobol style number into a regular integer. I got it from a fixed length text file. From the description file: Amount Columns 131-137 Numeric In the fixed width text file, the amounts are in COBOL format. If the value is negative, the right most column will contain a special character: ] = -0, j = -1, k = -2, l = -3, m = -4, n = -5, o = -6, p = -7, q = -8, and r = -9. example numbers: I have 1500 numbers that look like this! the rest are normal integers. Any help would /really/ be appreciated. TIA. 000125] 20] 25] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Super-smack install problem
Warning Unable to process data: multipart/mixed; boundary=--==_846811060==_
Re[2]: How to load binary data with Perl DBI?
Hello Paul, Thank you for a quick reply. It doesn't look same way :(. Normally I've read data from a file on a client's machine using Perl's read function like this while(read($file, $data, 1024)) { print TO $data; } to write it from $file on client's computer to a file associated with file handle TO. Now I obviously need to store the data in a variable. Just pushing $data strings into array and then joining (join('',@array) doesn't work, because it's not ASCII (file gets corrupted). So, what I do not understand, is how to open a filehandle to a database field and then print to it? :). Regards, Tom Saturday, March 09, 2002, 9:00:08 PM, you wrote: PD At 16:39 +0200 3/9/02, [EMAIL PROTECTED] wrote: Hello. How to load binary data into a table using Perl DBI module (the data is uploaded from a HTML form)? PD Same way you load any other kind of data. Use placeholders or the quote() PD function. I failed to find any information on MySQL site. Thanks in advance. PD - PD Before posting, please check: PDhttp://www.mysql.com/manual.php (the manual) PDhttp://lists.mysql.com/ (the list archive) PD To request this thread, e-mail [EMAIL PROTECTED] PD To unsubscribe, e-mail [EMAIL PROTECTED] PD Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Toomasmailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php