Import Database via Command Prompt



Step 1:- copy sql file into  C:\wamp\bin\mysql\mysql5.5.8\bin  folder.
Step 2:- go to cmd
          C:\wamp\bin\mysql\mysql5.5.8\bin >mysql –u root –p password databasename < sqlfilename.sql

-u= root ,php myadmin username
-p=password , php myadmin password. 


Comments

  1. Jeeva RathinamJanuary 18, 2017 at 11:31 PM

    actually my db size 1.5 gb, is it possible import by localhost. i tried what u suggested above not working.

    ReplyDelete
  2. Pintu DabhiMarch 30, 2017 at 12:59 AM

    Hi Kaushik,

    Great trick, it's works for me. Larger database has uploaded through your suggested tricks.

    ReplyDelete

Post a Comment

Popular posts from this blog

Adding Contact us link to Top Menu in Magento

Image
Create New Category " Contcat Us ". Set " Display Mode "=" static block only " from " Display Settings " Tab. Set below code in " Custom Layout Update " from " Custom Design " Tab. <reference name="content">             <block type="core/template" name="contactForm" template="contacts/form.phtml"/> </reference> Save it.... Enjoy...
Read more

Credit card number for Testing payment methods

American Express: 378282246310005 3111111111111117 343434343434343 370000000000002 340000000000009 371449635398431 378734493671000 Visa: 4111111111111111 4007000000027 4222222222222 4012888888881881 MasterCard: 5105105105105100 5111111111111118 5454545454545454 5500000000000004 5555555555551111 5555555555554444 Discover: 6011111111111117 6011000000000004 6011000990139424 6011601160116611 6111111111111116 for expiry date select any feature month and year.... 
Read more

Magento create invoice of specific order by programmatically

<?php require_once('app/Mage.php'); Mage::app(); $orderId = '10508'; /////$order->getId(); $fullOrder = Mage::getModel('sales/order')->load($orderId); $fullOrder->setState(Mage_Sales_Model_Order::STATE_PROCESSING, true); $fullOrder->setStatus('processing', false); $fullOrder->save(); try { if(!$fullOrder->canInvoice()) { Mage::throwException(Mage::helper('core')->__('Cannot create an invoice.')); } $invoice = Mage::getModel('sales/service_order', $fullOrder)->prepareInvoice(); if (!$invoice->getTotalQty()) { Mage::throwException(Mage::helper('core')->__('Cannot create an invoice without products.')); } $invoice->setRequestedCaptureCase(Mage_Sales_Model_Order_Invoice::CAPTURE_OFFLINE); $invoice->register(); $transactionSave = Mage::getModel('core/resource_transaction')->addObject($invoice)->addObject($invoice->ge...
Read more