Ubuntu: MySQL Export/Import all databases in CLI

To Export all your MySQL databases, do this :
mysqldump -u yourusername -p -h localhost --all-databases | gzip > filename.sql.gz

To Import all your MySQL databases, do this :
mysql -u yourusername -p -h localhost < filename.sql

Also you might wonder how I unzipped the gz file. You can do this
gunzip filename.sql.gz

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