database

Hi When I want to install cpanel on Centos 7.9, after the installation progresses, the following error appears and the installation process fails. [2022-01-17 11:52:29 -0500] [2771] (DEBUG): - ssystem [END] [2022-01-17 11:52:29 -0500] [2771] ( INFO): Completed execution of...

I use the api via root, for actions like WHM and Cpanel. In the chaos of creating a database and a mysql user associated with it, I don't see that there is an api call from whm, and I understand that there should be an option like the ones I use to create an addon domain, that is, a call to...

I am having some trouble getting a command line mysqldump to work. Once a day I want to do a mysqldump of my database to a backup. Below is the command line, and I can't get it to work with or without passwords. Does anyone know why? SHELL="/bin/bash" 35 1 * * 0 mysqldump -q...

My server has really slowed down recently. I think it's due to MySQL. Please find below the results from mysqltuner.pl. -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM...

i cant import a database via ssh or via phpmyadmin. its throwing some error like this ERROR 1118 (42000) at line 38669: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768...

In the past, either databases or usernames (A Google image search of the wizard shows the username was 7?) could have a max amount of 7 characters, and I've been 'stuck' in to using 7 characters ever since, until now when using the MySQL database wizard which shows the maximum characters (the...

Guys I was advised to do full database backup including system tables but not sure how to do that. I do not see this option in whm :)

Before I go ahead and update MariaDB from 10.3 to 10.5 can someone please confirm that 10.5 works correctly with v98 when using remote databases? Manage MySQL® Profiles still shows it only supports : MySQL versions 5.6, 5.7, and 8.0. MariaDB versions 10.1, 10.2, and 10.3. It was my...

Hi Guys If I want to just run the experimental "Database" Server Profile, do I need to buy a license? and if so, which one?

Or if I only revision my home folder with a few files added to gitignore, and not the database, will that not cause conflicts at later deployments? Thanks! Best regards!

I've been trying to figure out how to customize my PMA configuration (for a specific user, not necessarily everyone) forever, but the docs make no sense at all to me. At this point I'm led to find config.inc.php... great, but where is it? I'm using CentOS 7 and PMA 4.9.7, and the docs say it...

All websites on my server this morning were reporting "Error establishing a database connection". I rebooted the server through WHM and everything came back online - I assumed it was caused by an automatic update to WHM version 96.0.13 - 2021-07-19 [security] TSR-2021-0004. Is there a setting...

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