import database schema & data sql files with pgAdmin

Hi-   I'm wondering how to import database schema & data with pgAdmin?  Right now I'm just using the sample sakila database,  Is there a way to do it without the sql command line?  

Who is Participating?
xanabobanaConnect With a Mentor Author Commented:
I finally got the data migration wizard installed!

just in case other people need explicit instructions:

I found & ran the StackBuilder application, which is included in the postgres server install.  I was able to install the data migration tool from there.  Trying it out now, I'll let you know if I get it working!
xanabobanaAuthor Commented:
ok, so I found there's a Data Migration tool but I can't get the installer to download!

C:\Documents and Settings\Administrator\My Documents\Downloads\postgresql_datawizard_setup.exe. could not be saved, because the source file could not be read.

I've tried 5 or 6 times since midnight last night with no luck.  Tried emailing them but no luck yet...
Kevin CrossChief Technology OfficerCommented:
Which database environment are you using, PostgreSQL or MySQL?  In the question you are trying the MySQL db, but the tool download is PostgreSQL?
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Kevin CrossChief Technology OfficerCommented:
And I see you are using pgAdmin, so this must be PostgreSQL, right?  So are you trying to import MySQL database to your PostgreSQL server?
Kevin CrossChief Technology OfficerCommented:
Good luck. So guess you are trying to migrate a MySQL server to PostgreSQL. Got you now on the mix of zones and information.
Kevin CrossChief Technology OfficerCommented:
If it does work, you can accept your last comment above as the answer which will (1) refund your points but (2) leave your solution available to the community.  Nice work!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.