Styjun

Cauchy reals and Dedekind reals satisfy "the same mathematical theorems"

How could an animal "smell" carbon monoxide?

Do I need a 50/60Hz notch filter for battery powered devices?

Is there any conditions on a finite abelian group so that it cannot be class group of any number field?

Is the Gritty Realism variant incompatible with dungeon-based adventures?

Can you perfectly wrap a cube with this blocky shape?

Can a dragon's breath weapon pass through Leomund's Tiny Hut?

What advantages do focused Arrows of Slaying have over more generic ones?

How can I leave a car for someone if we can't meet in person?

Can a Resident Assistant Be Told to Ignore a Lawful Order?

What happens on Day 6?

What are "full piece" and "half piece" in chess?

What is the meaning of [[:space:]] in bash?

How to remove the first colon ':' from a timestamp?

Why doesn't philosophy have higher standards for its arguments?

How to determine the optimal threshold to achieve the highest accuracy

Why isn't aluminium involved in biological processes?

Sankhara meditation

What is the word for "event executor"?

Interviewing with an unmentioned 9 months of sick leave taken during a job

When does Fisher's "go get more data" approach make sense?

How can I find what program is preventing my Mac from going to sleep?

A scene of Jimmy diversity

How to ask my office to remove the pride decorations without appearing anti-LGBTQ?

How to do a `mysqldump` from a remote server with the terminal and save locally

How do I restore a dump file from mysqldump?Compare two MySQL databasesmysqldump backup and restore to remote serverhow to mysqldump remote db from local machinebrew install mysql on macOShow to log in to mysql and query the database from linux terminalHow to save the mysqldump file on remote serverERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)Reference - What does this error mean in PHP?How to get the current date and time in the terminal and set a custom command in terminal for it?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

How can I do a mysqldump from a server by using the Terminal?

I did the following:

First of all I logged in:

ssh root@123.456.78.90 // then I enter my password

then I do:

mysql->show databases;

after that:

use the_database;

then I do:

mysqldump -u myusername -p the_database > db_backup.sql

after that, obviously, nothing happens and I do not get an error. So my question is, where does it save the backup and how can I get a the mysqldump on my local machine?

mysql terminal

share|improve this question

asked Mar 26 at 8:19

ST80ST80

86122 gold badges1818 silver badges3434 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you explain that further? Why is it that obvious that nothing happens?
  
  – Nico Haase
  Mar 26 at 9:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I did choose the wrong words, what I was trying to say is that I visually dont see anything, I mean there is no backup sql file somewhere visible
  
  – ST80
  Mar 26 at 9:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you pipe the output to some file, nothing is printed - if you want to see the output, either skip the pipe or run something like cat on the resulting file
  
  – Nico Haase
  Mar 26 at 9:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @NicoHaase ok, but I do not understand what you are saying
  
  – ST80
  Mar 26 at 9:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you use > in a command line, you redirect the output (here: the dumped data) to a file - that's why you see no output
  
  – Nico Haase
  Mar 26 at 9:59
  

  
  
  
  

 | 
show 2 more comments

0

How can I do a mysqldump from a server by using the Terminal?

I did the following:

First of all I logged in:

ssh root@123.456.78.90 // then I enter my password

then I do:

mysql->show databases;

after that:

use the_database;

then I do:

mysqldump -u myusername -p the_database > db_backup.sql

after that, obviously, nothing happens and I do not get an error. So my question is, where does it save the backup and how can I get a the mysqldump on my local machine?

mysql terminal

share|improve this question

asked Mar 26 at 8:19

ST80ST80

86122 gold badges1818 silver badges3434 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you explain that further? Why is it that obvious that nothing happens?
  
  – Nico Haase
  Mar 26 at 9:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I did choose the wrong words, what I was trying to say is that I visually dont see anything, I mean there is no backup sql file somewhere visible
  
  – ST80
  Mar 26 at 9:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you pipe the output to some file, nothing is printed - if you want to see the output, either skip the pipe or run something like cat on the resulting file
  
  – Nico Haase
  Mar 26 at 9:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @NicoHaase ok, but I do not understand what you are saying
  
  – ST80
  Mar 26 at 9:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you use > in a command line, you redirect the output (here: the dumped data) to a file - that's why you see no output
  
  – Nico Haase
  Mar 26 at 9:59
  

  
  
  
  

 | 
