database

Hello guys! Currently im accessing my plesk db with ssh. I want a nice CSV where I got everything I need. The past 3 days I tried to understand your database scheme, which worked. So far the important things for me are the tables: domains, Limits. I know I can see an overview in the...

In the middle of a backup received this error: Server Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine, query was: DESCRIBE `sessions` Type Plesk\Exception\Database Message DB query failed: SQLSTATE[HY000]: General error...

I foolishly deleted a subscription and database which I desperately need to retrieve (somehow). Luckily I do have a weekly backup of the server's file system which I can browse. I am unclear though as to the best place to find a downloadable .sql file as the server structure is large. I can...

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