databases

  1. S

    MYSQL 5.5.24 databases on all cpanel servers corrupt during transfer

    I have come across a very odd problem that is replicated on three cpanel server's two running release builds and one running on a current build. All three servers run Centos 6.x 64bit. Whenever I attempt to move any of the websites hosted over across any server (including these three and a...
  2. V

    Automatic Backups FTP / Cpanel Users / MySQL Databases

    First...here is what I'm running: WHM 11.32.2 (build 18) CENTOS 5.6 i686 virtuozzo Linux Server I'm learning how to manage my own server lately (lots more fun than I expected). Unfortunately, I've been too busy to spend the time finding quality information on setting up automatic backups...
  3. T

    Copy Multiple Accounts: databases failing

    Every account that I've copied using the "Copy multiple accounts/packages from another server" tool has copied without any problem except for the databases. Not one account had it's database copied correctly, and I had to mysqldump/scp/import dump for every one. Here is a sample of one...
  4. WebHostPro

    100's of accounts transfered with empty databases then phpadmin brakes FML

    Cpanel your killing me, not only didn't transfer hundreds of account incorrectly. You broke at the worst time and now because phpmyadmin doesn't work I can't even transfer the databases easily. Your killing me, seriously I might die from this.
  5. U

    backup all the databases when mysql is not running

    Hi, My hard disk has gone bad and data center has rebooted the server in single user mode with only networking and ssh enabled (that means mysql is not running). Then I backed up all the accounts to secondary drive using following command:- /usr/local/cpanel/scripts/cpbackup --force...
  6. V

    Wrong number of databases.

    Hello, After the last cPanel upgrade it shows now the wrong number of databases in user's cPanel. When the package allows to use 10 databases, cPanel shows 20 instead (on all of our servers). Is it a bug ?
  7. B

    [Case 48889] Bug report: Space for Removed MySQL databases remains visible in cPanel

    Hello, I've noticed that the "disk usage" shown in cPanel for an account is not correct when a MySQL database was removed earlier. It keeps showing the space used by the old MySQL database after more than 24hrs. In WHM the "disk usage" is shown correctly though for that specific account...
  8. S

    MySQL Databases not showing in CPanel

    Hi, MySQL databases page on a CPanel account isn't showing any of the existing databases: :2083/frontend/x3/sql/index.html Quota is unlimited /tmp isn't full server isn't out of space /usr/local/cpanel/bin/checkperlmodules hasn't fixed it /usr/local/cpanel/logs/error_logs...
  9. X

    Sorry, you have exceeded the maximum allowed databases on unlimited account

    Hi I have a WHM 11.28.86 CENTOS 5.5 i686 standard on hosting5 I try add new database by cpanel on account which created by root (not reseler). This account has a unlimited sql databases and i get "Sorry, you have exceeded the maximum allowed databases. " I try to change limit from...
  10. B

    Question regarding the mysql databases function within cpanel 11

    All, I have recently become an administrator of a forum in which Cpanel is the method of access for maintenance functions. I see cpanel 11 has a "MySQL databases" function. When I select that it then takes me into a page where one of the options is to "Check" and another is to "Repair" the...
  11. bin_asc

    Account migration without MySQL databases

    Is there any way to transfer accounts from on WHM server to another, BUT not transfer databases as well ? Any hidden setting ? The idea is ... I have some huge websites, and I usually rsync the database on the new location when moving accounts, so I would like to transfer only the account...
  12. G

    Backing up MySQL databases on regular schedule

    My semi-managed server is running RedHat Enterprise 4 i686. It has a large, virtually unused partition on the hard drive (230GB) named /backup. Is there an easy way to have cPanel or WHM copy all of my MySQL databases to /backup each night?
  13. F

    list all databases associated with a reseller !!

    Hello All : I have a requirement from a reseller and he needs to know all the DB's associated with all his hosted accounts. he has some 100 account and i cannot go browsing each panel for the info. How is it possible to get it via CLI or any available script ? Any assistance please !!!
  14. T

    Upgraded Cpanel to ... no databases, file manager?

    I upgraded to version cPanel 11.25.0-R46156 - WHM 11.25.0 and I dont see where i manage / add databases i no longer see a file manager... did the upgrade not complete or something or what is going on... i can't find this stuff anymore.
  15. S

    cpanel reports all databases have size of zero

    Is anyone else seeing this ? I searched and didnt find any thing Doug
  16. A

    Linking Databases With domains

    Hi, I am trying to visually link which MySql Databases belongs to which of my domains and I am not seeing any way to tell this in cpanel. I am sure it is simple but I cannot figure it out so would really appreciate any help or guidance you guys can offer. Thanks.
  17. K

    Creating an account backup without the MySQL databases?

    I'd like to transfer (backup and restore) a cPanel account and its home folder, but without the MySQL databases (the size of the DB is causing load to go crazy while trying to restore a full cpmove, so I'm trying to restore the DB separately). Is there a way to backup an account (home folder...
  18. 4

    11.25 - mysql databases used - incorrect

    Just added an account to a server running 11.25. Noticed it said the account was using 1/2 mysql databases. I added a db and it then said using 2/2. Checked via phpmyadmin and there is only one db owned by that user. There is no additional db with the same name as the username (I know there...
  19. R

    Restoring a Database backup while using all of the number of databases allowed

    My Hosting provider allows me 5 MySql DBs on my Hosting Account. Till last week, I had used 4 of these. My backups & restores of the DBs from the CPanel went smoothly. This week, I added the final 5th DB allowed in my account. Today, I was trying to restore one of the DBs from the CPanel. I...
  20. J

    Limit PostgreSQL databases

    How to limit the number of PostgreSQL databases that each user can create in their account? Exactly like MySQL... I miss other things for PostgreSQL that exists on MySQL administration.