Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'X' for key 'PRIMARY'
- How to back up/restore Plesk system databases
- Is it possible to setup MS SQL replication in Plesk?
- Plesk database: Inconsistency in the table 'MailOutgoingMessagesStats'
- [FIXED BUG] In Plesk Obsidian for Linux, exported database dump is downloaded multiple times if the option "Automatically download dump after creation" is enabled
- [FIXED BUG] Unable to create MSSQL databases: There are no available resources of this type (MySQL databases) left
- [FIXED BUG] PHPmyadmin templates are removed after updating Plesk
- MariaDB does not start after update on November the 5th: Assertion failure in file
- [FIXED BUG] Error on attempt to create new database or user: Unable to find row with id in DatabaseServers table
- Unable to repair Plesk database using Repair Kit: Checking the consistency of the Plesk database Inconsistency in the table 'ModuleSettings' for the column module_id
- [BUG] MariaDB 10.3 error after upgrade: Plugin 'unix_socket' is not loaded
- MariaDB 10.4 support in Plesk
- [FIXED BUG] MSSQL databases take long time to load on Plesk server
- [BUG] Cannot add PostgreSQL with custom port in Plesk: Is the server running locally and accepting connections on Unix domain socket
- [FIXED BUG] Wrong email specified for WordPress administrator after creating a subscription with automatic provisioning WordPress installation
- [BUG] MySQL instance is stopped and set as Manual Startup during Updates
- [BUG] Unable to create Mysql database in Plesk: Database user name is invalid. Only latin letters are allowed in the database user name
- How to increase upload dump size in phpMyAdmin?
- How to allow/deny customers to choose a database server when creating a database in Plesk
- MariaDB logrotate on Plesk server reports error: logrotate_script: 3: [: /var/run/mysqld/mysqld.pid: unexpected operator
- Unable to change PostgreSQL admin password or log in to PostgreSQL on Plesk: psql: FATAL: Ident authentication failed for user "postgres"
- Unable to access the Drupal website: Insufficient value for max_allowed_packet option
- [BUG] Error when running a query inside PHPMyAdmin in Plesk for Windows Server: unrecognized statement type (near lock)
- Unable to remove database server: A database server should not be deleted while databases or database users are hosted there
- [FIXED BUG] Websites show garbled characters after Plesk update
- Multiple Vulnerabilities in Oracle MySQL Server before 5.7.25, 5.6.43: potential Unauthorized access
- [BUG] Unable to connect to Plesk server via FTP to any account
- Unable to import a MySQL dump via phpMyAdmin: Operation hangs on FOREIGN_KEY_CHECKS
- Option to export table in SQL format is missing in phpMyAdmin on Plesk
- How to enable the MySQL slow query log on Windows Server