Dumping Database

Question

how to dump the whole database at once.. do u guys have any query ???????

Answer 1

i think that dumping your data is a function of your database system. So it is no business of SQL.
if you have a MySQL you can use mysqldump, if it is a MS SQL then the management studio will do this for you.
You can not dumping a system you are running in, so it is an external task.