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, http://downloads.mysql.com/docs/sakila-db.zip.  Is there a way to do it without the sql command line?  

thanks!
-xana
xanabobanaAsked:
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!
0
 
xanabobanaAuthor Commented:
ok, so I found there's a Data Migration tool but I can't get the installer to download!   http://www.sqlmaestro.com/products/postgresql/datawizard/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...
0
 
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?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
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?
0
 
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.
0
 
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!
0
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.