Suresh Yadav

If you know questions put them here. If you know answer of a question put below that question. If you have doubt in any question or answer, you can add comments below that answer.

Eg.

Q. What is scaffolding?

Many time you have seen a error that port 80 is not availabe and used by another program, due to which your web server (apache in my case ) cannot statred. As you are not aware who is using port 80 and why.

Here are some steps for window to diagnose this issue:

Hello sir

I am using ubercart module for shoping cart but i found bug Issue of discount on product ubercart module (stable version of discount module not availble ). please suggest that what module should beuse for discount

Description : I want delete duplicate zipcode from zipcode table, in that table i have zipcode field, which one have duplicate zipcods. After searching and help of Suresh we have got the solution to delete duplicate records, but in that table u have need one filed as primary key. In this query id is working as primary key. See b below for the that terriffic query :)

Recently working on one of my projects i found how powerful linux commands are, if u have proper knowledge.

My Problems is to find a files (test.php) in a directory and its sub directory. and then take a backup of that file and then copy a new file at the same place.

# backup test.php
find */*/www/code/ -name 'test.php' -exec cp {} {}.bak \;

# copy new_test.php
find */*/www/ -name 'code' -type d -exec cp /home/new_test.php {}/ \; 2>/dev/null

For dumping a mysql database we can use mysqldump utility comes with mysql. Go to mysql bin directory and try:

mysqldump dbname -u username -p password > path/to/file

# backup of a table in database
mysqldump dbname tablename -u username -p password > /path/to/file

and for loading same database on another server , login into mysql and run following queries

create dbname;
use dbname;
source path/to/file;

While sharing internet connections between windows is quite easy for normal users because most of time all settings are done by windows itself i.e. Network setup wizard or creating new connection. But if you are sharing internet connection between Linux and windows you need to know the technical details of IP Address, Default Gateway, and DNS server. I have faced the same problem yesterday and after a lot of research and talking to friends I finally get it done.

Requirements:
An Internet connection
A LAN network