Scoop || I've a double migration question...

Front Page · Everything · News · Code · Help! · Wishlist · Project · Scoop Sites · Dev Notes · Latest CVS changes · Development Activities

I've a double migration question...
By xrayspx , Section Help! [] Posted on Fri Aug 22, 2003 at 12:00:00 PM PST

I've just migrated not only from one sql server to another, but between scoop versions. There must be a better way than how I went about it.

I am moving from Scoop .8.1 on RH 6.2 to Scoop .9 on RedHat 9. Apache is all set at 1.3, not 2. But in moving the DB, I ham-handedly "adminned" my way through the move. What I did was to backup the .9 database on the new machine and the .8.1 db on the old machine. I then just imported the old db over the new with mysql -u root -p scoop -f < old-db.sql. Then, since that broke many things, re-imported the new one. That left my stories and users intact, but all of the custom stuff is long gone, so my index page template and blocks are basically history.

I've "liberally skimmed" the documentation, let's say, but is there a decent way to handle such a double move? Keeping in mind that my database is exceptionally small, this is an internal site which is more my passion than anything anyone uses. Also keeping in mind that I'm a BOFH, not a dba or programmer. If all it takes is a bigger hammer, I can do that. The pages contained here are, however extremely useful to me and a few other core users. It's unfortunate that none of it can see the light of day unless I or one of my associates royally screws up :-)

< Rotating sigfiles. | A Naked Poll >

Menu

· create account
· faq
· search
· report bugs
· Scoop Administrators Guide
· Scoop Box Exchange

Login

Make a new account

Username:

Password:

Related Links

· Scoop
· More on Announcements
· Also by xrayspx

Story Views

33 Scoop users have viewed this story.

I've a double migration question... | 3 comments (3 topical, 0 hidden)

much the same as any upgrade (none / 0) (#1)
by janra on Fri Aug 22, 2003 at 09:22:05 PM PST

...oddly enough.

I also upgraded my Scoop version when I moved computers; all you really have to do is the normal upgrade stuff.

Specifically, get your apache set up with the scoop code as it was before (only with the new code). Then, load your old database into mysql. Then, use scoop/scripts/upgrade-db.pl and point it at the 0.8-0.9 patch directory. This will bring your database up to date to match the 0.9 code, without clobbering your customizations.

Then, start apache. That should be all.

--
Discuss the art and craft of writing

The "right" way to do it (none / 0) (#2)
by panner on Fri Aug 22, 2003 at 10:21:12 PM PST

I'm assuming by moving from one SQL server to another, you mean one version to another, as Scoop currently only runs on mysql. The main issue in upgrading a Scoop site is updating the database, and there's a much smoother way that what you did. Check the README.upgrade file in the main Scoop dir for more upgrade information.

Mainly, you use the scripts/upgrade-db.pl to automatically apply a series of "patches" which will bring your old database up to date. If you're current upgraded DB hasn't really changed from the old one, you could drop the database (well, back it up first), import the old one, then use this method. Make sure your site is shut down during the upgrade, otherwise things could get odd.

Since you're only updating by one step (0.8.1 -> 0.9), you'll only need to run the command once. Just enter "scripts/upgrade-db.pl" and let it prompt you for the rest of the information. Once it's gathered information, it'll run all of the scripts and SQL code needed, which is quite a bit for your upgrade (47 SQL files, in fact). There may be a few errors in there, but they're generally safe to ignore. Once it finishes running, start apache back up, and you should find that your site is correctly updated.

--
Keith Smiley

Thanks (none / 0) (#3)
by xrayspx on Mon Aug 25, 2003 at 11:53:14 AM PST

Things pretty much worked very nicely. I've got my index template back, my boxes and special pages seem to still be in tact, so I think things worked out.

Thanks for the quick advice. Very helpful. Scoop is the easiest such package for me to "get" and extend. Sometime I'll have to do a public site with it.

I've a double migration question... | 3 comments (3 topical, 0 hidden)

create account | faq | search