I want to move one table in one database to other database using mysql dump on linux terminal How can I go about it ?
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:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as off-topic by Max Vernon, dezso, Mark Storey-Smith, Kin, StanleyJohns Sep 22 '13 at 4:54
Take dump of a particular table from the particular database.
Import the table into new database.
If you want to rename the table.