If you compare the backup from phpBB Security with the one from General Admin, there are quite a few differences.
Account History Table from phpBB Security
- Code: Select all
CREATE TABLE phpbb_account_hist ( user_id mediumint(8) default '0', lw_post_id mediumint(8) default '0', lw_money float default '0', lw_plus_minus smallint(5) default '0', MNY_CURRENCY varchar(8) default '', lw_date int(11) default '0', comment varchar(255) default '', status varchar(64) default '', txn_id varchar(64) default '', lw_site varchar(10) default '') TYPE=MyISAM;
Account History Table from General Admin
- Code: Select all
DROP TABLE IF EXISTS phpbb_account_hist;CREATE TABLE phpbb_account_hist( user_id mediumint(8), lw_post_id mediumint(8), lw_money float, lw_plus_minus smallint(5), MNY_CURRENCY varchar(8), lw_date int(11), comment varchar(255), status varchar(64), txn_id varchar(64), lw_site varchar(10));
They are very different, it looks like the Daily Database Backup is using MySQL4 compatibility, I don't know what the General Admin formatting is. Also, the General Admin backup includes the drop table command on all tables.
If you go to phpmyadmin, select your DB and select export, you'll see all the options for backing up and each one's gonna give you a different file size.