Ubuntu: MySQL import/export with gunzip

To export your mysql database simply do the following :

mysqldump -u user -p database | gzip > database.sql.gz
 
And to import it :

gunzip < database.sql.gz | mysql -u user -p database

Comments

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)

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

Magento: How to fix "The requested URL /index.php was not found on this server" error