mysql -h<host name> -u<username> -p<password> <database name> < my-dump.file
How to load up a file into the database, which was created using mysqldump which includes SQL statements
- How to dump the contents of 1 table from MySQL into a file, that includes SQL type INSERT statements
- How to select a random set of records using MySQL