rsync mysql problem

Support/Development for MySQL, MariaDB, and other database systems
mist_firefly
Forum User
Forum User
Posts: 60
Joined: Mon Jul 23, 2012 5:22 am
Location: Salisbury

rsync mysql problem

Unread post by mist_firefly »

Just got the msgl dump from my server and wanted to back it up to a second server (I've been doing this before) but this time I get the following error when I use
rsync -v -e ssh mysql_24_09_2012.sql.gz root@plesk2.domain.co.uk:~ command to move it to the second server


mysql_24_09_2012.sql.gz
rsync: writefd_unbuffered failed to write 4 bytes to socket [sender]: Broken pipe (32)
rsync: write failed on "/root/mysql_24_09_2012.sql.gz": No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(301) [receiver=3.0.6]
rsync: connection unexpectedly closed (28 bytes received so far) [sender]
rsync error: error in rsync protocol data stream (code 12) at io.c(600) [sender=3.0.6]


What could I do?
Thanks
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: rsync mysql problem

Unread post by breun »

rsync: write failed on "/root/mysql_24_09_2012.sql.gz": No space left on device (28)
Looks like the /root filesystem on plesk2.domain.co.uk is full.
Lemonbit Internet Dedicated Server Management
mist_firefly
Forum User
Forum User
Posts: 60
Joined: Mon Jul 23, 2012 5:22 am
Location: Salisbury

Re: rsync mysql problem

Unread post by mist_firefly »

Does that mean all our server is full?
How can we check that?

Does it mean we need to remove things and that's the only option ?

Thanks
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: rsync mysql problem

Unread post by breun »

mist_firefly wrote:Does that mean all our server is full?
Note necessarily. It could be that /root is a separate filesystem.
mist_firefly wrote:How can we check that?
For instance by running df -h on the server.
mist_firefly wrote:Does it mean we need to remove things and that's the only option ?
Maybe the server has multiple filesystems and others might have more space available. You could then rsync the file to another filesystem.
Lemonbit Internet Dedicated Server Management
mist_firefly
Forum User
Forum User
Posts: 60
Joined: Mon Jul 23, 2012 5:22 am
Location: Salisbury

Re: rsync mysql problem

Unread post by mist_firefly »

Thanks for the help

I did a df -h and got the following


Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
225G 225G 0 100% /
/dev/sda1 99M 32M 63M 34% /boot
tmpfs 3.0G 0 3.0G 0% /dev/shm
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-local
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-queue
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-remote
tmpfs 3.0G 7.5M 3.0G 1% /usr/local/psa/handlers/info
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/spool


Could you please help me read this. (does it mean my root is 225 G and it's full and the rest of the directories are only 3 G?)
On our server we have more file systems but they don't seem to show on this list. (or maybe I'm just reading it wrong)
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: rsync mysql problem

Unread post by breun »

mist_firefly wrote:Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
225G 225G 0 100% /
/dev/sda1 99M 32M 63M 34% /boot
tmpfs 3.0G 0 3.0G 0% /dev/shm
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-local
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-queue
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-remote
tmpfs 3.0G 7.5M 3.0G 1% /usr/local/psa/handlers/info
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/spool


Could you please help me read this. (does it mean my root is 225 G and it's full and the rest of the directories are only 3 G?)
This indeed says that the / filesystem is 225 GB and completely full, so you'll need to free up some space by deleting files. The tmpfs filesystems are in-memory filesystems created by Plesk.
mist_firefly wrote:On our server we have more file systems but they don't seem to show on this list. (or maybe I'm just reading it wrong)
The output of df shows all filesystems by default. What other filesystems do you think you have? Maybe they are not mounted?
Lemonbit Internet Dedicated Server Management
Post Reply