show 2 more comments

How can I do a mysqldump from a server by using the Terminal?

I did the following:

First of all I logged in:

ssh root@123.456.78.90 // then I enter my password

then I do:

mysql->show databases;

after that:

use the_database;

then I do:

mysqldump -u myusername -p the_database > db_backup.sql

after that, obviously, nothing happens and I do not get an error. So my question is, where does it save the backup and how can I get a the mysqldump on my local machine?

mysql terminal

share|improve this question

asked Mar 26 at 8:19

ST80ST80

86122 gold badges1818 silver badges3434 bronze badges

ssh root@123.456.78.90 // then I enter my password

mysql->show databases;

use the_database;

mysqldump -u myusername -p the_database > db_backup.sql

share|improve this question

asked Mar 26 at 8:19

ST80ST80

86122 gold badges1818 silver badges3434 bronze badges

share|improve this question

asked Mar 26 at 8:19

ST80ST80

86122 gold badges1818 silver badges3434 bronze badges

asked Mar 26 at 8:19

ST80ST80

86122 gold badges1818 silver badges3434 bronze badges

asked Mar 26 at 8:19

ST80ST80

86122 gold badges1818 silver badges3434 bronze badges

2 Answers
2

active

oldest

votes

1

There are multiple ways of how and where to backup, but most probably you would not like to store your backup in the same server where you are running the database.

If you have ssh access to the server you could create an ssh-tunnel, the most basic example of this could be:

$ ssh -L 3307:localhost:3306 root@123.456.78.90

What this will do is to open port 3307 locally (just in case you already are using 3306) and forward it to localhost:3306 going through 123.456.78.90

Then you could do something like:

$ mysqldump -h localhost -P 3307 -u myusername -p the_database > db_backup.sql

To know your current path, run pwd it will print your current directory and in where the db_backup.sql will be created in case you don't specify and absolute path.

Without using ssh you could also try to connect directly by just specifying the host:

$ mysqldump -h 123.456.78.90 -u myusername -p the_database > db_backup.sql

In case the port is open probably you will need just to modify/grant the user permissions to allow your IP to access:

 mysql> GRANT ALL ON the_database.* TO your_user@'123.456.78.90' IDENTIFIED BY 'secret';

share|improve this answer

edited Mar 26 at 9:07

answered Mar 26 at 8:37

nbarinbari

13.7k33 gold badges2828 silver badges5252 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ah ok, so pwd I should enter something like User/myusername/Desktop/somefolder/ ?
  
  – ST80
  Mar 26 at 8:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you can fully ignore the pwd command, is just for you to use it as a reference and to know where probably the files will be stored, for example, if you want your backup to be in /tmp/db_backup.sql you could use myqldump -h localhost -P 3307 -u myusername -p the_database > /tmp/db_backup.sql, if you don't specify an absolute path the files will be stored in the current directory, normally the output of the pwd command
  
  – nbari
  Mar 26 at 8:44
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok, should I then create the tunnel after I entered the mysql command (see above in the question)? sorry, pretty new to this :-)
  
  – ST80
  Mar 26 at 8:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Depends if the port is accessible and if your user permissions in the DB, you could either try to connect directly without the ssh tunnel and if that doesn't work a try, create the tunnel and then try the mysqldump
  
  – nbari
  Mar 26 at 8:55
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OK, either or, nothing happens :-s
  
  – ST80
  Mar 26 at 8:57
  

  
  
  
  

 | 
show 1 more comment

0

Connect to your server using ssh command.

run below code

mysqldump -u userName -p databaseName > /path/to/backup.sql

the location path must be on same server

share|improve this answer

edited Mar 26 at 9:03

yunzen

23.8k88 gold badges5555 silver badges8484 bronze badges

answered Mar 26 at 9:00

Rajesh M. KanojiaRajesh M. Kanojia

2955 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55352580%2fhow-to-do-a-mysqldump-from-a-remote-server-with-the-terminal-and-save-locally%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

