Using Adminer - Revision history

Pcy: fix typos

2019-11-10T21:25:03Z

fix typos

← Older revision		Revision as of 23:25, 10 November 2019
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. 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.		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 website's 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 your applications may stop working correctly.

	To use MySQL, please use the server <code>mysql.ulyssis.org</code>. In case of PostgreSQL, please use <code>pgsql.ulyssis.org</code>.		To use MySQL, please use the server <code>mysql.ulyssis.org</code>. In case of PostgreSQL, please use <code>pgsql.ulyssis.org</code>.

Bert at 17:48, 4 November 2019

2019-11-04T17:48:33Z

← Older revision		Revision as of 19:48, 4 November 2019
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. 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 <code>mysql.ulyssis.org</code>. In case of PostgreSQL, please use <code>pgsql.ulyssis.org</code>.		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 <code>mysql.ulyssis.org</code>. In case of PostgreSQL, please use <code>pgsql.ulyssis.org</code>.

	== Basic Usage ==		== Basic Usage ==

Bert at 17:48, 4 November 2019

2019-11-04T17:48:16Z

← Older revision		Revision as of 19:48, 4 November 2019
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. 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.		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 <code>mysql.ulyssis.org</code>. In case of PostgreSQL, please use <code>pgsql.ulyssis.org</code>.

	== Basic Usage ==		== Basic Usage ==

Bert at 00:49, 1 November 2019

2019-11-01T00:49:37Z

← Older revision		Revision as of 02:49, 1 November 2019
Line 9:		Line 9:
	== Making Backups ==		== Making Backups ==

	{{notice\|Keep in mind\|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. Please refer to [[Making Backups]] for more details}}		{{notice\|Keep in mind\|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. Please refer to [[Making Backups]] for more details.}}
	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.		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.

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

Bert: /* Making Backups */

2019-11-01T00:49:10Z

Making Backups

← Older revision		Revision as of 02:49, 1 November 2019
Line 9:		Line 9:
	== Making Backups ==		== Making Backups ==

			{{notice\|Keep in mind\|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. Please refer to [[Making Backups]] for more details}}
	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.		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.

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

Bert at 02:57, 11 September 2019

2019-09-11T02:57:31Z

← Older revision		Revision as of 04:57, 11 September 2019
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 ==

Bert: /* Making Backups */

2019-09-11T02:23:28Z

Making Backups

← Older revision		Revision as of 04:23, 11 September 2019
Line 9:		Line 9:
	== Making Backups ==		== Making 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.		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.

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

Bert at 14:12, 10 September 2019

2019-09-10T14:12:47Z

← Older revision		Revision as of 16:12, 10 September 2019
Line 7:		Line 7:
	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 [https://sourceforge.net/p/adminer/discussion/ forum] where you can ask for help.		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 [https://sourceforge.net/p/adminer/discussion/ forum] where you can ask for help.

	== ~~Taking~~ Backups ==		== Making 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.		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.

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

Bert: 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..."

2019-09-09T16:39:39Z

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..."

New page

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 [https://sourceforge.net/p/adminer/discussion/ 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.

[[Category:Databases]]