#dump
mysqldump -hlocalhost -uuser -ppassword nomdatabase> nomdatabase.sql

#restore
mysql -hlocalhost -uuser -ppassword nomdatabase < nomdatabase