Import MySQL text dump

Importing a mysql text dump is pretty staright forward:

mysql table_name < mysql_dump_file.sql

In addition the following options may be of use:

• --user=YOUR_USER_NAME, login as the specified user, if not specified it will user the default
• -p, prompt for password, if not specified it will use the default
• -h YOUR_HOST_NAME, the name of the host the database is on, this is often localhost which is usually the default

Put together this is used in the following way:

mysql --user=YOUR_USER_NAME -p -h localhost table_name < mysql_dump_file.sql