|
by jeep 04/16/2005, 10:52pm PDT |
|
 |
|
 |
|
Fussbett wrote:
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.
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.
Ice Cream Jonsey wrote:
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).
The rule is: if you're going to do it twice, write a program. You're only going to do this once.
Ice Cream Jonsey wrote:
*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.
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/ |
|
 |
|
 |
|
|
|
If I had caltrops forum code, I could just put it up along with the archive. by Creexul :( 04/14/2005, 9:09pm PDT 
Jesus Fuck NT by Entropy Stew 04/14/2005, 9:57pm PDT
Yes, you should hurry up and fix everything. :( NT by Creexul :( 04/14/2005, 10:04pm PDT
You should hurry up and jump up my ass! by Entropy Stew 04/14/2005, 10:13pm PDT
No and no. by Creexul :( 04/14/2005, 11:51pm PDT
Re: If I had caltrops forum code, I could just put it up along with the archive. by Ice Cream Jonsey 04/15/2005, 12:25am PDT
Re: If I had caltrops forum code, I could just put it up along with the archive. by Creexul :( 04/15/2005, 12:44am PDT
Jesus Fuck NT by Entropy Stew 04/15/2005, 5:51pm PDT
I'll try to handle this. Speak his language. by Fussbett 04/16/2005, 4:00am PDT
Re: I'll try to handle this. Speak his language. by Creexul :( 04/16/2005, 9:51am PDT
I don't get it. NT by bink 04/16/2005, 12:01pm PDT
Re: I'll try to handle this. Speak his language. by Ice Cream Jonsey 04/16/2005, 12:47pm PDT
Re: I'll try to handle this. Speak his language. by jeep 04/16/2005, 10:52pm PDT
Re: I'll try to handle this. Speak his language. by Ray of Light 04/16/2005, 11:26pm PDT
Re: I'll try to handle this. Speak his language. by jeep 04/17/2005, 3:50pm PDT
Re: I'll try to handle this. Speak his language. by Fussbett 04/17/2005, 2:29am PDT
Re: I'll try to handle this. Speak his language. by Creexul :( 04/17/2005, 3:22am PDT
Re: I'll try to handle this. Speak his language. by Creexul :( 04/17/2005, 3:21am PDT
I could take an LOA from my job and hand-type them in. NT by Bill Dungsroman 04/17/2005, 10:19am PDT
Re: If I had caltrops forum code, I could just put it up along with the archive. by Mischief Maker 04/16/2005, 9:23am PDT
Because it's the best, if you're a huge fucking dork. That's just a guess. NT by Fullofkittens 04/16/2005, 11:55am PDT
I think I can help you out, there. by jeep 04/16/2005, 10:25pm PDT
You probably wouldn't need me to send you the old backup. by Creexul :( 04/17/2005, 3:29am PDT
Thank you, jeep by Ice Cream Jonsey 04/18/2005, 10:29am PDT
No problem by jeep 04/18/2005, 8:29pm PDT
Re: No problem by Ice Cream Jonsey 04/19/2005, 10:26am PDT
Re: I think I can help you out, there. by Mischief Maker 04/18/2005, 10:33am PDT
Re: I think I can help you out, there. by jeep 04/18/2005, 8:31pm PDT
Blanket response to all "why Postgres?" questions by Entropy Stew 04/17/2005, 2:59pm PDT
Re: Blanket response to all "why Postgres?" questions by jeep 04/17/2005, 4:14pm PDT
Re: Blanket response to all "why Postgres?" questions by Entropy Stew 04/17/2005, 4:56pm PDT
It looks like I owe some people an apology. by Ice Cream Jonsey 04/18/2005, 10:26am PDT
Like sb? NT by Creexul :( 04/18/2005, 12:08pm PDT
I tried replacing all them /324/432 whatevers with br tags. by Creexul :( 04/19/2005, 2:51pm PDT
jeep - don't touch the stuff. This is too fucking funny NT by Entropy Stew 04/19/2005, 2:59pm PDT
It won't be funny if I get it working. >:( NT by Creexul :( 04/19/2005, 3:07pm PDT
That it actually the funniest outcome possible NT by Entropy Stew 04/19/2005, 3:11pm PDT
IS NT by Entropy Stew 04/19/2005, 3:11pm PDT
I gave up, sorry. :( by Creexul :( 04/19/2005, 8:33pm PDT
And you're on a browser that can't disable picture display? How unfortunate. NT by Casual observer 04/19/2005, 9:46pm PDT
I don't know, I probably am. NT by Creexul :( 04/19/2005, 11:49pm PDT
|
|
