DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: will full export dump of a schema overwrite an existing table of the same schema ?

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    will full export dump of a schema overwrite an existing table of the same schema ?

    hi,

    I have done a full export dump of a schema and this copy was keep as OLD copy. Now when i want to do a full import of the same schema but maintaining certain table with current contents...will my full import of OLD dump affect those table's current contents as in ?

    I do not have a spare db to test on this so might need some help from this forum.

    thanks in advance.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you dont need spare database to test, create a dummy user and import a table to that user twice

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width