I have found a way to upload the SQL dump to restore the Full Moodle
1- Create a database in myphpadmin named as moodle_backup, for example
2- Open the SQL sump file and get rid of the following command
CREATE DATABASE `moodle` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
3- Go into Myphpadmin, localhost->moodle_backup database which you created in step1
4- click on SQL and import the DQL dump file which you have just amended (Step2))
5- In order to see the desired results you need to configure moodle/config file dbname as moodle_backup
It worked for me atleast
Cheers
Fouzia