Databases

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

MySQL/MariaDB reports the error on a Plesk for Linux server: Cannot load from mysql.<table_name>. The table is probably corrupted
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