HOME       >>       Web Hosting Support

Mysql Probelms


Milk

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.


Becca

was it a server mysql problem ? happened to me before..is it okay now ? post back


OpaQue

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.


iwuvcookies

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.


OpaQue

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.


LuciferStar

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.


SilentWarrior

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.


SilentWarrior

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?


Deaths Aprentice

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.

Deaths Aprentice

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...

Xedos

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!


Deaths Aprentice

Sometimes it can be an accident .


Xedos

How do you mean an accident?


Florisjuh

Slight crashes, maybe power failures etc... Even happens with payed hosing once in a while...


hansley

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


8bit

This is starting to happen now...


bureX

That happened to me 3 times, and when I logged in to cPanel, I saw that mySQL was down... Once, mySQL was down for more than an hour, I freaked out because I thought that my databases were deleted .



VIEW DESKTOP VERSION REGISTERGET FREE HOSTING

Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.