Re: give me a sample to print out to printer
Maybe you can try find the application at hotscripts.com. regards, Teddy -- experience the online learning commmunity at http://www.mycyberclassroom.com At 08:32 AM 2/7/2002 +0700, Franky Aniversarius wrote: when i click the icon client1(in end client, it's show up from php application) that the icon has link to mysql and the result directly print the out put to printer (share or local printer) by coulomb. there's anyone knows about this, please help me. Rgds, Franky Aniversarius - 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
Re: select stmt problem
I did the grouping too... ...group by hpnumber so what could be wrong? regards, Teddy At 02:13 AM 10/24/2001 -0400, Kodrik wrote: for one, counts is not a colums, it aggreate values. In your case, since you didn't group, all record retrieved will have the same value for count(*), the number of record. So of course you can't order by counts, it's a single value. On Wednesday 24 October 2001 02:43 am, Carl Troein wrote: Teddy A Jasin writes: Hi, I have this mysql statement: select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs where counts 10 and datesent between '2001-09-24' and '2001-10-24' and (returncode 0 and returncode 10) group by hpnumber order by counts DESC - 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 Teddy A Jasin Systems Analyst / Administrator 45B, Circular Road Singapore 049400 Tel: 438 2418 DID: 4386924 Fax: 438 4803 email: [EMAIL PROTECTED] w w w . e f u s i o n . c o m . s g - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select stmt problem
Hi, I have this mysql statement: select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs where counts 10 and datesent between '2001-09-24' and '2001-10-24' and (returncode 0 and returncode 10) group by hpnumber order by counts DESC and i Get this following error: Unknown column 'counts' in 'where clause' why is that so??? it works before and now give me this problem. any idea? regards. Teddy - 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: lost connection to mysql!
I faced this problem before i used script_timeout function to fix. maybe you can try the same. regards, Teddy At 01:26 AM 10/18/2001 -0400, Sebastien Grenier wrote: Hi, I'm running 2 websites in PHP 4.0.6 with Mysql 3.23.42 on OpenBSD 2.7. If the client machine browse the 2 websites at the same time in get the following error: Warning: Lost connection to MySQL server during query in /usr/local/apache/vhdocs/tech/includes/database.inc on line 4 Lost connection to MySQL server during query The only way I can get things backup to browse is by restarting MySQL. Can someone help me on this? or how do I debug this? Thank you. Sebas - 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 Teddy A Jasin Systems Analyst / Administrator 45B, Circular Road Singapore 049400 Tel: 438 2418 DID: 4386924 Fax: 438 4803 email: [EMAIL PROTECTED] w w w . e f u s i o n . c o m . s g - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql is really a slow rdbms
Just simple question.. why u designed it such a way that differentiate the 'thn','bln' and 'hari' field when you can do it just using one field and using DATE type field instead of integer. and when you query u can use your SQL sorting to speed up searching. Regards Teddy - Original Message - From: "Muhammad Ilhami" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 26, 2001 12:41 PM Subject: mysql is really a slow rdbms This table contains more than 2.5 million records. I created index on column hari. It needs more than 3797 secs, and have not finished yet. Anybody has advice? mysql describe tb_trafik_bulanan; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | thn | smallint(5) unsigned | YES | | NULL | | | bln | tinyint(3) unsigned | YES | | NULL | | | hari | tinyint(3) unsigned | YES | | NULL | | | id_hari | int(10) unsigned | YES | | NULL | | | kd_link | char(4) | YES | | NULL | | | ip_asal | int(10) unsigned | YES | MUL | NULL | | | sip_asal | char(19) | YES | | NULL | | | port_asal | smallint(5) unsigned | YES | MUL | NULL | | | ip_tujuan | int(10) unsigned | YES | MUL | NULL | | | sip_tujuan | char(19) | YES | | NULL | | | port_tujuan | smallint(5) unsigned | YES | MUL | NULL | | | jml_byte | int(10) unsigned | YES | | NULL | | | jml_flow | smallint(5) unsigned | YES | | NULL | | | jml_packet | int(10) unsigned | YES | | NULL | | | kd_neg | char(2) | YES | MUL | NULL | | | id_pelanggan | char(8) | YES | MUL | NULL | | | kd_jasa | char(2) | YES | MUL | NULL | | | arah_dan_tipe | tinyint(3) unsigned | YES | MUL | NULL | | | kd_server | char(2) | YES | MUL | NULL | | | kd_non_server | char(2) | YES | MUL | NULL | | +---+--+--+-+-+---+ mysql show processlist; +++---+--+-+--+- -+---+ | Id | User | Host | db | Command | Time | State| Info | +++---+--+-+--+- -+---+ | 31 | netmon | localhost | tracemon | Query | 3797 | Repair with keycache | create index hari on tb_trafik_bulanan (hari) | | 40 | netmon | localhost | tracemon | Query | 0 | NULL | show processlist | +++---+--+-+--+- -+---+ 2 rows in set (0.00 sec) regards -ilham- __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.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: cannot connect to database
just do it using grant statement so that you can connect from another host. use grant to username@'%' instead of localhost - Original Message - From: "Emre Yildirim" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 18, 2001 12:40 AM Subject: cannot connect to database -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Hello folks, This is probably some very stupid mistake, but I don't know what else to do. I just installed the latest mysql source. Everything compiled nice and without errors and installed correctly. My problem is, I can't connect to the database. Here is the error message: Warning: Access denied for user: 'root@localhost' (Using password: YES) The password is set, but I still get this. Also, is there a way to let other hosts, other than localhost connect to the db? Thanks for any help. Please e-mail any answers to me directly, as I am not on this list. Cheers... -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.4 (OSF1) Comment: http://1086362465/emre-dsa.asc iD8DBQE6jql6UGchLJL+QvQRA6oPAJ9gqNQje7Hf2eKF6K4TU2Tv1rOzDACgqD7t rKSrX4uvKH+tB+4mkDZnKt8= =Kit1 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 extremely slow
Hi All, Below is the status that I got from my server's mysql server, can anyone explain to me more on this?? and as u see here... currently mysql server is running extremely slow: mysqlshow variables; ++--+ | Variable_name | Value| ++--+ | back_log | 5|| | datadir| .| | join_buffer| 131072 | | key_buffer | 1048568 | | max_allowed_packet | 65536| | max_connections| 90 | | max_join_size | 4294967295 | | max_sort_length| 1024 | | net_buffer_length | 8192 | | port | 3380 | | record_buffer | 131072 | | skip_locking | 0| | sort_buffer| 2097144 | | table_cache| 64 | | thread_stack | 65536| | tmp_table_size | 1048576 | ++--+ 19 rows in set (4 min 8.20 sec) mysql show status; ++-+---+---+-+-+ | Uptime | Running_threads | Questions | Opened_tables | Reloads | Open_tables | ++-+---+---+-+-+ | 108855 | 20 |344541 | 838 | 1 | 63 | ++-+---+---+-+-+ 1 row in set (55.35 sec) so, can anyone tell me on how to improve my mysql server so that it can run very fast thanks Teddy
Re: mysql extremely slow
Hi, The problem is when I execute show processlist; the mysql replied syntax error. So i cant use the processlist. here's wat the mysql respond: SHOW PROCESSLIST;parse error near 'PROCESSLIST' at line 1 thanks teddy- Original Message - From: "Fred van Engen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 18, 2001 2:09 AM Subject: Re: mysql extremely slow On Sun, Feb 18, 2001 at 01:18:04AM +0800, Teddy A Jasin wrote: Hi All, Below is the status that I got from my server's mysql server, can anyone explain to me more on this?? and as u see here... currently mysql server is running extremely slow: Try posting a 'show processlist' so you can figure out what query it is working on. Maybe you have some long running query that blocks everything else? show variables and show status alone don't tell much. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
returning PID
Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy
mysql takes so much resources
Hi there, I have 2 different websites using a single mysql server. Today the websites respons very slow and when I check the mysql proces i got the following info: PID %CPU %MEMVSZ RSS TT STAT STARTED TIME COMMAND 24339 51.6 0.7 6876 3704 p2- R10:56AM2:00.79 mysqld So I suspect that my websites is slow because of the mysql server takes so much of the CPU resources (51.6%). So how to solve this problem? I tried restarting mysql then it again reach up until 50-60% of CPU. Thanks Teddy
MySQL set up plan
Hi All, Currently I have four websites using one MySQL server. The MySQL and the four websites each is placed on different server. However this MySQL server, I dont know why after running for a few days can stop responding that I have to restart the MySQL server. This caused my four websites also down. Now, how do I create the MySQL server such that I have 2 MySQL server running on the same server that if the main MySQL server is down, the other will be up and running. Of course that the other server must have the same databases. For your info, currently we have over 100MB of databases on the server running on Linux Redhat 6.2. A typical visit at one time on the website will be 2000 over (one hour). Thanks Teddy
Re: MySQL GUI for Windows
Use PhpMyadmin - Original Message - From: "indrek siitan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 11:00 PM Subject: MySQL GUI for Windows Hi, can anyone suggest a good GUI client to suggest to MySQL hosting customers? it should: * be able to display table structures, add and alter tables (field, indexes) * show and edit table data * be freeware (or it can be half-commercial, as long as the above functionality is available without paying) * ask for database name in the connection parameters or only display the list of databases user has access to Rgds, Indrek -- - Indrek Siitan, CEO eMotion Ltd. [http://www.eMotion.ee] e-mail: [EMAIL PROTECTED] Narva mnt 31, 10120 Tallinn Estonia GSM: +372 50 17621+372 6605 890 - 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: external access to mysql
Hi, again phpmyadmin can do this :) Teddy - Original Message - From: "Mike Yuen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 1:45 PM Subject: external access to mysql I and 2 others are working on a web site an occasionally. Each of us are in different locations and exchange info email. Some of them need to query the database to compare results with what is on the site with the MySQL database. My question is, is there a way to allow access to my database by creating an account for each user and allowing them to connect to the database externally? Thanks, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
ISAM and MYISAM
Hi, I've read some people talking about ISAM and MYISAM table. I dont understand what are those tables and can anyone explain to me and the difference of each table. and also which one has better performance? thanks Teddy - 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 BENCHMARKING PROBLEMS
Hi, My website is running on MySql 3.21 and it has so much records that it sometimes stopped running and I had to restart the mysqld. My question is how do I go about benchmarking my site and the mysql server? TIA Teddy
Re: binary data
Hi okie heres a snippet of my php code: the code below takes a file uploaded from the web with $file as declared filename on the form. if ($file_size0) { //check whether the file is not empty $data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the file and add neccessary quotes $SQL="Insert into Files (Filename,Filetype,Filesize,data) values ('$file_name','$file_type','$file_size','$data')"; //SQL commands to insert into table named 'FILES' $result = mysql_query ($SQL) or die ("ERROR Uploading File:".mysql_errno().": ".mysql_error()."BR$SQL"); } okie hope that helps! Teddy "Robert C. Paulsen Jr." wrote: On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote: I have the scripts in php to do this if u want. Yes, that would help! thanks. "Robert C. Paulsen Jr." wrote: How can I put binary data into a MySQL database? I assume the data type is blob, but I don't see how I can use SQL syntax to insert anything but text data. I would like to include various binary files (tar files, zip files, image files, etc.). -- Robert Paulsen [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 - 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