database

  1. keat63

    MYSQL timezone support

    I'm seeing some PHP errors on one of my web sites. The coding guys are telling me that my server doesn't support MYSQL time zones. The server time is correct, and I can see its configured for the correct time zone. Do I need to enable something in MySql ?
  2. B

    How to convert all InnoDB to MyISAM & disable InnoDB ?

    Hello guys, I was searching in the last 2 days to convert all my innodb tables,databases to myisam because is the secand time i have problems witch innodb and i`m not able to fix the tables/databases, so i whant to stop using innodb at all for the entire server. I didnt found nothink clearly...
  3. B

    MariaDB problem after upgrading 10.1 to 10.3

    Hello guys, I upgrade MariaDB 10.1 to 10.3 and since i made this update i get " Error establishing a database connection " on some websites but lots of them. on the tail -f /var/lib/mysql/....hostname.err i dont have any errors at all, only this ones 2019-09-11 9:35:19 3051 [Warning] Access...
  4. A

    phpMyAdmin - Internal Server Error 500

    Hi Team, I tried to access phpMyAdmin on VPS Server getting 500 Internal Server Error and also my all Created cron jobs are deleted from server.. I try to create new cron and then newly created cron automatically deleted., Please resolve this issue on high priority bacause we dont access last...
  5. plague

    In Progress [CPANEL-29288] Non-Public Schemas in PostgreSQL Databases Do Not Restore

    Hello. Last week I had to move some server to new hardware and I noticed that postgres databases were transfered with empty data. The database was created in the new server, the user was created, but the database was totally empty. Data was lost. The transfer and restore log shows no error...
  6. Z

    MySQL Restore one account from Backup in WHM

    I currently have 'Entire MySql Directory' checked in my backup configuration. If I restore just one account, will only the databases from that account be restored, or will ALL databases from ALL the sites on the server be restored? Should I check 'per account only' instead? Or maybe per...
  7. A

    SOLVED MySql and PHP upgrade

    Hi I need to upgrade MySql and PHP on my servers. >>>>>>>>>>>>>>>>>>>>>>> Cpanel's documentation says 1) We strongly recommend that you back up your database before you upgrade your database or change to MariaDB. Is this backup a special backup or is this just the regular WHM backups...
  8. S

    Unable to authenticate using the password error

    I keep getting the error "The system was unable to authenticate using the password in the /root/.my.cnf file. Reset the root MySQL password to proceed." I have tried resetting the password. Still no luck I am getting this error as well
  9. G

    SOLVED Disable MySQL strict mode - CloudLinux + MySQL 5.7

    Hello, I have a problem with the STRICT_TRANS_TABLES and i want to disable it. I tried some fixed from this threds: Disable MySQL Strict Mode and Strict Mode Thred sql_mode="" sql_mode=NO_ENGINE_SUBSTITUTION...
  10. B

    VPS MySQL Optimization Needed

    Hello There. I have a vps that on paper should be very powerful but it is running very slow and the cpu is very high. Can someone help please thanks This is the spec Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz Speed 2199.998 MHz Cache 16384 KB 1.2TB SSD and 50gb ram These are my mycnf file...
  11. T

    Can't Connect to Remote MySQL Database

    Hey Guys, I'm new on this forum. Remote Mysql doesn't work anymore on my host, I tried with others host and it's the same problem. The host support told me that CPanel don't support remote Mysql anymore since the new Cpanel update. I whitelist my Ip and even all Ip with the % parameter, but the...
  12. P

    DBD::mysql has been removed during upgrade

    Hello everyone I've had a look round for an answer, but to be honest I'm completely stuck, so apologies in advance for being a noob. I look after the website for the Isle of Man Family History Society - a small group. The host is Manx Telecom and I've used cpanel to set up a SQL database...
  13. S

    Create new database for second website?

    hi 1st i want to tell i am not technical person just little knowledge about the things. my question is we have a free classified website in WordPress now we want to move in another platform we are going to design a customized website in PHP and want to move all data from existing website to new...
  14. M

    PHPMyAdmin User Side slow on cPanel 82.0.9

    Hi all I have a very strange problem accessing PhpMyAdmin from user side then via Cpanel user. Before version 82.0.9 was all ok, after the update the access to PhPMyAdmin in the user area of Panel is veeeery slow. The access from the WHM area, then the access with root rights, it's ok. I tried...
  15. PPNSteve

    Multiple errors (esp database related) on multi-account cPanel -to- cPanel transfers

    Seeing a large bunch of errors during account transfers from old to new server.. mainly can't find the DB user password and then not able to add user to db on new server.. Unable to detect a password set for “commuteb”@“%”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80. Unable to...
  16. R

    Import large database

    - Removed - can you login to my cpanel or WHM to help import a database ? I'm not able to use SSH
  17. sahostking

    mysqldump all databases returns error

    mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES I googled it a bit and they state this happens with left over parts from mysql to mariadb upgrade which we did...
  18. M

    Maria 10.4 Support

    Any ETA when 10.4 will be supported as it's stable since one month ago
  19. D

    Granting account access to multiple databases

    I’m trying to share a database between two domains. I have two sites, let’s call them siteA and siteB. Each site has it’s own cpanel account (siteA_user and siteB_user) and each site has it’s own database (siteA_db and siteB_db) which reside on the same server. siteA is an interactive site...
  20. L

    Connection check error

    Hello friends I have received this message yesterday: [2019-07-31 21:17:01 -0300] E [/usr/local/cpanel/scripts/mysqlconnectioncheck] The “/usr/local/cpanel/scripts/mysqlconnectioncheck” command (process 4990) reported error number 1 when it ended. We are using for a long time MariaDB and not...