« previous next »
Pages: [1]   Go Down

Author Topic: Empty database backups.  (Read 1564 times)

0 Members and 1 Guest are viewing this topic.

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Empty database backups.
« on: April 04, 2008, 05:41:00 AM »
Got a funny one for you. I backed up my database the other day and got a full 10 meg file.
Just tried to do it again and I keep getting 0 bytes.
There are no error messages and the forum seem to be working perfectly, so I know I can access the database. I'm a tad confused here and I'd like to get a solid backup done soonish.
« Last Edit: April 09, 2008, 09:47:22 AM by bigguy »
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Empty database backups.
« Reply #1 on: April 04, 2008, 08:12:12 AM »
Meh. Read in another thread about doing it through cpanel so I went with that option.
Got all four databases and the home directory. Now that's a backup.  :righton

It's still weird that the admin centre didn't do it though.
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13215
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Empty database backups.
« Reply #2 on: April 04, 2008, 11:58:25 AM »
Mine all seem to be fine. What host are you with; maybe this is something server side. ??? Glad you got it done though.
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Empty database backups.
« Reply #3 on: April 04, 2008, 05:48:11 PM »
Usually it works perfectly. As you'd expect with a functioning forum there has been a consistent increase in the size of the backup files. This is the first time it has played up.

We're with asmallorange.

Given how convenient it is (we have four MySQL databases) I think I'll mainly use cpanel from now on anyway. Is it worth doing the home directory on a regular basis, or is that so static that occasionally is fine?
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13215
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Empty database backups.
« Reply #4 on: April 04, 2008, 06:29:40 PM »
I would say occasionally is ok for that.
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Empty database backups.
« Reply #5 on: April 04, 2008, 06:33:58 PM »
Cool.

Off-topic, I just tried to upload an avatar.What's your maximum size here?
I need to resize it to fit.
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13215
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Empty database backups.
« Reply #6 on: April 04, 2008, 06:35:54 PM »
It's 100x100 :)
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Empty database backups.
« Reply #7 on: April 04, 2008, 06:45:35 PM »
 :righton Got it. An oldie but a goody.
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13215
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Empty database backups.
« Reply #8 on: April 04, 2008, 06:59:18 PM »
Lmao, good one. :)
Logged

Offline Smoky

  • who, me?
  • Guru
  • *
  • Posts: 3980
  • Karma: 1450
  • Gender: Female
  • It's all in your HEAD!
    • HangOutSpot
  • SMF Version: 2.0 ??
Re: Empty database backups.
« Reply #9 on: April 04, 2008, 07:08:03 PM »
i like that Antechinus.. lol poor bear!!  ;)
Logged
Oh wow, guess who dropped by! Im still on secondlife.. but will respond to im's *waves

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Empty database backups.
« Reply #10 on: April 09, 2008, 05:49:26 AM »
Found a solution this problem. It looks like it may be a timeout thing on the database.
I edited DumpDatabase.php as suggested here and it's back to full downloads again.  :righton
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13215
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Empty database backups.
« Reply #11 on: April 09, 2008, 09:47:14 AM »
Thats great to here.  :)
Logged

Offline Smoky

  • who, me?
  • Guru
  • *
  • Posts: 3980
  • Karma: 1450
  • Gender: Female
  • It's all in your HEAD!
    • HangOutSpot
  • SMF Version: 2.0 ??
Re: Empty database backups.
« Reply #12 on: April 09, 2008, 01:25:56 PM »
sure is, good job Antechinus!!  ;)
Logged
Oh wow, guess who dropped by! Im still on secondlife.. but will respond to im's *waves

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Empty database backups.
« Reply #13 on: April 09, 2008, 06:00:14 PM »
I'd recommend everyone do that edit. From what I can gather there are no possible drawbacks to it and it may save future problems.
Logged
Pages: [1]   Go Up
« previous next »