Documentation

Difference between revisions of "Making Backups"

(A backup of your databases)
Line 6: Line 6:
 
== A backup of your databases ==
 
== A backup of your databases ==
 
To take a backup of your database you simple use the export function of PHPMyAdmin, PHPPgAdmin and/or Adminer as described on [[Using PHPMyAdmin]], [[Using PHPPgAdmin]] and [[Using Adminer]].
 
To take a backup of your database you simple use the export function of PHPMyAdmin, PHPPgAdmin and/or Adminer as described on [[Using PHPMyAdmin]], [[Using PHPPgAdmin]] and [[Using Adminer]].
 +
 +
If you are backing up and/or restoring a larger database, it's advised to use command line tools since they are more performant than webtools and don't have any timeouts that could interrupt your backup/restore.
 +
 +
In case of MySQL, you can use mysqdump to take a backup:
 +
 +
mysqldump -h mysql.ulyssis.org -p username_database > backup.sql
 +
 +
This will prompt you for your database password (please refer to [Using MySQL] if you don't know your password) and then dump the entire database to backup.sql. To restore your backup you can use the mysql command:
 +
 +
mysql -h mysql.ulyssis.org -p username_database < backup.sql
 +
 +
Please keep in mind that by default mysqldump includes statements in the SQL file that will delete all tables that will be restored.
  
 
[[Category:Files]]
 
[[Category:Files]]
 
[[Category:Databases]]
 
[[Category:Databases]]

Revision as of 19:54, 31 October 2019

ULYSSIS takes backups of all files, databases, settings and repositories 1-4 times a week. These backups can be restored in case of severe server failure or in case of an emergency (if for example a user by mistake deletes all of their site). It is, however, more convenient that users take their own backups when they do experimental things on their account.

A backup of your files

You can use the graphical methods described in Accessing your files to download a copy of all of your files. This copy, or certain files, can then easily be uploaded again using the same method to restore backups

A backup of your databases

To take a backup of your database you simple use the export function of PHPMyAdmin, PHPPgAdmin and/or Adminer as described on Using PHPMyAdmin, Using PHPPgAdmin and Using Adminer.

If you are backing up and/or restoring a larger database, it's advised to use command line tools since they are more performant than webtools and don't have any timeouts that could interrupt your backup/restore.

In case of MySQL, you can use mysqdump to take a backup:

mysqldump -h mysql.ulyssis.org -p username_database > backup.sql

This will prompt you for your database password (please refer to [Using MySQL] if you don't know your password) and then dump the entire database to backup.sql. To restore your backup you can use the mysql command:

mysql -h mysql.ulyssis.org -p username_database < backup.sql

Please keep in mind that by default mysqldump includes statements in the SQL file that will delete all tables that will be restored.