database

Hi there, I am currently migrating all my customers to a new server. This is what I do: 1. Go to customer on old server and make full backup to ftp backup server 2. Create customer on new server 3. Add the same ftp credentials to the new customer in backup manager 4. Import recently made...

(Plesk Onyx 17.8.11) I have a domain and a database connected to it. I have set the settings to 'Allow remote connections from any host' and created a user. When I try to connect to it from an external programm (datagrip) it gives this error: (database and host.com are the databasename and the...

Consulta DB fallida: SQLSTATE [42S02]: Tabla base o vista no encontrada: 1146 Tabla 'psa.sessions' no existe, la consulta fue: DESCRIBE `sessions` hi, someone could help me!!!!!!! thanks!!!!!

Hi, When i install the latest MariaDB 10.3.8, do i'll found some problems by creating a subdomain at my website and can't proceed any further. DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5' for key 'PRIMARY', query was: replace DomainServices set...

Hi, We are attempting to migrate some wordpress sites residing in a shared server to a new exclusive server on Plesk. Old shared server -We have moved all original files from the shared servers using FTP -The respective databases were exported without compressing to ensure integrity. New...

how to configure plesk database remote access settings? can anyone tell me step by step guide because i'm noob to this field

Hi, I've noticed lately that sites installed by the WP Toolkit create databases that have no Plesk username prefix. i.e. the complete database name is something like "wordpress_v" (whereas it should be "pleskuser_wordpress_v") I've checked my Database Hosting Settings and I have 'username'...

Hello, I have downloaded and installed the latest NextCloud docker image and set the port and firewall configurations properly. I am welcomed by the NextCloud installer and choose to use the MySQL / MariaDB database and made sure that I entered the correct login details. However, NextCloud...

Hi , since nowadays centos7 comes out with MariaDB 5.5 so any plesk I installed on centos7 , it is already binded with mariadb how can I switch to Percona or Mysql ? because all I googled out is about change from mysql to mariadb, no vice versa.

I'd like to request that the "Recreate the database" option that shows when importing a database be unchecked by default. This is definitely my fault for moving too quickly: I imported a single table dump and forgot to uncheck that box, causing the entire database to be wiped out. I had just...

Hi I have a dedicated mysql server to host the clients' databases. I have the need to turn off this dedicated server. In order to do this, I need to migrate the databases that are on this dedicated server to the server where plesk is installed. How should I proceed? Thank you

My subscription was suspended because I exceded database quota by testing database. I want to delete test database but I can't because the plesk interface is blocked. How I can delete database and unblock subscription? Help!!!

Hi, anyone know how to solve this? I'm missing a few MySQL users after using the Plesk Migration tool to migrate from an old server to a new server. Both using Plesk. I see all the databases migrated to new server, but not all the users. Thanks!

Hello, today I've searched for a solution to my Problem but wasn't able to find something that can help me. I got a Subdomain with 3 Databases. Now I want to make a Backup of that Subdomain but with only two of these three Databases. Is there a way to exclude a specific Database from the...

Good night. I think I've found a possible bug. I have a signature with a database called db_one. When I click on the phpmyadmin url, the database opens and the tables are displayed correctly. I needed to create a second database called db_two. There is no table in it. When I click on the...

Hi I'm having a issue with connecting my percona cluster with plesk. everytime i try to connect from plesk (tools&settings -> add database) to the percona cluster i get this error: Error: The test connection to the database server has failed because the supplied account does not possess...

In the DB list, if you have more than 1 database, only 1 DB can be assigned to a domain. If you assign a different one, the one that was related b4 is un related, because it has the option to assign to a domain, instead of being related. z

Hello, I've got a problem on my plesk panel. Actually, everything works well (all my websites are running) but I cannot manage my database server from plesk. Plesk tell me that it cannot connect to the server. In addition, when I try to create a new user on this database, i've got this message...

I'm attempting to create an additional database server on port 3307, although because the port apparently doesn't open after creating another firewall rule specifically for it the database server cannot be created. I checked the port via nmap and it appears the firewall rule does not...

Hello, i have the following problem in the Plesk Onyx Backup Manager and console: mysqldump: unknown variable 'tmpdir=/var/tmp' System: CentOS 7x MariaDB 10.1 my.cnf: [mysqld] bind-address = 127.0.0.1 skip_name_resolve tmpdir=/var/tmp log-error=/var/log/mariadb/mariadb.log local-infile=0...