Nov 20, 2009

Problem With MySQL

free web hosting
Open Discussion & Free Web Hosting > Astahost > Hosted Members Support

Problem With MySQL

BitShift
I tried to visit my website today and I recieved the dreadful page from my php-nuke site

"There seems to be a problem with the MySQL database"

First I thought, "no big deal server is probably rebooting or down for a little bit" So i logged into my cpanel and clicked on "Server Status".

Thats when I started worrying. It said the MySQL servers were up and runnign fine. I went back to my main page and looked at my MySQL server count and instead of saying 2/99 it now says NA/99

I am unable to create a new database and I recieve this error when I click on PHPmyadmin
QUOTE

phpMyAdmin - error
#1040 - Too many connections


This is a huge problem for me because my website uses PHP-Nuke and it cannot display anything except for an error page without access to the database. Hopefully the data is not lost because my backup is a few days old.

Anyone else having this problem, and what do I do to fix this?

 

 

 


Comment/Reply (w/o sign-up)

pyost
Same here.. I have had this problem on another server, but it usually lasted for only a few minutes. I don't know why the server is taking so long to recover.

Comment/Reply (w/o sign-up)

tezza
I think the whole servers are having issue problems. Dont worry about it. However did you take backups just in case?
Give them a while as I think the admins are trying to sort these problems now.
However Im just a newbie so dont listen to me. lol
Hopefully it is alrite.

Comment/Reply (w/o sign-up)

BitShift
Yes of course I have backups but the problem here is I can not even make a new database to put the backup on.

The MySQL service for me is completely shut down, and even if I did manage to create a new database the PHPMyAdmin is also not working so there would be know way to upload my backup file to the database.

Comment/Reply (w/o sign-up)

Mark420
but hey guess what? the easiest and fastest way to backup your DB is to use a CRON job...guess what has NOT been working since the CPANEL upgrade?

Yes go to the top of the class!!! the cron jobs DO NOT run at all these days...not a good thing!!!!this needs to be fixed also!!!

Comment/Reply (w/o sign-up)

BitShift
Well the MySQL issue seems to be resolved as my website is back up and running with no data loss.

I would like to thank the site administrators and anyone who contributed to getting this done in a timely fashion.

