database

Hi, I want to change the database assigned to my online store in the Plesk settings. I already know how to link the application to a different database by navigating in the Prestashop file system to /app/config/parameters.php and editing the parameters. What I'm asking here is how do you...

Hello guys, we just did a restart, after that we get error: "DB query failed: SQLSTATE[HY000] [2002] No such file or directory" We need your help very urgent. What can we do, we can not restart mariadb? No access to plesk an no access to the websites...

Can some body help me to backup one of my database to google drive using cronjob GUI. I have installed the google drive extension and connected my account. I cannot afford the Premium backup scheduled option now. If possible to backup zipped sql?

Hello,,, When i click in check for issues, on Plesk Database show this msg: WARNING Checking the consistency of the Plesk database Inconsistency in the table 'SubscriptionOutgoingMessagesStats' for the column subscriptionId: No rows in the table 'Subscriptions' with = 8 If i click in...

Im about to upgrade my database from MariaDB 5.5 to 10.4 in my PLESK Obsidian install Ive decided to clean the database of all old and unused wordpress installs before i dump the database. Ive been deleting all the old and unused Wordpress instances, when i do im given the option to delete the...

Hi, I'm currently trying to install plesk with the autoinstall/one-click installer on Ubuntu Server 18.04 already running a (pre-existing) MySQL database. I'm stuck at this error: DATABASE ERROR!!! Database psa found, but version undefined ERROR while trying to find psa database which...

I'm full on my server and MariaDB crashes. I gave additional space and solved the capacity problem. However, MariaDB does not start. Why can't I start? Memory and space issues have been resolved. I used PleskRepair, but MariaDB does not respond. The following is the error content. ------- ●...

Fresh install of ‪Ubuntu 18.04.2 LTS‬ running Plesk Onyx Version 17.8.11 Update #60 Through the UI I've installed a a PostgreSQL localhost server with 3 database. As the main partition is 20GB I've moved the database to my /home partition which has more space. The process followed after I had...

Hello, I'm trying to automate the creation of a database whenever a domain is created, but I cannot seam to get it to work. I'm missing the part where I fetch the subscriber for which the new domain is created. . I'm running this line: plesk bin database -c ${NEW_DOMAIN_NAME} -domain...

Hello! Thank you in advance for your ideas on this issue. Some of our Clients have their own separate database servers (AWS) which are meant to be "PRIVATE" and for their own use only. We can connect successfully and it all works just 'fine'. The issue that we have is that when a user creates...

Hi, since long time I had no errors by running: # plesk repair all -n After testing today I got the following error under section Checking the structure of the Plesk database Wrong attributes for the column 'login' in the table 'sys_users': . [ERROR] - The attribute 'type' value mismatch...

Hi, When I try to restore a database backed up by Plesk via SQL Server Management Studio it fails. This is the message when I "Verify Backup Media": Backup media verification failed: C:\Program Files (x86)\Plesk\PrivateTemp\pmm-mssdp-dd-dump-474b75d579244201a02390dd59fe474c...

Hello, I just have a problem with two Wordpress pages of a client. The customer has three Wordpress pages. Today I have edited a Wordpress page of the client via the Wordpress extension. I applied the security rules for an instance. After that two Wordpress pages from the client had the error...

Please help me figure out - how can I create and manage my own separate database? I use this code: #DB connect $ pdo = new PDO ('sqlite: /root/db.php'); $ pdo-> setAttribute (PDO :: ATTR_DEFAULT_FETCH_MODE, PDO :: FETCH_ASSOC); But nothing happens, there is a connection to the database but I...

The Plesk database ("psa") has some InnoDB tables without primary key. This is bad for performance, and incompatible with multi-master replication. It needs fixing. - psa.BackupsSettings - psa.SBConfig -...

how to change the MySQL and web directory in Plesk for Linux? My idea is to have the database on one disk and the Web on another, I have already changed the mail directory, setting in the file /etc/psa/psa.conf. Disk1 = SO Done Disk2 = Database Disk3 = Web Disk4 = Mail Done

Hello guys! I've been fiddling around with the webinterface and the "CSV Extension". Unluckily it is nearly impossible to merge multiple CSV sheets, which I extracted from the webinterface, into one big CSV which contains EVERY info about ServicePlan,Subscription,Domain. I dont see any other...

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...