Forums / General / URGENT !!!! removed root folder, how to fix?

URGENT !!!! removed root folder, how to fix?

Author Message

Baur Aibek

Monday 21 June 2004 2:48:46 am

user deleted root folder of a huge site :( the whole site gone to trash.

tried to restore root from trash - no result.

PLEASE help how to repair.

Bård Farstad

Monday 21 June 2004 2:53:52 am

The quickest would be to restore the site from backup.

eZ publish does not support restoring the site structure, only the content. So it will take some time to re-build this manually.

--bård

Documentation: http://ez.no/doc

Baur Aibek

Monday 21 June 2004 2:57:57 am

how to do it?
what is backup? ( we had done only database backup a month ago :(

Baur Aibek

Monday 21 June 2004 3:06:43 am

say at least how to create empty root folder again. we r ready to make structure manually

your advice lookes like a joke (did u really wanted to help?)

Björn Dieding@xrow.de

Monday 21 June 2004 7:03:06 am

To create a new root folder you will have to insert data in the following tables

-ezcontentobject
-ezcontentobject_attribute
-eznode_assignment
-ezcontentobject_tree

make sure it si using the node id 2

you can read the past settings from the the

kernel/sql/mysql/kernel_schema.sql

Doing no daily backups isn't funny either.

-
http://www.xrow.de

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Björn Dieding@xrow.de

Monday 21 June 2004 7:05:35 am

just an additional note

if your data is still in the db (trash)

try to set all co to published objects (manually)

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Baur Aibek

Monday 21 June 2004 7:57:28 pm

thank people

pls explain "try to set all co to published objects (manually) "

whats "co"m where to set? which table?

please explain

Balazs Halasy

Tuesday 22 June 2004 1:15:05 am

I would suggest that you back up your database (even if it is corrupt) before you do anything else:

mysqldump -u <user> -p <pass> <db_name> > backupfile.sql

When you've backed it up: try to create a new root node by doing as Bjørn says. Finally: you can try to do manual restore from trash, node-by-node. Good luck!

Balazs

Baur Aibek

Tuesday 22 June 2004 2:02:40 am

all is ok
root repaired
we have restored site manually

thanks to all