| EXPORT AND IMPORT [message #383985] |
Sun, 01 February 2009 06:47  |
eml2raghu
Messages: 11
Registered: April 2007
Location: CHENNAI
|
Junior Member |
|
|
Hi, Can anyone help me how to import the entire database. I have an old database, which is having some schemas. Now I want to remove all the schemas and create a new database which is exactlly same as the new one, which is in the form of dump. I have a rough idea on this, but not clear idea. Can someone help me by providing the steps i have to do in order.
Thanks in advance
|
|
|
|
|
|
| Re: EXPORT AND IMPORT [message #384807 is a reply to message #383985] |
Thu, 05 February 2009 04:48  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I can't understand what you're trying to do.
| Quote: | I have an old database, which is having some schemas
|
Ok - you have a database.
| Quote: | Now I want to remove all the schemas
|
DROP USER <username> CASCADE; would seem to be a useful command.
and create a new database which is exactlly same as the new one, which is in the form of dump
what sort of Export was taken?
Was it for the whole Db, or just the schemas that you want to import?
Was the soure database the same version as the database that you're trying to import into?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
