Backup is to big

I just got a reply from my admins and they told me to check again if the problem is still there. Should I check it or you will have a look with yoour admin account?

You should check it. I have looked at everything there is to look at on your server/site so I will not be logging back in again.

@all

it worked – now with only the DB scheduled for backup it did a 55kb DB zip backup and the sql dump landed in wp-content/upgrade folder in the zip file – the name of the file is like this df74f1c67b143ba917e586f565849dbb.sql – 305kb after unpacking.

Could we call it a resolved problem?

What is the address to send a bunch of beers for this huge amount of work which you have done to help me?

That file name looks right. Random string + dbb (which is your db name?). Yikes, that was weird.

Your MySQL Database: virt106208_win

So hmmm not ??

I have opened the sql file in gedit and it looks like it has in it the right things.

virt106208_win … win? What flavor is your MySQL setup?

@infolotnicze – what was changed on the site/server to get things to happen differently/working? Send me the dump file so i can take a look at it.

@ipstenu – I am curious why these variables are being used:

$tables = $wpdb->get_col("SHOW TABLES LIKE '" . $wpdb->prefix . "%'");
$tables_string = implode( ' ', $tables );

Is there some additional reason to get the tables like this? In my XAMPP dump code I did not use these variables since I could not see a reason for why they would be needed. The XAMPP dump was perfect and tested a phpMyAdmin import.

virt106208_win … win? What flavor is your MySQL setup?

@ipstenu – yeah i had to check that out to “win….dows”. ?? it is just the naming convention that he picked because his domain name starts with “win”. ??

The dump is probably good (I would still like to see the actual dump file though to verify it 100%). Comparing dump file sizes with the BPS DB Backup I did during testing these are the numbers:

BPS zip size: 56KB
DreamObjects zip size: 55KB
BPS extracted sql dump size: 335KB
DreamObjects extracted sql dump size: 305KB

I have just send you the DreamObjects dump on your mail. Will report with the specific changes as soon as the admins will respond to my ticket.

Got it and compared the dumps. The DreamObjects dump is perfect. The slight difference in dump size between BPS dump and DreamObjects dump is because of additional SQL comment text in BPS dumps, which accounts for the other 30KB in size. The additional SQL comment text is placeholder text that is used by the DB Diff Tool to compare DB data table by table/line by line.

@ipstenu – the dump file name is: 6a2ad16831b51a24c54180b7fa20b9f3.sql so the extra “dbb” characters must have been added after the fact by infolotnicze in his previous post.

@aitpro

The sql dump I send was a dump from a full backup – files and sql.

The dump of only sql which was made earlier has that name with dbb – it has the same size so I think that the dbb was just a randob string added to that specific backup.

You only sent me the .sql file. I changed your DreamObjects settings to only create DB Backups for testing so you need to change that back to File and DB Backups.

Wow! You are correct: total characters in each hashed string is: 32. What a wierd/fluke coincidence. ??

I just did a full backup and now the name is:

ce66cbd50c39cc70cec4feb78f984b56.sql

@ipstenu – looking at the DreamObjects dump file I now see why you are using the other variables. ??