From: | Erin Jonaitis <jonaitis(at)wisc(dot)edu> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Restoring from SQL dump |
Date: | 2013-10-18 13:57:29 |
Message-ID: | 00ab01cecc09$fc2e0750$f48a15f0$@wisc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello!
I am trying to restore data from an SQL dump. I am using Windows 7,
PostgreSQL version 9.3, pgAdmin III 1.18.0.
Here is what I did.
1) I used the pgAdmin III interface to create a new database.
2) I selected this db in the console and selected Plugins > PSQL
console.
3) Now I have a psql window open with the following prompt:
dbname=#
4) I tried typing the following:
psql -f M:\LongitudinalDB\backups\2013.10.02\uw.sql
and got the following error:
Invalid command \LongitudinalDB. Try \? For help.
5) OK, so maybe the backslashes are the problem. I then tried
psql -f M:/LongitudinalDB/backups/2013.10.02/uw.sql
and got no error.
6) However, none of the data or tables appeared in the db - it looks
just as it did as a fresh db.
7) I tried a few other things in the psql window, deliberately typing
nonsense. No error messages then, either, just a fresh prompt.
Advice would be much appreciated.
Thanks,
Erin
From | Date | Subject | |
---|---|---|---|
Next Message | Payal Singh | 2013-10-18 14:12:21 | Re: Restoring from SQL dump |
Previous Message | David Johnston | 2013-10-17 20:45:57 | Re: error: there is no parameter $1 |