Doc tools: Log in
|Line 9:||Line 9:|
== Making Backups ==
== Making Backups ==
of databases the export button in the sidebar to the database or table . You can restore the import button in the sidebar. To make restoring easier, we suggest you backup individual databases or even individual tables .
You can access both your MySQL and PostgreSQL databases using Adminer, though not both at the same time. This application can be found on https://adminer.ulyssis.org. To login you need to use your MySQL or PostgreSQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your passwords you can get it from your websites configuration file. This is usually called config.php, wp-config.php, settings.php or something similar. To use MySQL, please use the server mysql.ulyssis.org. In case of PostgreSQL, please use pgsql.ulyssis.org.
When logging in using MySQL, you will see an overview of all your databases. When using PostgreSQL you will see all databases that have been created by all of our users (this is a known problem with Adminer), though you won't be able to view them.
You can then view databases and tables. For each table you can view the records, view and change the structure, add records, take backups, etc. Sadly no official documentation is available, though Adminer has a forum where you can ask for help.
Adminer has an export option which can be used to backup the structure and/or data of databases and tables. When no database or table has been selected, the export button in the sidebar allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported. You can specify to save the file, in what format, and whether structures and data should be dropped, truncated or created. You can later restore backups by uploading the file through the form available through the import button in the sidebar. To make restoring easier, we suggest you backup individual databases or even individual tables and use the SQL format.