As for the cron jobs well the best of luck to you on that.

Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : Mysql

  1. Mysql Connect Error, Too Many Connections. - (1)
    Just to begin with I want to say that I am not here necessarily to complain about it lol. I'm
    not sure but if my site is possibly helping to contribute to the problem, I'd like to know if
    anyone knows any good articles or tutorials that might have information on what to look out for that
    could contribute to these sort of problems. I know my site may not have anything to do with it (as
    I don't think it is overly popular or anything or even close), but knowing what to look out for
    when messing with PHP/mySQL would be great. I personally haven't found too...
  2. Connecting To Astahost's Mysql - (8)
  3. Mysql Server Not Stable After Hard Disk Swap On April 6th - (2)
    Hi... All are aware of the server issues happened on April 6th:
    http://www.astahost.com/current-server-iss...ade-t15435.html I'm still facing the issue with
    the MySQL Server after the server problems!! I'm using phpBB forum for my site, and it often
    shows some error message after losing connection with the Database server! Its happening many times
    in a minute! Its not at all stable after the server issues! I had tried repairing the databases and
    optimizing the databases! But nothing helped me! Still facing the issues! Its showing like:
    DEBUG MODE ...
  4. Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql - (3)
    Hi all, Please help me! My site was working fine! ( www.fun.niranvv.com ) But now, its showing
    one error message as: Warning: mysql_connect() : Can't connect to local MySQL server
    through socket '/var/lib/mysql/mysql.sock' (2) in
    /home/niranvv/public_html/fun/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is
    not a valid MySQL-Link resource in /home/niranvv/public_html/fun/db/mysql4.php on line 330 Warning:
    mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/niranvv/public_html/fun/db/mysql4.php on line...
  5. What Is The MySQL Version @ Asta ? - MySQL 4.0.26-Max
    (16)
    Hi, A few question here, 1. Just wondering, the MySQL hosted on astahost.com is actually version
    "4.0.26-Max" according to phpmyadmin. But why is cPanel showing "4.1.21-standard"? 2. Actually
    i've existing codes that need function introduced after version 4.1.1, is there by any chance
    astahost or xisto is going to upgrade the MySQL package? Thanks...
  6. Php And Mysql Version. - (7)
    Is there any plan to upgrade or see if it can be upgraded to PHP5 and mySQL5 in the future?...
  7. Mysql Error Never Seen On My Site Before (too Many Connections). - (13)
    I just tried to visit my site to see if anything had changed on my forums and such and I got this
    message: Warning: mysql_connect(): Too many connections in /xxxx/xxxxx/xxxxxx_xxxxx/xxx/xx_xxxx.php
    on line 7 Error! Could not connect: Too many connections. I have never recieved this error before,
    does this mean someone is mucking with my site somehow??? The particular php file it mentions is
    the one that defines variables like db username etc and connection to the site's database that I
    include wherever it is needed in various file for the site. EDIT: I managed t...
  8. Help Me! - Frontpage & phpBB with MySQL (3)
    I was just approved an Astahost account with the starter package. I explored the Cpanel a bit
    and have got the following problems : 1.Frontpage Extensions The Cpanel states that the
    Frontpage Extensions have been installed. But when I uploaded my site on frontpage at
    "ftp://ftp.mysitename.astahost.com/public_html/" it stated an error that Fronpage Extensions are not
    installed on this server! When I opened my site online, I can see the page, but I cannot see any
    graphics/images! Also, my forms and other stuff isn't working either. Please help me out and let
    me...
  9. Weird MySQL Message - (4)
    wenever i assign priviledges to a MySQL databases, it seems to work properly but this message is
    always there QUOTE bitshift_wforumu (Privileges: ALL PRIVILEGES) Connection Strings
    Perl $dbh = DBI->connect("DBI:mysql:bitshift_wforum:localhost","bitshift_wforumu"," ");
    PHP $dbh=mysql_connect ("localhost", "bitshift_wforumu", " ") or die ('I cannot connect to the
    database because: ' . mysql_error()); mysql_select_db ("bitshift_wforum"); My database
    name is: bitshift_wforum the username is: bitshift_wforumu What does all that maen, it ...
  10. Problem With MySQL Not Being Able To Connect - Anyone know the reason for this error... (9)
    Hello everyone, Im currently having a problem with mySQL, I wrote a PHP login script that
    doesnt seem to be working for some reason. I created a database and everything looks correct, is
    this a server issue or is the issue related to my script? But anyway this is my error, hope someone
    can help Ive tried to search forum for answer but none of the posts seems to answer my question:
    QUOTE Warning: mysql_connect(): Host 'gamma.xisto.com' is not allowed to connect to this
    MySQL server in /home/hp2001/public_html/ucscKGD/checklogin.php on line 10 cannot co...
  11. MySQL - Can't Connect - Cristal Report (1)
    From http://thoaionline.com (hosted by Astahost) QUOTE Warning: mysql_connect(): Can't
    connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
    /home/pheart/public_html/thoaionline/includes/database.mysql.inc on line 31 Can't connect to
    local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) In cPanel Mysql
    databases 0 / 99 But I have 5 MySQL databases in my account (maybe more). All of them become
    unusable now. Some more messages from http://website.thoaionline.com QUOTE Warning: 
    mysql_pc...
  12. Can I Access MySQL Database From Outsite, Directly - (10)
    I'm going to make an OFFLINE FORUM. So I want to know is that possible or not. My paid host
    don't allow that. How about astahost?...
  13. MySQL Database - Important Report (3)
    I'm writing this to report about a error. One of my mySQL database has been droped and my site
    stop working. I don't know the reason. I'm hosted on gamma server. I think you (admin)
    should check it. PS: One of my paid hosting provider also met this problem a few day ago....
  14. IPS Driver Error / MySQL Database - What in the world? How is this possible? (1)
    Just several hours ago, I couldn't access my website/forum because of some error with an SQL
    socket or something like that. I need desperate help because I don't want to reformat everything
    again. Well, here is what comes up: IPB WARNING mysql_connect(): Can't connect to local
    MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (Line: 114 of
    /ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can
    try to refresh the page by clicking here. Error Returned: SQL error: Can't connect to local
    M...
  15. General Problems With New Account - MySQL problems and quota issues (2)
    I just got a new account and CPanel reports that I have -380.2 MB of quota space and using 400.2MB.
    This disables some of Cpanel's functions. It would have been nice to use the automated Mambo
    installer, but no biggy. I uploaded the latest Mambo .tar.gz from my FTP program and unpacked it
    via Cpanel's file manager with no problem. When I first logged into the system I created a new
    Database for mambo and a new user for that database and linked the two from Cpanel. I logged off to
    watch something on TV and came back and that database isn't being reported...
  16. Problem With Mysql - Cannot connect to database.... (6)
    Hi, this is the first time after I got my hosting to try and use MySQL. My site is
    http://abhiram.astahost.com . I created a user in CPanel -> 'MySQL Databases' as root. So,
    the new user created will be 'abhiram_root'. Similarly I created a database called
    'webpage' (which changes to 'abhiram_webpage'). I set up the database and the tables
    using phpMyAdmin and uploaded the files after making changes to the user name and the database. But
    it's not opening the database. It's connecting to MySQL without any problems, but it
    isn'...
  17. Mysql Error - (5)
    Hey i got this error trying to install something on my database CODE mysql error: You have an
    error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the
    right syntax to use near 'rpg_class` (`name`, `folder`, `regatt`, `magicatt`, `magicdef` mysql
    error number: 1064 can anyone tell me what this means or how i fix it?? thanks in advance...
  18. MySQL Errors? - Error 13! - (0)
    Recently been attacked by "Can't create/write to file '/tmp/#sql_28e2_0.MYI' (Errcode:
    13)"? Then its a simple fix, please DELETE (backup first) your SOURCE files that talk to the MySQL
    database, and re-upload them This will purge them from the system and force them to recreate the
    temporary files. Do NOT delete your database, just backup your files, delete them, re-upload them
    and youll be fine. This is due to MySQL crash. Easily fixed and no data has been lost. Sorry guys
    Details: MySQL crashed while writing data, it seems the temporary file has bee...



Looking for problem, mysql

See Also,

*SIMILAR VIDEOS*
Searching Video's for problem, mysql
advertisement



Problem With MySQL

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com