Milk 0 Report post Posted February 3, 2005 I installed a forum, not phpbb, and it was going fine and a user put a huge pic in his sig. Well, after he posted about 14 times, my entire site crashed. Like, it stopped working. Now, it's back up, but my forum doesn't work because my mysql database got deleted. I tried going back and making another database, but everytime I do, it's like it was never made. Like, I enter my database name, press submit/whatever, then it says "so and so database was created" or something, and I press go back. But nothing shows up.I tried to install the phpbb script to see if it would make a mysql database, but when i put in my admin name and password and file name thing for the phpbb, it said there was an error, which didn't happen before. So i've come to the conclusion there is something wrong with my mysql.Um...does anyone know how they can possible help me?? Or will it be alright tomorrow?Thanks in advanced. Share this post Link to post Share on other sites
Becca 0 Report post Posted February 3, 2005 was it a server mysql problem ? happened to me before..is it okay now ? post back Share this post Link to post Share on other sites
OpaQue 15 Report post Posted February 5, 2005 You must CREATE a USER and give it all the PERMISSIONS to that particular DATABASE. DATABASE DO NOT SHOW UP IF THE MYSQL SERVICE IS RESTARTED, STOPPED, HALTE D OR SHUTDOWN. THESE THINGS LAST FOR ABOUT 10 - 15 MINUTES and ARE BACK ONLINE. OUR SITE IS HOSTED AMOUNG THE SAME SERVER AND BE ASSURED YOUR DATA IS SAFE.PS : WE DO NOT DELETE DATA AND RELIABILITY IS OUR FIRST PRIORITY. WE HAVE 24 HOUR BACK UP CYCLES AND IF ANY SUCH SITUATIONS ARISE, WE RESTORE THE ENTIRE BACKUPS. PLEASE DO NOT SPREAD BAD FAITH. Share this post Link to post Share on other sites
iwuvcookies 0 Report post Posted February 5, 2005 i do'nt get it why does the mysql sometimes doesn't work? its weird.... like some times it works and sometimes it doesn't and then it works again. Share this post Link to post Share on other sites
OpaQue 15 Report post Posted February 5, 2005 Must be your connection. It does not happen that way. Our server is powered by 4 XEON processors with 2 GB RAM. Definately, the load must be extremely high when it ceases to function. But the operation does not flicker as you are saying. I get detailed reports of the operation and We dont expereince anything like that. Share this post Link to post Share on other sites
LuciferStar 0 Report post Posted February 8, 2005 before reinstall your database,you may go and modify your code,set a limitation to the length of the uploaded file.delete the old database,then reinstall. Share this post Link to post Share on other sites
SilentWarrior 0 Report post Posted February 8, 2005 It seems like everycouple of days the mysql databases for my site go down from anywhere of minutes to hours. Is this supposed to happen and I am using phpnuke cms. If this happens alot I may be convinced to switch to paid hosting if paid hosting doesnt have mysql go down for extended periods. Yarr. Share this post Link to post Share on other sites
SilentWarrior 0 Report post Posted February 8, 2005 Yet another issue im having. When I login to cpanel it shows that I am using 0 mysqls and in mysql admin there is none there. Where did mysql db go? I have made no changes to it and it was there before as it is needed for the phpnuke site. Does this have something to do with Xisto apache servers or something? Share this post Link to post Share on other sites
Deaths Aprentice 0 Report post Posted February 8, 2005 THESE THINGS LAST FOR ABOUT 10 - 15 MINUTES and Lol?In Christmas holliday I've expierenced downtimes of over 2 hours.To make this clear:Your Cpanel gets the MySQL data from the MySQL server.If this is shut down, or not working for one reason or another, Cpanel cannot get the data from the MySQL server.It will look like there are no MySQL databases, but actually the server is just not functioning correctly. Share this post Link to post Share on other sites
Deaths Aprentice 0 Report post Posted February 8, 2005 It seems like everycouple of days the mysql databases for my site go down from anywhere of minutes to hours. Is this supposed to happen and I am using phpnuke cms. If this happens alot I may be convinced to switch to paid hosting if paid hosting doesnt have mysql go down for extended periods. Yarr. 48181[/snapback] Paid hosting indeed doesn't have quite as many downtimes, because they don't have noobs playing around with faulty MySQL commands... Share this post Link to post Share on other sites
Xedos 0 Report post Posted February 8, 2005 Indeed. Â I wish one of the rules was to agree that you know how to use MySQL and wouldn't crash it! Â It never used to happen, when it did, short downtimes. I'm sure someone is messing with the system. It has to be. It never used to happen! Â May it be fixed soon! Share this post Link to post Share on other sites
Deaths Aprentice 0 Report post Posted February 8, 2005 Sometimes it can be an accident . Share this post Link to post Share on other sites
Xedos 0 Report post Posted February 8, 2005 How do you mean an accident? Share this post Link to post Share on other sites
Florisjuh 0 Report post Posted February 9, 2005 Slight crashes, maybe power failures etc... Even happens with payed hosing once in a while... Share this post Link to post Share on other sites
hansley 0 Report post Posted February 16, 2005 I recently installed a PHPBB on my site and not long after its launch, these messages appeared:Warning: mysql_connect(): Too many connections in /home/hansley/public_html/forum/db/mysql4.php on line 48Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/hansley/public_html/forum/db/mysql4.php on line 330Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/hansley/public_html/forum/db/mysql4.php on line 331phpBB : Critical ErrorCould not connect to the databaseDoes anyone have any idea why and how this happens?How to fix it?If it is from the Xisto, how long will it be fixed?Thank you Share this post Link to post Share on other sites