View Full Version : Backing up particular relations in MySQL

10-27-2002, 04:07 AM
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!

10-30-2002, 09:58 PM
Use phpMyAdmin. It has many features to do just that:


10-31-2002, 05:30 AM
Thanks a million Spookster. Exactly what I needed!!! :thumbsup: