FreePgs.com Forum
December 07, 2021, 01:07:31 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Click Here for Toll-Free Service for your business starting at $2.00 per month and 4.5 cents per minute
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Problems with mysql  (Read 7091 times)
roco
Verified Account
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 2

Blog entries (0)

View Profile
« on: July 18, 2007, 08:45:05 AM »

I know that mysql5 is under update.

Half of my DB just suddendly  vanished, i want to know if it possible to recover it.
Logged
looie
Verified Account
Jr. Member
*

Karma: +1/-0
Offline Offline

Posts: 37

Gangsta =P

Blog entries (0)

View Profile
« Reply #1 on: July 18, 2007, 10:56:12 AM »

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.
Logged
FreePgs.com Forum
« Reply #1 on: July 18, 2007, 10:56:12 AM »

 Logged
brainiac744
Verified Account
Sr. Member
*

Karma: +10/-0
Offline Offline

Posts: 403

Blog entries (0)

View Profile
« Reply #2 on: July 18, 2007, 12: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?
Logged
bruno2
Verified Account
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 3

Blog entries (0)

View Profile
« Reply #3 on: July 20, 2007, 03: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
Logged
FreePgs.com Forum
« Reply #3 on: July 20, 2007, 03:42:57 AM »

 Logged
OLG
Verified Account
Jr. Member
*

Karma: +0/-0
Offline Offline

Posts: 25

Blog entries (0)

View Profile
« Reply #4 on: July 20, 2007, 04: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
« Last Edit: July 20, 2007, 04:33:36 AM by OLG » Logged
dragonqueen
Verified Account
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 13

Blog entries (0)

View Profile
« Reply #5 on: July 21, 2007, 05:27:50 AM »

Has either drive been replaced yet? Huh
Logged
OLG
Verified Account
Jr. Member
*

Karma: +0/-0
Offline Offline

Posts: 25

Blog entries (0)

View Profile
« Reply #6 on: July 21, 2007, 06:42:52 AM »

One has, but cannot withstand the strain, also, read the message on the freepgs homepage.
 
Quote
MySQL5 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.

Logged
mstram
Verified Account
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 6

Blog entries (0)

View Profile
« Reply #7 on: July 27, 2007, 12:22:24 PM »

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 Sad

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
« Last Edit: July 27, 2007, 01:17:42 PM by mstram » Logged
brainiac744
Verified Account
Sr. Member
*

Karma: +10/-0
Offline Offline

Posts: 403

Blog entries (0)

View Profile
« Reply #8 on: July 27, 2007, 02: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.
Logged
doctoreast
Verified Account
Jr. Member
*

Karma: +2/-4
Offline Offline

Posts: 60

Blog entries (0)

View Profile
« Reply #9 on: July 27, 2007, 09:25:16 PM »


  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
Logged
admin
Administrator
Hero Member
*****

Karma: +30/-2
Offline Offline

Posts: 1567

Blog entries (0)

View Profile
« Reply #10 on: July 28, 2007, 09:02:13 AM »

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
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!