Forum archive 2000-2006

Lars Jensen - Essential files to backup?

Lars Jensen - Essential files to backup?

by Arnold Pizer -
Number of replies: 0
inactiveTopicEssential files to backup? topic started 8/26/2004; 1:34:21 AM
last post 2/12/2005; 8:02:36 PM
userLars Jensen - Essential files to backup?  blueArrow
8/26/2004; 1:34:21 AM (reads: 1220, responses: 2)
Hi,

What are the essential course files in webwork2 that should be backed up to have a minimal backup?

In webwork 1 we used to only backup the set definition files of all courses, and all DATA directories.

Thanks, Lars.

<| Post or View Comments |>


userSam Hathaway - Re: Essential files to backup?  blueArrow
8/26/2004; 11:04:53 AM (reads: 1530, responses: 0)
Since set definition files are no longer essential to the operation of WeBWorK 2 courses, you don't need to back them up. However, you do need to back up the course database, regardless of whether it is stored in the DATA directory or in an SQL database. (See http://webhost.math.rochester.edu/webworkdocs/discuss/msgReader$2600#2612 for more information.)

An easy way to back up the course database is with the Course Administration database export tool. If you need to automate things, use the wwdb command-line utility. it is self-documented -- just take a look at the top of the webwork2/bin/wwdb file.

Here are the things I can think of that need to be backed up:

 

  • The course database
  • The DATA directory, which may contain database files
  • The course.conf file, if it exists
  • Any set definition files for sets that are not represented in the course database.
  • Any mail merge files (directory templates/email).
  • The scoring directory.

<| Post or View Comments |>


userLars Jensen - Re: Essential files to backup?  blueArrow
2/12/2005; 8:02:36 PM (reads: 1290, responses: 0)
Hi Sam,

Thanks! What minimum mysql databadse privileges are needed to do the backup of the database (using mysqldump) is SELECT and LOCK TABLES enough?

-Lars.

<| Post or View Comments |>