databases

  1. F

    MySQL databases and quota.

    Does the space of the MySQL databases count in the total user disk quota? It's a newbie question, sorry :D Thanks, fedlerner
  2. B

    How to restore mysql databases from /var/lib/mysql/user_database/ files only

    Hi, as the title asks. I recenlty had a hardrive failure and luckliy I can still access certian directories on this drive. I can still access the /var/lib/mysql/ direcoty which holds all the users databases and have backed all these up using tar. Now what I need to know is how do you...
  3. Y

    I\'m unable to add db users to my mysql databases using cpanel.

    Hello All, I\'m unable to add db users to my mysql databases using cpanel.Which are the possibilities to fix it.I have run #/script/upcp ...Please tell me another possiblities for fix the issue Thanks in Advance
  4. Y

    I\'m unable to add db users to my mysql databases using cpanel.

    Hello All, I\'m unable to add db users to my mysql databases using cpanel.Which are the possibilities to fix it.I have run #/script/upcp ...Please tell me another possiblities for fix the issue Thanks in Advance
  5. S

    cpanel current database list is showing .sql.gz files as databases

    Hi, I've recently noticed that in cPanel > MySQL databases that in the list of 'current databases' cPanel appears to be listing the .sql.gz files corresponding to each actual mysql db - AND counting these files towards the total of dbs being used by the hosting account. This is...
  6. X

    Removing MySQL databases and users

    My WHM is stuck on "Removing MySQL databases and users" when removing a user. What do I do ?
  7. G

    Shift Postgres's databases to another bigger partition

    Hi, Sooner or later our Postgres's databases going filled up the current partition. Is there a way to reconfigure Postgres to store the database at another location on the server? Probably another bigger partition like /home or / Appreciate your guidance. Thanks alot.
  8. W

    Tie existing MySQL databases to existing users

    I've dug around in the /scripts directory to no avail. The problem I'm having right now is that a customer of mine has several databases in this format: customers_database1 customers_database2 customers_database3 Note the "s" at the end of "customers". I manually migrated these over...
  9. M

    Shared MySQL databases and php files for several CPanel accounts

    Hello! My client is moving his sites from one host (VDS) to another (CPanel based). The problem is that all sites (5+) use (a) two shared mySQL databases (b) common include files. And I don't have an idea what's the best way to move such a structure on CPanel. Is there any posibilities to...
  10. L

    WHM backup not backing up all my databases

    Hi, I'm a newbie here and new to cpanel. I use the cpanel backup to backup all my databases to a remote drive and this all works fine except that it does not backup all the databases. It has been set to back up user accounts and entire mysql directory All the databases that are created...
  11. sehh

    Disk Space Usage doesn't include MySQL databases size

    The "Disk Space Usage" bar on the left side of the cPanel, doesn't include the size of the SQL databases. As a result, my users complain why they hit their over quota limit when the displayed usage is only showing 30% or so (user has 1gb quota with a 700mb database). Is there a way to...
  12. R

    Default character set for new databases

    Hi. Can one change default character set used for NEW databases created by cPanel? I know I could change the default one in my.cnf, but then it corrupts data returned by my clients databases - their websites use old charsets. The idea my friend came up with is to find, where cPanel creates...
  13. K

    Databases suddenly dissapears / get corrupted

    Hi We are having a problem with one off our server. Our server management company are not able to find the cause yet. During the last 2 months we are having the issue that suddenly databases becomes corrupted, and will have to be restored from backup. This can also suddenly happens to files...
  14. doubleg

    cpanel accounts cant add database users to databases

    Checking the tail -f /usr/local/cpanel/logs/error_log upon trying to add a user to the database Wed Jun 6 17:11:57 2007 trace [ExpVar]: Deprecated used of DOMAIN as a variable in DOMAIN : ./frontend/cpanelnew/webtools/addusertodb.html at /usr/local/cpanel/Cpanel/ExpVar.pm line...
  15. dory36

    checking/repairing all mysql databases

    Our datacenter had a power outage Friday, and since the power cycle, I have had a few complaints about error messages on sites using mysql. I tested numerous sites, and found the error in only a few. Using the cPanel/whm function to "repair sql database" seems to work to resolve the problem...
  16. P

    Users can't import mySQL databases. ._.;

    Users cannot import mySQL databases such as wikimedia databases. Example query run in phpmyadmin(SQL Import): CREATE TABLE `wiki_categorylinks` ( `cl_from` int( 8 ) unsigned NOT NULL default '0', `cl_to` varchar( 255 ) COLLATE utf8_bin NOT NULL default '', `cl_sortkey` varchar( 86 )...
  17. M

    Where are the databases stored for Postgresql ?

    As above for the default location.. Thanks I'm planning to uninstall Postgresql but I need to check whether any of my users are using it.
  18. WebHostPro

    remote mysql server is full, I think cpanel is not removing old databases

    Any idea how to check if a database is not used and remove it for free space?
  19. A

    How to move MySQL databases between accounts

    Here's the situation. All this is taking place on the same server. Let's say we have an account setup for: ALPHA.domainname.com. We install vBulletin and a couple of other programs for the site which require SQL databases. Ok, now it's 6 months later and we setup another account on the...
  20. S

    MySQL dosen't see databases with more than 4 characters in name, why?

    Hello! Now I want transfer my accounts to new server. But in new server with Cpanel MySQL dosen't see databases with more than 4 characters in name. I transfer accounts using WHM. For example, Databases user_test is OK But for database user_tester - database is empty and for scripts...