Documentation

Difference between revisions of "Using Adminer"

(Making Backups)
Line 1: Line 1:
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.
+
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. You can change your database passwords through our control panel [https://ucc.ulyssis.org/ UCC], but keep in mind to then also change the password in relevant configuration files, or you applications may stop working correctly. To use MySQL, please use the server mysql.ulyssis.org. In case of PostgreSQL, please use pgsql.ulyssis.org.  
  
 
== Basic Usage ==
 
== Basic Usage ==

Revision as of 03:57, 11 September 2019

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. You can change your database passwords through our control panel UCC, but keep in mind to then also change the password in relevant configuration files, or you applications may stop working correctly. 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.

Making Backups

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.