Posted November 9, 200618 yr I have a vbulletin board and my backups are 30mb+ so they time out in php. I downloaded mysqldumper and uploaded it. This is what it says for my database Database: theforums (124 Tables, 184472 Records, 31.2 MB) Table Prefix: GZip compression: activated Multipart Backup: no Backup Format: Complete Inserts Send email report: not activated FTP Transfer: not activated But for backups are only ~9mb! This is what it says for my latest (last night) backup. theforums compressed (gz) php(1.21 b6) BETTER BE 31MB BETTER BE 31MB 08.11.2006 18:32 no 124 / 183.635 9.51 MB Why does it show like x1000 less records in the backup? Is it the compression? Thanks.
November 9, 200618 yr Where are you getting your backups from? The vbulletin maintenance thing I take it? If so I recommend you backup from phpmyadmin or cpanel/directadmin... the backup from vbulletin doesnt compress as far as I am aware just gives you the .sql. Whereas cpanel/directadmin will compress it to a gzip. This is also easier as you can use the cpanel/directadmin admin backup tool instead of upping to phpmyadmin... just makes life easier.
November 9, 200618 yr Author No no, I used to use the built in one in maintence, but my db is so big it times out. So I uploaded a script that does it. Called 'myaqldumper', very simple... How would you do int my phpmyadmin? And is it possible to compress 31mb to 9.5mb ?l;ol
November 9, 200618 yr You could split the file into parts and copy and paste the code into the area in phpmyadmin. Hope you can get that sorted, in future take backups from your webadmin or phpmyadmin. vbulletin site tells you to telnet the DB but mosts host block telnet ports now I believe... Keep a backup of the backup and try spliting it into sections and uploading each section... /Typo
November 10, 200618 yr im not to sure mate, 30 mb to 9mb hmm :/ best bet is too have a go at splittin and uploadin in parts.. try ;)
November 10, 200618 yr Author How would I do that? Sorry, I'm not too good at sql. Edit: got it, thanks. Turns out it really was compressing 35mb into 10 mb. amazing.
