CodingForums.com - View Single Post

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!

10-27-2002, 04:07 AM	PM User \| #1
kestrel7 New Coder Join Date: Aug 2002 Location: Cape Town, South Africa Posts: 25 Thanks: 0 Thanked 0 Times in 0 Posts	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!