mysqldump a large database? (26gb)
 

hey guys,

phpmyadmin shows my database is 26 gigs.. but whenever i mysqldump --all-databases --quick > alldatabases.sql I only get 11gigs (consistently)

I know there's a way to convert the db to myisam but my harddrive is @ 93% :( I'm trying to dump to my slave drive.

So is there a way to dump all 26 gigs to a slave drive? Thanks guys!

A dump is a dump: if you've got space, then the dump should contain all your data. Otherwise, you should get an error. Whether or not it happens to be a "slave drive" is totally irrelevant!

I'm not sure where you're getting the "26GB" and "11GB" numbers from ...
... but "database space used" does NOT necessarily equal "data currently stored in database".

Think of some other way to validate that the dump contains "all your data". I suspect you'll find you're already successful - you just didn't realize it ;-)

'Hope that helps .. PSM

PS:
You never responded back to your previous post:
http://www.linuxquestions.org/questi...emains-712376/

thanks.. i'm trying to solve the first step.. the ibdata1 file is 50 gigs.. but the size in use is 26 gigs.. when i dump, it only comes out 11gb..

there was no error either:

[root@WS-10022 ~]# mysqldump --single-transaction --quick --all-databases > /home2/alldatabases.sql
[root@WS-10022 ~]#

What is your inode size on your filesystem?

128


i just did this again: mysqldump -u root -p --single-transaction --quick --opt --all-databases > /home2/alldatabases2.sql

and still 11gb..

Hi -

Does "select count(*) from <<some table>>" show the same row count? Can you think of anything else to verify whether or not any actual "data" is missing?

Can you give me the stats on your file system? type, inode, blocks, etc? It sounds like you might have hit your file systems limit. A good example is ext2, with a block size of 1k your max single file size is around 16gb.