Importing SQL dumps into MySQL through Command line

Question

To source sqldump i can use the source command, but if I need to do the same stuff using command line without going to the sqlpromt, can I achieve that.

Answer 1

If I understand your question correctly, and assuming a *nix environment, you can:

mysql -u xxx dbname -p < mysqldump

You'll get prompted for the password. [you can embed the pw there, but that's not good form as it will then be in your shell's history, which can be cleared, but can be captured.]

I always dump my table definition(s) separately from the data, so do the load in two steps, but if you did the dump as a single action that will work too, though it is harder to debug if there's a problem.