I Am The Shadow On The Sun

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