[CentOS] Problem getting mysqldump on Centos 5.x server

Bruce Whealton bruce at futurewaveonline.com
Wed Apr 24 18:40:31 UTC 2013


>> 

Bruce, one other option if you are low on diskspace is using ssh to pipe the
file to another server.

Check out
http://christiank.org/wp/2010/12/pipe-a-gzipped-mysql-dump-over-ssh/ for an
example of how you might do this

 

On Wed, Apr 24, 2013 at 7:06 PM, Eero Volotinen <eero.volotinen at iki.fi>
wrote:

Hi Bruce,

Error 28 means that "not enought diskspace", free some more disk space and
try again.
>>

I freed up some space but we are back to the access denied.  But wait.  I
recall that I changed the password yesterday.

Ok, so we are back to the error that relates to the lack of disk space.  So,
I guess that other technique will put the sqldump file into the users home
folder on that other server.

Interestingly, it isn't the directory or partition that holds the mysql
files that is nearly full, it is the /usr and the /tmp.  The latter, even
when I recursively delete everything is still reporting as full.  So, my
curiosity is whether or not, for the purpose of piping it through to another
server, it still needs disk space from one of those partitions.  I'm not
sure otherwise, why it reports not enough disk space when the /home
partition has over 100GB free.  Maybe it needs space in the /tmp directory.
I'll see if I get the same error trying to pipe it through to another
server.

Bruce




 




More information about the CentOS mailing list