Topic: Moving part of database?

Wolf CMS is used on a website and now the owner like me to make a new fresh start by doing a fresh install, there is only one catch: the articles page and all its children under that page need to be moved.

How should I proceed?

Re: Moving part of database?

Not sure if this needs a database change, but in case it doesn't, can't you just use the admin Pages drag/drop to copy the the parent page and it's siblings and set the new parent to hidden or draft while you make changes, then test the new location works, then remove the original parent and siblings?

Last edited by BlueWolf (2012-01-27 00:29)

Thumbs up

Re: Moving part of database?

I need to do a fresh Wolf install, including new database and then I supossed to get the existing articles page (including its children) from the old database and "move" them into the new database. I'm not sure what would be the best way, or if it is possible at all.
Perhaps I should add each page and content by hand, there's about 40 of them.

Re: Moving part of database?

Can't you just simply export the database (trough phpmyadmin) and copy the "INSERT" lines? If I must guess, you only need the "wolf_page" and "wolf_page_part" tables.

I'm not sure though, because I've never done this before.

Re: Moving part of database?

You should be able to make an export with the Backup Restore plugin and edit the XML file to remove everything you don't need (i.e. anything that's not a Page or Page Part)

The Backup Restore plugin supports partial imports. (so you could for example import a single Layout)

Assuming you're importing on a virgin system, you can then simply empty/truncate the page and page_parts tables... then import the partial XML.

I've used this technique myself and it works. The most common problem that can happen with this technique is conflicting page IDs which is why you should ideally empty the page & page_part tables to reset the automatically generated ID.

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

Re: Moving part of database?

Editing the XML proved to be more difficult then editing the SQL;
for some reason the XML output is not really userfriendly for editing?

But I got it working.
Thanks for the suggestions guys/gals.

Last edited by Fortron (2012-01-27 19:17)