Re: Store dump from DB on Server A to Server B (File) and test restore on C

[Rick James]

First, a mini-lesson in shell syntax.

foo | bar
"pipes" the output of foo to bar. That is, whatever foo writes is treated as input to bar.

foo >filex
Sends the output from program foo to the file "filex".

bar <filex
gives the program bar the data that is in filex.

mysqldump's output is the interesting stuff.
mysql's input can be the output from mysqldump.

So...
To dump and reload in one step:
mysqldump ... | mysql ...
Note: No redirecting of output/input to/from any files.

Alternatively, doing it in 2 steps (and using some disk space for the file "dump.sql"):
mysqldump ... >dump.sql
mysql ... <dump.sql