PostgreSQL to MySQL???

Discussion in 'MySQL' started by jawinn, Jul 24, 2006.

0
  1. #1
    I just got stuck with a PostgreSQL based website. Is there a way to convert it into a MySQL DB?

    The reason I ask is because I only use Godaddy to host and they only have MySQL support.

    thx
     
    jawinn, Jul 24, 2006 IP
  2. dc dalton

    dc dalton Active Member

    Messages:
    521
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #2
    You shouldnt have a problem unless it has triggers or procedures or other thing MySQL cant handle. You will have to recreate the tables with the proper syntax for MySQL and do a data dump and then import the data into MySQL.

    Personally being "stuck" with a Postgresql based website isnt being stuck at all! IT is 1000 times more powerful than MySQL could EVER be!
     
    dc dalton, Jul 24, 2006 IP
  3. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #3
    correct, mysql is kindof catching up to the power of Postgres but it far supasses myssql in power and functions.
     
    ccoonen, Jul 24, 2006 IP
  4. dc dalton

    dc dalton Active Member

    Messages:
    521
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #4
    Still has a LONG way to go!
     
    dc dalton, Jul 24, 2006 IP