what is the best procedure to quickly restore the MySQL database without using dump files. can any body help me in this regard. Thanks in advance.
Ofcourse a physical files restore will be quicker than loading a dump. So, if you have full physical backup / snapshot of mysql data-directory - you can go fast!
(Below answer assumes that you have physical backup available.)
Tables are MyISAM:
Copy database folder to mysql datadir
Tables are InnoDB:
If we have InnoDB tables in the picture then things are not as simple. Considering you have Xtrabackup.
You will have to import tables one after another.
Refer Importing-Exporting-Tables-using-Xtrabackup OR how-to-recover-a-single-innodb-table-from-a-full-backup (For this to work you should have used xtrabackup as backup option.)
If you want to extract only one database from full mysqldump then you might want to extract single database from mysqldump and load it (saves you from loading full dump).