Cacher is the code snippet organizer for pro developers

#import
mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

#export
mysqldump -u db_user -p db-name > filename

#export just one table
mysqldump -u db_user -p db-name table-name > filename

# export all databases from server one to server two with the same mysql version and OS
mysqldump -u root -pPASSWORD --all-databases | ssh USER@HOST.COM 'cat - | mysql -u root -pPASSWORD'

# then restart mysql to flush rights

# export all database to a single file
mysqldump -uroot -p --all-databases > alldb.sql

# get single db from all databases dump (change dbname to your needs)
sed -n '/^-- Current Database: `dbname`/,/^-- Current Database: `/p' alldatabases.sql > output.sql