Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    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!

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Use phpMyAdmin. It has many features to do just that:

    http://www.phpmyadmin.net/
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #3
    New Coder
    Join Date
    Aug 2002
    Location
    Cape Town, South Africa
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up

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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •