1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Copy a database

Discussion in 'Databases' started by Darren Paine, Oct 11, 2018.

  1. #1
    Hi im quite new to coding just over a year. i have a website that has a phpmyadmin, mysql Database. Is it possible to clone the database so i can create another website from the same database.
    SEMrush
     
    Darren Paine, Oct 11, 2018 IP
    SEMrush
  2. sarahk

    sarahk iTamer Staff

    Messages:
    25,386
    Likes Received:
    3,493
    Best Answers:
    101
    Trophy Points:
    665
    #2
    Absolutely. Download a sql dump (Export) and then upload and run it through the other phpmyadmin
     
    sarahk, Oct 11, 2018 IP
  3. mmerlinn

    mmerlinn Notable Member

    Messages:
    2,376
    Likes Received:
    334
    Best Answers:
    6
    Trophy Points:
    290
    #3
    Will the database EVER change? If so, HOW do plan on keeping BOTH databases in sync with each other?

    If the database is not static, why don't you use the same database for BOTH websites?
     
    mmerlinn, Oct 11, 2018 IP
  4. Darren Paine

    Darren Paine Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #4
    Hi yes after looking around it seams pointing both websites to one database is the solution. I wasnt sure if the database could be cloned? just like your web files so creating two websites with two databases. The first website is a directory for tradesmen. I wanted to clone that site so we could then create another website for engineers.

    thanks for your reply
     
    Darren Paine, Oct 11, 2018 IP
  5. JEET

    JEET Notable Member

    Messages:
    2,441
    Likes Received:
    141
    Best Answers:
    3
    Trophy Points:
    215
    #5
    If content of both websites is different, then best is to create a new database, with same table "structure" only, and "new"data entries.

    However, if raw data is same for both, only output style is changing, then use the same database. Saves a lot of updating troubles...
     
    JEET, Mar 29, 2019 IP