When moving mysql database from one server to another or, to test that the data backup works as expected we need to import mysql dump file in the testing environment.
Create the database (test-database) in the testing environment and identify the location of the .gz or .sql file.
If the mysql dump was a .gz file, you need to gunzip to uncompress the file by typing
$ gunzip mysqldump.sql.gz
This will uncompress the .gz file and will just store mysqldump.sql in the same location.
Type the following command to import sql data file:
$ mysql -u username -p -h localhost test-database < mysqldump.sql password: _
For the hostname part, you need to give the respective hostname of the mysql server depending on how it was configured (some times it may be just an IP, some times it may be an IP with port number)
