Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Unable to restore the Plesk psa database: ERROR 1813 (HY000) at line 104: Tablespace for table '`psa`.`tablename`' exists. Please DISCARD the tablespace before IMPORT
- Unable to delete MS SQL database in Plesk: User does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks
- Unable to export MySQL dump for a domain in Plesk: insufficient privileges to SHOW CREATE
- Unable to access Plesk with 500 error message: [2002] No such file or directory
- A PHP-based website fails to open: Failed to connect to MySQL: Access denied for user 'jdoe'@'localhost' (using password: YES)
- MySQL service fails to start on a Plesk server: Table 'mysql.user' doesn't exist
- Unable to add external database server in Plesk: 1044 Access denied for user
- How to restore Plesk system databases from a Plesk daily/pre-upgrade dump
- Websites configured with PHP 7.2 or lower version fail to establish a database connection after updating MariaDB to v10.2.35 or v10.3.26: Malformed communication packet
- Restoration of a database fails in Plesk: errno: 140 "Wrong create options"
- Unable to export database via phpMyAdmin in Plesk: Argument 5 passed to PhpMyAdmin\Export::getFilenameAndMimetype() must be of the type string, null given
- How to switch database server from MySQL to MariaDB on Plesk Obsidian for Windows
- Is it possible to install PostgreSQL 10.x on CentOS 7 with Plesk?
- Diagnose & Repair tool detected issues with the database: Checking the Plesk database using the native database server tools
- Backup failed with the error in Plesk: 1049 Unknown database 'example'
- Checking the consistency of the Plesk database shows: Inconsistency in the table 'smb_roleServicePermissions' for the column servicePermissionId: No rows in the table 'smb_servicePermissions' with id = 1
- Remote connection to MySQL database hosted on Plesk fails: ERROR 2003 (HY000): Can't connect to MySQL server
- MySQL error on the server with Plesk: Could not increase number of max_open_files to more than 16384
- Domains show Plesk default page: web service cannot operate: the IP address list with ID 101 is empty
- Cannot import database dump in Plesk: Index column size too large. The maximum column size is 767 bytes
- InnoDB corruption occurs in MariaDB on Plesk server after reboot: Unspecified GSS failure
- Exporting a database dump in Plesk fails: There is not enough space on the disk
- Unable to add new MSSQL database in Plesk: mssqlmng failed: Login failed for user 'jdoe' at (VADOConnection::open line 48) at Unable to ADO conect with connection string
- Microsoft SQL Server support in Plesk
- Plesk was partially removed by mistake along with psa database
- Unable to export mysql database: Unable to backup database 'db' (Error code 21)
- Which MariaDB versions are supported by Plesk?
- Unable to create a subscription/domain or switch the Hosting type to website hosting in Plesk: User account already exists
- Unable to add new records to database via MyLittleAdmin in Plesk: example.com redirected you too many times
- MariaDB does not start after update on November the 5th: Assertion failure in file