Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- How to import PostgreSQL database dump?
- Database importing hangs in Plesk: Got an error reading communication packets
- How to connect to MSSQL server from Plesk interface?
- How to upgrade MySQL 5.6 to 5.7 on Plesk Onyx for Windows?
- How to add an existing database to Plesk from the remote MySQL server to a subscription
- How to enable remote access to PostgreSQL server on a Plesk server?
- Migration fails: MySQL server has gone away
- How to set a default database server for customers' databases in Plesk
- Cannot update master IP address for slave DNS zone in Plesk: DNS Inconsistent zone : The NS record IN NS has no address records (A or AAAA)
- Unable to clone a WordPress instance that contains VIEW with a database user as DEFINER in its database: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
- Is it possible to use a remote database server for Plesk and system databases?
- Plesk is not accessible and MariaDB service cannot start: InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
- Upgrade of MySQL schema with mysql_upgrade fails with the error: Error: Incorrect database name '#mysql50#.ssh'
- How to change the max_user_connections value in MySQL/MariaDB on a Plesk server
- How to register an existing database in Plesk
- Unable to remove a database marked as "Used by an installed web app" in Plesk
- Unable to import a database dump: Cannot add or update a child row: a foreign key constraint fails
- How to change the innodb_log_file_size value in MySQL/MariaDB
- Attempt to connect or drop psa database hangs: Native table 'performance_schema'.'session_variables' has the wrong structure
- Database import fails: There can be only one TIMESTAMP column
- Unable to restore database backup InnoDB: Error: Table "mysql"."innodb_table_stats"
- Failed to login to the client's MySQL using Plesk admin credentials
- Is it possible to add MS SQL server in Plesk based on Linux system?
- A MySQL query executed in phpMyAdmin/PHP script fails when the ONLY_FULL_GROUP_BY SQL mode is configured
- Cannot restart MySQL service from Plesk administrator panel on Linux
- How to create a database dump using PHPMyAdmin in Plesk?
- How to change default MySQL directory %plesk_dir%\Databases\MySQL\data to another one?
- How to add a new instance of existing MS SQL Server to Plesk
- Plesk and websites are not accessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
- How to add an already installed Microsoft SQL server in Plesk