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

download - Firefox cannot save files (most of the time), how to solve? - Super User

this not full duplicate of this question or this question , though base question same. however, questions have no answers. for on half year have problems downloading files firefox. when click on download link, download dialog opened asking me do, save or open it. immediately, there error/warning pop-up (twice, can see 1 @ first) ok button. looks this message : "c:\users\%user%\appdata\local\temp\wbbdv9k8.zip.part not saved because source file not read. try again later or contact server administrator." replace '%user%' name of user trying download. after closing pop-up, download dialog disappears , have minimize firefox , open again, see other pop-up. downloading exact same file internet explorer work, not desired. i tried solutions here . tried solutions here . tried disabling extensions. tried fixing permissions on temp folder. tried making files , folder in profile directory non-readonly. tried running firefox administrator. tried ...
Read more

windows - "-2146893807 NTE_NOT_FOUND" when repair certificate store - Super User

i try repair certificate store in windows 10 doing c:\windows\system32>certutil -store -user ‎330000019dba8d5dddb98062a900000000019d "personal" certutil: -store command failed: 0x80090011 (-2146893807 nte_not_found) certutil: object not found. i have double check mmc, certificate details serial number of certificate. still fail repair certificate store. can please help? i getting same error when trying export pfx. turns out had export c:\cert.pfx instead of cert.pfx (it trying export file cert store ( cert:\localmachine\my ).
Read more