I had a recent situation where i needed to backup a site using WPMUDEV plugin Snapshot Pro.

It ‘s a good plugin, but I don’t like that it exports each table from MySQL as a separate *.sql file.

To import all of them in one handy command that can be used via the terminal, use the following:

cat *.sql | mysql -u database_user -p database_name