SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    May 2008
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How do i duplicate an entire database? Please Help Me

    Hi, I need some help, I want to know how do i duplicate an entire mysql database and all the software thats on that database. For example, I have a websiteA that has a databaseA, I am going to create a websiteB, so now, I want to duplicate databaseA and make a databaseB so it will work with websiteB. I want to have websiteA,databaseA and websiteB,databaseB on different ip address,but on the same server. I have a linux server running redhat. I am a newbie,so thank you in advance.

  2. #2
    SitePoint Wizard jimbo_dk's Avatar
    Join Date
    May 2005
    Location
    Singapore
    Posts
    1,261
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Welcome to SP.....

    You can log onto your cpanel and download the MySQL backup and import it into the new database. Alternatively you can do an export to SQL from inside of PHPMyAdmin.
    Winners Respond. Losers React.
    Singapore Web Designer

  3. #3
    SitePoint Member
    Join Date
    Feb 2008
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Blackimpallass is right. It just like backup and restore the database to another database machine. But I think you should not forget to change values in setting tables if any (most of database has setting tables) regarding the website identity. CMIIW. Good Luck


Bookmarks

Posting Permissions

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