Databases

Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.

How to upgrade MySQL from 5.1 to 5.5 on Plesk for Linux?
How to repair website MySQL/MariaDB databases and tables in Plesk?
Fail2ban jails not activated on Plesk server: NOK: ('database disk image is malformed')
How to manually create MSSQL database backup in Plesk?
MySQL/MariaDB crashes with error: Fatal error: cannot allocate memory for the buffer pool
How to change the PostgreSQL admin password in Plesk for Linux
Unable to create domain under a subscription: IP addresses for mail service of domain are not set
Unable to upload database with phpMyAdmin: Script timeout passed or 504 Gateway Timeout is shown
How to install and enable PostgreSQL database server in Plesk
Unable to remove a database in Plesk: This resource is used by installed web application
Unable to import/export an SQL Server database or apply the changes for a database user in Plesk: User or role does not exist in this database
Unable to repair MySQL using Plesk repair utility: Operation CREATE USER failed
Databases are not shown in MyLittleAdmin on a Plesk for Windows server: Retrieving data
Unable to add MySQL/MariaDB/MSSQL database in Plesk: the option is missing
How to access the Plesk psa database in MySQL/MariaDB
Dump of a MySQL/MariaDB database hosted on the Plesk server fails: mysqldump table doesn't exist when using LOCK TABLES
Cannot open phpMyAdmin for the database in Plesk: Access denied for user
How to manually back up or restore client MySQL/MariaDB database in Plesk for Windows
Plesk is not available: Unknown database 'apsc'
Plesk and/or websites are inaccessible: SQLSTATE[08004] [1040] Too many connections error
Database operations fail in Plesk for Linux: "Can't open file" or "Out of resources when opening file"
MySQL/MariaDB on the server with Plesk shows the error: Too many open files
How to fix InnoDB corruption cases for the MySQL/MariaDB databases on Plesk for Linux?
How to reset a password for the 'sa' user of a Microsoft SQL Server instance on a server with Plesk
Database importing in Plesk fails: ERROR 2006 (HY000): MySQL server has gone away
Plesk backup task and other operations complete with the error: "Access denied for user 'apsc'@'localhost'" or "Error while parsing DSN"
Unable to start MySQL/MariaDB after changing the innodb_log_file_size parameter: log file ./ib_logfile0 is of different size
It is not possible to manage MSSQL server in Plesk
Unable to start MySQL/MariaDB on a Plesk for Linux server: unknown variable
How to troubleshoot slow performance of MySQL/MariaDB on a Plesk server?