FreePgs.com Forum

FreePgs Related => Support Requests => Topic started by: roco on July 18, 2007, 12:45:05 PM

Title: Problems with mysql
Post by: roco on July 18, 2007, 12:45:05 PM
I know that mysql5 is under update.

Half of my DB just suddendly  vanished, i want to know if it possible to recover it.
Title: Re: Problems with mysql
Post by: looie on July 18, 2007, 02:56:12 PM
A drive was failing so they removed it until they get a new one on friday, so they might have backed it all up, and you'll just have to wait. Wait for tech support to confirm this though, cause I might be wrong.
Title: Re: Problems with mysql
Post by: brainiac744 on July 18, 2007, 04:08:53 PM
As far as I'm aware, freepgs doesn't do ANY backups of user data, and in the past they've made it very clear that it is up to each individual user to backup any important files or databases.

That being said, the RAID array is running in degraded mode because of the failed drive, so all hope isn't entirely lost, but if you can't see part of the data perhaps you should be looking for a backup and backing up what is left of it?
Title: Re: Problems with mysql
Post by: bruno2 on July 20, 2007, 07:42:57 AM
my phpbb forum can not connect to the database,,i hope freepgs have a backup,,plz can somebody confirm,,or must i make a new install becoz i dont have a backup.

thnxx
Title: Re: Problems with mysql
Post by: OLG on July 20, 2007, 08:22:38 AM
Hey, despite not being a member of freepgs staff i can confirm the following:

Freepgs do not perform backups of user data
- However in this case they will attempt to retrieve as much data as they can (according to admin)

Both hard disks in the MYSQL5 server RAID array have now failed (according to admin)

Quote
In most cases, the data on the MySQL5 server should not be lost.  We are attempting to run a chkdsk operation on the drive now to see if any of the "missing" files can be recovered.  [Hopefully, most users will not have any missing tables or data]

Once this new drive is in, the array will be rebuilt.  The array is not able to keep up with demands at this time.  Attempted access may result in data loss.  Once the first failed drive is replaced, we will replace the second drive to ensure we have two good drives on the system.

Thank you,
FreePgs.com Admin
Title: Re: Problems with mysql
Post by: dragonqueen on July 21, 2007, 09:27:50 AM
Has either drive been replaced yet? ???
Title: Re: Problems with mysql
Post by: OLG on July 21, 2007, 10:42:52 AM
One has, but cannot withstand the strain, also, read the message on the freepgs homepage.

QuoteMySQL5 Database Failure 
Both hard disks have failed on the MySQL5 database server. We are waiting for the second failed drive to be replaced. We will most likely not be able to recover any data from the drives.

Title: Re: Problems with mysql
Post by: mstram on July 27, 2007, 04:22:24 PM
Quote from: OLG on July 20, 2007, 08:22:38 AM
Hey, despite not being a member of freepgs staff i can confirm the following:

Freepgs do not perform backups of user data
- However in this case they will attempt to retrieve as much data as they can (according to admin)

Both hard disks in the MYSQL5 server RAID array have now failed (according to admin)

Quote
In most cases, the data on the MySQL5 server should not be lost.  We are attempting to run a chkdsk operation on the drive now to see if any of the "missing" files can be recovered.  [Hopefully, most users will not have any missing tables or data]

Once this new drive is in, the array will be rebuilt.  The array is not able to keep up with demands at this time.  Attempted access may result in data loss.  Once the first failed drive is replaced, we will replace the second drive to ensure we have two good drives on the system.

Thank you,
FreePgs.com Admin

Well I guess I just found out the hard way, why the hosting here is so inexpensive :(

So no backups are done here at all?

While technically, Mysql database data can be divided between "user" and "system" data, it makes little sense to backup the  system data without backing up the actual *data*

Mike
Title: Re: Problems with mysql
Post by: brainiac744 on July 27, 2007, 06:06:53 PM
They make it fairly well publicized that they do not do backups of any kind, it is your responsibility to do so. I'd recommend setting up some sort of automated script that would email the database to you, etc.
Title: Re: Problems with mysql
Post by: doctoreast on July 28, 2007, 01:25:16 AM

  I downloaded a package called "MYSQL Administrator",
to do quick dbase backup/restore and maintenance on
my own computer.  I also made a folder called "Daily_Backups".

Doc
Title: Re: Problems with mysql
Post by: admin on July 28, 2007, 01:02:13 PM
MySQL Administrator is part of the MySQL GUI Tools and can be found on the MySQL website.

http://dev.mysql.com/downloads/gui-tools/index.html

Thank you,
FreePgs.com Admin