Search results for query: *

hi, my question is... How to stop a perl script (a.pl) from running if the a.pl is currently in running state Those reload, or human error is un-avoidable, so i hope script can stop themselve when they saw a "twin" there. thanks

Thanks everyone... Ya.. I am worrying about down time. Every second or every minute will have traffic come in. I am sure that I can't turn off the Mysql for the back up process. My database has innodb tables... that's why I think mysqlhotcopy can't use for the back up. So, does mysqldump with...

I have a database which is around 6gb. May I know which is the better way to backup my database? 1. Copy the MySQL data directory to create a backup or 2. mysqldump? I'm just worried that zipping up the data directory will make the MySQL hang as I'm goin to zip a big directory. But using...

I'm doing a PHP + mysql application which will verify zip code on member form. I hope to do the verification on client side script, javascript. Zip Code: <input text> City: <input text> State: <selection box> or <input text> After user enter 5 digits zip code, javascript function is called and...

So anything wrong with this figure? core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m)...

I found there's a process keep on running in my server, here's the process name I saw from WHM: Pid Command 28193 /usr/local/apache/bin/httpd -DSSL from SSH: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 28193 root 25 0 10864 5208 3140 R 1.0 0.3 34:20.64...

I'm using perl script to generate a csv file. When I opened the csv file with Microsoft Excel, right click on any column, click on Format Cells, on Number tab, the Category has 'General' selected. I wonder if there's any way to format all cells in 'Text' format when I generate this csv from my...

Oh, i m using mysql, will it be possible?

hi, i come into a situation like this. My table is something similiar to below table id Name Status Datetime 1 Jack success 2006-06-06 2 Jack fail 2006-06-06 3 Jack success 2006-06-06 4 Jack success 2006-06-06 5 Mal fail 2006-06-06 6 Mal fail...

Thanks swampBoogie! It's work!

Thanks for your reply, swampBoogie. But I'm sad that my Mysql version do not support subquery. Any other way to write this query? Thanks...

I had 2 tables here, tbl1 and tbl2. Now we got 6 items in tbl1, and tbl2 store the color for each item (maximum 3 colors for each item). tbl1 ---- id(PK) name 1 Jack 2 Amy 3 Bill 4 Ken 5 Rye 6 Icy tbl2 ----- id(PK) t1_id(FK) color 1 1...

Thanks very much!

First of all, Thanks for reply my post. But is important for me to get the final landing page's url, which is url of Pg_D. But in real life, i don't have control for page other then pg_A, which is reside in my domain. All other page is reside in client's domain and not mine. So, would it be...

hi, i had a situation here. Is it possible for me to get a return of url by a perl command? E.g. Pg A(currently)->Pg B->Pg C->....->Pg D '->' means 'redirect' Is there a perl function can retrieve the URL of Pg D from Pg A? Like i m currently in Pg A, then inside the a.pl, i write Code ...

hai everybody, i faced a problem here to let the script perform some action here... script index.html : <img src="http://example.com/pix.pl" width=1 height=1> i using this script to perform some background process while the script is loading. then at the pix.pl is a script from another...

Thanks TonyGroves, by using this query to count table rows, i able to get the same row number finally! but, may i know why the total rows shown is different everytime i browse through this table? And, what is meant by this sentence -> InnoDB free: 46080 kB ? thanks...

from phpmyadmin, juz by looking at the total rows for this table.

i'm trying to convert a big table (approx 200,000 rows) from type MYISAM to INNODB but i found problem after converting the table type. I tried 2 ways to convert it, TblA - myISAM (original table with 200,420 rows) TblB - (to be INNODB table) 1. Copy structure of TblA to TblB, alter TblB to...

Hi, I really hope to get some help for this. How do I setup the proxy server to filter form input ? For example: The user enter "abc" in google.com search box and press submit. But the proxy server will transform "abc" to "xyz" and submit to google.com. Any proxy server will do. Any ideas of...