There are multiple ways of how and where to backup, but most probably you would not like to store your backup in the same server where you are running the database.

If you have ssh access to the server you could create an ssh-tunnel, the most basic example of this could be:

$ ssh -L 3307:localhost:3306 root@123.456.78.90

What this will do is to open port 3307 locally (just in case you already are using 3306) and forward it to localhost:3306 going through 123.456.78.90

Then you could do something like:

$ mysqldump -h localhost -P 3307 -u myusername -p the_database > db_backup.sql

To know your current path, run pwd it will print your current directory and in where the db_backup.sql will be created in case you don't specify and absolute path.

Without using ssh you could also try to connect directly by just specifying the host:

$ mysqldump -h 123.456.78.90 -u myusername -p the_database > db_backup.sql

In case the port is open probably you will need just to modify/grant the user permissions to allow your IP to access:

 mysql> GRANT ALL ON the_database.* TO your_user@'123.456.78.90' IDENTIFIED BY 'secret';

share|improve this answer

edited Mar 26 at 9:07

answered Mar 26 at 8:37

nbarinbari

13.7k33 gold badges2828 silver badges5252 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ah ok, so pwd I should enter something like User/myusername/Desktop/somefolder/ ?
  
  – ST80
  Mar 26 at 8:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you can fully ignore the pwd command, is just for you to use it as a reference and to know where probably the files will be stored, for example, if you want your backup to be in /tmp/db_backup.sql you could use myqldump -h localhost -P 3307 -u myusername -p the_database > /tmp/db_backup.sql, if you don't specify an absolute path the files will be stored in the current directory, normally the output of the pwd command
  
  – nbari
  Mar 26 at 8:44
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok, should I then create the tunnel after I entered the mysql command (see above in the question)? sorry, pretty new to this :-)
  
  – ST80
  Mar 26 at 8:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Depends if the port is accessible and if your user permissions in the DB, you could either try to connect directly without the ssh tunnel and if that doesn't work a try, create the tunnel and then try the mysqldump
  
  – nbari
  Mar 26 at 8:55
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OK, either or, nothing happens :-s
  
  – ST80
  Mar 26 at 8:57
  

  
  
  
  

 | 
show 1 more comment

1

There are multiple ways of how and where to backup, but most probably you would not like to store your backup in the same server where you are running the database.

If you have ssh access to the server you could create an ssh-tunnel, the most basic example of this could be:

$ ssh -L 3307:localhost:3306 root@123.456.78.90

What this will do is to open port 3307 locally (just in case you already are using 3306) and forward it to localhost:3306 going through 123.456.78.90

Then you could do something like:

$ mysqldump -h localhost -P 3307 -u myusername -p the_database > db_backup.sql

To know your current path, run pwd it will print your current directory and in where the db_backup.sql will be created in case you don't specify and absolute path.

Without using ssh you could also try to connect directly by just specifying the host:

$ mysqldump -h 123.456.78.90 -u myusername -p the_database > db_backup.sql

In case the port is open probably you will need just to modify/grant the user permissions to allow your IP to access:

 mysql> GRANT ALL ON the_database.* TO your_user@'123.456.78.90' IDENTIFIED BY 'secret';

share|improve this answer

edited Mar 26 at 9:07

answered Mar 26 at 8:37

nbarinbari

13.7k33 gold badges2828 silver badges5252 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ah ok, so pwd I should enter something like User/myusername/Desktop/somefolder/ ?
  
  – ST80
  Mar 26 at 8:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you can fully ignore the pwd command, is just for you to use it as a reference and to know where probably the files will be stored, for example, if you want your backup to be in /tmp/db_backup.sql you could use myqldump -h localhost -P 3307 -u myusername -p the_database > /tmp/db_backup.sql, if you don't specify an absolute path the files will be stored in the current directory, normally the output of the pwd command
  
  – nbari
  Mar 26 at 8:44
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok, should I then create the tunnel after I entered the mysql command (see above in the question)? sorry, pretty new to this :-)
  
  – ST80
  Mar 26 at 8:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Depends if the port is accessible and if your user permissions in the DB, you could either try to connect directly without the ssh tunnel and if that doesn't work a try, create the tunnel and then try the mysqldump
  
  – nbari
  Mar 26 at 8:55
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OK, either or, nothing happens :-s
  
  – ST80
  Mar 26 at 8:57
  

  
  
  
  

 | 
