Cat pipe mysql : Stopped. What stopped and how can I fix that?

Question

I imported a large database from remote using a cat + mysql command :

cat my_db.sql | mysql --host=external_host --user=my_user --password=some_password my_database

And after some time, it returned

[1]+  Stopped                 cat my_db.sql | mysql --host=external_host --user=my_user --password=some_password my_database

What does that mean ? I did the same command with a smaller file and I got a [1]+ Done, so clearly, the first try didn't succeed completly, but I don't know what went wrong neither what to do to make it work completely.

Is there a possible solution to that ?

Thanks for your help !

I can't access them (It's a shared server with limited access) — Cyril N., Jun 16 '14 at 11:45
can you bring back the execution to the foreground again (`fg`)? — dawud, Jun 16 '14 at 11:47
I closed the ssh connection since, is it still possible to do that ? — Cyril N., Jun 16 '14 at 12:01
The shell does not let you logout if there are commands in background. How did you exactly executed the command? — dawud, Jun 16 '14 at 12:05
well, I ssh'd in, then executed the command, it showed the stopped, then I did the other one that showed the Done. Finally, I did a `exit`, and voila. — Cyril N., Jun 16 '14 at 12:29

score 0 · Answer 1 · answered Jun 16 '14 at 13:41

0

You have interrupted the command using Ctrl+Z.

You can bring it back to the foreground using the fg commnad.

This is part of the JOB CONTROL capabilities of the shell.

$ man bash

Ctrl+Z

[2]+  Stopped                 man bash

$ jobs
[1]-  Running                 sudo virt-viewer W7 2>&1 > /dev/null &
[2]+  Stopped                 man bash

$ fg %2

answered Jun 16 '14 at 13:41

dawud

14,918
3
41
61

No I didn't stopped it using Ctrl+z :p It stopped all alone ! – Cyril N. Jun 16 '14 at 14:03

Cat pipe mysql : Stopped. What stopped and how can I fix that?

1 Answers1