Using Adminer

From ULYSSIS documentation
Revision as of 17:39, 9 September 2019 by Bert (talk | contribs) (Created page with "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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

Basic Usage

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.

Taking Backups

At all stages of browsing databases using Adminer you can use the export button in the left sidebar to backup the database(s) or table(s) you're viewing. You can then restore your backup using the import button in the sidebar. To make restoring easier, we suggest however you backup individual databases or even individual tables.