CODE EXAMPLE FOR SHELL

dum mysql db with cli

# export mysql
mysqldump -h localhost -u username -p dbname > filename.sql


# restore / import mysql
mysqldump -h localhost -u username -p dbname < filename.sql