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
rsync mysql problem
-
- Forum User
- Posts: 60
- Joined: Mon Jul 23, 2012 5:22 am
- Location: Salisbury
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: rsync mysql problem
Looks like the /root filesystem on plesk2.domain.co.uk is full.rsync: write failed on "/root/mysql_24_09_2012.sql.gz": No space left on device (28)
Lemonbit Internet Dedicated Server Management
-
- Forum User
- Posts: 60
- Joined: Mon Jul 23, 2012 5:22 am
- Location: Salisbury
Re: rsync mysql problem
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
How can we check that?
Does it mean we need to remove things and that's the only option ?
Thanks
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: rsync mysql problem
Note necessarily. It could be that /root is a separate filesystem.mist_firefly wrote:Does that mean all our server is full?
For instance by running df -h on the server.mist_firefly wrote:How can we check that?
Maybe the server has multiple filesystems and others might have more space available. You could then rsync the file to another filesystem.mist_firefly wrote:Does it mean we need to remove things and that's the only option ?
Lemonbit Internet Dedicated Server Management
-
- Forum User
- Posts: 60
- Joined: Mon Jul 23, 2012 5:22 am
- Location: Salisbury
Re: rsync mysql problem
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)
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)
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: rsync mysql problem
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: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?)
The output of df shows all filesystems by default. What other filesystems do you think you have? Maybe they are not mounted?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)
Lemonbit Internet Dedicated Server Management