How to import large sql files into mysql using phpmyadmin wamp server

When you try to import sql file to wamp server usually it cann't upload more than  2,048KiB size and gives error message like

When you try to import sql file to wamp server usually it cann't upload more than  2,048KiB size and gives error message like

There is another way to upload large size of sql file to wamp server

step 1

Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here: 

C:\wamp\apps\phpmyadmin3.4.5\config.inc.php 

Note:  phymyadmin3.4.5 folder name is different in different version of wamp

step 2:

Find the line with $cfg['UploadDir'] on it and update it to:

$cfg['UploadDir'] = 'upload';

step 3:
Create a directory called ‘upload’ within the phpmyadmin directory.
    
C:\wamp\apps\phpmyadmin3.2.0.1\upload\

step 4:

copy and paste the  large sql file into upload directory which you want importing to phymyadmin

step 5: 

select sql file from drop down list from phymyadmin to import

Instant Payment Notification

Instant Payment Notification (IPN) is a message service that automatically notifies merchants of events related to PayPal transactions. Merchants can use it to automate back-office and administrative functions, like fulfilling orders and providing customers with order status.  

Applicable Use Cases

• Managing Orders and Creating Transaction Reports

How it works

Merchants enter in their PayPal profile a URL they established on their website where they want to receive automated notice of transaction-related events.  When customers pay for goods or services, PayPal sends a secure FORM POST containing payment information to the URL. The IPN service detects and processes IPN messages with a listener, sometimes called a handler. The listener is a custom script or program that resides on the merchant’s website. It waits for messages, validates them with PayPal, and passes them to various back-office applications.

Why use Instant Payment Notification

Instant Payment Notification (IPN) notifies merchants almost instantly about transaction events, such as:

• Payments received, including Express Checkout, and Adaptive Payments.
• Credit card authorizations.
• eCheck payments and related pending, completed, or denied status events.
• Recurring payments and subscription actions.
• Chargebacks, disputes, reversals, and refunds.

Merchants can act based on the information they receive. For example, they can:

• Update their inventory.
• Email a purchase confirmation.
• Trigger order fulfillment.
• Enable download of digital media.
• Update their customer list.
• Email a shipping notification.
• Issue a refund.
• Update accounting-related information.

Using IPN in your checkout flow

Although PayPal usually processes IPN messages immediately, IPN is not synchronized with actions on your website. Internet connectivity is not always 100% reliable and IPN messages can be lost or delayed. The IPN service automatically resends messages until the listener acknowledges them. The service resents messages for up to 4 days.
Because IPN is not a real-time service, your checkout flow should not wait for the IPN message before it is allowed to complete. If the checkout flow is dependent on receiving an IPN message, processing can be delayed by system load or other reasons. Configure your checkout flow to handle a possible delay.

How to get started

1. Check your account status. Login to PayPal. Go to your PayPal Profile and click My settings. Confirm that your “Account type” is either Premier or Business, or upgrade your account.
2. Check your API settings. Click My selling tools. Expand “Selling online” if needed and check “API access.” Click Update and Add or edit API permission or View API signature.
3. In your PayPal Profile, click My selling tools, click Instant Payment Notification. Follow the instructions to enable your IPN including entering your Notification URL.
4. To create a basic IPN listener script, information is available in the following document: How To Process Instant Payment Notification Messages.
5. Install your script on your website at the Notification URL you specified in your PayPal Profile.
6. Test your script using the PayPal Sandbox. (Registration is free.)
7. Once you’ve verified that your implementation works correctly in the Sandbox, you’re now ready to go live.

U.S. fees

There are no fees for Instant Payment Notification.

International availability and fees

You can use Instant Payment Notification in any country where PayPal is accepted.
There are fees for currency conversion and to receive payments from another country.

How to Integrate Paypal Payment System in PHP & MySQL

In this tutorial I want to explain how to work with Paypal Sandbox test accounts for payment system development and sending arguments while click buy now button. It’s simple and very easy to integrate in your web projects.

Step 1

Create a Paypal Sandbox account at https://developer.paypal.com/

Step 2

Now create test accounts for payment system. Take a look at Sandbox menu left-side topSandbox->Test Accounts

Step 3

Here I have created two accounts Buyer (personal) and Seller (merchant/business)

index.php

Contains PHP code. Displaying products, product image, product name and product price. Here you have to give your business(seller) $paypal_id id. Modify paypal button formreturn and cancel_return URLs.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

<?php $paypal_url='https://www.sandbox.paypal.com/cgi-bin/webscr'; // Test Paypal API URL $paypal_id='your_seller_id'; // Business email ID ?> <h4>Welcome, Guest</h4> <div class="product">                 <div class="image">         <img src="rkphpsolution.blogspot.in/wp-content/uploads/img.jpg" />     </div>          <div class="price">         Price:$10     </div>     <div class="btn">     <form action="<?php echo $paypal_url; ?>" method="post" name="frmPayPal1">     <input type="hidden" name="business" value="<?php echo $paypal_id; ?>">     <input type="hidden" name="cmd" value="_xclick">     <input type="hidden" name="item_name" value="PHPGang Payment">     <input type="hidden" name="item_number" value="1">     <input type="hidden" name="credits" value="510">     <input type="hidden" name="userid" value="1">     <input type="hidden" name="amount" value="10">     <input type="hidden" name="cpp_header_image" value="http://rkphpsolution.blogspot.in/wp-content/uploads/gang.jpg">     <input type="hidden" name="no_shipping" value="1">     <input type="hidden" name="currency_code" value="USD">     <input type="hidden" name="handling" value="0">     <input type="hidden" name="cancel_return" value="http://demo.rkphpsolution.blogspot.in/payment_with_paypal/cancel.php">     <input type="hidden" name="return" value="http://demo.rkphpsolution.blogspot.in/payment_with_paypal/success.php">     <input type="image" src="https://www.sandbox.paypal.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">     <img alt="" border="0" src="https://www.sandbox.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">     </form>     </div> </div>

success.php

Paypal payment success return file. Getting Paypal argument like item_number. Paypal data success.php?tx=83437E384950D&st=Completed&amt=10.00&cc=USD&cm=&item_number=1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

<?php $item_no            = $_REQUEST['item_number']; $item_transaction   = $_REQUEST['tx']; // Paypal transaction ID $item_price         = $_REQUEST['amt']; // Paypal received amount $item_currency      = $_REQUEST['cc']; // Paypal received currency type $price = '10.00'; $currency='USD'; //Rechecking the product price and currency details if($item_price==$price && $item_currency==$currency) {     echo "<h1>Welcome, Guest</h1>";     echo "<h1>Payment Successful</h1>"; } else {     echo "<h1>Payment Failed</h1>"; }

cancel.php

Paypal API cancel_return file.

1 2 3 4

<?php echo "<h1>Welcome, Guest</h1>"; echo "<h1>Payment Canceled</h1>"; ?>

 Step 4

When your web application test payment system workflow is completed. Change the form action development API URLs to original API URLs and give valid $paypal_id seller email id.

1 2 3

$paypal_url='https://www.sandbox.paypal.com/cgi-bin/webscr'; //to $paypal_url='https://www.paypal.com/cgi-bin/webscr';