Jump to content
xisto Community
Milk

Mysql Probelms

Recommended Posts

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

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

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

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

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

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

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

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

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.