Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dumping and restoring again

Status
Not open for further replies.

eheidrich

Programmer
Feb 2, 2005
7
BR
Well, I was able to dump and restore a database, but my problem is that I want to fill up a new database with a old dump file records. I have grown the database table number and columns. The file I am trying to restore has data that is ment to be on a new production database, so I have cleared all the tables and I am try to populate them using the dump file. I keep getting the message:

"invalid command \N"

The dump file works perfectly if I use it on a empty database, I mean, with no tables on it. But all I want to recover is the data.

Can any one give me some help? Thanks!
 
the easiest way I think of right now is when dumping using the option

-a or --data-only dump only the data, not the schema

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top