...

View Full Version : Backing up particular relations in MySQL



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

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

http://www.phpmyadmin.net/

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum