Mysteriously Dissapearing Data from MYSQL database
This is going to sound strange but...
I have a reoccuring issue. My Mysql database reverts at random to previous version. This erases changes, additions, and deletions. The only way to undo is to have a constant backup and reupload to my server. I use a jumperserver site with cpanel to administrate my databases. Is this even POSSIBLE? Is it a server issue? What can I do??
Thanks for any help!
pr0gr4mm3r posted this at 00:18 — 18th March 2009.
He has: 1,502 posts
Joined: Sep 2006
First, I would check with your host and see if they are restoring backups for whatever reason.
Are you doing anything with MySQL transactions or anything?
decibel.places posted this at 00:19 — 18th March 2009.
He has: 1,494 posts
Joined: Jun 2008
Welcome to TWF Martha!
Sounds to me like your server admins are restoring backups for some reason that do not have your current data. I cannot imagine how else this would happen unless you have installed some kind of backup and restore app that is malfunctioning.
I have had many aggravating experiences with databases on shared hosting accounts.
At BlueHost they changed the password on on one of my dbs and refused to give me the new one (I had already decided to leave them for other reasons).
My client's web site at Webhostingpad dropped all connection with his database. They "fixed" it by placing static content where the dynamic db content should be. We could install the app and database, and the db was viewable in phpmyadmin, but the site could not find it. Probably a bad connection URL but he eventually had to move to another host.
You should have a frank talk with your support team and try to find out what is going on. If they start trying to blame you, it's time to move - ugh - but there are some good hosting companies out there!
martha783 posted this at 23:07 — 18th March 2009.
They have: 2 posts
Joined: Mar 2009
Yeah, I've been meaning to change hosts for a while cause I'm with jumpserver and their support staff disappeared from the face of the planet a while back. Don't give phone numbers and don't answer emails. ERgh, changing will not be fun but appears to be the only option...
pr0gr4mm3r posted this at 01:05 — 19th March 2009.
He has: 1,502 posts
Joined: Sep 2006
Moving websites isn't hard. You may want to consider hiring someone to help you out if you don't think you can do it w/o a ton of downtime.
fantastvik posted this at 08:08 — 6th July 2009.
They have: 28 posts
Joined: Sep 2008
Hi Martha ,
Even i agree changing webhosts would be a wise decision as far as moving your web site to the new host you can always seek my help if you do not know how to this.You can always post your problem in this thread and i will help you with your doubts.
{{ self promotional content removed by moderators }}
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.