Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to move one table in one database to other database using mysql dump on linux terminal How can I go about it ?

share|improve this question

closed as off-topic by Max Vernon, dezso, Mark Storey-Smith, Kin, StanleyJohns Sep 22 '13 at 4:54

If this question can be reworded to fit the rules in the help center, please edit the question.

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;
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.