Importing SQL Databases via command

Most backups of databases use utilities such as mysqldump to generate a SQL insert statements and data that describes the old database. SQL files are also used when creating new databases. To import these .sql files, use the following command (when logged into the server via SSH):

mysql -u username -ppassword database_name < your_data.sql

This command loads all the SQL commands from the specified file as if you were to enter them line by line.