database

i need to restore one database from one server to new server with new username. For Eg: Existing database name like cpanelusername1_dbname.sql. i need to restore the content of these database to new server with cpanelusername2_dbname. Is this possible.

Hello, i have imported an database via this command : mysql -u root < all_databases.sql after it, everything stopped working. WHM >> phpmyadmin this is also not working. cPanel's phpmyadmin also not working. mysql server is offline. in whm >> phpmyadmin i am getting this error ...

I need to transfer a single cPanel account from one VPS to another. Source is running cPanel 86.0.40 while target running 96.0.11. While I attempting to transfer using the Transfer tool, I get the following message: Source: “x.x.x.x” Roundcube database type is “mysql” … Target...

Hello dear, today I have the following question, I want to move or duplicate a database from user1 to user2 the database is very large and it is I need to have this database in another account / another user always from the same server user1 -> BD move or copy it to user2 if this is not...

Hello On 3 websites I have running on a WHM server using cPanel over the last few weeks I have an "error establishing connection to database". This error has appeared out of the blue with nothing being done to any of the websites as they are all brochure sites.. They instantly fixed...

I cannot add user to database. I tried by creating user and database in MySql Database Wizard and database and user is created successfully but at last it shows Error ID: ww9ydv. When I tried to add manually in MySql Databases, its same issue there.

Hi Guys We've just had to change our local network address range and we have a separate MariaDB database server. I logged into mysql and updated all of the hostnames in mysql.user and ran FLUSH PRIVILEGES, but the web sites still can't connect to the db server. I also tried to update the...

I have gotten this error twice now... WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships AS tr ON...

As I have many times before, I just logged in to user's cPanel to delete a no longer needed database, it seemed successful, and I removed the DB user as well. But then the database (with no user) mysteriously came back a couple minutes later while I was working in the user's cPanel. Tried...

I'm unable to add user to the database. When I do all privilege and do make changes, it keeps loading for sometime and stops. When I go back, it is not added.

I'm installing the wordpress and with the database but unable to do it.

Hello, When you click on manage databases from the list on the left (main cpanel home interface) .. it doesn't show all databases on the system. I'm guessing it only shows databases activity tied to an account. However, if you use the transfer tool and transfer a site, and it messes up in...

Hi! I did not find any answer in the forum yet for what I wish to do. We have an external system that backups our entire machine, which allows us to restore the full machine, or access individual files. In that sense, we do not need to backup the accounts, nor the system. But for backups to...

Hi, When I click on databases in cPanel, such error appears. MariaDB 10.3

Hello team and everyone, I'm system admin in Vietnam. I just migrate all accounts from old server named h1.mydomain.com.vn to the new server named test.h1.mydomain.com.vn. The domain test.h1.mydomain.com own its cPanel SSL. So I need to change the hostname on new server to h1.mydomain.com.vn...

Roundcube - sqlite DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. I got this error for a few accounts only and after migrate from a server with roundcube in mysql all accounts migrated with transfer tool. New server have sqlite...

Hi, i want to add Geolocation db in modsecurity config... looking to the description: so it appears ModSecurity accepts only GeoIp v1 format in the maxmind i found only Geoip2 database... any suggestions please??thanks a lot

Hello, we are considering to shut down the PostgreSQL Database Server to try and save memory and resources. It seems PostgreSQL is not very popular. Before we disable PostgreSQL on our server, how can we find out if anyone is actually using it? Is there a way to see if any user has created a...

Hello guys. Today, sudenly one of the servers showed this error when trying to access Roundcube from any of the accounts. DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. My current server: CENTOS 7.8 kvm cPanel v90.0.10 mariadb...

Hi, I have a server with disk quota problem, I removed old databases but when use command "df -h" not appear the new free disk quota. -Before remove database: df -h / -> 94% -After remove database (I calculated should get 2.5%): df -h / -> 94% too Why happened?. Too I used the command "lsof...