This is actually a very easy thing to accomplish. On the source system, I run the following command:
Where -u is a switch to accept the database username to use, -p will prompt for a password, and the last entry is the database to export, in this case the sguildb database. Now, I have a large script that will rebuild the Sguil database on my development system in my user directory.
I log into the target system, and copy the script using the following command: