Oh I almost forgot the part about using dump files. If local put the dump file in a directory you can rember, if remote FTP file up to a directory you want to use. For this we use the "SOURCE" command.
First login to Mysql, and get into the database (db) you want to use. To do this use the "USE" command.
mysql> USE Database1
now we want to use our *.sql file to dump a large amout of data into the database.
mysql> source "/path/to/directory/dump_file.sql";
Then just let it run. That simple.
My New site OpenEyes