Wednesday, 19 June 2013

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

No comments:

Post a Comment