Backing up particular relations in MySQL
 

Hi
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!

Use phpMyAdmin. It has many features to do just that:

http://www.phpmyadmin.net/

Thanks a million Spookster. Exactly what I needed!!! :thumbsup: