mysqldump from remote host


Marty Wallace:

Is it possible to dump database from remote host over ssh connection and save backup file on local machine.

If so, how to achieve this?

I'm assuming it will be some combination of piped output from ssh to dump or vice versa, but can't figure it out.

Michel Feldheim:

This will dump over ssh, compress and stream to a local file

ssh -l user remoteserver "mysqldump -mysqldumpoptions database | gzip -3 -c" > /localpath/localfile.sql.gz 

Related


mysqldump from remote host

Marty Wallace: Is it possible to dump database from remote host over ssh connection and save backup file on local machine. If so, how to achieve this? I'm assuming it will be some combination of piped output from ssh to dump or vice versa, but can't figure it

mysqldump from remote host

Marty Wallace: Is it possible to dump database from remote host over ssh connection and save backup file on local machine. If so, how to achieve this? I'm assuming it will be some combination of piped output from ssh to dump or vice versa, but can't figure it

From mysqldump on local machine, no ssh access to remote

Dasharji I can SSH to a server with Apache installed (on a private network, connected via VPN). The internal IP of this server is 192.168.10.98. The web framework on this server can connect to the MySQL server on 192.168.10.97. Also, given that I only have acc

From mysqldump on local machine, no ssh access to remote

Dasharji I can SSH to a server with Apache installed (on a private network, connected via VPN). The internal IP of this server is 192.168.10.98. The web framework on this server can connect to the MySQL server on 192.168.10.97. Also, given that I only have acc

How to mysqldump remote database from local computer

Mauritz Hansen I need to perform a mysqldump of a database on a remote server, but that server doesn't have mysqldump installed. I want to use mysqldump on my machine to connect to a remote database and make a dump on my machine. I've tried to create an ssh tu

From mysqldump on local machine, no ssh access to remote

Dasharji I can SSH to a server with Apache installed (on a private network, connected via VPN). The internal IP of this server is 192.168.10.98. The web framework on this server can connect to the MySQL server on 192.168.10.97. Also, given that I only have acc

Copy files from local host to remote host

Thumbtack Thief This answer must exist somewhere because it's so basic, but I can't find it. I have a file on my local computer that I want to copy to a remote host. I know how to use scp, but if I use it from localhost to remote I get permission errors. I can

Access Kubernetes from a remote host

fear I'm pretty sure I'm misconfigured or missing something. My home network is 10.11.0.0/16 I set up a kubernetes instance with sudo kubeadm init --pod-network-cidr=10.166.0.0/16 Then I installed Calico CALICO_IPV4POOL_CIDR=10.166.32.0/20 then I use apiVers

Access Kubernetes from a remote host

fear I'm pretty sure I'm misconfigured or missing something. My home network is 10.11.0.0/16 I set up a kubernetes instance with sudo kubeadm init --pod-network-cidr=10.166.0.0/16 Then I installed Calico CALICO_IPV4POOL_CIDR=10.166.32.0/20 then I use apiVers

Access Kubernetes from a remote host

fear I'm pretty sure I'm misconfigured or missing something. My home network is 10.11.0.0/16 I set up a kubernetes instance with sudo kubeadm init --pod-network-cidr=10.166.0.0/16 Then I installed Calico CALICO_IPV4POOL_CIDR=10.166.32.0/20 then I use apiVers

from remote access virtual host?

Lord 3d I have a Linux (debian7), I run many different virtual hosts (for all my projects) - apache2, I usually use my dev server to test new features via mobile (for mobile), but it takes a long time time. How to set up a configuration on Linux so that the vi

Access Kubernetes from a remote host

fear I'm pretty sure I'm misconfigured or missing something. My home network is 10.11.0.0/16 I set up a kubernetes instance with sudo kubeadm init --pod-network-cidr=10.166.0.0/16 Then I installed Calico CALICO_IPV4POOL_CIDR=10.166.32.0/20 then I use apiVers

Access Kubernetes from a remote host

fear I'm pretty sure I'm misconfigured or missing something. My home network is 10.11.0.0/16 I set up a kubernetes instance with sudo kubeadm init --pod-network-cidr=10.166.0.0/16 Then I installed Calico CALICO_IPV4POOL_CIDR=10.166.32.0/20 then I use apiVers

Access Kubernetes from a remote host

fear I'm pretty sure I'm misconfigured or missing something. My home network is 10.11.0.0/16 I set up a kubernetes instance with sudo kubeadm init --pod-network-cidr=10.166.0.0/16 Then I installed Calico CALICO_IPV4POOL_CIDR=10.166.32.0/20 then I use apiVers

Access Kubernetes from a remote host

fear I'm pretty sure I'm misconfigured or missing something. My home network is 10.11.0.0/16 I set up a kubernetes instance with sudo kubeadm init --pod-network-cidr=10.166.0.0/16 Then I installed Calico CALICO_IPV4POOL_CIDR=10.166.32.0/20 then I use apiVers

Backup mysql from remote database, mysqldump process error occurs

Danius Java I want to backup my remote mysql database. I looked at many examples but couldn't find the correct answer. I have a mysql server on my computer with a different name than the remote database and just want to create a sql file on my computer to get

Backup mysql from remote database, mysqldump process error occurs

Danius Java I want to backup my remote mysql database. I looked at many examples but couldn't find the correct answer. I have a mysql server on my computer with a different name than the remote database and just want to create a sql file on my computer to get

Open file from remote host using Kate

stdcerr: Is it possible to open a file from a remote host Katelike using vim vim scp://root@cc3//var/log/dp.log:? I've tried the following but none of the options seem to work: kate scp://root@cc3//var/log/dp.log &andkate fish://root@cc3//var/log/dp.log & Augu

Ansible - include vars file from remote host

Mikhail Janowski I want to include variables from a file on a remote host, not the controlling computer running Ansible. For example, I have a file /var/database_credentials.yml (on my web server) What's the best way to add variables from a file to hostvars so

Open file from remote host using Kate

stdcerr: Is it possible to open a file from a remote host Katelike using vim vim scp://root@cc3//var/log/dp.log:? I've tried the following but none of the options seem to work: kate scp://root@cc3//var/log/dp.log &andkate fish://root@cc3//var/log/dp.log & Augu

How to copy files from remote to host ansible?

user_dev I am trying to copy a file from a remote host to a local server running an Ansible playbook. Although the task always executes successfully, the file is never copied to the local server. Here is the code: - file: path: vm_info.config mode: 077

Cannot access MySQL from remote host

james I've been following some documentation and trying to hack this documentation everywhere. Scenario I want to open the database for a specific user for any connection to anywhere in the world. For the sake of argument, let's call this user user1. I have cr

Protect files from Cat localhost to remote host

dspshyama Is there a way to secure appending text to a file on a remote computer? No need to actually copy the files like this. Currently, I need to do a safe copy before adding the cat. Is there any way to attach directly and safely? Any help would be great,

Can you run KSQL from a remote host?

Tony I have confluent-ksql-server running on one node of the cluster. Can we make ksql connect by specific host/computer outside kafka cluster? PS - this is to provide ksql access to developers Thanks! Nishutel Yes, you can. KSQL supports client-server archite

Ansible - include vars file from remote host

Mikhail Janowski I want to include variables from a file on a remote host, not the controlling computer running Ansible. For example, I have a file /var/database_credentials.yml (on my web server) What's the best way to add variables from a file to hostvars so

Ansible - include vars file from remote host

Mikhail Janowski I want to include variables from a file on a remote host, not the controlling computer running Ansible. For example, I have a file /var/database_credentials.yml (on my web server) What's the best way to add variables from a file to hostvars so