I want to move one table in one database to other database using mysql dump on linux terminal How can I go about it ?
closed as off-topic by Max Vernon, dezso, Mark Storey-Smith, Kin Shah, StanleyJohns Sep 22 '13 at 4:54
- This question does not appear to belong here. Either it's not database-related or it otherwise conflicts with the scope of our site. See What topics can I ask about here?, What types of questions should I avoid asking? or this blog post for more info.
Take dump of a particular table from the particular database.
mysqldump -u root -p --databases DBname --tables Tablename > xxyy.sql
Import the table into new database.
mysql -u root -p newDBname < xxyy.sql
If you want to rename the table.
rename table dbname.tablename to dbname.newtablename;