Thursday 26 August 2004 6:05:00 am

Hi Björn, and thanks for replying.

I see that this approach has its uses too, but how about renaming all the old eZ database tables, installing eZ in a new directory, copying all the needed settings/* and design/* from the old site, and then transferring the needed data from the old tables?

Hmmm, that actually sounds like the GUI form of what you have suggested...

I also remembered that I have some custom classes, so I will probably have to transfer the contents of all the ezcontentclass* tables as well, right?

My main point is, if I can get away with recreating the root node using just a few insert statements, as mentioned in the above thread, then I will try. But emptying the table totally seems to me like shooting sparrows with cannonballs. Then I might as well start all over again, and maybe even upgrade to 3.4.1 at the same time.

best regards
trondåge

trondåge

Thursday 26 August 2004 8:03:17 am

You're right, you did not mention anything about deleting the whole table. My mistake. Sorry, it's just that I'm little frustrated at the moment, and I don't understand which tables I need to edit to remove only the object with id=1.

So, I've made a little list of what I need to do in order to combine a recreation of my site + an upgrade to 3.4-1.

<i>Steps needed to recreate my site after deleting the root node.

1. rename all eZpublish tables to ez_ez*
2. rename the current ez directory
3. unpack the eZpublish 3.4-1 tar.gz file
4. rename the new eZpublish directory to the old name
5. run the setup again
6. copy the all the design/* + settings/* + var/* files from the old version
7. transfer the contents of ez_ezcontentclass* tables
8. transfer the contents of ez_ezcontentobject* tables where id<>1
9. transfer only the contents of name, and datatext1 and datatext2 where id=1</i>

Does this list seem ok? Or are there things that I have forgotten?

Any comments are highly appreciated, perhaps someone from the eZ crew could chip in as well.... ;-)

Best regards
trondåge

trondåge

Monday 30 August 2004 2:22:49 am

OK, thanks Björn.

At the moment I'm at stage seven in my new list:

<i>7. transfer the contents of ezcontentclass* tables
8. transfer the contents of the eznode_assignment table
9. transfer the contents of the ezurl_alias table
10. transfer the contents of ezcontentobject* tables where id<>1
11. transfer only the contents of name, and datatext1 and datatext2 where id=1</i>

And to try to avoid any more major f**kups, I need a little guidance in the mySQL world.

When I renamed the tables I used the mySQL command RENAME TABLE, what I see now is that I perhaps should have used BACKUP TABLE.

I think renaming the ez_ezcontentclass* back to ezcontentclass* should be enough to get these data straight. Is that a correct assumption?

If this is true I believe that holds for the next two steps as well.

The tricky part (for me) comes in step 10. Does anyone know how I would write that statement?

And as far as I can see step 11 is best handled through the admin interface.

Any thoughts anyone?

BTW: I wholeheartedly aggree with all who vote for erase-protection on the root node :-/

best regards

trondåge