i already create my database and i create all the tables and done with all insert data....but i need to save the database as file in my USB or in any other storage but i don't know how?

i mean how to save it as (file.sql)?

thanx :-)

if you use MySQL Administrator you can schedule backups of db's. you can also do that via the MySQLDUMP command

lets say my db`s name is cars.... so how to do it by the command MySQLDUMP??

mysqldump -u <username > -p<password> --all-databases > <filename> it will take all backup all databases
-- for particular database cars
mysqldump -u <username> -p<password> cars > <filename> it will take particular database backup