database

  1. S

    In Progress CPANEL-42266 - Addon domain converter - database prefixes

    So with the Convert Addon Domain to Account - the database name and database user name prefixes don't change? Is that wise? If you ask me, that's a recipe for disaster later on. So if user1 has an addon domain - myaddondomain.com - that's using a database - user1_wp1 and they want to split...
  2. charliecres

    Mysql database error

    facing this error after importing an SQL file to my server, but this SQL file working perfectly on another server! Note: (Server version: 8.0.31-cll-lve - MySQL) I have attached a screenshot for better view.
  3. X

    Removing an account does not remove the database

    Hi, First time this happen but on a new Linux VPS when I remove an account using the command: /scripts/removeacct xyz and try to restore the same account /scripts/restorepkg cpmove-xyz.tar.gz I get this message during the process of restoration: The system will restore the database...
  4. F

    Cpanel transfer completed but cannot find database

    Hi, One of the accounts which was transferred via cpanel transfer tool does not show databases in the database section in cpanel(New Server). It says that the databases already exist as when i try to create these manually. I can see the DBusers and password but cannot see the databases. DO i...
  5. V

    Ubuntu fresh install mariadb database server

    Hello On our Ubuntu 20.04 server, we were able to use the mariadb server by adding the line mysql-version=10.5 to the /root/cpanel_profile/cpanel.config file, but this setting no longer works. I see an error during the installation phase and the installation does not continue; 2022-12-23...
  6. M

    The system failed to grant privileges on the database ...

    Hello, Just made a backup restoration of account and this appeared: Warning: The system failed to grant privileges on the database “new_db” to the user “new” because of an error: (XID ju8a2v) This system will not add the database user “new” to the database “new_db” because this user does not...
  7. ljj3

    In Progress CPANEL-41695 - Modsecurity Geo Database

    Is GeoLite2-Country-Locations-en.csv the file that ModSecurity needs to have Geolocation Database pointed to? I'm confused... My GeoIP.dat is very old, but the MAXMIND list of databases are al GeoIP2 which are not compatible with ModSecurity...
  8. N

    Change Database Server Name

    Hi, Previously I had a server that was hacked, and I saw a lot of mysql hostnames using huffingtonpost.co.za. And now I'm moving it to a 3x new server, but some cpanel accounts still display the huffingtonpost text on cPanel => Server Information (Server Name). Where can I edit the text? and...
  9. J

    Frequent Database Backups (Jetbackup)

    I'm using Jetbackup for backups. Used it for years. Works really well. I have several sites I want to backup the databases more frequently than once a day. A couple of the sites, there's a lot of things being updated in the database constantly. The most critical one is 1.3GB of data, 2.5...
  10. P

    Cannot Restore Database Backup

    Hi, When deleting all Wordpress posts before a specific post I accidentally deleted a bunch of categories, so I need to restore the database from the backup I made right before I did that. Problem is when I upload the backup I get the error: Error: SyntaxError: Unexpected token '<', "<!DOCTYPE...
  11. behinam

    could not be added to the database The request failed

    When I want to add a database to the user I give this error: could not be added to the database aaa_bbb”. The request failed. (Error ID: rcyg25) Ask your hosting provider to research this error in cPanel & WHM’s main error log. in Cpanel log show this error: Error from MySQL query: (XID...
  12. K

    Database Migration

    What's the fast way of copying a large database (size is around 150Gb) onto another server? Both old and new servers are cPanel ones and mariadb 10.5 version. I only need to move the db to another server.
  13. charliecres

    error establishing a database connection after upgrade mysql to MariaDB

    Last Night I upgraded MySQL to MariaDB 10.5. Currently, i am using cloudlinux. Now I am facing an error issue" error establishing a database connection"| after per 10-20 minutes it's getting this error for 1-2 minutes. I have tried to fix this. but unable to fix this issue. so need help to...
  14. G

    Force Wordpress to install in MyISAM instead of InnoDB

    I had a major problem last year with InnoDB, and had to completely disable it using: innodb_force_recovery=5 No one has been able to track down the actual error, so instead I had to change everything to MyISAM. Now I have a new account that wants to install Wordpress, but I keep getting...
  15. N

    csv cronjob to import in mysql database table

    Hello, I am having a CSV daily sent via ftp to my public_html folder on a website. I am trying to make a cron job to import it into database called "grijanjetuzla_stanjeracuna" in table "saldo" , and delete records in table "saldo" it next day so I can import it again with fresh data. This is...
  16. K

    terminated cpanel still working and using another site files and database

    Hi, I deleted/terminated a cpanel account for example test.com now if i go to test.com it shows the exact website as another site example.com on the server and also uses the other sites database after getting deleted why is this happening? is this a secutity issue?
  17. H

    1 Database, 2 Websites

    Hello Does anyone know if it is possible to have two website folders in public_html of the same Cpanel account use the same (1) database? The reason for this is while one site is running live a copy of the site can be running on a subdomain for maintenance..
  18. D

    whm "Manage Databases" does not see database copied in phpMyAdmin

    Hello, I recently copied a database in phpMyAdmin using the "Operations" interface. After copying, I intended to use whm's "manage databases" interface to adjust the permissions on the copied database as it was only to be use for development purposes. Unfortunately, the database does not show...
  19. S

    Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'?

    Hi All, I notice that some of our MariaDB 10.3 database have a mixture of MyISAM and InnoDB table types on them. Is it inherently "bad" to have both types of table on the same database? Or doesn't/shouldn't it make any difference? If it is ill-advised, then I guess we'll look into converting...
  20. S

    Corrupted Database Tables

    Hi, lately I've received 3 email with this in the Subject: "check_mysql has determined that there are corrupted database tables" The 1st few lines in the email contains: "cPanel & WHM has determined that the following database tables are corrupt: Database Error mysql...