Forum Overview :: Deleted Posts :: Re: I'll try to handle this. Speak his language.

[quote name="jeep"][quote name="Fussbett"]Jhoh, the old database you and ICJ have is in Postgres. It's like having a game on an NEC TurboGrafix-16 HuCard. Splatterhouse may be fun, but it's nearly unplayable in today's dystopian of very few TurboGrafix-16s kicking around. You see, everyone has MySQL instead, which is like having Super Nintendos. Plentiful, but incompatible with your HuCard. [/quote] The above statement is accurate except for the part where we all have PCs that can read and write both HuCards and SuperNintendo Carts, though there's some driver issues. It's really not as bad as you think. [quote name="Ice Cream Jonsey"]Once we have that all plotted out we just make a tool to go line-by-line through the Postgresql database, make the conversions when necessary and attach it to the MySQL one, as if all these new posts were just created (with the appropriate, older time/date stamp). [/quote] The rule is: if you're going to do it twice, write a program. You're only going to do this once. [quote name="Ice Cream Jonsey"]*IN THEORY = Who knows if uploading the Postgresql database could/would actually work. It should, but I wouldn't be surprised if something hilariously went wrong while attempting to do it. But going that route has more negatives than positives.[/quote] The direct upload won't work if SB used any pgsql extensions. If the caltrops forum code worked with pgsql and then mysql without any tweaking, then you might be able to pull it off, but more likely the numbering, as you said, has changed. More likely you'll want to load up the data in their respective databases, and then find a common import/export pattern. These two databases are probably the easiest to do this with. Your problem here is that you're going the opposite way most people do: most websites that grow out of their mysql database migrate to postgres, so there's lots of howtos for that. You can probably do this pretty easily, ICJ. /jeep/[/quote]