Tag Archives: Databases

Hello, hope all of you are doing great today Maybe someone has encountered such a problem and can help me. ShareTweetPostPin It!

Ever since I updated MariaDB, I have been having issues every now and then with queries getting stuck and breaking the website for everyone. What happens is that there is some intensive or problematic query that’s started, the /tmp drive Continue reading Issues ever since I updated to MariaDB 10.6→

I want to take advantage of an external managed database (similar to AWS RDS). I understand it’s possible with cPanel server. I also want to be able to use phpmyadmin to manage the external database. Can you please offer some Continue reading how to connect between managed database→

Hello, i have a strange situation with OOM killer. Every 14 or 15 days at exactly 14:10, Cpanel kills mysql with out of memory message. I checked logs, cron jobs, everything. Nothing happens at that particular time frame. ShareTweetPostPin It!

Hello I had a WordPress website wit the domain “domain.com” in a hosting (let’s call it A), and now i have a new hosting (B) and i want to move the site in the old hosting(A) to the new one Continue reading Problem moving my database to a new server→

I want to take advantage of an external managed database (similar to AWS RDS). I understand it’s possible with cPanel server. I also want to be able to use phpmyadmin to manage the external database. Can you please offer some Continue reading how to connect bextwrnal managed database→

Hello. This one popped up today, first time it’s been reported. /usr/local/cpanel/logs/error_log: ShareTweetPostPin It!

Hello, mySQL version 8.0.35 CloudLinux v8.8.0 STANDARD standard ShareTweetPostPin It!

Hi I have the following in my server: As you can see myql is hugging 40 Gigs in VIRT and 6 Gigs in RES. ShareTweetPostPin It!

Hallo, I wanted to upgrade MySQL according to the CPanel instructions in preparation for switching from CentOs to AlmaLinux. The upgrade checker when upgrading from MySQL 5.7 to 8.0 shows the following result: Errors: 3 ShareTweetPostPin It!

I’m trying to validate a new MySQL 8 Server running on AlmaLinux 9 and when I try to validate the profile, I get the error – Failed to “validate” Remote MySQL profile. 1 error occurred. The MySQL server uses the Continue reading Validating New Remote MySQL Server→

hello with ShareTweetPostPin It!

cpanel restoration error Warning (“MysqlBase::_do_cpanel_mysql_with_newuser_privs”, line 599): Error from MySQL query XID s48fmk) The system received an error from the “MySQL” database “mysql”: 1410 (You are not allowed to create a user with GRANT): ShareTweetPostPin It!

Hi, I face a prblem for migrating a database around 200mb from shared hosting to my own AWS Lightsail with WHM My current shared hosting disable backup function in cPanel. I can only export it from phpmyadmin or request provider Continue reading Migrate database from shared hosting to AWS Lightsail with WHM→

Hello, i am currently running Mysql 5.7 on cpanel/whm v110.0.7. I host a couple of websites and i am not sure they ensure 100% compatibility with Mysql 8. ShareTweetPostPin It!

I didn’t know that this was a thing until yesterday :-O ShareTweetPostPin It!

Hi, after an error during update from CentOS7 to AlmaLinux 8 I lost completlly the Apache server. I installed it back, but now I am missing the MYSQL service with phpadmin. It is also missing in the Service Manager. Also Continue reading MYSQL service missing→

Hello, i have a question, is it safe to change routin for specific database like as CREATE DEFINER=`cpanelusername`@`localhost` ShareTweetPostPin It!