Mysql Database Import/Export Command Line

Export mysql database

          mysql -u username -p database name > filename.sql


Import mysql database

          mysql -u username -p database name < filename.sql


Export all databases from remote server to local machine

          mysqldump -u username -p -h hostname --all-databases > filename.sql

import command for mysql,export command for mysql,import mysql,export mysql,mysql import,mysql export,command line import mysql database,command line export mysql database,mysql database export,mysql database import