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, StanleyJohns Sep 22 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.
Import the table into new database.
If you want to rename the table.