AW: AW: [opencms-dev] Use existing tables with a new OpenCms

[Arash Kaffamanesh]

Ups:

This line:

C:\mysql\bin>mysql -uroot -Dopencms < c:\temp\opencms.sql -p Enter
password: ********

Shall be so:

C:\mysql\bin>mysql -uroot -Dopencms < c:\temp\opencms.sql -p

-----Original Message-----
From: Arash Kaffamanesh [mailto:arash.kaffamanesh at pomegranate.de] 
Sent: Dienstag, 18. Oktober 2005 20:08
To: 'The OpenCms mailing list'
Cc: 'Nick Panienski'
Subject: RE: AW: AW: [opencms-dev] Use existing tables with a new
OpenCms


Nick,

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!

HTH,
Kind Regards,
Arash



-----Original Message-----
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
OpenCms


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
nose...

Cheers
Nick 

> -----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,
> Arash
> 
> -----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...
> 
> HTH
> --
> Regards
> 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
visit http://mail.opencms.org/mailman/listinfo/opencms-dev