MySQL dump query from table and restore

depam · 06-23-2014, 09:12 PM

Any easy way of dumping a query from a database specific table and restore it on another DB?

I googled around and can do mysql -uuname -ppass -e "SELECT * FROM tablename WHERE column=y" > output.sql

I don't know how to restore this on table on other DB

Tried mysql -uuname -ppass dbname.tablename < output.sql but not working

sag47 · 06-24-2014, 01:21 AM

Why don't you use mysqldump? It's a command to dump databases for backup (and later restoration).