I want to be able to take tables I created in one MySQL database and move it to another MySQL database (on another machine) in such a manner that the data in the tables are preserved.
Is it possible to backup particular relations in a database to a file and then to 're-install' it on another MySQL database? If so, I would really appreciate a little help with the commands to achieve this.
I don't know if it makes a difference, but the databases are likely to have different names (though the relation names will of course be the same).
(Alternatively, if I could find a way to backup just the structure of the tables and to export and import the data then I could also achieve the above situation).
As usual, any help is greatly appreciated!