[opencms-dev] backup problems

Thomas Maerz thomasmaerz at gmx.de
Fri Apr 15 13:30:10 CEST 2005


Timo Eissler <timo.eissler at dtnet.de> writes:

> Can me anyone explain what´s the best way to backup opencms and how i 
> can test this backup?
>
> I already searched a howto on google, but i didnt find matching site.

I use

,----[ http://dev.mysql.com/doc/mysql/en/backup.html ]
|  You can also simply copy all table files (*.frm, *.MYD, and *.MYI
|  files) as long as the server isn't updating anything. The mysqlhotcopy
|  script uses this method. (But note that these methods do not work if
|  your database contains InnoDB tables. InnoDB does not store table
|  contents in database directories, and mysqlhotcopy works only for
|  MyISAM and ISAM tables.)
`----

I update my development data by copying 
mysql at live:/var/lib/mysql/opencms to mysql at dev:/var/lib/mysql/opencms

That's it. Maybe update permissions and restart MySQL.

Regards,
Thomas




More information about the opencms-dev mailing list