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!
"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!