databases

  1. BrianLayman

    User databases are no longer created

    I've somehow changed my default behavior for WHM. Prior to this, for each new account I created from WHM, I would get a MySQL User and a MySQL database. Now I only get the User. I can find threads that indicate ppl used to modify some of the post*acct scripts to create the databases...
  2. C

    Error for Create postgres databases

    Hi all i try create postgres databases after create not appear in box of databeses but not appear errors when try create, i try view in log erros of cpanel and can view this: ERROR: role "corecolo" does not exist ERROR: role "corecolo" does not exist ERROR: role "corecolo" does not...
  3. S

    Removing MySQL databases and users...DBD::mysql::db do failed ??

    Everytime I terminate an account through killacc shell I got the following error. Removing MySQL databases and users...DBD::mysql::db do failed: Table 'db' is marked as crashed and should be repaired at /scripts/cPScript/Mysql.pm line 1074. DBD::mysql::db do failed: Table 'db' is marked as...
  4. T

    Creating Databases

    Hello When I try to create a databse in a clients cPanel, I get the following error: Sorry, you have exceeded the maximum allowed databases. But I havent used all my databases. Ive got 1 left. Does anyone know whats happening? Thanks Tom
  5. C

    Sorry, you have exceeded the maximum allowed databases with mysql database unlimited

    :confused: I have a cpanel user, who have unlimited mysql databases... i try to add a new mysql database and i get this error: Sorry, you have exceeded the maximum allowed databases. i tryed in admin, to change from unlimited to a fix number of database: 30-50-100 and all seems work...
  6. C

    cPanel shows the wrong number of databases

    Hello, After we updated to 11.24-stable we have one server that always shows the customer is using one more database than the actually are. Other servers we updated to the same version do not have this problem. It appears to be related to the theme (x3) but we have not made any alterations to...
  7. G

    MySQL - unable to create new databases

    All users is denied to create new databases, and is rejected with: Sorry, you have exceeded the maximum allowed databases. in the cpanel interface cPanel 11.24.4-R33311 - WHM 11.24.2 - X 3.9 FREEBSD 6.3 amd64 on standard
  8. T

    MySQL databases not being backed up!

    After upgrading to the latest WHM/Cpanel package our MySQL databases are NOT being backed up! This is a MAJOR issue for us. I have checked all of the settings in WHM and the system is set to backup accounts and full Mysql directory, but when I restore a site, the databases are NOT there! Any...
  9. tazman2000

    Cpanel - MySQL Databases Blank

    Last weekend I updated to the latest version of Cpanel & Apache, now when I go into Cpanel>MySQL Databases nothing is listed, no databases, and yet I know they are their as they are active on the site, and show in MyPHPAdmin....this has happened on every account on the server. ...and it will...
  10. M

    Restore MySQL databases

    Hello, I am trying to restore some databases. I copied /var/lib/mysql to mysql on another server. When I view the databases they are listed, but the usernames created with the databases are not listed and are not linked with the databases. Are the usernames stored somewhere else?
  11. Silent Ninja

    How to optimize all tables in all databases

    I've made up this code (based on another one from Son Nguyen) to optimize all databases on the server so they index what they can run faster and smoothly. If you want to, it could be a good addon on the WHM / cPanel scripts :) It's a bash script, but it can be easily rewrote in Perl or PHP if...
  12. I

    /scripts/upcp hang at "Updating services & databases..."

    I see this issue couple of times either from the Cron Daemon email or when i tried to do /scripts/upcp from SSH (including WHM of course) /scripts/upcp always hang at "Updating services & databases..." nothing comes up after that, anyone can help me out with this? Thanks
  13. J

    var directory too small to hold all the MySQL databases, will this solution work?

    Currently using: WHM 11.23.2 cPanel 11.23.6-R27225 REDHAT Enterprise 5.2 i686 on standard - WHM X v3.1.0 Our /var directory is over 90% full, even though the /home directory is less than half full. This is due to all the large databases being kept by the hosted accounts in /var/lib/mysql And...
  14. A

    Current Databases only shows 1 DB

    hello guyz, i guess i have a challenging problem which i really started getting fed up with, i have a Cpanel on RHEL3 and remote MySQL anyhow when i create a DB (let say called TEST1) using MySQL Databases in the cPanel its created and shown in the Current Databases Table (TEST1) but when i...
  15. hostmedic

    remote mysql server import of Databases?

    When setting this up - will it automatically copy all of the databases or do we need to do this one by one? ? We are looking to take all mysql databases onto a monster db server cluster (3 db servers using htproxy. Anyhow - my concern is if we will need to copy each database manually...
  16. H

    Can not add users to the databases

    Hello, I can create databases and users in cPanel, but I can not add users to the databases, though cPanel says the users were added. This started to happen just a few days ago. Can anyone help me? Thank you, Best regards
  17. gertiebeth

    Need to convert databases

    Can anyone point out a tutorial link or tell me how to convert my existing mysql5 databases back to mysql4.1? (I already know how to convert the server) From what I have gathered by searching Google is that the databases need to be saved then deleted then recreated and then restored. Is that...
  18. D

    Large mySQL databases

    Large MySQL databases are not being backed up fully. They are pretty much losing all of their tables. Any ideas around this or hints? This seems to only happen on larger databases. Thanks ahead of time
  19. D

    Restore Backups not Restoring Databases

    My server suddenly has decided to terminate 52 accounts every day. I go into WHM and restore them but the databases are not being restored. I checked in the backup folder and they are the databases are there. How can I force WHM to restore the databasesand what shell commands can I use to...
  20. G

    Changed account username and now databases locked

    I changed the username on one of my accounts and now all the databases associated to this account are "in use". They cannot be modified or deleted. How can I delete them? I went into phpMyAdmin and set the privileges of the database to the new username and root but I still cannot edit or...