If you have followed the Site backup instructions and created a backup of a LMS site, you may need to know how to restore the site backup you created.

There are 3 areas that could be restored individually or together:

• LMS code
• LMS uploaded or created files
• LMS database – MySQL, Progres or other

The location and names of these areas can be found in the Configuration file.

Command line (linux) restore

Here is a set of basic steps that make up the restore process.

1. Rename the original LMS directory to something different (so you still have it) and copy the backed up LMS directory or a newly downloaded LMS directory in its place.

2. If you are running MySQL, a backup of the database should be a .sql, .gz or .tar.gz file. If it is .tar.gz or .gz you need to extract it until it is an sql file.

tar -xzvf lmssqlfile.tar.gz

3. If you are running mysql, import the SQL file back into a newly created database on the MySQL server. Be careful here, some backups try to import right back into the same working database that LMS is connected to. This causes database problems that damage a LMS installation. The best thing to do is make a new database, restore the backed up database into it, and change the LMS config.php file to connect to this new database (this way you still have the original database).

Once you have created the new database:

mysql -p new_database < lmssqlfile.sql

For other databases, follow their instructions for restoring a backup.

Tools for site backup and restore

• phpMyAdmin
• MySQLdump

Tools for backing up data files

Restore with phpMyAdmin

Restoring a backup of a MySql database

1. Open the database to restore
2. Click the SQL tab.
3. On the “SQL”-page , unclick the show query here again.
4. Browse to your backup of the database.
5. Click Go.

See also

• Site backup
• Site restore for low-tech users
• Backup and restore FAQ
• Course restore