How do i duplicate a database?

Discussion in 'Databases' started by Bjam, Sep 15, 2007.

  1. #1
    Hey guys,

    I have a phpld link directory and i want to duplicate the database so i can use it on a new link directory. Whats the best way to do this??
     
    Bjam, Sep 15, 2007 IP
  2. alexjdb

    alexjdb Well-Known Member

    Messages:
    69
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    120
    #2
    In phpMyAdmin, export it, change the names of the databases (in the text file you exported), and reimport it using the db names you want ;)
     
    alexjdb, Sep 15, 2007 IP
  3. azoundria

    azoundria Member

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    Why don't you just get the second directory to use the same database? Or do you need to copy it?
     
    azoundria, Sep 15, 2007 IP
  4. alexjdb

    alexjdb Well-Known Member

    Messages:
    69
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    120
    #4
    Yup, that's another option
     
    alexjdb, Sep 15, 2007 IP
  5. LanZord

    LanZord Peon

    Messages:
    324
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Are you want copy full database or certain table..?? Its easy just export then import to new db..
     
    LanZord, Sep 15, 2007 IP
  6. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #6
    If the other link directory is on the server, you can use it directly using the same connection parameters. Even if it is on another server, you can provide remote access to your db.
     
    Kuldeep1952, Sep 15, 2007 IP