"What can a one liner do for you?" - Frankly Speaking
mysqldump -h ip -uuser -ppass from_db from_table | mysql -uuser -ppass target_db
Be careful specifying your password on the command line like that. Other users might be able to view it at /proc/[mysqldump pid]/cmdline
I thought this was a neat one until I tried it, and found it less problematic to just make a dump file and import it.
Post a Comment