Making Backups - Revision history

Bert at 23:23, 6 November 2020

2020-11-06T23:23:52Z

← Older revision		Revision as of 01:23, 7 November 2020
Line 1:		Line 1:
	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 experiments on their account.		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). An account holder who made a mistake and would like certain files restored can simply send us an email explaining what has happened, why certain files or folders need to be restored, when things went wrong, and finally list those files or folders. We will then try to find a suitable backup from before the date and time where things went wrong. Keep in mind that restoring backups is a slow process. It is therefore more convenient that users take their own backups when they do experiments on their account and then remove those backups once the experiments are done.

	== A backup of your files ==		== A backup of your files ==

Pcy: fix typos

2019-11-10T21:19:47Z

fix typos

← Older revision		Revision as of 23:19, 10 November 2019
Line 1:		Line 1:
	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.		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 experiments on their account.

	== A backup of your files ==		== A backup of your files ==
Line 5:		Line 5:

	== 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 simply 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 ~~advisale~~ to use command line tools since they are more performant than ~~webtools~~ and don't have any timeouts that could interrupt your backup/restore.		If you are backing up and/or restoring a larger database, it's advisable to use command line tools since they are more performant than the web-based tools and don't have any timeouts that could interrupt your backup/restore.

	=== MySQL command line ===		=== MySQL command line ===

Yoa: /* A backup of your databases */

2019-11-05T22:26:26Z

A backup of your databases

← Older revision		Revision as of 00:26, 6 November 2019
Line 7:		Line 7:
	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.		If you are backing up and/or restoring a larger database, it's advisale to use command line tools since they are more performant than webtools and don't have any timeouts that could interrupt your backup/restore.

	=== MySQL command line ===		=== MySQL command line ===

Bert: /* A backup of your files */

2019-11-03T11:36:19Z

A backup of your files

← Older revision		Revision as of 13:36, 3 November 2019
Line 2:		Line 2:

	== A backup of your files ==		== 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~~		You can use the methods described in [[Accessing your files]] to download a copy of all of your files or specific folders you will be working on. If something goes wrong, you can easily restore files to a previous state by re-uploading those you have downloaded and saved.

	== A backup of your databases ==		== A backup of your databases ==

Bert: /* PostgreSQL command line */

2019-11-01T00:34:26Z

PostgreSQL command line

← Older revision		Revision as of 02:34, 1 November 2019
Line 26:		Line 26:

	=== PostgreSQL command line ===		=== PostgreSQL command line ===
			To take a backup, execute the following command on one of our shellservers (with the right database name filled in):

			pg_dump -h pgsql.ulyssis.org -W --clean username_database > backup.sql

			This will prompt you for your database password (please refer to [[Using PostgreSQL]] if you don't know your password) and then dump the entire database to backup.sql file as SQL with COPY statements. If you prefer INSERT instead of COPY statements, you can add <code>--inserts</code> to your command.

			To restore your backup you can use the pg_restore command on one of our shellservers (with the right database name filled in), whatever SQL file you specify will be executed:

			psql -h pgsql.ulyssis.org -W username_database < backup.sql

			Please keep in mind that because we specified <code>--clean</code> earlier, our SQL file includes statements that will delete all tables, sequences, functions and schemas that will be restored.

			If you wish to have more control over different settings when taking or restoring please, you can refer to the respective man pages of pg_dump and psql using <code>man pg_dump</code> and <code>man psql</code>

	[[Category:Files]]		[[Category:Files]]
	[[Category:Databases]]		[[Category:Databases]]

Bert: /* MySQL command line */

2019-11-01T00:18:40Z

MySQL command line

← Older revision		Revision as of 02:18, 1 November 2019
Line 22:		Line 22:

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

			If you wish to have more control over different settings when taking or restoring please, you can refer to the respective man pages of mysqldump and mysql using <code>man mysqldump</code> and <code>man mysql</code>

	=== PostgreSQL command line ===		=== PostgreSQL command line ===

Bert: /* MySQL command line */

2019-11-01T00:03:20Z

MySQL command line

← Older revision		Revision as of 02:03, 1 November 2019
Line 15:		Line 15:
	mysqldump -h mysql.ulyssis.org -p username_database > backup.sql		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:		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 file as SQL.

			To restore your backup you can use the mysql command on one of our shellservers (with the right database name filled in), whatever SQL file you specify will be executed:

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

Bert at 00:01, 1 November 2019

2019-11-01T00:01:29Z

← Older revision		Revision as of 02:01, 1 November 2019
Line 9:		Line 9:
	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.		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:		=== MySQL command line ===

			To take a backup, execute the following command on one of our shellservers (with the right database name filled in):

	mysqldump -h mysql.ulyssis.org -p username_database > backup.sql		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:		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		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.		Please keep in mind that by default mysqldump includes statements in the SQL file that will delete all tables that will be restored.

			=== PostgreSQL command line ===



	[[Category:Files]]		[[Category:Files]]
	[[Category:Databases]]		[[Category:Databases]]

Bert: /* A backup of your databases */

2019-10-31T18:54:54Z

A backup of your databases

@@ Line 6: / Line 6: @@
 == 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]].
 [[Category:Files]]
 [[Category:Databases]]

Bert at 16:56, 9 September 2019

2019-09-09T16:56:26Z

← Older revision		Revision as of 18:56, 9 September 2019
Line 5:		Line 5:

	== 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 as described on [[Using PHPMyAdmin]].		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]].

	[[Category:Files]]		[[Category:Files]]
	[[Category:Databases]]		[[Category:Databases]]