show 1 more comment

There are multiple ways of how and where to backup, but most probably you would not like to store your backup in the same server where you are running the database.

If you have ssh access to the server you could create an ssh-tunnel, the most basic example of this could be:

$ ssh -L 3307:localhost:3306 root@123.456.78.90

What this will do is to open port 3307 locally (just in case you already are using 3306) and forward it to localhost:3306 going through 123.456.78.90

Then you could do something like:

$ mysqldump -h localhost -P 3307 -u myusername -p the_database > db_backup.sql

To know your current path, run pwd it will print your current directory and in where the db_backup.sql will be created in case you don't specify and absolute path.

Without using ssh you could also try to connect directly by just specifying the host:

$ mysqldump -h 123.456.78.90 -u myusername -p the_database > db_backup.sql

In case the port is open probably you will need just to modify/grant the user permissions to allow your IP to access:

 mysql> GRANT ALL ON the_database.* TO your_user@'123.456.78.90' IDENTIFIED BY 'secret';

share|improve this answer

edited Mar 26 at 9:07

answered Mar 26 at 8:37

nbarinbari

13.7k33 gold badges2828 silver badges5252 bronze badges

$ ssh -L 3307:localhost:3306 root@123.456.78.90

$ mysqldump -h localhost -P 3307 -u myusername -p the_database > db_backup.sql

$ mysqldump -h 123.456.78.90 -u myusername -p the_database > db_backup.sql

 mysql> GRANT ALL ON the_database.* TO your_user@'123.456.78.90' IDENTIFIED BY 'secret';

share|improve this answer

edited Mar 26 at 9:07

answered Mar 26 at 8:37

nbarinbari

13.7k33 gold badges2828 silver badges5252 bronze badges

answered Mar 26 at 8:37

nbarinbari

13.7k33 gold badges2828 silver badges5252 bronze badges

answered Mar 26 at 8:37

nbarinbari

13.7k33 gold badges2828 silver badges5252 bronze badges

0

Connect to your server using ssh command.

run below code

mysqldump -u userName -p databaseName > /path/to/backup.sql

the location path must be on same server

share|improve this answer

edited Mar 26 at 9:03

yunzen

23.8k88 gold badges5555 silver badges8484 bronze badges

answered Mar 26 at 9:00

Rajesh M. KanojiaRajesh M. Kanojia

2955 bronze badges

add a comment | 

0

Connect to your server using ssh command.

run below code

mysqldump -u userName -p databaseName > /path/to/backup.sql

the location path must be on same server

share|improve this answer

edited Mar 26 at 9:03

yunzen

23.8k88 gold badges5555 silver badges8484 bronze badges

answered Mar 26 at 9:00

Rajesh M. KanojiaRajesh M. Kanojia

2955 bronze badges

add a comment | 

Connect to your server using ssh command.

run below code

mysqldump -u userName -p databaseName > /path/to/backup.sql

the location path must be on same server

share|improve this answer

edited Mar 26 at 9:03

yunzen

23.8k88 gold badges5555 silver badges8484 bronze badges

answered Mar 26 at 9:00

Rajesh M. KanojiaRajesh M. Kanojia

2955 bronze badges

mysqldump -u userName -p databaseName > /path/to/backup.sql

share|improve this answer

edited Mar 26 at 9:03

yunzen

23.8k88 gold badges5555 silver badges8484 bronze badges

answered Mar 26 at 9:00

Rajesh M. KanojiaRajesh M. Kanojia

2955 bronze badges

edited Mar 26 at 9:03

yunzen

23.8k88 gold badges5555 silver badges8484 bronze badges

edited Mar 26 at 9:03

yunzen

23.8k88 gold badges5555 silver badges8484 bronze badges

answered Mar 26 at 9:00

Rajesh M. KanojiaRajesh M. Kanojia

2955 bronze badges

answered Mar 26 at 9:00

Rajesh M. KanojiaRajesh M. Kanojia

2955 bronze badges