DB backup problem from Server

[swapnil0545]

Hii everyone,
I have got a problem regarding my database backup from the server.

Here it is:
On my CPanel database it shows that my db is of 32 mb.

But when i download that db from CPanel Backup,vB maintainance and Phpmyadmin It shows only 22 mb.

And when i used it on my local host it showed an error while importing(As it was not complete).

My board is running good without any problems But I want to have a backup thats my THING.

Please help asap:hissyfit:

swapnil0545 Reviewed by swapnil0545 on 15th Feb 2009. DB backup problem from Server Hii everyone, I have got a problem regarding my database backup from the server. Here it is: On my CPanel database it shows that my db is of 32 mb. But when i download that db from CPanel Backup,vB maintainance and Phpmyadmin It shows only 22 mb. And when i used it on my local host it showed an error while importing(As it was not complete). Rating: 5

[Warex-Z]

Use mysqldumper.

[MRDJ]

yup the size u will download will be less thn what is showed in capneel as when u download the file is compressed using Gzip

[swapnil0545]

lol @keshav the gziped size is around 4.2 mb something when i extract then it comes to 22 mb.
@Warez-X, I will give it a try now.

[Sl!M]

mysqldumper will do the trick for you. its a beasty script.

[SplitIce]

I think you are referering to "mysqldump" no "er". But yes the file you download will be smaller as it is compressed.

Oh and importing large dumps use this command:

gunzip < file.sql.gz | mysql -u user -ppass database

[swapnil0545]

Can I get the link of that file

[swapnil0545]

I m getting this error at my emailID

Invalid or missing dbid argument in the query string: ?

[Warex-Z]

I think you are referering to "mysqldump" no "er". But yes the file you download will be smaller as it is compressed.

No, I'm referring to mysqldumper.

http://www.mysqldumper.de/en/

[swapnil0545]

Erratic it gave me the same 21mb file indeed