Welcome Guest ( Log In | Register)



2 Pages V   1 2 >  
Reply to this topicStart new topic
> Mysql Probelms
Milk
post 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.
Go to the top of the page
 
+Quote Post
Becca
post 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
Go to the top of the page
 
+Quote Post
OpaQue
post Feb 5 2005, 03:55 AM
Post #3


Administrator
Group Icon

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.
Go to the top of the page
 
+Quote Post
iwuvcookies
post 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.
Go to the top of the page
 
+Quote Post
OpaQue
post Feb 5 2005, 08:26 AM
Post #5


Administrator
Group Icon

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.
Go to the top of the page
 
+Quote Post
LuciferStar
post 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.
Go to the top of the page
 
+Quote Post
SilentWarrior
post 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.
Go to the top of the page
 
+Quote Post
SilentWarrior
post 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?
Go to the top of the page
 
+Quote Post
Deaths Aprentice
post 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.
Go to the top of the page
 
+Quote Post
Deaths Aprentice