|
|
|
|
![]() ![]() |
Feb 3 2005, 01:56 AM
Post
#1
|
|
|
Super Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 270 Joined: 2-December 04 Member No.: 2,503 |
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. |
|
|
|
Feb 3 2005, 05:47 PM
Post
#2
|
|
|
Princess ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 1,233 Joined: 9-October 04 From: England Member No.: 1,563 |
was it a server mysql problem ? happened to me before..
is it okay now ? post back |
|
|
|
Feb 5 2005, 03:55 AM
Post
#3
|
|
|
Administrator ![]() Group: Admin Posts: 1,479 Joined: 11-June 04 From: Somewhere in Time & Space. Member No.: 1 |
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. |
|
|
|
Feb 5 2005, 05:38 AM
Post
#4
|
|
|
Privileged Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 675 Joined: 11-September 04 Member No.: 1,079 |
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.
|
|
|
|
Feb 5 2005, 08:26 AM
Post
#5
|
|
|
Administrator ![]() Group: Admin Posts: 1,479 Joined: 11-June 04 From: Somewhere in Time & Space. Member No.: 1 |
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.
|
|
|
|
Feb 8 2005, 12:15 PM
Post
#6
|
|
|
Advanced Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 114 Joined: 9-August 04 From: Suzhou Jiangsu China Member No.: 743 |
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. |
|
|
|
Feb 8 2005, 04:47 PM
Post
#7
|
|
|
www.tcclan.org ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 116 Joined: 9-December 04 Member No.: 2,636 |
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.
|
|
|
|
Feb 8 2005, 05:26 PM
Post
#8
|
|
|
www.tcclan.org ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 116 Joined: 9-December 04 Member No.: 2,636 |
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 trap17 apache servers or something?
|
|
|
|
Feb 8 2005, 06:27 PM
Post
#9
|
|
|
.: http://www.xgnews.tk :. ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 119 Joined: 29-October 04 Member No.: 2,025 |
QUOTE(OpaQue @ Feb 5 2005, 03:55 AM) 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. |
|
|
|