So I have two forums:
Forum 1:
database size: 61 MB
downloaded backup: 36 MB
Forum 2:
database size: 202 MB
downloaded backup: 1.4 MB
Why is forum 2's downloaded backup sooo small?! I clicked on "Select all" for tables and backup content set to structure and data...what gives? Tried 3 times all three were 1.4 mb...
Just tried on another forum...with the same results:
Forum 3:
database size: 290 MB
downloaded backup: 1.6 MB
What's up with these tiny backups?!
Probaby because it's compressed.
Why would you want a big one anyway? :p
All three forum backups were compressed. There's no reason why forum 2 and 3 would compress so much more compared forum 1.
Also, there's no way compression can make 200 MB database into 2 MB! lol
It's probably not saving all the tables. Load the database on a different host/forum and see if that's the problem.
Are you backing up from phpMyAdmin or the MyBB admin cp?
They will be incomplete backups. It will hit memory or execution time limit.
MyBB 1.8 improves that a little (
https://github.com/mybb/mybb/pull/226 ) and you can patch 1.6:
http://community.mybb.com/thread-128397-...#pid997156 (the latter for the backup task only)
That way for backup files in the admin/backup/ folder you can at least see directly whether a backup is incomplete or not (incomplete in the filename).
However, at some point you will simply not be able to use the ACP to backup directly anymore, not without running it as cronjob without restrictions.
It seemed like they were incomplete backups but how is it that it's aways incomplete the exact same size? I tried forum 2 like 4 times...every time it finished at 1.4MB.
(2014-07-26, 12:33 PM)frostschutz Wrote: [ -> ]They will be incomplete backups. It will hit memory or execution time limit.
MyBB 1.8 improves that a little ( https://github.com/mybb/mybb/pull/226 ) and you can patch 1.6: http://community.mybb.com/thread-128397-...#pid997156 (the latter for the backup task only)
That way for backup files in the admin/backup/ folder you can at least see directly whether a backup is incomplete or not (incomplete in the filename).
However, at some point you will simply not be able to use the ACP to backup directly anymore, not without running it as cronjob without restrictions.
it may always hit the memory limit at the same query... does it matter? if it's incomplete, it's useless either way.