Re: [PHP-DB] RE: [PHP-WIN] Re: Need Help in setting up a server
u can do one more thing, u need to get a public ip or a static ip from ur ISP, this will make sure that u have a constant ip on ur machine so that it can be accessed from anywhere.. Chaitanya On Wed, Jun 30, 2010 at 2:10 AM, Warren Vail war...@vailtech.net wrote: The IP you cited Is the IP provided by your router or modem, and not one others from out side can use to access your server. Now on the other side of that, if you go to the machine that has the WAMP installed and open a browser and point it to http://what.is.my.ip.com; you may see the public IP for that machine, which can be used for linking to your server, but is not guaranteed to stay with that machine depending on powering up and down of your systems, and your ISP's procedures for assigning IP's. Hope this helps, Warren Vail Vail Systems Technology -Original Message- From: nagendra prasad [mailto:nagendra802...@gmail.com] Sent: Tuesday, June 29, 2010 1:12 PM To: phpexpe...@yahoogroups.com; PHP DB; php mysql; php-wind...@lists.php.net Subject: [PHP-WIN] Re: Need Help in setting up a server Hi all, Thanks everyone. I just tried all of your suggestions and found that WAMP server is working by using the running WAMP server's system IP. I just typed 192.168.1.4 in the address bar and its working now. So, I came to a conclusion that if I have a static IP then I can access it from out side as well right. Correct me if I am wrong ?? So, if I am right is it possible to run a server from home ?? Best, Guru. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] RE: [PHP-WIN] Re: Need Help in setting up a server
Well, there are two more things to do. 1. If you have a router you will have to forward the ports for the webserver (80, etc) to the correct internal ip. - depending on your security needs consider putting your webserver into the fm 2. There are multiple services out there that offer dynamic dns (dyndns.com , etc) these might even be an option from within your router and would allow you to get a public domain name even if you don't have a static ip. Let me know if you need more info. Regards, eli aschkenasy On Jun 30, 2010, at 6:55 AM, Chaitanya Yanamadala dr.virus.in...@gmail.com wrote: u can do one more thing, u need to get a public ip or a static ip from ur ISP, this will make sure that u have a constant ip on ur machine so that it can be accessed from anywhere.. Chaitanya On Wed, Jun 30, 2010 at 2:10 AM, Warren Vail war...@vailtech.net wrote: The IP you cited Is the IP provided by your router or modem, and not one others from out side can use to access your server. Now on the other side of that, if you go to the machine that has the WAMP installed and open a browser and point it to http://what.is.my.ip.com; you may see the public IP for that machine, which can be used for linking to your server, but is not guaranteed to stay with that machine depending on powering up and down of your systems, and your ISP's procedures for assigning IP's. Hope this helps, Warren Vail Vail Systems Technology -Original Message- From: nagendra prasad [mailto:nagendra802...@gmail.com] Sent: Tuesday, June 29, 2010 1:12 PM To: phpexpe...@yahoogroups.com; PHP DB; php mysql; php-wind...@lists.php.net Subject: [PHP-WIN] Re: Need Help in setting up a server Hi all, Thanks everyone. I just tried all of your suggestions and found that WAMP server is working by using the running WAMP server's system IP. I just typed 192.168.1.4 in the address bar and its working now. So, I came to a conclusion that if I have a static IP then I can access it from out side as well right. Correct me if I am wrong ?? So, if I am right is it possible to run a server from home ?? Best, Guru. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Need Help in Mysql database
Hi All, I have a huge set of MP3 database. My problem is that when I try to search in my database its getting very slow. I was wondering if I split that database into 2 or more tables. Will this improve the speed of searching? Is it the best solution for my problem or is their any other solution? Best, Guru.
Re: [PHP-DB] Need Help in Mysql database
On Wed, Jun 30, 2010 at 10:52 AM, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I have a huge set of MP3 database. My problem is that when I try to search in my database its getting very slow. I was wondering if I split that database into 2 or more tables. Will this improve the speed of searching? Is it the best solution for my problem or is their any other solution? Best, Guru. What are you : a) searching on b) have mysql indeces on Also have you run an explain plan on the query to see if its using any indexes? -- Bastien Cat, the other other white meat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
