Milk
Feb 3 2005, 01:56 AM
| | 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. |
Reply
Becca
Feb 3 2005, 05:47 PM
was it a server mysql problem ? happened to me before.. is it okay now ? post back
Reply
OpaQue
Feb 5 2005, 03:55 AM
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.
Reply
iwuvcookies
Feb 5 2005, 05:38 AM
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.
Reply
OpaQue
Feb 5 2005, 08:26 AM
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.
Reply
LuciferStar
Feb 8 2005, 12:15 PM
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.
Reply
SilentWarrior
Feb 8 2005, 04:47 PM
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.
Reply
SilentWarrior
Feb 8 2005, 05:26 PM
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?
Reply
Deaths Aprentice
Feb 8 2005, 06:27 PM
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.
Reply
Deaths Aprentice
Feb 8 2005, 06:29 PM
QUOTE(SilentWarrior @ Feb 8 2005, 04:47 PM) 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. Paid hosting indeed doesn't have quite as many downtimes, because they don't have noobs playing around with faulty MySQL commands...
Reply
bureX
Feb 16 2005, 11:49 PM
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  .
Reply
8bit
Feb 16 2005, 09:22 PM
This is starting to happen now...
Reply
hansley
Feb 16 2005, 03:55 PM
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 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/hansley/public_html/forum/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/hansley/public_html/forum/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database Does anyone have any idea why and how this happens? How to fix it? If it is from the trap17, how long will it be fixed? Thank you
Reply
Florisjuh
Feb 9 2005, 10:31 PM
Slight crashes, maybe power failures etc... Even happens with payed hosing once in a while...
Reply
Xedos
Feb 8 2005, 07:48 PM
How do you mean an accident?
Reply
Similar Topics
Keywords : mysql, probelms
- Mysql Database Not Working
(3)
It Went Well For A While
MySQL problem back in all its glory. (5) Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
effect. File(include/errors.xml) is not within the allowed path(s):
(/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
fopen(include/errors.xml) : failed to open stream: Operation not permitted in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
incl....
How Do I Find My Mysql Password? [resolved]
Cannot access my MySQL (5) After all the recent problems, my account has been restored. I have setup my parked domain agin, and
that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
that's all). I had to create a new user for my databases, and created the user with exactly the
same username and password I had before, but some of my web pages do not let me access the pages I
have associated with my databases. Where could i find out what my DB password is? (Although I am as
good as sure I am using the right one). I have tried my old password, the new c....
Remote Access Mysql
(8) Is it possible to directly access my local database from my website? For example, if somebody
submits info on my website, the info they submitted would be transferred to my local database
directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
my database to my subdomain is because it would be difficult to keep the website database and my
local database in sync . . . or is there a way to do that? Thanks for any replies.....
Question About The Upgrade And The Mysql Usage ?
question about the upgrade and the mysql usage? (3) thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ....
Question About Adding Message Board To Site
Using mysql? (5) Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
how can I set up a messageboard. Thanks. std split from another topic ....
Phpbb2.17 Mysql Problems
Just this week they started (4) The forum has been up and running for about a year and a half. It has been through numerous server
upgrades, etc, including the recent HDD change, but for some reason, just this week it started
throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,....
99 Mysql Databases?
(2) I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
just prefix my tables, but I was just wondering why it would say that. If for some reason it was
letting me get more than one database, and I wasn't supposed to, I don't want to get my
account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m....
Mysql Access Error[resolved]
(5) The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
Please kindly look into this.....
Mysql Server Problems [resolved]
(3) hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
ERRORS, like that the server is going down so now and often is it due to my cms or is the server
having some probs ? this is what i just saw from the statistics: QUOTE Service Status
named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
(5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17....
Cpanel And Mysql Problem. [resolved]
(3) hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
loads with a blank page. however both worked earlier today. so is there a problem with the server?
and if there is, will it be fixed?....
Sites Disapeard, Mysql Errors? Also Server Folders Deleted
(18) Hello its 15:40 and I login see if everything runs oke, and I see numerus things deleted my mysql is
working again. Whats going on? My Webpage couple websites got deleted, and server folder files now
whats going on? /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> my
forum also give errors but mysql db stil there /sad.gif" style="vertical-align:middle" emoid=":("
border="0" alt="sad.gif" />.......
The Difference Between Mysql And Postgresql ?
(4) I found those two in cPanel and they loofed nearly the same as each other but what is the difference
? I tried to go to phpMyAdmin and phpPgAdmin and they are nearly the same too. Do you know that ?
Please reply , thanks a lot.....
Mysql Backup Cronjob
How to? : / (6) Well, I want basically a cron job that will run and backup my MySQL database. I've been told
in the shoutbox that you can do it via cron job. Didn't told me how. Now, I just want help on
how to do it and what commands I should put in the cPanel. ....
How Do You Check Mysql Info, And Act According To It's Content?
(6) As part of a web-game on my site, I have a php form that requires people to enter their username,
and information about the characters they want to have in the game. All this information is stored
into a MySQL table. I want the players to be able to visit a page where every character they have
registered with their username can be seen. My question is simply, how can I check the values of
the MySQL data, and act accordingly? What I need to do is check for a Username and a character
number, and if it finds it, takes the data in that part and acts on it, eg. by showing th....
I Can Not Create Mysql Databases In Control Panel Using Phpmyadmin
Phpmyadmin says i don't have permissions to create databases (3) I went to phpmyadmin script a few minutes ago and i could not create a database. Since it says
there on my control panel that i have unlimited mysql databases, plus i am using only a couple of
databases, please respond and fix this, please.....
Is It Possible To Access The Mysql Remotely?
(10) I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
remotely. If that's not possible, are we allowed to run Python scripts on the server?....
Does Trap17 keep back-ups of my MySQL Databases?
(6) ok, well i screwed up yes i admit it i screwed up big time... anywho, umm i was wondering is
trap17 kept back-ups of the MySQL Databases??? and if they do would it be possible for me to get a
copy of the backup for my forums sent to me somehow? because stupid me, i was re-installing my
forums, and went to make a backup of my MySQL database jsut in case, and selected all and hit make
backup, and well it only made a backup of only one of the databses, so right now i am without the
many posts i had ten minutes ago so if you so keep backups thats awsome!! youv....
How To Crate Mysql Database?
urgent help (7) Hi everyone!
I'm trying to make in my site a page system that allows me to create users
account (with a foto for every user)...
I'm doing that in PHP, I learned all I have to
know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
is messing: ....
Mysql?
(15) My board has a mySQL error on it and when i went to cpanel it says for mySQL databases /99 instead
of 1/99 or 0/99. I tried making new one but it didn't appear after i created it /unsure.gif"
style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" />....
Mysql Version4.0.27
mysql version is old (2) I have came to my control cpanel,And I saw the mysql version,It is old,and with this version we
don't have to install into computer before use it,that is the way make it to hard to use to me
when I try to use it on my computer.So I want to ask you,Admin.Do you plan to upgrade mysql to
higher version like mysql 5.1.?If yes,please do it as soon as posible.Because right now i'm
using mysql 5.1 and I don't know how to use mysql 4.0.27. Otherwise,can I upload my exist
database to my account. I don't know how to create it in my account.It is so hard for me be....
Mysql Troubles
(0) Hey i am having troubles connecting to my mySQL database... Not exactly sure what to enter for the
server/host and database name, etc. Please shed some light on this subject for me /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Sorry i should have looked
around for an answer to this before i asked the question. I found an answer on another post If
anyone else reads this post looking for an answer to the same question try using "localhost" as the
server/host name /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt=....
Mysql Connection With Tsw Webcoder 2005
(2) Ok i just downloaded TSW Webcoder 2005 and i need to connect to my MySql databases through TSW
Webcoder 2005, but i dont know wat to put in for Server Url or port or anything, any elp would be
very very very much appreciated. Thanks ....
Mysql Databases Disapered
(8) Hi, my Mysql databases gone and i can not add any database! /sad.gif"
style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> Is this temporaly? In the
General account information the info show this: QUOTE Mysql databases / 99 /sad.gif"
style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> Any help would be very
thankful.....
Is It Possible To Move Only Part Of A Mysql Database
more like copying it and putting it elsewhere (4) Ok, well on my forums, i have two different forums, one for Role Playing (Harry Potter Role Playing
not $3x) and the other is for general harry potter discussions, and i added over 100 smilies to
my rpg forums, and i am guessing that the area that they store the shortcuts for it is in a mysql
database because i cannot find it anywhere else, and so i am curious if there is any way that i can
copy the part of the mysql database and move move to copie to the other database, so i dont have to
enter over 100 shortcuts AGAIN....because i basicly added all of the yahoo me....
Mysql Databases Disappeared
Any ideas? (6) Today I was checking my account, as my site forums were down, so I wanted to see the SQL server
status or fix the mySQL database. On Cpanel it says I have 0/99 mySQL databases - which is really
weird seeing that I have definitely had one for over a year /blink.gif"
style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" />. Anyone have any ideas?
Or will I need to start from scratch?....
Mysql Database Problem
appears to be deleted, but still has data (6) Hello. My Mysql databases appear to have been removed off of my account, yet according to my
cpanel, space is still being used on databases. Hopefully I haven't lost any of my data,
because I haven't taken a backup after recent updates, but If I have, I'll have to make do
with previous backup. Any idea what's wrong? Here's a quote from my cpanel QUOTE
Mysql databases 0 / 99 PostgreSQL Databases 0 / 99 Disk usage 13.16 / 150.00 MB SQL
Disk usage 2.99 MB As you can see, my database data still appears to be on the system, b....
Mysql
how to access MySQl from my computer (2) hello guys!, does anyone know which is the host or the ip of MySQL in trap17 in order to access
the server from a program called Navicat, i know trap17 has PHPMyAdmin but i would like to acces
with this Navicat thanx in advance.....
Installing Apache, Mysql, Phpmyadmin Locally
Solving the "php_mbstring.dll missing" (5) Since Trap17's CP provide the individual site's owner with goodies like MySql and
PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
expected that most people considering to make use of a database on their site will want to do most
of the tedious job of developing and testing on their own local system before sending the wrapped-up
result on their domain/subdomain. This involves four basic steps (sorry for the compuwi....
Mysql Database Setup : Setting Up Mysql Database
Guide to use MySQL database in your site (6) A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....
Looking for mysql, probelms
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for mysql, probelms
*MORE FROM TRAP17.COM*
|
advertisement
|
|
