mysql -u root -p[root_password] < path_to_dump_file/dumpfilename.sql This will restore all the db from the dump file. -- Regards, T.Shrinivasan My experiences with Linux are here http://goinggnu.wordpress.com For Free and Open Source Jobs http://fossjobs.in BootCamp For Freshers/Students is going to conduct by our kanchilug members from 31 st May to 5 th June.