[opencms-dev] How to backup/restore?

[cherif]

Hi  Anatol,

1--> if the new version did not change  the database structure
definition(tables naming and length ...) then restoring the dump should work
2--> if the new version adds new tables and the "old" tables remain
inchanged, the restore will juste load the old tables leaving the new
inchanged (unknowon of corse)
3--> with this method, you don't merge but erase.
4--> I think the real care is for the data not the meta data
5--> after dumping your backup is juste a texte file so you can use a texte
editor to view it --and make any chages you want

----- Original Message ----- 
From: "Anatol" <opencms at recordcaster.de>
To: "The OpenCms mailing list" <opencms-dev at opencms.org>
Sent: Monday, June 06, 2005 1:49 PM
Subject: Re: [opencms-dev] How to backup/restore?


> Hi Arash, hi all!
>
> ark-d at betasystems.com schrieb:
>
> >you can dump and restore your mysql db:
> >
> >Dump:
> >mysqldump -u<username> -p<password> <database name> > <output file>
> >
> >Restore:
> >mysql -u<username> -p<password> <database name> < <input file>
> >
> >
> If it is for the same opencms version your approch sounds good :-) But,
> what ist, when a new version of opencms (the final comes in a few days,
> I assume ;) ) was published? In this case you would restore with your
> mysqldumps an old system. Right? How can I merge a new blank
> installation with old data? Is it possible to dump some special tables?
> And if, which tables should be backuped and  which not?
>
> Greetings
> Anatol
>
>
>
> _______________________________________________
> 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
>