Using PHPMyAdmin - Revision history

Pcy: fix typos

2019-11-10T21:22:30Z

fix typos

← Older revision		Revision as of 23:22, 10 November 2019
Line 1:		Line 1:
	You can access your MySQL databases using PHPMyAdmin. This application can be found on https://phpmyadmin.ulyssis.org. To login you need to use your MySQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your MySQL password 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 your MySQL databases using PHPMyAdmin. This application can be found on https://phpmyadmin.ulyssis.org. To login you need to use your MySQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your MySQL password, 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.

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

	Once you've logged in, you will see your username on the left~~, you~~ can click the plus sign to reveal all your databases. 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. Detailed documentation is available on the PHPMyAdmin [https://www.phpmyadmin.net/docs/ official documentation website]		Once you've logged in, you will see your username on the left. You can click the plus sign right next to your name to reveal all your databases. 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. Detailed documentation is available on the PHPMyAdmin [https://www.phpmyadmin.net/docs/ official documentation website]

	== 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.}}
	PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can ~~later~~ restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.		PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can restore backups at a later point in time by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.

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

Bert at 00:49, 1 November 2019

2019-11-01T00:49:52Z

← Older revision		Revision as of 02:49, 1 November 2019
Line 7:		Line 7:
	== 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.}}
	PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.		PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.

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

Bert at 00:39, 1 November 2019

2019-11-01T00:39:30Z

← Older revision		Revision as of 02:39, 1 November 2019
Line 8:		Line 8:

	{{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}}

	PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.		PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.

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

Bert: /* Making Backups */

2019-11-01T00:39:22Z

Making Backups

← Older revision		Revision as of 02:39, 1 November 2019
Line 6:		Line 6:

	== 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}}

	PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.		PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.

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

Bert at 02:57, 11 September 2019

2019-09-11T02:57:16Z

← Older revision		Revision as of 04:57, 11 September 2019
Line 1:		Line 1:
	You can access your MySQL databases using PHPMyAdmin. This application can be found on https://phpmyadmin.ulyssis.org. To login you need to use your MySQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your MySQL password 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 access your MySQL databases using PHPMyAdmin. This application can be found on https://phpmyadmin.ulyssis.org. To login you need to use your MySQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your MySQL password 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.

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

Bert: /* Making Backups */

2019-09-11T01:43:06Z

Making Backups

← Older revision		Revision as of 03:43, 11 September 2019
Line 7:		Line 7:
	== Making Backups ==		== Making Backups ==

	PHPMyAdmin has an export option which can be used to backup the structure and/or data of databases and tables. When no ~~databases~~ or table has been selected, the export tab in the top menu allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported ~~on the export tab~~. You can either accept the default settings, or ask for more settings to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.		PHPMyAdmin 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 tab in the top menu 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 either accept the default settings, or ask for more settings, to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.

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

Bert: /* Making Backups */

2019-09-11T01:41:59Z

Making Backups

← Older revision		Revision as of 03:41, 11 September 2019
Line 7:		Line 7:
	== Making Backups ==		== Making Backups ==

	~~To take a~~ backup of all ~~your~~ databases you ~~simply select "Export" on~~ the ~~main menu and press start~~. You can later restore backups by uploading the file to the ~~"Import" page~~.		PHPMyAdmin has an export option which can be used to backup the structure and/or data of databases and tables. When no databases or table has been selected, the export tab in the top menu allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported on the export tab. You can either accept the default settings, or ask for more settings to specificy whether any checks, DROPs or time settings are required, as well as to specify if you wish to export the structure, the data or both. You can later restore backups by uploading the file through the form on the import tab. To make restoring easier, we suggest you backup individual databases or even individual tables.

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

Bert at 14:12, 10 September 2019

2019-09-10T14:12:56Z

← Older revision		Revision as of 16:12, 10 September 2019
Line 5:		Line 5:
	Once you've logged in, you will see your username on the left, you can click the plus sign to reveal all your databases. 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. Detailed documentation is available on the PHPMyAdmin [https://www.phpmyadmin.net/docs/ official documentation website]		Once you've logged in, you will see your username on the left, you can click the plus sign to reveal all your databases. 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. Detailed documentation is available on the PHPMyAdmin [https://www.phpmyadmin.net/docs/ official documentation website]

	== ~~Taking~~ Backups ==		== Making Backups ==

	To take a backup of all your databases you simply select "Export" on the main menu and press start. You can later restore backups by uploading the file to the "Import" page.		To take a backup of all your databases you simply select "Export" on the main menu and press start. You can later restore backups by uploading the file to the "Import" page.

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

Bert at 15:43, 9 September 2019

2019-09-09T15:43:49Z

← Older revision		Revision as of 17:43, 9 September 2019
Line 7:		Line 7:
	== Taking Backups ==		== Taking Backups ==

	To take a backup of all your databases you ~~simple~~ select "Export" on the main menu and press start. You can later restore backups by uploading the file to the "Import" page.		To take a backup of all your databases you simply select "Export" on the main menu and press start. You can later restore backups by uploading the file to the "Import" page.

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

Bert at 15:37, 9 September 2019

2019-09-09T15:37:25Z

← Older revision		Revision as of 17:37, 9 September 2019
Line 3:		Line 3:
	== Basic Usage ==		== Basic Usage ==

	~~On the left~~ you will see your username, you can click the plus sign to reveal all your databases. 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. Detailed documentation is available on the PHPMyAdmin [https://www.phpmyadmin.net/docs/ official documentation website]		Once you've logged in, you will see your username on the left, you can click the plus sign to reveal all your databases. 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. Detailed documentation is available on the PHPMyAdmin [https://www.phpmyadmin.net/docs/ official documentation website]

	== Taking Backups ==		== Taking Backups ==