mysql - Take backup of a server which is 90% full - Ask Ubuntu


how take backup of live (database) ubuntu server, 90% full , how use tar or rsync & mysqldump command copy 1 server another?

from machine can access server across network on tcp port 3306, can use mysqldump remotely, , it's same running on server itself, except dump file created locally.

the --host option used specify ip address of server. --compress option allow transfer faster across wire. purpose -- transport compression -- doesn't make actual backup file smaller.

this can done server running normally.

rsync not safe tool use mysql server, if mysql running. won't hurt server, , backup appear work, files not usable. same applies tar or other copies files themselves. using mysqldump not read files directly, if run locally.

in ubuntu, typing mysqldump on machine isn't installed, should prompt several options of "client" packages include it, 1 of should fine.


Comments

Post a Comment

Popular posts from this blog

crash - Windows Rundll32 (child process of DllHost) is crashing. How can I even identify it? - Super User

windows 10 home / "x64-based pc" / dell xps 13 9360 in reliability monitor, have many "app failures" every day. go way 2017-12-04 without variation (the details below identical), when believe machine first used. problem marked having been reported (apart problem instances in past few minutes). @magicandre1981 suggested open public problem in windows app feedback hub reason. my question is: how can identify this? causes crashes? can resolved somehow? problem details faulting application path: c:\windows\system32\rundll32.exe problem event name: appcrash fault module name: windows.ui.immersive.dll fault module version: 10.0.16299.125 exception offset: 00000000000ac885 exception code: c0000005 os version: 10.0.16299.2.0.0.768.101 bucket id: ab5106f0b0020ee0d7e0c2d4f71642fb (1720589277589816059) "anti-virus" installed (mcafee virussafe) , running no alerts, no quarantined items, no significant logs can find. sfc /scanno...
Read more

debian - Kali Linux - Debootstrap error Failed to determine codename for the release - Super User

installing new kali linux 2016 rolling release hdd via usb. i made bootable usb using universal usb. booted off usb , selected "graphical install", had issue @ beginning install prompting cannot find data in cdrom, pulled usb , waited 30 seconds, plugged in waited 30 seconds plugged in , allowed me continue through install. i enabled lvm , went through whole process once done went next step "install system" @ point error debootstrap error failed determine codename release at point cannot go further in installation. went "debian installer menu" , executed shell. shell tried mount usb /cdrom using "mount -t vfat /dev/sdb1 /cdrom" found on debian forum. receive following error "mounting /dev/sdb1 on /cdrom failed: no such file or directory" try mkdir cdrom, states exists. sdb1 usb according "mount" i not sure @ point. advice great. thanks. i had same issue installing kali linux usb. tried install os graphic...
Read more

networking - Slave steals IP meant for bonded interface - Ask Ubuntu

i'm having issue combo. i'm trying set lacp bond using ubuntu 16.04 , cisco sg-300. have cisco configured lacp on 2 server's ports . in ubuntu have following config: # /etc/network/interfaces auto lo iface lo inet loopback auto eno1 iface eno1 inet manual bond-master bond0 auto eno2 iface eno2 inet manual bond-master bond0 auto bond0 iface bond0 inet static address 10.0.0.5 gateway 10.0.0.1 netmask 255.255.255.0 dns-nameserver 8.8.8.8 bond-mode 4 bond-miimon 100 bond-lacp-rate 1 bond-slaves eno1 eno2 xmit_hash_policy 0 this works has 1 issue. whenever system started [eno1 seems grab static ip bond0 10.0.0.5 , 10.0.0.5 unreachable on network. if 'ifdown eno1 && ifup eno1' bond grab 10.0.0.5 , start working normally. have clue why slave device grabbing static ip meant bond0 that? there static configuration in /etc/dhcpcd.conf. not sure how got there since i've used static on box. removed offending lines file removing dhcpcd5 pack...
Read more