473,884 Members | 2,430 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

My web hosting company lost my data from mysql database

Hello

My web hosting company has lost my data due to the mysql software failing,
it only affected those people using innoDB engine. I asked them why they
didnt restore from a back up. They said

"there is not an effective way of backing up mysql without either suspending
the service or causing latency problems connecting the database"

are they bull s*****g me or are they correct?

I think they have been totally unprofessional in my opinion, and have caused
me weeks of work and lost all my user details and the data they keep on my
database.

Their terms of condition has the usual get out clause, does this mean that
legally there is nothing I can do?

Ian
Aug 7 '06 #1
5 4115
mantrid wrote:
"there is not an effective way of backing up mysql without either suspending
the service or causing latency problems connecting the database"

are they bull s*****g me or are they correct?
I'm sorry to hear about your loss.

I don't think they are correct.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html says, regarding
the "mysqldump --single-transaction" option:

"This option issues a BEGIN SQL statement before dumping data
from the server. It is useful only with transactional tables
such as InnoDB and BDB, because then it dumps the consistent
state of the database at the time when BEGIN was issued
without blocking any applications."

But you might want to try it yourself before you call them liars on
this, so you can demonstrate that backing up InnoDB tables do not cause
concurrency problems.

Create a MySQL database on your PC, large enough so that a backup takes
several moments. Then run a backup using that --single-transaction
option, while simultaneously trying to read and write to the database,
and see if you get delays. From the wording above, you should not see
any blocking.
Their terms of condition has the usual get out clause, does this mean that
legally there is nothing I can do?
If the terms absolve them of responsibility for data backups, I'd assume
that there is little you can do to seek damages. But of course, *never*
accept legal advice from some clown on an internet newsgroup! Talk to
your lawyer and show him/her the terms of service from your hosting
provider. Then it's up to you and your lawyer to decide if you think
you can win enough in a settlement or judgment, to justify the exercise.

If it were me, I'd consider it a regrettable learning experience, and in
the future, create my _own_ backups, if the database contains valuable
and irreplaceable data.

For instance, if you use a hosting service that provides a web-based
MySQL administration tool like phpMyAdmin or something like it, there
should be a way to "export" your data to a text file, and then you
download the text file to your local PC, burn it to a CD, label and date
the CD, and put it in a fire safe.

Regards,
Bill K.
Aug 8 '06 #2
>My web hosting company has lost my data due to the mysql software failing,
>it only affected those people using innoDB engine. I asked them why they
didnt restore from a back up. They said

"there is not an effective way of backing up mysql without either suspending
the service or causing latency problems connecting the database"

are they bull s*****g me or are they correct?
They are correct in that there is no effective way of backing up mysql by using
a conventional file-by-file backup program of the kind typically supplied
with an operating system (dump/restore, tar, cpio, recursive copy, etc.)

With InnoDB tables, there is also no way they can hand you the last file-by-file
backup of the InnoDB databases, and let YOU try to extract something from them,
because they also contain *OTHER CUSTOMER'S DATA*.

I don't know how much it would slow down the database (or jam up
updates completely) if they had used "mysqldump --single-transaction"
on all databases (not just yours) while the web site was still up,
running, and making changes for the web sites of all the custoemrs.
>I think they have been totally unprofessional in my opinion, and have caused
me weeks of work and lost all my user details and the data they keep on my
database.
Why didn't YOU make backups?
>Their terms of condition has the usual get out clause, does this mean that
legally there is nothing I can do?
You can find another host. A host willing to take responsibility for your
data will be expensive, however.
Aug 10 '06 #3
>
Why didn't YOU make backups?
Easy to say in hindsight.
Because I stupidly assumed that anyone holding data on their computers does
regular backups (I do of my PC). Even more so if you are providing a charged
service and holding other peoples data, some of which may be extremely
valuble to your customers. Its seems like common sense to me. A senario, if
I lent you my car and you lost it by not taking common sense precations who
would you blame me or yourself for lending me the car. I feel it is unusual
to not make back ups of data on your system.If they dont the hosting company
should have made this very clear by indicating so during the sign up
procedure. But they are not going to jeopardize a contract at the last
moment by indicating that fact are they?
Their terms of condition has the usual get out clause, does this mean
that
legally there is nothing I can do?

