to restore the database

Ameii83 · 06-09-2006, 03:09 AM

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

prozac · 06-09-2006, 03:29 AM

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

Ameii83 · 06-09-2006, 03:49 AM

can u give the exactly/proper command line ??

prozac · 06-09-2006, 04:11 AM

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.