Ubuntu Terminal: mysql -u username -p database_name < database.sql does not import completely

If ever you have encountered the issue mentioned in the title of this post, I have an alternative for that. I experienced that when I imported a very large sql file which is about 2GB.

What I did was I used the mysql command line client. I think you have an idea now how i did it.
But here we go. In your terminal, type mysql -u <your_username> -p. Then type of course type the password when prompted.

 Then run use <database_name>; press enter.
And then, source sqlfile.sql;

 That should do the trick. Just wait for it to finish importing.

Comments

Post a Comment

Popular posts from this blog

How to fix Cignal Top Box error - Please perform a smart card reset by removing your smart card for 15 seconds then reinsert the card. (1/2)

Turn off the top box. Remove the Smart card from the top box. Clean the chip part (usual color of the chip is gold) with an eraser or a soft cloth Blow the Smart card slot to remove excess dirt Replace the Smart card to the slot Wait for 15-20 seconds and restart the top box. Did it help? If so, can you return the favor? Kindly just click any of the ads on this page.
Read more

Magento: can't login to admin panel, can't add product to cart

Image
If ever you encountered issues like you cannot login to the admin panel or cannot even add product to the cart, I have a better solution for you. Using phpMyAdmin, in your magento database, look for the core_config_data table and click it. Click the "Search" tab.  Then on the "path" column set the operator to LIKE %...% and the Value to cookie and click the "Go" button to search. Screenshot provided for clarity After searching, set the value of web/cookie/cookie_path ,  web/cookie/cookie_domain ,  web/cookie/cookie_httponly , and  web/browser_capabilities/cookies to NULL Just like this on the screenshot. Screenshot provided for clarity Adding product to cart and logging in to the admin panel should work now!
Read more

Fatal error: Uncaught TypeError: Argument 1 passed to Magento\Catalog\Model\ProductRepository::getProductFromLocalCache() must be of the type string, null given, called in /vendor/magento/module-catalog/Model/ProductRepository.php on line 270 and defined in vendor/magento/module-catalog/Model/ProductRepository.php:751

Possible reason is that there's a NULL sku in catalog_product_entity. To find out, query the catalog_product_entity table for a NULL sku. Something like: SELECT * FROM catalog_product_entity WHERE sku IS NULL; If there is, then just set the SKU and you're good!
Read more