Welcome to RCF - WHF

abdulbasit · Apr 01, 2007

Hi brother,

When I export backup of MySQL from phpMyAdmin for FunWadi database so sometimes it makes 35.1 MB sometimes 35.2 sometimes 34.8

Why is that so? Is the backup complete or it gets broken in between the download or what happens actually! I am actually confused whether the database is downloaded complete or not dontknow

Nightrider · Sep 25, 2004

Do you regularly prune the messages from any of your forums or do you have any processes that optimize and clean up the database tables? That would explain why the backups vary from day to day...

If you are unsure whether a backup is complete, you can open the sql file in a good text editor and make sure that there are CREATE TABLE queries for all of the tables in your database. If a CREATE TABLE entry exists for the last table in your database, then most likely all the other data is valid too. The only text editor that I've found that can handle large database backup files is UltraEdit...

munky2

abdulbasit · Apr 01, 2007

oh yeah i never thought of pruining. There is some pruining system going in some forums but not in all. But the problem is when I make backup now will be let's say of 35 MB, just after that I will make the same backup again and it will be of some other size! and it happens after every download i make and it finishes in 34-35 MB.

So than I think i must check through UltraEdit to see what is actually happening... Rolling Eyes

Nightrider · Sep 25, 2004

Why would you make two database backups in a row???

I doubt that there is anything to worry about. phpMyAdmin seems quite stable and usually tells you if there is a problem. Once you open the database backups in UltraEdit, it will be easy to tell whether there is a problem in the backup...

munky2

abdulbasit · Apr 01, 2007

NO, I just tried it once I don't know why and than saw the size was different of both the files even though there was no major changed in the board. So i doubt there is some problem.

Hmm... Alright, so I will download UltraEdit and check out whether there is any problem or not...

Nightrider · Sep 25, 2004

Ok, maybe between the time you ran the first backup and then the second, the forum prune option ran. I can't even begin to guess what changed, but I imagine that there is nothing wrong with what you have now...

munky2

rb2d2 · Sep 25, 2004

Our backups do the same thing. Seems they grow to a certain point and suddenly drop, then began to grow again ..... dontknow

Nightrider · Sep 25, 2004

Our backups decreased in size because I emptied some of the log tables. There really isn't anything magical about why this might happen. There is always a logical explanation even if it isn't immediately obvious...

munky2

abdulbasit · Apr 01, 2007

Ahaan. Than it's fine. I am quite happy now.

Thanks NR and rb2d2.

headbang

Nightrider · Sep 25, 2004