You have two options:Upload over serial. This requires a bootloader installed on your ATmega328P and a USB-serial interface (AKA "FTDI"), such as the one you're using on the Pro Mini.Upload using programmer. This requires an ISP programmer connected to the ATmega328P, as you did when you burned the bootloader. You will need to use the Sketch > Upload Using Programmer method to do the upload.
Have a look at this Arduino on a Breadboard tutorial...R
add the capacitor as required, still I can hardly control the reset timing thing.
(2)I tried this method too but it shows an error:avrdude: Error: Could not find USBtiny device (0x2341/0x49)Do I have to use USBtiny as a ISP programmer since I am using bus pirate from Spark Fun with SPI MOSI,MISO interfaces, maybe plus CS too.
You need to select Tools > Programmer > Bus Pirate as ISP. This option is only available with relatively recent versions of the Arduino IDE/Arduino AVR Boards.