database

Following the instructions here, I was able to get my zipped database SQL Server backup file (.bak) uploaded to the Files area: The database and its tables do exist, but they are currently empty: So how can I get get the database file (uploaded to the Plesk Files area) to populate my...

I am facing database backup issues with Wordpress.

Hi, I am using a webhost in order to keep track of some user information (just a test at this point) using MySQL and PHP. I have created a (actually several) user in order to connect to my database, and this entire process used to worked fine until a few weeks ago, but now I encounter PHP Error...

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