to restore the database
 

i have "test.sql" .. the mysql file.Then i have create one database that called "test".So i want to restore the test.sql into the "test" database. What command i should use?? I have try many types commands but it never works for me :)

i think you should just run the 'test.sql' in your sql | sqlplus prompt.

can u give the exactly/proper command line ??

I am joggling it out of memory. its the same as running any of your sql commands. just copy/paste the content of the .sql file in to your prompt and run it.or you can use the edit command in sql which opens up a notepad (i guess) where you can copy/paste the content of .sql file. the save-exit the editor and back at the prompt just type / and hit enter. your commands in the .sql file should run.