MYSQL file with lots of database's restore to different databases names

Quickest way to restore a MYSQL database, with around 8 different accounts
and databases?

E.g:

Someone has giving me a text file containing the databases they want and the
usernames for the access of the different databases

..
//test_general
test_des
123456
--
..
//test_general1
test_des1
123456
--
..
//test_general1
test_asc1
123456
--


I have a localhost.sql file which contains the all the databases. How do I restore
all to the correct database when it is one file, remember its quite large.

 

 

 

 

Top