Link to home
Create AccountLog in
Avatar of xanabobana
xanabobanaFlag for United States of America

asked on

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
Avatar of xanabobana
xanabobana
Flag of United States of America image

ASKER

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...
Avatar of Kevin Cross
Which database environment are you using, PostgreSQL or MySQL?  In the question you are trying the MySQL db, but the tool download is PostgreSQL?
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?
ASKER CERTIFIED SOLUTION
Avatar of xanabobana
xanabobana
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Good luck. So guess you are trying to migrate a MySQL server to PostgreSQL. Got you now on the mix of zones and information.
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!