Mysql Database Problem - appears to be deleted, but still has data

free web hosting
Free Web Hosting, No Ads > General > Hosted Members Area

Mysql Database Problem - appears to be deleted, but still has data

sportytalk
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, but I can't access my database at all, nor can my scripts.

Hope you can help smile.gif

Edit: Sorry If I've posted in the wrong forum, wasn't sure which one to post in, saw this was free webhosting support, so posted here, but just noticed another support forum. Please move if it's in the wrong place! smile.gif

 

 

 


Reply

brandice
I checked and mine is the same. Outages like this happen every so often, so it's happening to everyone.

You can scroll down in your cpanel, on the left hand side, at the very bottom, It says "Server status - Click to view" That will show you if it's just your problem or something that is happening across the board. Right now I see that there are a couple of things down. MySQL and something called "eximstats"

Reply

sportytalk
Ouch, I didn't think to look on the server status tab. I guess I should've checked it out, I guess this is a warning reminding me to take a backup!

Sorry for the hassle and thanks for your help brandice smile.gif

This topic is now solved biggrin.gif

Reply

itssami
Im trying to access my forum since last night
http://forum.pakdir.com

but its not working.It says critical error occured.Is it something wrong with my forum or its because of the server problem ???

Reply

kelvinismyname
QUOTE(brandice @ Feb 7 2006, 06:53 AM) *

I checked and mine is the same. Outages like this happen every so often, so it's happening to everyone.

You can scroll down in your cpanel, on the left hand side, at the very bottom, It says "Server status - Click to view" That will show you if it's just your problem or something that is happening across the board. Right now I see that there are a couple of things down. MySQL and something called "eximstats"



ok so it happens often, umm would i be able to get back my data bases or is it gone for GOOD?....

Trap17 is a good Service,and since its free i dont mind Outages like this once in a while,just as long as my data is safe.
cuz as of the moment,I totally forgot to back my db up,So i am praying that it will return soon sad.gif

 

 

 


Reply

tuddy
QUOTE(kelvinismyname @ Feb 7 2006, 11:58 PM) *

ok so it happens often, umm would i be able to get back my data bases or is it gone for GOOD?....

Trap17 is a good Service,and since its free i dont mind Outages like this once in a while,just as long as my data is safe.
cuz as of the moment,I totally forgot to back my db up,So i am praying that it will return soon sad.gif


Your data should be safe, but it is always good to have your own backup. Failures to servers ain't data loses, they occur more as power failures or hardware failures.

Im not 100% sure, but i'd say the server runs its own back up anyway, but thats not always safe to assume. Also, this is a very rare thing, hasn't happened until now since i been here.

If you think of how many web sites we have running here were webmasters just install a script that automates there datebase, they won't backup, or even know how in some cases, so apart of any great service like Trap17, i guess they keep on top of it.

Reply

