converting PostgreSQl to MySQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • daddy321
    Registered User
    • Jul 2005
    • 22

    #1

    converting PostgreSQl to MySQL

    Hey guys, does anyone know how to convert PostgreSQl database to Mysql format?
  • psili
    Confirmed User
    • Apr 2003
    • 5526

    #2
    I've never done it, but this is how I'd envision doing it:

    Create a similar schema in mySQL,
    Dump the data to delimited text file from PostgresSQL
    Load Data INFILE into the mySQL db?
    Your post count means nothing.

    Comment

    • Doc911
      Confirmed User
      • Feb 2004
      • 3695

      #3
      Originally posted by psili
      I've never done it, but this is how I'd envision doing it:

      Create a similar schema in mySQL,
      Dump the data to delimited text file from PostgresSQL
      Load Data INFILE into the mySQL db?

      thats the simplest solution in the book.


      For PHP/MySQL scripts ICQ 161480555 or email [email protected]

      Comment

      • HorseShit
        Too lazy to set a custom title
        • Dec 2004
        • 17513

        #4
        I charge a very high consulting fee.

        Comment

        Working...