Mr. Green Posted May 27, 2009 Share Posted May 27, 2009 I have been searching for threads the entire day and cannot seem to find the answers I'm looking for. Please help. I have an approx. 30 MB database called losa that I have exported using the inbuild feature in phppgadmin. The dump is called dump.sql. I have created a test environment on my windows where I want to import the dump to my postgres 8.3 (localhost). I don't want to link directly to the live database. The test environment db is also called losa and it is created with the same usernames etc. I just need it to be filled out with tables and relations from the dump. The dump path is: C:\Documents and Settings\dump.sql. Sounds simple enough but (&%€(! Link to comment https://forums.phpfreaks.com/topic/159873-solved-importing-from-windows-desktop-to-localhost/ Share on other sites More sharing options...
roopurt18 Posted May 28, 2009 Share Posted May 28, 2009 I just use the pgAdmin III interface to perform such tasks. Right click on the db and search through the pop-up menu for the option that allows you to restore. Or you can probably do it from the command prompt. Did you read the postgre manual?!? Link to comment https://forums.phpfreaks.com/topic/159873-solved-importing-from-windows-desktop-to-localhost/#findComment-844497 Share on other sites More sharing options...
Mr. Green Posted July 24, 2009 Author Share Posted July 24, 2009 It is solved now, I made a dump of the sql and then i used the command prompt with this line: psql -1 -f dump.sql DB_name postgres (first i located the dump file in command prompt). Once you know it's simple but damn it has taken me long time. I hope you guys with similar problem will find this post quickly. Link to comment https://forums.phpfreaks.com/topic/159873-solved-importing-from-windows-desktop-to-localhost/#findComment-881942 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.