AW: AW: [opencms-dev] Use existing tables with a new OpenCms
arash.kaffamanesh at pomegranate.de
Tue Oct 18 20:08:25 CEST 2005
You can use mysqldump to write the dump to the filesystem:
C:\mysql\bin> mysqldump -u root opencms -p > c:\temp\opencms.sql
Install OpenCms from scratch, delete the DB, create a new DB with the
same users root and possibly opencmsuser and restore the dumped file
like this: (you can create the db with mysqladministrator or otrher
clients of your choise)
C:\mysql\bin>mysql -uroot -Dopencms < c:\temp\opencms.sql -p
Enter password: ********
Restart tomcat, you are done.
The another easier way is to copy the c:\mysql\data\opencms of your
orginal opencms db to another folder (e.g c:\temp) and install opencms
from scratch to a new db, delete / move the new db and copy back your
original opencms db (from c:\temp) under c:\mysql\data\, this works on
windows, on linux you have to set the righs properly with "chown -R
root:root /opt/mysql/data/openmcms/, but the first solution over the
shell is faster and safer (at least for me on linux or even windows).
> If I was OpenCms I would complain about somebody trying to exchange
dbs right under my nose...
;-) why? No OpenCms doesn't care about it, because you shall have root
and admin rights to do that!
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Nick Panienski
Sent: Dienstag, 18. Oktober 2005 19:28
To: 'The OpenCms mailing list'
Subject: AW: AW: AW: [opencms-dev] Use existing tables with a new
Thanks Michael and Arash for the tips, I managed to export the database
through the legacy administration of my criples installation and now I
can install OpenCms from scratch and import the content again.
Arash, how excatly do you do your backup? With MySql Admin I exportet
the whole opencms schema. Do you reinstall OpenCms and then just import
back the Sql Backup file? Sounds way too easy ;) If I was OpenCms I
would complain about somebody trying to exchange dbs right under my
> -----Ursprüngliche Nachricht-----
> Von: Arash Kaffamanesh [mailto:arash.kaffamanesh at pomegranate.de]
> Gesendet: Dienstag, 18. Oktober 2005 17:42
> An: 'The OpenCms mailing list'
> Cc: 'Nick Panienski'
> Betreff: RE: AW: AW: [opencms-dev] Use existing tables with a
> new OpenCms
> Hi Nik, hi Michael,
> As described bevor, you could dump back your db and export
> your modules (which is in the DB fortunatelly) and restart
> tomcat perhaps, the the world is ok. again :-) I did that
> several times and it worked allways, believe me Nik!
> Don't forget in the future to backup your /webapps/opencms
> folder on RFS too ;-)
> Kind Regards,
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Michael Moossen
> Sent: Dienstag, 18. Oktober 2005 17:22
> To: The OpenCms mailing list
> Subject: Re: AW: AW: [opencms-dev] Use existing tables with a
> new OpenCms
> Hi, Nick!
> > seems some of the modules (workplace) have to be selected
> during the
> > installation?!
> not really, but i forgot an important point:
> you also have lost your configuration files. including the
> opencms-modules.xml. sorry for that.
> now you have to get one from somewhere else. may be Arash'
> idea was better...
> Michael Moossen
> Alkacon Software GmbH - The OpenCms Experts http://www.alkacon.com
> Quoting Nick Panienski <panienski at codecentric.de>:
> > Hi Michael
> > > > You have not created the OpenCms database.
> > > > You cannot import the modules successfully without the
> > > database and tables!
> > > this is just a warning.
> > Ah, thanks, sure I could continue, after the installtion
> the login to
> > the OpenCms Web Gui is successfull but then I get 404s in
> parts of the
> > page (VFS tree to the left), seems some of the modules (workplace)
> > have to be selected during the installation?!
> > Bye
> > Nick
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> To change
> > your list options, or to unsubscribe from the list, please visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
> This message was sent using IMP, the Internet Messaging Program.
> This mail is send to you from the opencms-dev mailing list To
> change your list options, or to unsubscribe from the list,
> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
More information about the opencms-dev