You can find another host.
In the process of doing so. It is a bewildering task reading carefully
throught the terms of servive to ensure they do exactly what you want them
to do. Do you have any recomendations I could check out?
>A host willing to take responsibility for your
data will be expensive, however.
Not as expensive as loosing 400+ users and all the data they had stored on
my database and a good reputation that is so difficult to develop. not to
mention all the weeks of work I am now doing reconstructing my tables from
sql scripts in my php files, and changing php script to match the field
names I missed.
Aug 10 '06 #4
mantrid wrote:
>Why didn't YOU make backups?
Easy to say in hindsight.
Because I stupidly assumed that anyone holding data on their computers does
regular backups (I do of my PC). Even more so if you are providing a charged
service and holding other peoples data, some of which may be extremely
valuble to your customers. Its seems like common sense to me. A senario, if
I lent you my car and you lost it by not taking common sense precations who
would you blame me or yourself for lending me the car. I feel it is unusual
to not make back ups of data on your system.If they dont the hosting company
should have made this very clear by indicating so during the sign up
procedure. But they are not going to jeopardize a contract at the last
moment by indicating that fact are they?
>>Their terms of condition has the usual get out clause, does this mean
that
>>legally there is nothing I can do?
You can find another host.

In the process of doing so. It is a bewildering task reading carefully
throught the terms of servive to ensure they do exactly what you want them
to do. Do you have any recomendations I could check out?
>A host willing to take responsibility for your
data will be expensive, however.

Not as expensive as loosing 400+ users and all the data they had stored on
my database and a good reputation that is so difficult to develop. not to
mention all the weeks of work I am now doing reconstructing my tables from
sql scripts in my php files, and changing php script to match the field
names I missed.

Every host I've ever used has made it pretty clear that MySQL backups
are my responsibility. I'm sure they do make backups, but they can't
guarantee that they'll be available for you. You really should be
running your own backups - it's simple to write a short mysqldump script
to do it. I even use replication so that I can do an offline backup
that doesn't stop the master from running.

-Steven
Aug 10 '06 #5
...work I am now doing reconstructing my tables from
sql scripts in my php files, and changing php script to match the field
names I missed.
[eyebrows raised in disbelief]

You didn't even keep a copy of the database schema? You developed the
only copy of this database on the production server? And you had no
development/test instance of the app or the database?

I don't think you can blame your hosting service provider for that.

You probably don't have your PHP code managed by a source control tool,
either, right?

Bill K.
Aug 10 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2063
by: Nick Mudge | last post by:
Hello, I want to find a good web hosting company to build a site on using mysql and PHP. It would need to be scalable so that my web site could get really big. But I would start off small and with little money to pay for hosting. Does anybody recommend a good hosting company? Thanks Nick
11
4210
by: Mike MacSween | last post by:
My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no direct access to the db server. I'd like to give her the facility to export the information in her local Access application to the shared PHP/MySql site. From one command button (or similar) in the Access application.
2
1379
by: Roy Danon | last post by:
Hi, I'm looking for an ASP host which has a package which fits all following requirements : 1. 3000-5000MB(3-5GB) disk space 2. 30GB and above - transfer 3. 300 Email Boxes 4. Dedicated IP Address(Atleast One) 5. 20 or more Hosted Domains 6. Compoments :
1
2202
by: NotGiven | last post by:
I have been using a large hosting company and until recently, when I wanted to combine domain names and they will not let me out of a contract with two months remaining to combine accounts. they are losing $11 and will not budge. I have referred my clients to them and have been a long-time customer and have explained all this to them - not budging. So...I am looking for a new hosting company. I need PHP, MYSQL, and prefer an account...
2
1703
by: Lyle Fairfield | last post by:
Just in case you were considering this http://www.interland.com/ provides internet accessible MS-SQL dbs packaged with many of their web- hosting plans. I have two such dbs. Interland backs up theses databases daily but does not provide access to theses backups directly.
7
2369
by: John | last post by:
Do you guys have any idea if web hosting companies usually give access to SQL Server databases through Enterprise Manager? I used to have have access to my DB through EE with my previous provider and now the more I am looking into offers on the net the less I can see this feature specified. What can I do without EE to backup my database in a completely automated way? Can I assume SQLDMO will always be available so that I can backup the...
5
2096
by: Scott | last post by:
Can anyone refer me to a good hosting provider? I'm looking for a reseller plan with PHP 5, MySql 5, 24 x 7 support, and most importantly, a solid uptime record. Customer referrals only, please. Thanks, Scott
3
1734
by: mpar612 | last post by:
Hi everyone, I am new to PHP and I am trying to learn about using PHP to connect to a MySQL database using PEAR modules. My current web hosting provider compiles the PEAR modules into PHP so the code in many of the books I have been using will not work. So I have 3 questions: 1. Is my web hosting company doing something unusual? 2. Can anyone recommend a web hosting company that uses PHP5, MySQL and PEAR in a Linux environmnet?
7
1783
by: Michel Couche | last post by:
Hello, I am working on a project for a potential customer. The project will basically involve an ASP.Net 2.0 application and a database (ideally MS SQL). The customer has already a hosting plan but it does not currently include a MS SQL database. This option is offered as a rather expensive add-on (600 US $ /year). If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own
0
9954
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9799
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11170
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10769
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9591
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7137
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5808
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4623
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4231
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.