darlord
Check it now. I had send mail with printscreen to administrator and now it works. laugh.gif

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : mysql, database, problem, appears, deleted, data

  1. It Went Well For A While
    MySQL problem back in all its glory. (5)
  2. Is The Database System Gone Again? [resolved]
    Errors on PHPMyAdmin again (12)
    I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
    again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
    failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
    Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
    current setting of session.save_path is correct
    (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
    /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca....
  3. 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....
  4. Very Disappointed With Data Center Migration
    What do you think? (9)
    I am hopping mad. I have had nothing but grief since Trap 17 moved their Data Center (DC).
    My site has been down more time than it has been up. I have had to contact Live Support at Xisto 4
    times now in the last month. This is ridiculous. They fix things, it lasts a few days and my site
    is down again. I am at my wits end. I have been told my support to contact Shree. I have
    already communicated with him and he told me that things were solved 6/16, then whatever happened,
    my site was lost completely and had to be restored from their backup. My whole acc....
  5. 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.....
  6. Phpmyadmin
    Create new database: No Privileges (6)
    i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
    install it the error is like this Creating Database Tables No database selected there a mysql
    database is made, but i can not use it for othere stuff... plz note that this is Free script and not
    for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
    but i am not sure if the script not working or it can be the server may be down on mysql...? ....
  7. I Need Help Transferring Sql Database?
    (3)
    ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the
    database. I am using phpmyadmin on both sides of the hosts. When i do the import i get this.
    QUOTE SQL query: -- -- Database: `apolopedia` -- CREATE DATABASE `apolopedia`
    DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access
    denied for user 'jaenagle'@'localhost' to database 'apolopedia' I tried to
    give my user all rights, but it gave me this also. QUOTE SQL query: GRANT A....
  8. 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 ....
  9. Changes In Phpmyadmin
    Access to my database from program not working anymore. (0)
    I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
    explaining this correctly). I run a newsletter system on my website and the details of the people
    who subscribed are in a MySQL database. To get those data from the database and to send the
    newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
    perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
    setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ....
  10. How To Know If Account Is Deleted
    (8)
    I think my trap17 account was deleted. How do we know? I guess our sites not working is a good
    enough indication, but i want to be sure. And if accounts are deleted, are all the files deleted
    also?....
  11. Need Help With My Database
    I cannot transfer my old site's database (19)
    I Couldn't import my database info via Import from php my admin and i got the .sql file from the
    php my admin of my old hosting and every time i try to import it give me an error that i don't
    have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" /> What shall i do?? I need Help Please....
  12. 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 ....
  13. Help! I Deleted All My Files!
    (5)
    Hi guys, i got hosted yesterday and i loged on to my file manager and deleted all the files in there
    i replaced them with my site including the index.htm page and now when i try to view it it says no
    page found!!! i dont no why this is as with my site when i payed for hosting from
    one.net it was as simple as using the run program and typing in mt ftp:\\ account copy the
    index.htm file and i was up and running! Can anyone help with what i have done wrong please
    thank you. /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sa....
  14. Installing Phpbb
    database problem (0)
    Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
    the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
    is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
    connect to the database Im not sure why this has happened as i have never really used mysql for
    ....
  15. 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,....
  16. Database Connection Problem
    phpBB2 installation error (5)
    *edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
    Transfered all of the database files over. On my new forums all of the old posts and everything
    shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
    me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
    says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
    know anyway to fix this?....
  17. 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....
  18. Database Errors!
    Started after HDD change.. (5)
    Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
    refresh site, they not that often but still i get them. It says "could not connect to database". And
    i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
    database! This is a notice email to let you know that SMF could not connect to the database,
    contact your host if this continues. so i am contacting my host......
  19. 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.....
  20. 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....
  21. 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?....
  22. Accidentally Deleted Pre-set Files
    (3)
    I made a bo-bo lol I've accidentally deleted those pre-set files that are in the file manager
    when you first register, you know those _vti thingy magiggers, well i accidentally deleted them, so
    i was wondering if an admin can re-insert them for me /biggrin.gif" style="vertical-align:middle"
    emoid=":D" border="0" alt="biggrin.gif" /> or re-set my hosting whatever you have to do.... thanks
    /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />....
  23. 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" />.......
  24. 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.....
  25. 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. ....
  26. 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?....
  27. 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....
  28. 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: ....
  29. 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....
  30. Mysql Database Setup : Setting Up Mysql Database
    Guide to use MySQL database in your site (4)
    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....

    1. Looking for mysql, database, problem, appears, deleted, data

Searching Video's for mysql, database, problem, appears, deleted, data
Similar
It Went Well
For A While
- MySQL
problem back
in all its
glory.
Is The
Database
System Gone
Again?
[resolved] -
Errors on
PHPMyAdmin
again
How Do I
Find My
Mysql
Password?
[resolved] -
Cannot
access my
MySQL
Very
Disappointed
With Data
Center
Migration -
What do you
think?
Remote
Access Mysql
Phpmyadmin -
Create new
database: No
Privileges
I Need Help
Transferring
Sql
Database?
Question
About The
Upgrade And
The Mysql
Usage ? -
question
about the
upgrade and
the mysql
usage?
Changes In
Phpmyadmin -
Access to my
database
from program
not working
anymore.
How To Know
If Account
Is Deleted
Need Help
With My
Database - I
cannot
transfer my
old
site's
database
Question
About Adding
Message
Board To
Site - Using
mysql?
Help! I
Deleted All
My
Files!
Installing
Phpbb -
database
problem
Phpbb2.17
Mysql
Problems -
Just this
week they
started
Database
Connection
Problem -
phpBB2
installation
error
99 Mysql
Databases?
Database
Errors!
- Started
after HDD
change..
Mysql Access
Error[resolv
ed]
Mysql Server
Problems
[resolved]
Cpanel And
Mysql
Problem.
[resolved]
Accidentally
Deleted
Pre-set
Files
Sites
Disapeard,
Mysql
Errors? Also
Server
Folders
Deleted
The
Difference
Between
Mysql And
Postgresql ?
Mysql Backup
Cronjob -
How to? : /
Is It
Possible To
Access The
Mysql
Remotely?
Does Trap17
keep
back-ups of
my MySQL
Databases?
How To Crate
Mysql
Database? -
urgent help
Installing
Apache,
Mysql,
Phpmyadmin
Locally -
Solving the
"php_mb
string.dll
missing"
;
Mysql
Database
Setup :
Setting Up
Mysql
Database -
Guide to use
MySQL
database in
your site
advertisement



Mysql Database Problem - appears to be deleted, but still has data



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE