Doc tools: Log in
(→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]] |
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.
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
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.
© ULYSSIS VZW