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:
    24,418
    Likes Received:
    3,286
    Best Answers:
    94
    Trophy Points:
    615
    #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:
    1,737
    Likes Received:
    198
    Best Answers:
    5
    Trophy Points:
    240
    #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